Esempio n. 1
0
        public Style SaveStyleInfo(Style objStyle, StyleParamFinish objFinParam, StyleParamGrey objGreyParam, StyleParamFabric objFabParam)
        {
            var res = new Style();

            if (!CheckIsExist(objStyle.StyleCode, objStyle.StyleNo))
            {
                res = _styleInfoDataService.SaveStyleInfo(objStyle, objFinParam, objGreyParam, objFabParam);
            }
            else
            {
                res.SaveStatus = Operation.Exists.ToString();
            }
            return(res);
        }
Esempio n. 2
0
        public Style SaveStyleInfo(Style objStyle, StyleParamFinish objFinParam, StyleParamGrey objGreyParam, StyleParamFabric objFabParam)
        {
            var rv = new Style();

            try
            {
                _dt           = new DataTable();
                _dt           = Insert_Update_StyleInfo("sp_insert_style_info", "savestyleinfo", objStyle, objFinParam, objGreyParam, objFabParam);
                rv.SID        = Convert.ToInt32(_dt.Rows[0]["SID"].ToString());
                rv.SaveStatus = Operation.Success.ToString();
            }
            catch (Exception ex)
            {
                rv.SaveStatus = ex.Message;
            }
            return(rv);
        }
Esempio n. 3
0
        public ActionResult SaveStyleInfo(Style objStyle, StyleParamFinish objFinParam, StyleParamGrey objGreyParam, StyleParamFabric objFabParam)
        {
            //int ucode;
            var user = (User)Session["CurrentUser"];

            objStyle.UserId    = user.EMPID;
            objStyle.TermId    = user.TermID;
            objStyle.EntryDate = DateTime.Now;

            var res = _styleInfoRepository.SaveStyleInfo(objStyle, objFinParam, objGreyParam, objFabParam);

            return(Json(res, JsonRequestBehavior.AllowGet));
        }
