public DyeingUtilityWastageDetail SaveWastageDetail(DyeingUtilityWastageDetail wastageDetail) { var res = new DyeingUtilityWastageDetail(); var dt = new DataTable(); try { dt = InserOrUpdateWastageDetail("SP_INSERT_DYEING_UTILITY_WASTAGE_DETAIL", "SAVE_WASTAGE_DETAIL", wastageDetail); 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 SaveWastageDetail(DyeingUtilityWastageDetail wastageDetail) { var user = (User)Session["CurrentUser"]; if (wastageDetail != null) { if (wastageDetail.ID == 0) { wastageDetail.EntryBy = user.USERID; wastageDetail.EntryDate = DateTime.Now; } else { wastageDetail.UpdateBy = user.USERID; wastageDetail.UpdateDate = DateTime.Now; } } var res = _dyeingUtilityRepo.SaveWastageDetail(wastageDetail); return(Json(res, JsonRequestBehavior.AllowGet)); }
public DataTable InserOrUpdateWastageDetail(string procedure, string callname, DyeingUtilityWastageDetail wastageDetail) { 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", wastageDetail.ID)); cmd.Parameters.Add(new SqlParameter("@SetNo", wastageDetail.SetNo)); cmd.Parameters.Add(new SqlParameter("@WastageTypeID", wastageDetail.WastageTypeID)); cmd.Parameters.Add(new SqlParameter("@WastageTypeName", wastageDetail.WastageTypeName)); cmd.Parameters.Add(new SqlParameter("@QuantityKg", wastageDetail.QuantityKg)); cmd.Parameters.Add(new SqlParameter("@Remark", wastageDetail.Remark)); cmd.Parameters.Add(new SqlParameter("@EntryBy", wastageDetail.EntryBy)); cmd.Parameters.Add(new SqlParameter("@EntryDate", wastageDetail.EntryDate)); cmd.Parameters.Add(new SqlParameter("@UpdateBy", wastageDetail.UpdateBy)); cmd.Parameters.Add(new SqlParameter("@UpdateDate", wastageDetail.UpdateDate)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }
public DyeingUtilityWastageDetail SaveWastageDetail(DyeingUtilityWastageDetail wastageDetail) { return(dataService.SaveWastageDetail(wastageDetail)); }