public DyeingProcessHeadStock SaveHeadStock(DyeingProcessHeadStock headStock) { var res = new DyeingProcessHeadStock(); var dt = new DataTable(); try { dt = InserOrUpdateHeadStock("SP_INSERT_DYEING_PROCESS_HEAD_STOCK", "SAVE_HEAD_STOCK", headStock); 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 SaveHeadStock(DyeingProcessHeadStock headStock) { var user = (User)Session["CurrentUser"]; if (headStock != null) { if (headStock.ID == 0) { headStock.EntryBy = user.USERID; headStock.EntryDate = DateTime.Now; } else { headStock.UpdateBy = user.USERID; headStock.UpdateDate = DateTime.Now; } } var res = _dyeingUtilityRepo.SaveHeadStock(headStock); return(Json(res, JsonRequestBehavior.AllowGet)); }
public DataTable InserOrUpdateHeadStock(string procedure, string callname, DyeingProcessHeadStock headStock) { 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", headStock.ID)); cmd.Parameters.Add(new SqlParameter("@SetNo", headStock.SetNo)); cmd.Parameters.Add(new SqlParameter("@DividingTableTension", headStock.DividingTableTension)); cmd.Parameters.Add(new SqlParameter("@WindingTension", headStock.WindingTension)); cmd.Parameters.Add(new SqlParameter("@PressingTension", headStock.PressingTension)); cmd.Parameters.Add(new SqlParameter("@Moisture", headStock.Moisture)); cmd.Parameters.Add(new SqlParameter("@Remark", headStock.Remark)); cmd.Parameters.Add(new SqlParameter("@EntryBy", headStock.EntryBy)); cmd.Parameters.Add(new SqlParameter("@EntryDate", headStock.EntryDate)); cmd.Parameters.Add(new SqlParameter("@UpdateBy", headStock.UpdateBy)); cmd.Parameters.Add(new SqlParameter("@UpdateDate", headStock.UpdateDate)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }
public DyeingProcessHeadStock SaveHeadStock(DyeingProcessHeadStock headStock) { return(dataService.SaveHeadStock(headStock)); }