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