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(); } }