public MTNMaterial Get(long MTNNO, String MaterialCode) { Material_DL objMaterial_DL = new Material_DL(Connection); MTN_DL objMTN_DL = new MTN_DL(Connection); MTNMaterial objMTNMaterial = new MTNMaterial(); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Original_MTNNO", MTNNO), new SqlParameter("@Original_MTNMaterialCode", MaterialCode) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPDELETE_MTNMaterial", paramList); objMTNMaterial.Material = objMaterial_DL.Get(Convert.ToString(dt.Rows[0]["MTNMaterialCode"])); objMTNMaterial.Batch = "No"; objMTNMaterial.Description = Convert.ToString(dt.Rows[0]["MTNDescription"]); objMTNMaterial.MTN = objMTN_DL.Get(Convert.ToInt64(dt.Rows[0]["MTNNO"])); objMTNMaterial.TransferQty = Convert.ToDecimal(dt.Rows[0]["MTNTransferQty"]); objMTNMaterial.UnitRate = Convert.ToDecimal(dt.Rows[0]["MTNUnitRate"]); objMTNMaterial.ReceivedQty = Convert.ToDecimal(dt.Rows[0]["ReceivedQty"]); return(objMTNMaterial); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public MaterialCollec Get(string MatMainType, string MatCategory) { try { Material_DL objMaterial_DL = new Material_DL(ConnectionStringClass.GetConnection()); SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MatMainType", MatMainType), new SqlParameter("@MatMainCategory", MatCategory) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MaterialByCategories"); MaterialCollec objMatCollec = new MaterialCollec(); for (int i = 0; i < dt.Rows.Count; i++) { Material objMaterial = new Material(); objMaterial.IsExport = Convert.ToBoolean(dt.Rows[i]["Export"]); objMaterial.IsLocal = Convert.ToBoolean(dt.Rows[i]["Local"]); objMaterial.IsSeasanal = Convert.ToBoolean(dt.Rows[i]["Seasanal"]); if (dt.Rows[i]["BasicMaterialCode"] != dt.Rows[i]["MaterialCode"]) { objMaterial.MatBasicMaterial = dt.Rows[i]["BasicMaterialCode"].ToString(); } objMaterial.MatBasicQty = Convert.ToDecimal(dt.Rows[i]["BasicQty"]); objMaterial.MatCost = Convert.ToDecimal(dt.Rows[i]["AVGCost"]); objMaterial.MateialType = objMaterialType_DL.Get(Convert.ToString(dt.Rows[i]["MatTypeID"])); objMaterial.MaterialMainType = Convert.ToString(dt.Rows[i]["MatMainType"]); objMaterial.MaterialCode = Convert.ToString(dt.Rows[i]["MaterialCode"]); objMaterial.MaterialDescription = Convert.ToString(dt.Rows[i]["MaterialDescription"]); objMaterial.MaterialStatus = Convert.ToInt32(dt.Rows[i]["Status"]); objMaterial.MaterialCategory = Convert.ToString(dt.Rows[i]["MatCatID"]); objMaterial.MatForm = objForm_DL.Get(Convert.ToInt64(dt.Rows[i]["ItemFormID"])); objMaterial.MatParticleSize = Convert.ToString(dt.Rows[i]["ParticalSize"]); objMaterial.MatSeasonFrom = Convert.ToString(dt.Rows[i]["SeasanFrom"]); objMaterial.MatSeasonTo = Convert.ToString(dt.Rows[i]["SeasanTo"]); objMaterial.MatUnit = objUnit_DL.Get(Convert.ToInt64(dt.Rows[i]["UnitID"])); objMatCollec.Add(objMaterial); } return(objMatCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public Material GetDryMaterial(String BasicMaterialCode) { try { Material_DL objMaterial_DL = new Material_DL(ConnectionStringClass.GetConnection()); SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MaterialCode", BasicMaterialCode) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_Material_Green_By_MaterialCode", paramList); Material objMaterial = new Material(); if (dt.Rows.Count > 0) { objMaterial.IsExport = Convert.ToBoolean(dt.Rows[0]["Export"]); objMaterial.IsLocal = Convert.ToBoolean(dt.Rows[0]["Local"]); objMaterial.IsSeasanal = Convert.ToBoolean(dt.Rows[0]["Seasanal"]); if (dt.Rows[0]["BasicMaterialCode"] != dt.Rows[0]["MaterialCode"]) { objMaterial.MatBasicMaterial = dt.Rows[0]["BasicMaterialCode"].ToString(); } objMaterial.MatBasicQty = Convert.ToDecimal(dt.Rows[0]["BasicQty"]); objMaterial.MatCost = Convert.ToDecimal(dt.Rows[0]["AVGCost"]); objMaterial.MateialType = objMaterialType_DL.Get(Convert.ToString(dt.Rows[0]["MatType"])); objMaterial.MaterialMainType = Convert.ToString(dt.Rows[0]["MatMainType"]); objMaterial.MaterialCode = Convert.ToString(dt.Rows[0]["MaterialCode"]); objMaterial.MaterialDescription = Convert.ToString(dt.Rows[0]["MaterialDescription"]); objMaterial.MaterialStatus = Convert.ToInt32(dt.Rows[0]["Status"]); objMaterial.MaterialCategory = Convert.ToString(dt.Rows[0]["MatCatID"]); objMaterial.MatForm = objForm_DL.Get(Convert.ToInt64(dt.Rows[0]["FormID"])); objMaterial.MatParticleSize = Convert.ToString(dt.Rows[0]["ParticalSize"]); objMaterial.MatSeasonFrom = Convert.ToString(dt.Rows[0]["SeasanFrom"]); objMaterial.MatSeasonTo = Convert.ToString(dt.Rows[0]["SeasanTo"]); objMaterial.MatUnit = objUnit_DL.Get(Convert.ToInt64(dt.Rows[0]["UnitID"])); objMaterial.MaterialCategory = Convert.ToString(dt.Rows[0]["UnitID"]); } return(objMaterial);; } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
//-- New - - public System.Data.DataTable GetDataViewByMTNNO(long MTNNO) { MTNMaterialCollc objMTNMaterialCollc = new MTNMaterialCollc(); Material_DL objMaterial_DL = new Material_DL(Connection); MTN_DL objMTN_DL = new MTN_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Original_MTNNO", MTNNO) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPDELETE_MTNMaterial", paramList); return(dt); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public Stock Get(long StockID) { Store_DL objStore_DL = new Store_DL(Connection); Material_DL objMaterial_DL = new Material_DL(Connection); BasicProduct_DL objBasicProduct_DL = new BasicProduct_DL(Connection); FinishProduct_DL objFinishProduct_DL = new FinishProduct_DL(Connection); Stock objStock = new Stock(); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@StockID", StockID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_StockByID", paramList); objStock.StockBasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[0]["StockBasicProduct"])); objStock.StockEconomicalQty = Convert.ToDecimal(dt.Rows[0]["StockEconomicalQty"]); objStock.StockFinishProduct = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[0]["StockFinishProduct"])); objStock.StockID = Convert.ToInt64(dt.Rows[0]["StockID"]); objStock.StockMaterial = objMaterial_DL.Get(Convert.ToString(dt.Rows[0]["StockMaterialID"])); objStock.StockMaximumQty = Convert.ToDecimal(dt.Rows[0]["StockMaximumQty"]); objStock.StockMinimumQty = Convert.ToDecimal(dt.Rows[0]["StockMinimumQty"]); objStock.StockQty = Convert.ToDecimal(dt.Rows[0]["StockQty"]); objStock.StockReorderLevel = Convert.ToDecimal(dt.Rows[0]["StockReorderLevel"]); objStock.StockReservedQty = Convert.ToDecimal(dt.Rows[0]["StockReservedQty"]); objStock.StockStatus = (Stock.Status)(dt.Rows[0]["StockStatus"]); objStock.StockStore = objStore_DL.Get(Convert.ToString(dt.Rows[0]["StoreID"])); objStock.StockType = (Stock.Type)(dt.Rows[0]["StockType"]); return(objStock); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }