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)); }