public JsonResult SaveInspectionProductionDetail(TblStock21 productionDetail) { if (productionDetail != null) { var user = (User)Session["CurrentUser"]; productionDetail.UserName = user.USERNAME; productionDetail.EDate = DateTime.Now; } var res = _repository.SaveInspectionProductionDetail(productionDetail); return(Json(res, JsonRequestBehavior.AllowGet)); }
public TblStock21 SaveInspectionProductionDetail(TblStock21 productionDetail) { var res = new TblStock21(); var dt = new DataTable(); try { dt = InsertOrUpdateInspectionProductionDetail("SP_INSERT_INSPECTION_PRODUCTION_PRODUCTION_INFO", "SAVE_INSPECTION_PRODUCTION", productionDetail); res.SaveStatus = Operation.Success.ToString(); res.DID = Convert.ToInt32(dt.Rows[0]["DID"].ToString()); } catch (Exception ex) { res.SaveStatus = ex.Message; } return(res); }
public TblStock21 SaveInspectionProductionDetail(TblStock21 productionDetail) { return(_service.SaveInspectionProductionDetail(productionDetail)); }
public DataTable InsertOrUpdateInspectionProductionDetail(string procedure, string callname, TblStock21 productionDetail) { 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("@DID", productionDetail.DID)); cmd.Parameters.Add(new SqlParameter("@ID", productionDetail.ID)); cmd.Parameters.Add(new SqlParameter("@StyleCode", productionDetail.StyleCode)); cmd.Parameters.Add(new SqlParameter("@StyleNo", productionDetail.StyleNo)); cmd.Parameters.Add(new SqlParameter("@Weight", productionDetail.Weight)); cmd.Parameters.Add(new SqlParameter("@Constraction", productionDetail.Constraction)); cmd.Parameters.Add(new SqlParameter("@Weave", productionDetail.Weave)); cmd.Parameters.Add(new SqlParameter("@Colour", productionDetail.Colour)); cmd.Parameters.Add(new SqlParameter("@Width", productionDetail.Width)); cmd.Parameters.Add(new SqlParameter("@QCode", productionDetail.QCode)); cmd.Parameters.Add(new SqlParameter("@FabQuality", productionDetail.FabQuality)); cmd.Parameters.Add(new SqlParameter("@Prod", productionDetail.Prod)); cmd.Parameters.Add(new SqlParameter("@FabReturn", productionDetail.FabReturn)); cmd.Parameters.Add(new SqlParameter("@Remarks", productionDetail.Remarks)); cmd.Parameters.Add(new SqlParameter("@CCode", productionDetail.CCode)); cmd.Parameters.Add(new SqlParameter("@CName", productionDetail.CName)); cmd.Parameters.Add(new SqlParameter("@TotalRoll", productionDetail.TotalRoll)); cmd.Parameters.Add(new SqlParameter("@TotalPoint", productionDetail.TotalPoint)); cmd.Parameters.Add(new SqlParameter("@SetNo", productionDetail.SetNo)); cmd.Parameters.Add(new SqlParameter("@SS", productionDetail.SS)); cmd.Parameters.Add(new SqlParameter("@Loom", productionDetail.Loom)); cmd.Parameters.Add(new SqlParameter("@Beam", productionDetail.Beam)); cmd.Parameters.Add(new SqlParameter("@ProdB", productionDetail.ProdB)); cmd.Parameters.Add(new SqlParameter("@ProdC", productionDetail.ProdC)); cmd.Parameters.Add(new SqlParameter("@CutPieece", productionDetail.CutPieece)); cmd.Parameters.Add(new SqlParameter("@Wastage", productionDetail.Wastage)); cmd.Parameters.Add(new SqlParameter("@ProdG", productionDetail.ProdG)); cmd.Parameters.Add(new SqlParameter("@TotalProd", productionDetail.TotalProd)); cmd.Parameters.Add(new SqlParameter("@FCode", productionDetail.FCode)); cmd.Parameters.Add(new SqlParameter("@FType", productionDetail.FType)); cmd.Parameters.Add(new SqlParameter("@UserName", productionDetail.UserName)); cmd.Parameters.Add(new SqlParameter("@EDate", productionDetail.EDate)); cmd.Parameters.Add(new SqlParameter("@PType", productionDetail.PType)); cmd.Parameters.Add(new SqlParameter("@PCode", productionDetail.PCode)); cmd.Parameters.Add(new SqlParameter("@UCode", productionDetail.UCode)); cmd.Parameters.Add(new SqlParameter("@UName", productionDetail.UName)); cmd.Parameters.Add(new SqlParameter("@FinishMCName", productionDetail.FinishMCName)); cmd.Parameters.Add(new SqlParameter("@FinishMCCode", productionDetail.FinishMCCode)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }