public ActionResult Insert_Data_Validation(CommanMasterValidation CMV) { try { int result1 = _objCM.insert_data_Validation(CMV); 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_Validation(CommanMasterValidation CMV) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_save_usermaster_validation", _cn); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@xmaster", CMV.xmaster); _cmd.Parameters.AddWithValue("@Field1", CMV.Field1); _cmd.Parameters.AddWithValue("@Field2", CMV.Field2); _cmd.Parameters.AddWithValue("@Field3", CMV.Field3); _cmd.Parameters.AddWithValue("@Field4", CMV.Field4); _cmd.Parameters.AddWithValue("@Field5", CMV.Field5); _cmd.Parameters.AddWithValue("@Field6", CMV.Field6); _cmd.Parameters.AddWithValue("@Field7 ", CMV.Field7); _cmd.Parameters.AddWithValue("@Field8", CMV.Field8); _cmd.Parameters.AddWithValue("@Field9", CMV.Field9); _cmd.Parameters.AddWithValue("@Field10", CMV.Field10); _cmd.Parameters.AddWithValue("@Field11", CMV.Field11); _cmd.Parameters.AddWithValue("@Field12", CMV.Field12); _cmd.Parameters.AddWithValue("@Field13", CMV.Field13); _cmd.Parameters.AddWithValue("@Field14", CMV.Field14); _cmd.Parameters.AddWithValue("@Field15", CMV.Field15); _cmd.Parameters.AddWithValue("@Field16", CMV.Field16); _cmd.Parameters.AddWithValue("@Field17", CMV.Field17); _cmd.Parameters.AddWithValue("@Field18", CMV.Field18); _cmd.Parameters.AddWithValue("@Field19", CMV.Field19); _cmd.Parameters.AddWithValue("@Field20", CMV.Field20); _cmd.Parameters.AddWithValue("@Language ", CMV.Language); _cmd.Parameters.AddWithValue("@Attribute1", CMV.Attribute1); _cmd.Parameters.AddWithValue("@Attribute2", CMV.Attribute2); _cmd.Parameters.AddWithValue("@Attribute3", CMV.Attribute3); _cmd.Parameters.AddWithValue("@Attribute4", CMV.Attribute4); _cmd.Parameters.AddWithValue("@Attribute5", CMV.Attribute5); _cmd.Parameters.AddWithValue("@Attribute6", CMV.Attribute6); _cmd.Parameters.AddWithValue("@Attribute7", CMV.Attribute7); _cmd.Parameters.AddWithValue("@Attribute8", CMV.Attribute8); _cmd.Parameters.AddWithValue("@Attribute9", CMV.Attribute9); _cmd.Parameters.AddWithValue("@Attribute10", CMV.Attribute10); _cmd.Parameters.AddWithValue("@Rating1", CMV.Rating1); _cmd.Parameters.AddWithValue("@Rating2", CMV.Rating2); _cmd.Parameters.AddWithValue("@Rating3", CMV.Rating3); _cmd.Parameters.AddWithValue("@Date1", CMV.Date1); _cmd.Parameters.AddWithValue("@Date2", CMV.Date2); _cmd.Parameters.AddWithValue("@Date3", CMV.Date3); _cmd.Parameters.AddWithValue("@Email1", CMV.Email1); _cmd.Parameters.AddWithValue("@Email2", CMV.Email2); _cmd.Parameters.AddWithValue("@Email3", CMV.Email3); _cmd.Parameters.AddWithValue("@Amount", CMV.Amount); _cmd.Parameters.AddWithValue("@Amount2", CMV.Amount2); _cmd.Parameters.AddWithValue("@Amount3", CMV.Amount3); _cmd.Parameters.AddWithValue("@Time1", CMV.Time1); _cmd.Parameters.AddWithValue("@Time2", CMV.Time2); _cmd.Parameters.AddWithValue("@Html", CMV.Html); _cmd.Parameters.AddWithValue("@Upload", CMV.Upload); _cmd.Parameters.AddWithValue("@TextArea", CMV.TextArea); _cmd.Parameters.AddWithValue("@MultiSelect1", CMV.MultiSelect1); _cmd.Parameters.AddWithValue("@MultiSelect2", CMV.MultiSelect2); _cmd.Parameters.AddWithValue("@MultiSelect3", CMV.MultiSelect3); _cmd.Parameters.AddWithValue("@MultiSelect4", CMV.MultiSelect4); _cmd.Parameters.AddWithValue("@MultiSelect5", CMV.MultiSelect5); _cmd.Parameters.AddWithValue("@CreatedBy", CMV.CreatedBy); if (CMV.EntryDatetime == null) { _cmd.Parameters.AddWithValue("@EntryDatetime", DBNull.Value); } else { _cmd.Parameters.AddWithValue("@EntryDatetime", DateTime.ParseExact(CMV.EntryDatetime, "dd/MM/yyyy", null)); } _cmd.Parameters.AddWithValue("@EditedBy", CMV.EditedBy); if (CMV.EditDatetime == null) { _cmd.Parameters.AddWithValue("@EditDatetime", DBNull.Value); } else { _cmd.Parameters.AddWithValue("@EditDatetime", DateTime.ParseExact(CMV.EditDatetime, "dd/MM/yyyy", null)); } _cmd.Parameters.AddWithValue("@CorpcentreBy", CMV.CorpcentreBy); _cmd.Parameters.AddWithValue("@UnitCorpBy", CMV.UnitCorpBy); _cmd.Parameters.AddWithValue("@TerminalBy", CMV.TerminalBy); int i = _cmd.ExecuteNonQuery(); return i; } catch { throw; } finally { _cn.Close(); _cn.Dispose(); } }