public ActionResult Insert_Data_Help(CommanMasterHelp CMH)
{
try
{
int result1 = _objCM.insert_data_help(CMH);
if (result1 == 1)
{
ViewBag.Message = "Record Save Sucessfully !";
}
return Json(new { success = true, responseText = "Record Save Sucessfully!" }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public int insert_data_help(CommanMasterHelp CMH)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_save_usermaster_help", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@xmaster", CMH.xmaster);
_cmd.Parameters.AddWithValue("@Field1", CMH.Field1);
_cmd.Parameters.AddWithValue("@Field2", CMH.Field2);
_cmd.Parameters.AddWithValue("@Field3", CMH.Field3);
_cmd.Parameters.AddWithValue("@Field4", CMH.Field4);
_cmd.Parameters.AddWithValue("@Field5", CMH.Field5);
_cmd.Parameters.AddWithValue("@Field6", CMH.Field6);
_cmd.Parameters.AddWithValue("@Field7 ", CMH.Field7);
_cmd.Parameters.AddWithValue("@Field8", CMH.Field8);
_cmd.Parameters.AddWithValue("@Field9", CMH.Field9);
_cmd.Parameters.AddWithValue("@Field10", CMH.Field10);
_cmd.Parameters.AddWithValue("@Field11", CMH.Field11);
_cmd.Parameters.AddWithValue("@Field12", CMH.Field12);
_cmd.Parameters.AddWithValue("@Field13", CMH.Field13);
_cmd.Parameters.AddWithValue("@Field14", CMH.Field14);
_cmd.Parameters.AddWithValue("@Field15", CMH.Field15);
_cmd.Parameters.AddWithValue("@Field16", CMH.Field16);
_cmd.Parameters.AddWithValue("@Field17", CMH.Field17);
_cmd.Parameters.AddWithValue("@Field18", CMH.Field18);
_cmd.Parameters.AddWithValue("@Field19", CMH.Field19);
_cmd.Parameters.AddWithValue("@Field20", CMH.Field20);
_cmd.Parameters.AddWithValue("@Language ", CMH.Language);
_cmd.Parameters.AddWithValue("@Attribute1", CMH.Attribute1);
_cmd.Parameters.AddWithValue("@Attribute2", CMH.Attribute2);
_cmd.Parameters.AddWithValue("@Attribute3", CMH.Attribute3);
_cmd.Parameters.AddWithValue("@Attribute4", CMH.Attribute4);
_cmd.Parameters.AddWithValue("@Attribute5", CMH.Attribute5);
_cmd.Parameters.AddWithValue("@Attribute6", CMH.Attribute6);
_cmd.Parameters.AddWithValue("@Attribute7", CMH.Attribute7);
_cmd.Parameters.AddWithValue("@Attribute8", CMH.Attribute8);
_cmd.Parameters.AddWithValue("@Attribute9", CMH.Attribute9);
_cmd.Parameters.AddWithValue("@Attribute10", CMH.Attribute10);
_cmd.Parameters.AddWithValue("@Rating1", CMH.Rating1);
_cmd.Parameters.AddWithValue("@Rating2", CMH.Rating2);
_cmd.Parameters.AddWithValue("@Rating3", CMH.Rating3);
_cmd.Parameters.AddWithValue("@Date1", CMH.Date1);
_cmd.Parameters.AddWithValue("@Date2", CMH.Date2);
_cmd.Parameters.AddWithValue("@Date3", CMH.Date3);
_cmd.Parameters.AddWithValue("@Email1", CMH.Email1);
_cmd.Parameters.AddWithValue("@Email2", CMH.Email2);
_cmd.Parameters.AddWithValue("@Email3", CMH.Email3);
_cmd.Parameters.AddWithValue("@Amount", CMH.Amount);
_cmd.Parameters.AddWithValue("@Amount2", CMH.Amount2);
_cmd.Parameters.AddWithValue("@Amount3", CMH.Amount3);
_cmd.Parameters.AddWithValue("@Time1", CMH.Time1);
_cmd.Parameters.AddWithValue("@Time2", CMH.Time2);
_cmd.Parameters.AddWithValue("@Html", CMH.Html);
_cmd.Parameters.AddWithValue("@Upload", CMH.Upload);
_cmd.Parameters.AddWithValue("@TextArea", CMH.TextArea);
_cmd.Parameters.AddWithValue("@MultiSelect1", CMH.MultiSelect1);
_cmd.Parameters.AddWithValue("@MultiSelect2", CMH.MultiSelect2);
_cmd.Parameters.AddWithValue("@MultiSelect3", CMH.MultiSelect3);
_cmd.Parameters.AddWithValue("@MultiSelect4", CMH.MultiSelect4);
_cmd.Parameters.AddWithValue("@MultiSelect5", CMH.MultiSelect5);
_cmd.Parameters.AddWithValue("@CreatedBy", CMH.CreatedBy);
if (CMH.EntryDatetime == null)
{
_cmd.Parameters.AddWithValue("@EntryDatetime", DBNull.Value);
}
else
{
_cmd.Parameters.AddWithValue("@EntryDatetime", DateTime.ParseExact(CMH.EntryDatetime, "dd/MM/yyyy", null));
}
_cmd.Parameters.AddWithValue("@EditedBy", CMH.EditedBy);
if (CMH.EditDatetime == null)
{
_cmd.Parameters.AddWithValue("@EditDatetime", DBNull.Value);
}
else
{
_cmd.Parameters.AddWithValue("@EditDatetime", DateTime.ParseExact(CMH.EditDatetime, "dd/MM/yyyy", null));
}
_cmd.Parameters.AddWithValue("@CorpcentreBy", CMH.CorpcentreBy);
_cmd.Parameters.AddWithValue("@UnitCorpBy", CMH.UnitCorpBy);
_cmd.Parameters.AddWithValue("@TerminalBy", CMH.TerminalBy);
int i = _cmd.ExecuteNonQuery();
return i;
}
catch
{
throw;
}
finally
{
_cn.Close();
_cn.Dispose();
}
}