Esempio n. 4
0
        public DataTable Insert_Update_StyleInfo(string procedure, string callname, Style objStyle, StyleParamFinish objFinParam, StyleParamGrey objGreyParam, StyleParamFabric objFabParam)
        {
            _dbConn = new SqlConnection(_connectionString);
            _dbConn.Open();
            _cmd = new SqlCommand(procedure, _dbConn)
            {
                CommandType = CommandType.StoredProcedure
            };

            _cmd.Parameters.Add(new SqlParameter("@call_name", callname));
            _cmd.Parameters.Add(new SqlParameter("@p_SID", objStyle.SID));
            _cmd.Parameters.Add(new SqlParameter("@p_UCode", objStyle.UCode));
            _cmd.Parameters.Add(new SqlParameter("@p_FabTypeCode", objStyle.FabricTypeCode));
            _cmd.Parameters.Add(new SqlParameter("@p_DevolopmentDate", objStyle.DevolopmentDate));
            _cmd.Parameters.Add(new SqlParameter("@p_PDNo", objStyle.PDNo));
            _cmd.Parameters.Add(new SqlParameter("@p_StyleNo", objStyle.StyleNo));
            _cmd.Parameters.Add(new SqlParameter("@p_StyleCode", objStyle.StyleCode));
            _cmd.Parameters.Add(new SqlParameter("@p_Weight", objStyle.Weight));
            _cmd.Parameters.Add(new SqlParameter("@p_Width", objStyle.Width));
            _cmd.Parameters.Add(new SqlParameter("@p_Shrinkage", objStyle.Shrinkage));
            _cmd.Parameters.Add(new SqlParameter("@p_Construction", objStyle.Construction));
            _cmd.Parameters.Add(new SqlParameter("@p_FConstruction", objStyle.FConstruction));
            _cmd.Parameters.Add(new SqlParameter("@p_YarnCode", objStyle.YarnCode));
            _cmd.Parameters.Add(new SqlParameter("@p_FabricDesc", objStyle.FabricDesc));
            _cmd.Parameters.Add(new SqlParameter("@p_FinishingRoute", objStyle.FinishingRoute));
            _cmd.Parameters.Add(new SqlParameter("@p_WarpRatio", objStyle.WarpRatio));
            _cmd.Parameters.Add(new SqlParameter("@p_WeftRatio", objStyle.WeftRatio));
            _cmd.Parameters.Add(new SqlParameter("@p_TEnds", objStyle.TEnds));
            _cmd.Parameters.Add(new SqlParameter("@p_Weave", objStyle.Weave));
            _cmd.Parameters.Add(new SqlParameter("@p_SetStd", objStyle.SetStd));
            _cmd.Parameters.Add(new SqlParameter("@p_ColorId", objStyle.ColorId));
            _cmd.Parameters.Add(new SqlParameter("@p_ShadeIndigo", objStyle.ShadeIndigo));
            _cmd.Parameters.Add(new SqlParameter("@p_ShadeBlack", objStyle.ShadeBlack));
            _cmd.Parameters.Add(new SqlParameter("@p_WarpSupp", objStyle.WarpSupp));
            _cmd.Parameters.Add(new SqlParameter("@p_WarpLot", objStyle.WarpLot));
            _cmd.Parameters.Add(new SqlParameter("@p_WeftSupp", objStyle.WeftSupp));
            _cmd.Parameters.Add(new SqlParameter("@p_WeftLot", objStyle.WeftLot));
            _cmd.Parameters.Add(new SqlParameter("@p_BuyerRef", objStyle.BuyerRef));
            _cmd.Parameters.Add(new SqlParameter("@p_GreadCode", objStyle.GreadCode));
            _cmd.Parameters.Add(new SqlParameter("@p_PYear", objStyle.PYear));
            _cmd.Parameters.Add(new SqlParameter("@p_Unit", objStyle.Unit));
            _cmd.Parameters.Add(new SqlParameter("@p_HSCode", objStyle.HSCode));
            _cmd.Parameters.Add(new SqlParameter("@p_SRate", objStyle.SRate));
            _cmd.Parameters.Add(new SqlParameter("@p_Rate1", objStyle.Rate1));
            _cmd.Parameters.Add(new SqlParameter("@p_StatusCode", objStyle.StatusCode));
            _cmd.Parameters.Add(new SqlParameter("@p_Trace", objStyle.Trace));
            _cmd.Parameters.Add(new SqlParameter("@p_Remarks", objStyle.Remarks));
            _cmd.Parameters.Add(new SqlParameter("@p_EntryDate", objStyle.EntryDate));
            _cmd.Parameters.Add(new SqlParameter("@p_FG", objStyle.FG));
            _cmd.Parameters.Add(new SqlParameter("@p_WarpCons", objStyle.WarpCons));
            _cmd.Parameters.Add(new SqlParameter("@p_WeftCons", objStyle.WeftCons));
            _cmd.Parameters.Add(new SqlParameter("@p_CheCons", objStyle.CheCons));
            _cmd.Parameters.Add(new SqlParameter("@p_RPM", objStyle.RPM));
            _cmd.Parameters.Add(new SqlParameter("@p_Effi", objStyle.Effi));
            _cmd.Parameters.Add(new SqlParameter("@p_FCode", objStyle.FinishTypeCode));
            _cmd.Parameters.Add(new SqlParameter("@p_CSV", objStyle.CSV));
            _cmd.Parameters.Add(new SqlParameter("@p_SpecialityCode", objStyle.SpecialityCode));
            _cmd.Parameters.Add(new SqlParameter("@p_CutableWidth", objStyle.CutableWidth));
            _cmd.Parameters.Add(new SqlParameter("@p_StdCrimp", objStyle.StdCrimp));
            _cmd.Parameters.Add(new SqlParameter("@p_StdShrink", objStyle.StdShrink));
            _cmd.Parameters.Add(new SqlParameter("@p_UserId", objStyle.UserId));
            _cmd.Parameters.Add(new SqlParameter("@p_TermId", objStyle.TermId));

            //---------------Finish Param-----------------------------------------------
            _cmd.Parameters.Add(new SqlParameter("@p_WarpShrinkage", objFinParam.WarpShrinkage));
            _cmd.Parameters.Add(new SqlParameter("@p_WeftShrinkage", objFinParam.WeftShrinkage));
            _cmd.Parameters.Add(new SqlParameter("@p_WeightFinish", objFinParam.WeightFinish));
            _cmd.Parameters.Add(new SqlParameter("@p_WeightWash", objFinParam.WeightWash));
            _cmd.Parameters.Add(new SqlParameter("@p_Skew", objFinParam.Skew));
            _cmd.Parameters.Add(new SqlParameter("@p_Movement", objFinParam.Movement));
            _cmd.Parameters.Add(new SqlParameter("@p_StretchAbblity", objFinParam.StretchAbblity));
            _cmd.Parameters.Add(new SqlParameter("@p_Growth", objFinParam.Growth));
            _cmd.Parameters.Add(new SqlParameter("@p_Recovery", objFinParam.Recovery));
            _cmd.Parameters.Add(new SqlParameter("@p_RemarksFin", objFinParam.Remarks));
            _cmd.Parameters.Add(new SqlParameter("@p_ShirnkEnzyme", objFinParam.ShirnkEnzyme));
            _cmd.Parameters.Add(new SqlParameter("@p_ShrinkBleach", objFinParam.ShrinkBleach));

            //---------------Grey Param-----------------------------------------------
            _cmd.Parameters.Add(new SqlParameter("@p_GreyShrinkageWarp", objGreyParam.GreyShrinkageWarp));
            _cmd.Parameters.Add(new SqlParameter("@p_GreyShrinkageWeft", objGreyParam.GreyShrinkageWeft));
            _cmd.Parameters.Add(new SqlParameter("@p_GreyWeigth", objGreyParam.GreyWeigth));
            _cmd.Parameters.Add(new SqlParameter("@p_GreyWashWeigth", objGreyParam.GreyWashWeigth));
            _cmd.Parameters.Add(new SqlParameter("@p_GreySkew", objGreyParam.GreySkew));
            _cmd.Parameters.Add(new SqlParameter("@p_GreyStretchAbblity", objGreyParam.GreyStretchAbblity));
            _cmd.Parameters.Add(new SqlParameter("@p_GreyWidth", objGreyParam.GreyWidth));
            _cmd.Parameters.Add(new SqlParameter("@p_GEPI", objGreyParam.GEPI));
            _cmd.Parameters.Add(new SqlParameter("@p_GPPI", objGreyParam.GPPI));
            _cmd.Parameters.Add(new SqlParameter("@p_RemarksGrey", objGreyParam.Remarks));
            _cmd.Parameters.Add(new SqlParameter("@p_RPMGrey", objGreyParam.RPM));
            _cmd.Parameters.Add(new SqlParameter("@p_EffiGrey", objGreyParam.Effi));
            _cmd.Parameters.Add(new SqlParameter("@p_Crime", objGreyParam.Crime));
            _cmd.Parameters.Add(new SqlParameter("@p_ReedSpaceGrey", objGreyParam.ReedSpace));
            _cmd.Parameters.Add(new SqlParameter("@p_ReedCount", objGreyParam.ReedCount));
            _cmd.Parameters.Add(new SqlParameter("@p_EndsDent", objGreyParam.EndsDent));

            //---------------Fabric Param-----------------------------------------------
            _cmd.Parameters.Add(new SqlParameter("@p_TensileStrengthWarp", objFabParam.TensileStrengthWarp));
            _cmd.Parameters.Add(new SqlParameter("@p_TensileStrengthWeft", objFabParam.TensileStrengthWeft));
            _cmd.Parameters.Add(new SqlParameter("@p_TearingStrengthWarp", objFabParam.TearingStrengthWarp));
            _cmd.Parameters.Add(new SqlParameter("@p_TearingStrengthWeft", objFabParam.TearingStrengthWeft));
            _cmd.Parameters.Add(new SqlParameter("@p_CrockingFastnessDry", objFabParam.CrockingFastnessDry));
            _cmd.Parameters.Add(new SqlParameter("@p_CrockingFastnessWeft", objFabParam.CrockingFastnessWeft));
            _cmd.Parameters.Add(new SqlParameter("@p_ColourFastnessWash", objFabParam.ColourFastnessWash));
            _cmd.Parameters.Add(new SqlParameter("@p_ColourFastnessAcetate", objFabParam.ColourFastnessAcetate));
            _cmd.Parameters.Add(new SqlParameter("@p_ColourFastnessCotton", objFabParam.ColourFastnessCotton));
            _cmd.Parameters.Add(new SqlParameter("@p_ColourFastnessNylon", objFabParam.ColourFastnessNylon));
            _cmd.Parameters.Add(new SqlParameter("@p_ColourFastnessPolyster", objFabParam.ColourFastnessPolyster));
            _cmd.Parameters.Add(new SqlParameter("@p_ColourFastnessAcrylic", objFabParam.ColourFastnessAcrylic));
            _cmd.Parameters.Add(new SqlParameter("@p_ColourFastnessWool", objFabParam.ColourFastnessWool));
            _cmd.Parameters.Add(new SqlParameter("@p_PH", objFabParam.PH));
            _cmd.Parameters.Add(new SqlParameter("@p_Moisture", objFabParam.Moisture));
            _cmd.Parameters.Add(new SqlParameter("@p_Steffness", objFabParam.Steffness));
            _cmd.Parameters.Add(new SqlParameter("@p_PickEffi", objFabParam.PickEffi));
            _cmd.Parameters.Add(new SqlParameter("@p_RPMFab", objFabParam.RPM));
            _cmd.Parameters.Add(new SqlParameter("@p_ValueLoss", objFabParam.ValueLoss));
            _cmd.Parameters.Add(new SqlParameter("@p_RemarksFab", objFabParam.Remarks));
            _cmd.Parameters.Add(new SqlParameter("@p_ReedSpaceFab", objFabParam.ReedSpace));

            _da = new SqlDataAdapter(_cmd);
            _dt = new DataTable();
            _da.Fill(_dt);
            _dbConn.Close();
            return(_dt);
        }