public DyeingProcessCreelLoading SaveCreelLoading(DyeingProcessCreelLoading creelLoading)
{
var res = new DyeingProcessCreelLoading();
var dt = new DataTable();
try
{
dt = InserOrUpdateCreelLoading("SP_INSERT_DYEING_PROCESS_CREEL_LOADING", "SAVE_CREEL_LOADING", creelLoading);
res.SaveStatus = Operation.Success.ToString();
res.ID = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public JsonResult SaveCreelLoading(DyeingProcessCreelLoading creelLoading)
{
var user = (User)Session["CurrentUser"];
if (creelLoading != null)
{
if (creelLoading.ID == 0)
{
creelLoading.EntryBy = user.USERID;
creelLoading.EntryDate = DateTime.Now;
}
else
{
creelLoading.UpdateBy = user.USERID;
creelLoading.UpdateDate = DateTime.Now;
}
}
var res = _dyeingUtilityRepo.SaveCreelLoading(creelLoading);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public DataTable InserOrUpdateCreelLoading(string procedure, string callname, DyeingProcessCreelLoading creelLoading)
{
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", creelLoading.ID));
cmd.Parameters.Add(new SqlParameter("@SetNo", creelLoading.SetNo));
cmd.Parameters.Add(new SqlParameter("@UpperCreel", creelLoading.UpperCreel));
cmd.Parameters.Add(new SqlParameter("@UpperCreelBeamNo", creelLoading.UpperCreelBeamNo));
cmd.Parameters.Add(new SqlParameter("@UpperCreelYarnCount", creelLoading.UpperCreelYarnCount));
cmd.Parameters.Add(new SqlParameter("@LowerCreel", creelLoading.LowerCreel));
cmd.Parameters.Add(new SqlParameter("@LowerCreelBeamNo", creelLoading.LowerCreelBeamNo));
cmd.Parameters.Add(new SqlParameter("@LowerCreelYarnCount", creelLoading.LowerCreelYarnCount));
cmd.Parameters.Add(new SqlParameter("@Remark", creelLoading.Remark));
cmd.Parameters.Add(new SqlParameter("@EntryBy", creelLoading.EntryBy));
cmd.Parameters.Add(new SqlParameter("@EntryDate", creelLoading.EntryDate));
cmd.Parameters.Add(new SqlParameter("@UpdateBy", creelLoading.UpdateBy));
cmd.Parameters.Add(new SqlParameter("@UpdateDate", creelLoading.UpdateDate));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public DyeingProcessCreelLoading SaveCreelLoading(DyeingProcessCreelLoading creelLoading)
{
return(dataService.SaveCreelLoading(creelLoading));
}
