public JsonResult SaveInspectionProductionMaster(TblStock11 master)
{
if (master != null)
{
var user = (User)Session["CurrentUser"];
master.DCode = 5;
master.DName = "Inspection";
master.UserName = user.USERNAME;
master.EDate = DateTime.Now;
}
var res = _repository.SaveInspectionProductionMaster(master);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public TblStock11 SaveInspectionProductionMaster(TblStock11 master)
{
var res = new TblStock11();
var dt = new DataTable();
try
{
dt = InsertOrUpdateInspectionProductionMaster("SP_INSERT_INSPECTION_PRODUCTION_MASTER_INFO", "SAVE_INSPECTION_PRODUCTION_MASTER", master);
res.SaveStatus = Operation.Success.ToString();
res.ID = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public TblStock11 SaveInspectionProductionMaster(TblStock11 master)
{
return(_service.SaveInspectionProductionMaster(master));
}
public DataTable InsertOrUpdateInspectionProductionMaster(string procedure, string callname, TblStock11 master)
{
dbConn = new SqlConnection(ConnectionString);
dbConn.Open();
cmd = new SqlCommand(procedure, dbConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@call_name", callname));
cmd.Parameters.Add(new SqlParameter("@ID", master.ID));
cmd.Parameters.Add(new SqlParameter("@SDate", master.SDate));
cmd.Parameters.Add(new SqlParameter("@TracDate", master.TracDate));
cmd.Parameters.Add(new SqlParameter("@Ref", master.Ref));
cmd.Parameters.Add(new SqlParameter("@DID", master.DID));
cmd.Parameters.Add(new SqlParameter("@DCode", master.DCode));
cmd.Parameters.Add(new SqlParameter("@DName", master.DName));
cmd.Parameters.Add(new SqlParameter("@UCode", master.UCode));
cmd.Parameters.Add(new SqlParameter("@UName", master.UName));
cmd.Parameters.Add(new SqlParameter("@TotalProd", master.TotalProd));
cmd.Parameters.Add(new SqlParameter("@CProd", master.CProd));
cmd.Parameters.Add(new SqlParameter("@Gramending", master.Gramending));
cmd.Parameters.Add(new SqlParameter("@UserName", master.UserName));
cmd.Parameters.Add(new SqlParameter("@EDate", master.EDate));
cmd.Parameters.Add(new SqlParameter("@InsFloorCode", master.InsFloorCode));
cmd.Parameters.Add(new SqlParameter("@InsFloorName", master.InsFloorName));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
