public JsonResult SaveRunAndStop(DyeingUtilityRunAndStop runAndStop)
{
var user = (User)Session["CurrentUser"];
if (runAndStop != null)
{
runAndStop.UserID = user.USERID;
runAndStop.TermID = user.TermID;
runAndStop.EntryDate = DateTime.Now;
}
var res = _dyeingUtilityRepo.SaveRunAndStop(runAndStop);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public DyeingUtilityRunAndStop SaveRunAndStop(DyeingUtilityRunAndStop runAndStop)
{
var res = new DyeingUtilityRunAndStop();
var dt = new DataTable();
try
{
dt = InserOrUpdateDyeingStopAndRun("SP_INSERT_DYEING_UTILITY_RUN_AND_STOP", "SAVE_RUN_AND_STOP", runAndStop);
res.SaveStatus = Operation.Success.ToString();
res.ID = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public DataTable InserOrUpdateDyeingStopAndRun(string procedure, string callname, DyeingUtilityRunAndStop runAndStop)
{
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", runAndStop.ID));
cmd.Parameters.Add(new SqlParameter("@SetNo", runAndStop.SetNo));
cmd.Parameters.Add(new SqlParameter("@DepartmentID", runAndStop.DepartmentID));
cmd.Parameters.Add(new SqlParameter("@DepartmentName", runAndStop.DepartmentName));
cmd.Parameters.Add(new SqlParameter("@SlowFromTime", runAndStop.SlowFromTime));
cmd.Parameters.Add(new SqlParameter("@SlowToTime", runAndStop.SlowToTime));
cmd.Parameters.Add(new SqlParameter("@StopFromTime", runAndStop.StopFromTime));
cmd.Parameters.Add(new SqlParameter("@StopToTime", runAndStop.StopToTime));
cmd.Parameters.Add(new SqlParameter("@Duration", runAndStop.Duration));
cmd.Parameters.Add(new SqlParameter("@ReasonID", runAndStop.ReasonID));
cmd.Parameters.Add(new SqlParameter("@ReasonName", runAndStop.ReasonName));
cmd.Parameters.Add(new SqlParameter("@ReasonType", runAndStop.ReasonType));
cmd.Parameters.Add(new SqlParameter("@ProductionLossMeter", runAndStop.ProductionLossMeter));
cmd.Parameters.Add(new SqlParameter("@CGradeYarnMeter", runAndStop.CGradeYarnMeter));
cmd.Parameters.Add(new SqlParameter("@UserID", runAndStop.UserID));
cmd.Parameters.Add(new SqlParameter("@TermID", runAndStop.TermID));
cmd.Parameters.Add(new SqlParameter("@EntryDate", runAndStop.EntryDate));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public DyeingUtilityRunAndStop SaveRunAndStop(DyeingUtilityRunAndStop runAndStop)
{
return(dataService.SaveRunAndStop(runAndStop));
}
