public int FePicDataSet(string strPicTitle, string strPicDate, string strPicName, int intPicType, string strPicIntro, string strThumbnail, int opID)
{
//string strPicTitle,
//string strPicDate,
//string strPicName,
//int intPicType,
//string strPicIntro,
//string strPicName,
//string strThumbnail,
//int opID
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand myCommand = new SqlCommand("mag_FePicDataSet", myConnection);
// Mark the Command as a SPROC
myCommand.CommandType = CommandType.StoredProcedure;
// Add Parameters to SPROC
SqlParameter parameterUserId = new SqlParameter("@opID", SqlDbType.Int);
parameterUserId.Value = opID;
myCommand.Parameters.Add(parameterUserId);
SqlParameter parameterPicTitle = new SqlParameter("@picTitle", SqlDbType.Char, 30);
parameterPicTitle.Value = strPicTitle;
myCommand.Parameters.Add(parameterPicTitle);
SqlParameter parameterPicDate = new SqlParameter("@picDate", SqlDbType.Char, 10);
parameterPicDate.Value = strPicDate;
myCommand.Parameters.Add(parameterPicDate);
SqlParameter parameterPicName = new SqlParameter("@picName", SqlDbType.Char, 50);
parameterPicName.Value = strPicName;
myCommand.Parameters.Add(parameterPicName);
SqlParameter parameterPicType = new SqlParameter("@picType", SqlDbType.Int);
parameterPicType.Value = intPicType;
myCommand.Parameters.Add(parameterPicType);
SqlParameter parameterPicIntro = new SqlParameter("@picIntro", SqlDbType.Char, 255);
parameterPicIntro.Value = strPicIntro;
myCommand.Parameters.Add(parameterPicIntro);
SqlParameter parameterThumbnail = new SqlParameter("@thumbnail", SqlDbType.Char, 50);
parameterThumbnail.Value = strThumbnail;
myCommand.Parameters.Add(parameterThumbnail);
SqlParameter parameterHostAddress = new SqlParameter("@opIP", SqlDbType.Char, 15);
parameterHostAddress.Value = Context.Request.UserHostAddress;
myCommand.Parameters.Add(parameterHostAddress);
//SqlParameter parameterRID = new SqlParameter("@returnID", SqlDbType.Int);
//parameterReturnUserID.Value = -1;
//parameterRID.Direction = ParameterDirection.Output;
//myCommand.Parameters.Add(parameterRID);
// Execute the command in a try/catch to catch duplicate username errors
try
{
// Open the connection and execute the Command
myConnection.Open();
myCommand.ExecuteNonQuery();
}
catch
{
// failed to create a new user
return -1;
}
finally
{
// Close the Connection
if (myConnection.State == ConnectionState.Open)
myConnection.Close();
}
return 1;
}
