public JsonResult SaveTimeUtilization(DyeingUtilityTimeUtilization timeUtilization)
{
var user = (User)Session["CurrentUser"];
if (timeUtilization != null)
{
timeUtilization.UserID = user.USERID;
timeUtilization.TermID = user.TermID;
timeUtilization.EntryDate = DateTime.Now;
}
var res = _dyeingUtilityRepo.SaveTimeUtilization(timeUtilization);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public DyeingUtilityTimeUtilization SaveTimeUtilization(DyeingUtilityTimeUtilization timeUtilization)
{
var res = new DyeingUtilityTimeUtilization();
var dt = new DataTable();
try
{
dt = InserOrUpdateTimeUtilization("SP_INSERT_DYEING_UTILITY_TIME_UTILIZATION", "SAVE_TIME_UTILIZATION", timeUtilization);
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 InserOrUpdateTimeUtilization(string procedure, string callname, DyeingUtilityTimeUtilization timeUtilization)
{
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", timeUtilization.ID));
cmd.Parameters.Add(new SqlParameter("@SetNo", timeUtilization.SetNo));
cmd.Parameters.Add(new SqlParameter("@TimeUtilizationID", timeUtilization.TimeUtilizationID));
cmd.Parameters.Add(new SqlParameter("@TimeUtilizationName", timeUtilization.TimeUtilizationName));
cmd.Parameters.Add(new SqlParameter("@MCRunFrom", timeUtilization.MCRunFrom));
cmd.Parameters.Add(new SqlParameter("@MCRunTo", timeUtilization.MCRunTo));
cmd.Parameters.Add(new SqlParameter("@TotalTimeHour", timeUtilization.TotalTimeHour));
cmd.Parameters.Add(new SqlParameter("@CalculatedRunHour", timeUtilization.CalculatedRunHour));
cmd.Parameters.Add(new SqlParameter("@Remark", timeUtilization.Remark));
cmd.Parameters.Add(new SqlParameter("@UserID", timeUtilization.UserID));
cmd.Parameters.Add(new SqlParameter("@TermID", timeUtilization.TermID));
cmd.Parameters.Add(new SqlParameter("@EntryDate", timeUtilization.EntryDate));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public DyeingUtilityTimeUtilization SaveTimeUtilization(DyeingUtilityTimeUtilization timeUtilization)
{
return(dataService.SaveTimeUtilization(timeUtilization));
}