public ActionResult Insert_Data_Caption(CommanMasterCaption CMC) { try { int result1 = _objCM.insert_data_Caption(CMC); if (result1 == 1) { } return Json(new { success = true, responseText = "Record Save Sucessfully!" }, JsonRequestBehavior.AllowGet); } catch (Exception) { throw; } }
public int insert_data_Caption(CommanMasterCaption CMC) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_save_usermaster_caption", _cn); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@xmaster", CMC.xmastercaption); _cmd.Parameters.AddWithValue("@SEGMENT", CMC.SEGMENTcaption); _cmd.Parameters.AddWithValue("@Field1", CMC.Field1caption); _cmd.Parameters.AddWithValue("@Field2", CMC.Field2caption); _cmd.Parameters.AddWithValue("@Field3", CMC.Field3caption); _cmd.Parameters.AddWithValue("@Field4", CMC.Field4caption); _cmd.Parameters.AddWithValue("@Field5", CMC.Field5caption); _cmd.Parameters.AddWithValue("@Field6", CMC.Field6caption); _cmd.Parameters.AddWithValue("@Field7 ", CMC.Field7caption); _cmd.Parameters.AddWithValue("@Field8", CMC.Field8caption); _cmd.Parameters.AddWithValue("@Field9", CMC.Field9caption); _cmd.Parameters.AddWithValue("@Field10", CMC.Field10caption); _cmd.Parameters.AddWithValue("@Field11", CMC.Field11caption); _cmd.Parameters.AddWithValue("@Field12", CMC.Field12caption); _cmd.Parameters.AddWithValue("@Field13", CMC.Field13caption); _cmd.Parameters.AddWithValue("@Field14", CMC.Field14caption); _cmd.Parameters.AddWithValue("@Field15", CMC.Field15caption); _cmd.Parameters.AddWithValue("@Field16", CMC.Field16caption); _cmd.Parameters.AddWithValue("@Field17", CMC.Field17caption); _cmd.Parameters.AddWithValue("@Field18", CMC.Field18caption); _cmd.Parameters.AddWithValue("@Field19", CMC.Field19caption); _cmd.Parameters.AddWithValue("@Field20", CMC.Field20caption); _cmd.Parameters.AddWithValue("@Language ", CMC.Languagecaption); _cmd.Parameters.AddWithValue("@Attribute1", CMC.Attribute1caption); _cmd.Parameters.AddWithValue("@Attribute2", CMC.Attribute2caption); _cmd.Parameters.AddWithValue("@Attribute3", CMC.Attribute3caption); _cmd.Parameters.AddWithValue("@Attribute4", CMC.Attribute4caption); _cmd.Parameters.AddWithValue("@Attribute5", CMC.Attribute5caption); _cmd.Parameters.AddWithValue("@Attribute6", CMC.Attribute6caption); _cmd.Parameters.AddWithValue("@Attribute7", CMC.Attribute7caption); _cmd.Parameters.AddWithValue("@Attribute8", CMC.Attribute8caption); _cmd.Parameters.AddWithValue("@Attribute9", CMC.Attribute9caption); _cmd.Parameters.AddWithValue("@Attribute10", CMC.Attribute10caption); _cmd.Parameters.AddWithValue("@Rating1", CMC.Rating1caption); _cmd.Parameters.AddWithValue("@Rating2", CMC.Rating2caption); _cmd.Parameters.AddWithValue("@Rating3", CMC.Rating3caption); _cmd.Parameters.AddWithValue("@Date1", CMC.Date1caption); _cmd.Parameters.AddWithValue("@Date2", CMC.Date2caption); _cmd.Parameters.AddWithValue("@Date3", CMC.Date3caption); _cmd.Parameters.AddWithValue("@Email1", CMC.Email1caption); _cmd.Parameters.AddWithValue("@Email2", CMC.Email2caption); _cmd.Parameters.AddWithValue("@Email3", CMC.Email3caption); _cmd.Parameters.AddWithValue("@Amount", CMC.Amountcaption); _cmd.Parameters.AddWithValue("@Amount2", CMC.Amount2caption); _cmd.Parameters.AddWithValue("@Amount3", CMC.Amount3caption); _cmd.Parameters.AddWithValue("@Time1", CMC.Time1caption); _cmd.Parameters.AddWithValue("@Time2", CMC.Time2caption); _cmd.Parameters.AddWithValue("@Html", CMC.Htmlcaption); _cmd.Parameters.AddWithValue("@Upload", CMC.Uploadcaption); _cmd.Parameters.AddWithValue("@TextArea", CMC.TextAreacaption); _cmd.Parameters.AddWithValue("@MultiSelect1", CMC.MultiSelect1caption); _cmd.Parameters.AddWithValue("@MultiSelect2", CMC.MultiSelect2caption); _cmd.Parameters.AddWithValue("@MultiSelect3", CMC.MultiSelect3caption); _cmd.Parameters.AddWithValue("@MultiSelect4", CMC.MultiSelect4caption); _cmd.Parameters.AddWithValue("@MultiSelect5", CMC.MultiSelect5caption); _cmd.Parameters.AddWithValue("@CreatedBy", CMC.CreatedBycaption); if (CMC.EntryDatetimecaption == null) { _cmd.Parameters.AddWithValue("@EntryDatetime", DBNull.Value); } else { _cmd.Parameters.AddWithValue("@EntryDatetime", DateTime.ParseExact(CMC.EntryDatetimecaption, "dd/MM/yyyy", null)); } _cmd.Parameters.AddWithValue("@EditedBy", CMC.EditedBycaption); if (CMC.EditDatetimecaption == null) { _cmd.Parameters.AddWithValue("@EditDatetime", DBNull.Value); } else { _cmd.Parameters.AddWithValue("@EditDatetime", DateTime.ParseExact(CMC.EditDatetimecaption, "dd/MM/yyyy", null)); } _cmd.Parameters.AddWithValue("@CorpcentreBy", CMC.CorpcentreBycaption); _cmd.Parameters.AddWithValue("@UnitCorpBy", CMC.UnitCorpBycaption); _cmd.Parameters.AddWithValue("@TerminalBy", CMC.TerminalBycaption); int i = _cmd.ExecuteNonQuery(); return i; } catch { throw; } finally { _cn.Close(); _cn.Dispose(); } }