public DyeingUtilityDrainageDetail SaveDrainageDetail(DyeingUtilityDrainageDetail drainageDetail)
{
var res = new DyeingUtilityDrainageDetail();
var dt = new DataTable();
try
{
dt = InserOrUpdateDrainageDetail("SP_INSERT_DYEING_UTILITY_DRAINAGE_DETAIL", "SAVE_DRAINAGE_DETAIL", drainageDetail);
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 SaveDrainageDetail(DyeingUtilityDrainageDetail drainageDetail)
{
var user = (User)Session["CurrentUser"];
if (drainageDetail != null)
{
if (drainageDetail.ID == 0)
{
drainageDetail.EntryBy = user.USERID;
drainageDetail.EntryDate = DateTime.Now;
}
else
{
drainageDetail.UpdateBy = user.USERID;
drainageDetail.UpdateDate = DateTime.Now;
}
}
var res = _dyeingUtilityRepo.SaveDrainageDetail(drainageDetail);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public DataTable InserOrUpdateDrainageDetail(string procedure, string callname, DyeingUtilityDrainageDetail drainageDetail)
{
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", drainageDetail.ID));
cmd.Parameters.Add(new SqlParameter("@SetNo", drainageDetail.SetNo));
cmd.Parameters.Add(new SqlParameter("@ItemID", drainageDetail.ItemID));
cmd.Parameters.Add(new SqlParameter("@ItemName", drainageDetail.ItemName));
cmd.Parameters.Add(new SqlParameter("@QuantityLiter", drainageDetail.QuantityLiter));
cmd.Parameters.Add(new SqlParameter("@Concentration", drainageDetail.Concentration));
cmd.Parameters.Add(new SqlParameter("@QuantityKg", drainageDetail.QuantityKg));
cmd.Parameters.Add(new SqlParameter("@ShiftCode", drainageDetail.ShiftCode));
cmd.Parameters.Add(new SqlParameter("@ShiftName", drainageDetail.ShiftName));
cmd.Parameters.Add(new SqlParameter("@PO", drainageDetail.PO));
cmd.Parameters.Add(new SqlParameter("@CardNo", drainageDetail.CardNo));
cmd.Parameters.Add(new SqlParameter("@Cost", drainageDetail.Cost));
cmd.Parameters.Add(new SqlParameter("@Rate", drainageDetail.Rate));
cmd.Parameters.Add(new SqlParameter("@ReasonID", drainageDetail.ReasonID));
cmd.Parameters.Add(new SqlParameter("@ReasonName", drainageDetail.ReasonName));
cmd.Parameters.Add(new SqlParameter("@Remark", drainageDetail.Remark));
cmd.Parameters.Add(new SqlParameter("@EntryBy", drainageDetail.EntryBy));
cmd.Parameters.Add(new SqlParameter("@EntryDate", drainageDetail.EntryDate));
cmd.Parameters.Add(new SqlParameter("@UpdateBy", drainageDetail.UpdateBy));
cmd.Parameters.Add(new SqlParameter("@UpdateDate", drainageDetail.UpdateDate));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public DyeingUtilityDrainageDetail SaveDrainageDetail(DyeingUtilityDrainageDetail drainageDetail)
{
return(dataService.SaveDrainageDetail(drainageDetail));
}
