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