public ActionResult Insert_Data(CommanUserMaster CUH)
{
try
{
ViewBag.Message = "";
ViewBag.Event = "";
DataSet result = _objCM.insert_data_UserMaster(CUH);
if (result != null)
{
ViewBag.Message = result.Tables[0].Rows[0]["msg"].ToString();
if (result.Tables[0].Rows[0]["Help"].ToString() == "Save" || result.Tables[0].Rows[0]["Help"].ToString() == "Update")
{
ViewBag.Event = "success";
ViewBag.Srno = result.Tables[0].Rows[0]["SrNo"].ToString();
}
else if (result.Tables[0].Rows[0]["Help"].ToString() == "Duplicate")
{
ViewBag.Event = "error";
}
}
var result1 = ViewBag.Message;
return Json(new { success = result1, Event = ViewBag.Event, srno = ViewBag.Srno }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public DataSet insert_data_UserMaster(CommanUserMaster CUH)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_save_usermaster", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@Srno", CUH.USrno);
_cmd.Parameters.AddWithValue("@xmaster", CUH.Uxmaster);
_cmd.Parameters.AddWithValue("@xcode", CUH.Uxcode);
_cmd.Parameters.AddWithValue("@xname", CUH.Uxname);
_cmd.Parameters.AddWithValue("@IsActive", CUH.UIsActive);
_cmd.Parameters.AddWithValue("@Remark", CUH.URemark);
if (CUH.Uxlink != null)
{
_cmd.Parameters.AddWithValue("@xlink", CUH.Uxlink);
}
else { _cmd.Parameters.AddWithValue("@xlink", "0"); }
if (CUH.Uxcross != null)
{
_cmd.Parameters.AddWithValue("@xcross", CUH.Uxcross);
}
else { _cmd.Parameters.AddWithValue("@xcross", "0"); }
if (CUH.Uxcross1 != null)
{
_cmd.Parameters.AddWithValue("@xcross1", CUH.Uxcross1);
}
else { _cmd.Parameters.AddWithValue("@xcross1", "0"); }
if (CUH.Uxcross2 != null)
{
_cmd.Parameters.AddWithValue("@xcross2", CUH.Uxcross2);
}
else { _cmd.Parameters.AddWithValue("@xcross2", "0"); }
if (CUH.Uxcross3 != null)
{
_cmd.Parameters.AddWithValue("@xcross3 ", CUH.Uxcross3);
}
else { _cmd.Parameters.AddWithValue("@xcross3", "0"); }
if (CUH.Uxcross4 != null)
{
_cmd.Parameters.AddWithValue("@xcross4", CUH.Uxcross4);
}
else { _cmd.Parameters.AddWithValue("@xcross4", "0"); }
if (CUH.Uxreference1 != null)
{
_cmd.Parameters.AddWithValue("@xreference1 ", CUH.Uxreference1);
}
else { _cmd.Parameters.AddWithValue("@xreference1", ""); }
if (CUH.Uxreference2 != null)
{
_cmd.Parameters.AddWithValue("@xreference2 ", CUH.Uxreference2);
}
else { _cmd.Parameters.AddWithValue("@xreference2", ""); }
if (CUH.Uxreference3 != null)
{
_cmd.Parameters.AddWithValue("@xreference3 ", CUH.Uxreference3);
}
else { _cmd.Parameters.AddWithValue("@xreference3", ""); }
if (CUH.Uxreference4 != null)
{
_cmd.Parameters.AddWithValue("@xreference4 ", CUH.Uxreference4);
}
else { _cmd.Parameters.AddWithValue("@xreference4", ""); }
if (CUH.Uxreference5 != null)
{
_cmd.Parameters.AddWithValue("@xreference5 ", CUH.Uxreference5);
}
else { _cmd.Parameters.AddWithValue("@xreference5", ""); }
if (CUH.Uxreference6 != null)
{
_cmd.Parameters.AddWithValue("@xreference6 ", CUH.Uxreference6);
}
else { _cmd.Parameters.AddWithValue("@xreference6", ""); }
_cmd.Parameters.AddWithValue("@xdetail ", CUH.Uxdetail);
_cmd.Parameters.AddWithValue("@Attribute1", CUH.UAttribute1);
_cmd.Parameters.AddWithValue("@Attribute2", CUH.UAttribute2);
_cmd.Parameters.AddWithValue("@Attribute3", CUH.UAttribute3);
_cmd.Parameters.AddWithValue("@Attribute4", CUH.UAttribute4);
_cmd.Parameters.AddWithValue("@Attribute5", CUH.UAttribute5);
_cmd.Parameters.AddWithValue("@Attribute6", CUH.UAttribute6);
_cmd.Parameters.AddWithValue("@Attribute7", CUH.UAttribute7);
_cmd.Parameters.AddWithValue("@Attribute8", CUH.UAttribute8);
_cmd.Parameters.AddWithValue("@Attribute9", CUH.UAttribute9);
_cmd.Parameters.AddWithValue("@Attribute10", CUH.UAttribute10);
_cmd.Parameters.AddWithValue("@Rating1", CUH.URating1);
_cmd.Parameters.AddWithValue("@Rating2", CUH.URating2);
_cmd.Parameters.AddWithValue("@Rating3", CUH.URating3);
if (CUH.UDate1 == null)
{
_cmd.Parameters.AddWithValue("@Date1", DBNull.Value);
}
else
{
_cmd.Parameters.AddWithValue("@Date1", DateTime.ParseExact(CUH.UDate1, "dd/MM/yyyy", null));
}
if (CUH.UDate2 == null)
{
_cmd.Parameters.AddWithValue("@Date2", DBNull.Value);
}
else
{
_cmd.Parameters.AddWithValue("@Date2", DateTime.ParseExact(CUH.UDate2, "dd/MM/yyyy", null));
}
if (CUH.UDate3 == null)
{
_cmd.Parameters.AddWithValue("@Date3", DBNull.Value);
}
else
{
_cmd.Parameters.AddWithValue("@Date3", DateTime.ParseExact(CUH.UDate3, "dd/MM/yyyy", null));
}
_cmd.Parameters.AddWithValue("@Email1", CUH.UEmail1);
_cmd.Parameters.AddWithValue("@Email2", CUH.UEmail2);
_cmd.Parameters.AddWithValue("@Email3", CUH.UEmail3);
_cmd.Parameters.AddWithValue("@Amount", CUH.UAmount);
_cmd.Parameters.AddWithValue("@Amount2", CUH.UAmount2);
_cmd.Parameters.AddWithValue("@Amount3", CUH.UAmount3);
if (CUH.UTime1 == null)
{
_cmd.Parameters.AddWithValue("@Time1", DBNull.Value);
}
else
{
_cmd.Parameters.AddWithValue("@Time1", CUH.UTime1);
}
if (CUH.UTime2 == null)
{
_cmd.Parameters.AddWithValue("@Time2", DBNull.Value);
}
else
{
_cmd.Parameters.AddWithValue("@Time2", CUH.UTime1);
}
_cmd.Parameters.AddWithValue("@Html", CUH.UHtml);
_cmd.Parameters.AddWithValue("@Upload", CUH.UUpload);
_cmd.Parameters.AddWithValue("@TextArea", CUH.UTextArea);
_cmd.Parameters.AddWithValue("@MultiSelect1", CUH.UMultiSelect1);
_cmd.Parameters.AddWithValue("@MultiSelect2", CUH.UMultiSelect2);
_cmd.Parameters.AddWithValue("@MultiSelect3", CUH.UMultiSelect3);
_cmd.Parameters.AddWithValue("@MultiSelect4", CUH.UMultiSelect4);
_cmd.Parameters.AddWithValue("@MultiSelect5", CUH.UMultiSelect5);
_cmd.Parameters.AddWithValue("@CreatedBy", CUH.CreatedBy);
_cmd.Parameters.AddWithValue("@CorpcentreBy", CUH.CorpcentreBy);
_cmd.Parameters.AddWithValue("@UnitCorpBy", CUH.UnitCorpBy);
_cmd.Parameters.AddWithValue("@TerminalBy", CUH.TerminalBy);
_cmd.Parameters.AddWithValue("@BranchBy", CUH.BranchBy);
_cmd.Parameters.AddWithValue("@UserId", CUH.CreatedBy);
// int i = _cmd.ExecuteNonQuery();
// return i;
SqlDataAdapter _adp = new SqlDataAdapter(_cmd);
DataSet _ds = new DataSet();
_adp.Fill(_ds);
_adp.Dispose();
_cmd.Dispose();
return _ds;
}
catch
{
throw;
}
finally
{
_cn.Close();
_cn.Dispose();
}
}