public DyeingProcessCompensator SaveCompensator(DyeingProcessCompensator compensator) { var res = new DyeingProcessCompensator(); var dt = new DataTable(); try { dt = InserOrUpdateCompensator("SP_INSERT_DYEING_PROCESS_COMPENSATOR", "SAVE_COMPENSATOR", compensator); 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 SaveCompensator(DyeingProcessCompensator compensator) { var user = (User)Session["CurrentUser"]; if (compensator != null) { if (compensator.ID == 0) { compensator.EntryBy = user.USERID; compensator.EntryDate = DateTime.Now; } else { compensator.UpdateBy = user.USERID; compensator.UpdateDate = DateTime.Now; } } var res = _dyeingUtilityRepo.SaveCompensator(compensator); return(Json(res, JsonRequestBehavior.AllowGet)); }
public DataTable InserOrUpdateCompensator(string procedure, string callname, DyeingProcessCompensator compensator) { 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", compensator.ID)); cmd.Parameters.Add(new SqlParameter("@SetNo", compensator.SetNo)); cmd.Parameters.Add(new SqlParameter("@HydrolicPressure", compensator.HydrolicPressure)); cmd.Parameters.Add(new SqlParameter("@Tension", compensator.Tension)); cmd.Parameters.Add(new SqlParameter("@Remark", compensator.Remark)); cmd.Parameters.Add(new SqlParameter("@EntryBy", compensator.EntryBy)); cmd.Parameters.Add(new SqlParameter("@EntryDate", compensator.EntryDate)); cmd.Parameters.Add(new SqlParameter("@UpdateBy", compensator.UpdateBy)); cmd.Parameters.Add(new SqlParameter("@UpdateDate", compensator.UpdateDate)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }
public DyeingProcessCompensator SaveCompensator(DyeingProcessCompensator compensator) { return(dataService.SaveCompensator(compensator)); }