public DyeingProcessDyeingParameter SaveDyeingParameter(DyeingProcessDyeingParameter dyeingParameter) { var res = new DyeingProcessDyeingParameter(); var dt = new DataTable(); try { dt = InserOrUpdateDyeingParameter("SP_INSERT_DYEING_PROCESS_DYEING_PARAMETER", "SAVE_DYEING_PARAMETER", dyeingParameter); 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 SaveDyeingParameter(DyeingProcessDyeingParameter dyeingParameter) { var user = (User)Session["CurrentUser"]; if (dyeingParameter != null) { if (dyeingParameter.ID == 0) { dyeingParameter.EntryBy = user.USERID; dyeingParameter.EntryDate = DateTime.Now; } else { dyeingParameter.UpdateBy = user.USERID; dyeingParameter.UpdateDate = DateTime.Now; } } var res = _dyeingUtilityRepo.SaveDyeingParameter(dyeingParameter); return(Json(res, JsonRequestBehavior.AllowGet)); }
public DataTable InserOrUpdateDyeingParameter(string procedure, string callname, DyeingProcessDyeingParameter dyeingParameter) { 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", dyeingParameter.ID)); cmd.Parameters.Add(new SqlParameter("@SetNo", dyeingParameter.SetNo)); cmd.Parameters.Add(new SqlParameter("@BathNo", dyeingParameter.BathNo)); cmd.Parameters.Add(new SqlParameter("@BathInProcess", dyeingParameter.BathInProcess)); cmd.Parameters.Add(new SqlParameter("@Temperature", dyeingParameter.Temperature)); cmd.Parameters.Add(new SqlParameter("@SqueezePressure", dyeingParameter.SqueezePressure)); cmd.Parameters.Add(new SqlParameter("@Tension", dyeingParameter.Tension)); cmd.Parameters.Add(new SqlParameter("@WaterFlow", dyeingParameter.WaterFlow)); cmd.Parameters.Add(new SqlParameter("@Remark", dyeingParameter.Remark)); cmd.Parameters.Add(new SqlParameter("@EntryBy", dyeingParameter.EntryBy)); cmd.Parameters.Add(new SqlParameter("@EntryDate", dyeingParameter.EntryDate)); cmd.Parameters.Add(new SqlParameter("@UpdateBy", dyeingParameter.UpdateBy)); cmd.Parameters.Add(new SqlParameter("@UpdateDate", dyeingParameter.UpdateDate)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }
public DyeingProcessDyeingParameter SaveDyeingParameter(DyeingProcessDyeingParameter dyeingParameter) { return(dataService.SaveDyeingParameter(dyeingParameter)); }