public int GHC_SiteConfiguration_Update(GHC_SiteConfigurationData objGHC_SiteConfiguration)
{
int rowsAffected = 0;
SqlConnection connection = null;
try
{
connection = (SqlConnection)new DBConnect().ConnectionObject;
SqlCommand Command = new SqlCommand("GHC_GHC_SiteConfiguration_Update", connection);
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.AddWithValue("@nSiteConfigurationID",objGHC_SiteConfiguration.nSiteConfigurationID);
Command.Parameters.AddWithValue("@sSMTPServer",objGHC_SiteConfiguration.sSMTPServer);
Command.Parameters.AddWithValue("@nPort",objGHC_SiteConfiguration.nPort);
Command.Parameters.AddWithValue("@sSMTPUsername",objGHC_SiteConfiguration.sSMTPUsername);
Command.Parameters.AddWithValue("@sSMTPPassword",objGHC_SiteConfiguration.sSMTPPassword);
Command.Parameters.AddWithValue("@sAdminEmailID",objGHC_SiteConfiguration.sAdminEmailID);
Command.Parameters.AddWithValue("@sInfoEmailID",objGHC_SiteConfiguration.sInfoEmailID);
Command.Parameters.AddWithValue("@sContactEmailID",objGHC_SiteConfiguration.sContactEmailID);
Command.Parameters.AddWithValue("@sReplyToEmailID",objGHC_SiteConfiguration.sReplyToEmailID);
Command.Parameters.AddWithValue("@sContactNo",objGHC_SiteConfiguration.sContactNo);
Command.Parameters.AddWithValue("@sFax",objGHC_SiteConfiguration.sFax);
Command.Parameters.AddWithValue("@sErrorEmailID",objGHC_SiteConfiguration.sErrorEmailID);
Command.Parameters.AddWithValue("@bIsSendErrorEmail",objGHC_SiteConfiguration.bIsSendErrorEmail);
SqlParameter returnValueParam = new SqlParameter("@RETURN_VALUE", SqlDbType.Int);
returnValueParam.Direction = ParameterDirection.ReturnValue;
Command.Parameters.Add(returnValueParam);
connection.Open();
Command.ExecuteNonQuery();
rowsAffected = Convert.ToInt32(returnValueParam.Value);
}
catch
{
rowsAffected = 0;
}
finally
{
if (connection != null)
connection.Close();
connection.Dispose();
}
return rowsAffected;
}
/// <summary>
/// Action use to add new record in site configuration
/// </summary>
/// <param name="objModel"></param>
/// <returns></returns>
public ActionResult AddRecord(GHC_SiteConfigurationData objModel)
{
try
{
GHC_SiteConfigurationData objnewRecord = new GHC_SiteConfigurationData();
objnewRecord.bIsSendErrorEmail = Methods.doBoolean(objModel.bIsSendErrorEmail);
objnewRecord.nPort = Methods.doInt(objModel.nPort);
objnewRecord.sAdminEmailID = Methods.doInsertable(objModel.sAdminEmailID);
objnewRecord.sContactEmailID = Methods.doInsertable(objModel.sContactEmailID);
objnewRecord.sContactNo = Methods.doInsertable(objModel.sContactNo);
objnewRecord.sErrorEmailID = Methods.doInsertable(objModel.sErrorEmailID);
objnewRecord.sFax = Methods.doInsertable(objModel.sFax);
objnewRecord.sInfoEmailID = Methods.doInsertable(objModel.sInfoEmailID);
objnewRecord.sReplyToEmailID = Methods.doInsertable(objModel.sReplyToEmailID);
objnewRecord.sSMTPPassword = (Methods.CorrectDBNull(objModel.sSMTPPassword) != "") ? Methods.Encryption(Methods.CorrectDBNull(objModel.sSMTPPassword)) : "";
objnewRecord.sSMTPServer = Methods.doInsertable(objModel.sSMTPServer);
objnewRecord.sSMTPUsername = Methods.doInsertable(objModel.sSMTPUsername);
int nReturn = objDBGHC_SiteConfiguration.GHC_SiteConfiguration_Insert(objnewRecord);
if (nReturn > 0)
{
Session[Helpers.CommonConstants.Message] = Messages.GetMessage("[Insert]", "Site Setting");
Session[Helpers.CommonConstants.MessageType] = "1";
}
else
{
Session[Helpers.CommonConstants.Message] = Messages.GetMessage("[Error]", "Site Setting");
Session[Helpers.CommonConstants.MessageType] = "2";
}
}
catch(Exception ex)
{
CommonRepository.LogError("SiteSettingController", "AddRecord", ex.ToString());
Session[Helpers.CommonConstants.Message] = Messages.GetMessage("[Error]");
Session[Helpers.CommonConstants.MessageType] = "2";
return RedirectToAction("index", "dashboard");
}
return RedirectToAction("Index","dashboard");
}