public ActionResult SaveWarpingProdInfo(WarpingProdInfo objWarp, List <WarpingProdDetails> objWarpDetails) { var user = (User)Session["CurrentUser"]; objWarp.UserId = user.EMPID; objWarp.TermId = user.TermID; objWarp.EDate = DateTime.Now; var res = _warpingProductionRepo.SaveWarpingProdInfo(objWarp, objWarpDetails); return(Json(res, JsonRequestBehavior.AllowGet)); }
public WarpingProdInfo SaveWarpingProdInfo(WarpingProdInfo objWarp, DataSet dsWarpDetails) { var res = new WarpingProdInfo(); var dt = new DataTable(); try { dt = Insert_Update_WarpingProductionInfo("sp_insert_warping_production_info", "save_warping_production_info", objWarp, dsWarpDetails); res.SaveStatus = Operation.Success.ToString(); res.IdNo = Convert.ToInt32(dt.Rows[0]["IdNo"].ToString()); } catch (Exception ex) { res.SaveStatus = ex.Message; } return(res); }
public DataTable Insert_Update_WarpingProductionInfo(string procedure, string callname, WarpingProdInfo objWarp, DataSet rqdXmlv1 = null) { 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("@dsxmlu1", SqlDbType.Xml).Value = (rqdXmlv1 == null ? null : rqdXmlv1.GetXml()); cmd.Parameters.Add(new SqlParameter("@p_IdNo", objWarp.IdNo)); cmd.Parameters.Add(new SqlParameter("@p_PWarpDate", objWarp.PWarpDate.ToString("dd-MMM-yyyy"))); cmd.Parameters.Add(new SqlParameter("@p_WarpLength", objWarp.WarpLength)); cmd.Parameters.Add(new SqlParameter("@p_Remarks", objWarp.Remarks)); cmd.Parameters.Add(new SqlParameter("@p_SetNo", objWarp.SetNo)); cmd.Parameters.Add(new SqlParameter("@p_EndsPerBeam", objWarp.EndsPerBeam)); cmd.Parameters.Add(new SqlParameter("@p_TotalBeam", objWarp.TotalBeam)); cmd.Parameters.Add(new SqlParameter("@p_NoOfBeam", objWarp.NoOfBeam)); cmd.Parameters.Add(new SqlParameter("@p_TotalCreal", objWarp.TotalCreal)); cmd.Parameters.Add(new SqlParameter("@p_NoOfCreal", objWarp.NoOfCreal)); cmd.Parameters.Add(new SqlParameter("@p_TotalEnds", objWarp.TotalEnds)); cmd.Parameters.Add(new SqlParameter("@p_MSpeed", objWarp.MSpeed)); cmd.Parameters.Add(new SqlParameter("@p_YarnTension", objWarp.YarnTension)); cmd.Parameters.Add(new SqlParameter("@p_ProcessingForce", objWarp.ProcessingForce)); cmd.Parameters.Add(new SqlParameter("@p_Code", objWarp.Code)); cmd.Parameters.Add(new SqlParameter("@p_LengthMtr", objWarp.LengthMtr)); cmd.Parameters.Add(new SqlParameter("@p_DeptCode", objWarp.DeptCode)); cmd.Parameters.Add(new SqlParameter("@p_WarpRatio", objWarp.WarpRatio)); cmd.Parameters.Add(new SqlParameter("@p_ProYarnLot", objWarp.ProYarnLot)); cmd.Parameters.Add(new SqlParameter("@p_ProYarnSupp", objWarp.ProYarnSupp)); cmd.Parameters.Add(new SqlParameter("@p_StyleNo", objWarp.StyleNo)); cmd.Parameters.Add(new SqlParameter("@p_StyleCode", objWarp.StyleCode)); cmd.Parameters.Add(new SqlParameter("@p_Construction", objWarp.Construction)); cmd.Parameters.Add(new SqlParameter("@p_Width", objWarp.Width)); cmd.Parameters.Add(new SqlParameter("@p_PTCode", objWarp.PTCode)); cmd.Parameters.Add(new SqlParameter("@p_CustCode", objWarp.CustCode)); cmd.Parameters.Add(new SqlParameter("@p_MCNo", objWarp.MCNo)); cmd.Parameters.Add(new SqlParameter("@p_MCCode", objWarp.MCCode)); cmd.Parameters.Add(new SqlParameter("@p_UCode", objWarp.UCode)); cmd.Parameters.Add(new SqlParameter("@p_YarnCounts", objWarp.YarnCounts)); cmd.Parameters.Add(new SqlParameter("@p_UserId", objWarp.UserId)); cmd.Parameters.Add(new SqlParameter("@p_TermId", objWarp.TermId)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }
public WarpingProdInfo SaveWarpingProdInfo(WarpingProdInfo objWarp, List <WarpingProdDetails> objWarpDetails) { //-------------------Warping Production Details information------------------------------------------ var rv = new WarpingProdInfo(); var res = CheckIsExistSetNo(objWarp.IdNo, objWarp.SetNo); if (!res) { var wpDetailsDt = new DataTable(); wpDetailsDt.Columns.Add("WARPDATE"); wpDetailsDt.Columns.Add("FLANGENO"); wpDetailsDt.Columns.Add("FLANGELENGTH"); wpDetailsDt.Columns.Add("WEAKPOINT"); wpDetailsDt.Columns.Add("SPILER"); wpDetailsDt.Columns.Add("SNARL"); wpDetailsDt.Columns.Add("DOUBLEYARN"); wpDetailsDt.Columns.Add("DUETOMACHINE"); wpDetailsDt.Columns.Add("DUETOCONE"); wpDetailsDt.Columns.Add("BADWDG"); wpDetailsDt.Columns.Add("TOTALYARNBKG"); wpDetailsDt.Columns.Add("TERMINATION"); wpDetailsDt.Columns.Add("TOTAL"); wpDetailsDt.Columns.Add("REMNANTPERCREEL"); wpDetailsDt.Columns.Add("WASTAGEPCREEL"); wpDetailsDt.Columns.Add("OPERATORCARDNO"); wpDetailsDt.Columns.Add("SHIFTCODE"); wpDetailsDt.Columns.Add("SHIFTTIME"); wpDetailsDt.Columns.Add("DESIGNATION"); wpDetailsDt.Columns.Add("ICODE"); wpDetailsDt.Columns.Add("UNIT"); wpDetailsDt.Columns.Add("ICOUNT"); wpDetailsDt.Columns.Add("ENDSBEAM"); wpDetailsDt.Columns.Add("BEAMKG"); wpDetailsDt.Columns.Add("SCODE"); wpDetailsDt.Columns.Add("YARNCODE"); wpDetailsDt.Columns.Add("YARNLOT"); wpDetailsDt.Columns.Add("BREAKAGEPOINT"); wpDetailsDt.Columns.Add("MSPEED"); wpDetailsDt.Columns.Add("MEFFI"); wpDetailsDt.Columns.Add("INTAKE"); wpDetailsDt.Columns.Add("REMINENT"); wpDetailsDt.Columns.Add("RECONE"); wpDetailsDt.Columns.Add("WEASTAGE"); wpDetailsDt.Columns.Add("IQNTY"); wpDetailsDt.Columns.Add("RATE"); wpDetailsDt.Columns.Add("BEAMVALUE"); wpDetailsDt.Columns.Add("WASTAGEVALUE"); wpDetailsDt.Columns.Add("STDBRKG"); wpDetailsDt.Columns.Add("BRUNTIME"); wpDetailsDt.Columns.Add("CAPCODE"); wpDetailsDt.Columns.Add("LAPPER"); if (objWarpDetails != null && objWarpDetails.Count > 0) { foreach (var warp in objWarpDetails) { DataRow row1; row1 = wpDetailsDt.NewRow(); row1["WARPDATE"] = warp.WarpDate; row1["FLANGENO"] = warp.FlangeNo; row1["FLANGELENGTH"] = warp.FlangeLength; row1["WEAKPOINT"] = warp.WeakPoint; row1["SPILER"] = warp.Spiler; row1["SNARL"] = warp.Snarl; row1["DOUBLEYARN"] = warp.DoubleYarn; row1["DUETOMACHINE"] = warp.DueToMachine; row1["DUETOCONE"] = warp.DueToCone; row1["BADWDG"] = warp.BadWdg; row1["TOTALYARNBKG"] = warp.TotalYarnBkg; row1["TERMINATION"] = warp.Termination; row1["TOTAL"] = warp.Total; row1["REMNANTPERCREEL"] = warp.RemnantPerCreel; row1["WASTAGEPCREEL"] = warp.WastagePCreel; row1["OPERATORCARDNO"] = warp.OperatorCardNo; row1["SHIFTCODE"] = warp.ShiftCode; row1["SHIFTTIME"] = warp.ShiftTime; row1["DESIGNATION"] = warp.Designation; row1["ICODE"] = warp.ICode; row1["UNIT"] = warp.Unit; row1["ICOUNT"] = warp.ICount; row1["ENDSBEAM"] = warp.EndsBeam; row1["BEAMKG"] = warp.BeamKg; row1["SCODE"] = warp.SCode; row1["YARNCODE"] = warp.YarnCode; row1["YARNLOT"] = warp.YarnLot; row1["BREAKAGEPOINT"] = warp.BreakagePoint; row1["MSPEED"] = warp.MSpeed; row1["MEFFI"] = warp.MEffi; row1["INTAKE"] = warp.Intake; row1["REMINENT"] = warp.Reminent; row1["RECONE"] = warp.Recone; row1["WEASTAGE"] = warp.Weastage; row1["IQNTY"] = warp.IQnty; row1["RATE"] = warp.Rate; row1["BEAMVALUE"] = warp.BeamValue; row1["WASTAGEVALUE"] = warp.WastageValue; row1["STDBRKG"] = warp.StdBrkg; row1["BRUNTIME"] = warp.BRunTime; row1["CAPCODE"] = warp.CapCode; row1["LAPPER"] = warp.Lapper; wpDetailsDt.Rows.Add(row1); } } wpDetailsDt.TableName = "tblwpDetails"; DataSet dsWarpDetails = new DataSet("dsLcDetails"); dsWarpDetails.Tables.Add(wpDetailsDt); return(_WarpingProductionDataService.SaveWarpingProdInfo(objWarp, dsWarpDetails)); } else { rv.SaveStatus = Operation.Exists.ToString(); return(rv); } }