public long GenerateMR(PRPDBatch objPRPD) { MR objMR = new MR(); MRMaterialCollec objMRMatCollec = new MRMaterialCollec(); MRFinishProductCollec objMRFinishProductCollec = new MRFinishProductCollec(); MRBasicProductCollec objMRBasicProductCollec = new MRBasicProductCollec(); BatchMR objBatchMR = new BatchMR(); Department_DL objDepDL = new Department_DL(ConnectionStringClass.GetConnection()); MR_DL objMRDL = new MR_DL(ConnectionStringClass.GetConnection()); MRMaterial_DL objMRMaterialDL = new MRMaterial_DL(ConnectionStringClass.GetConnection()); Store_DL objStoreDL = new Store_DL(ConnectionStringClass.GetConnection()); try { objMR.MRDate = DateTime.Now; objMR.MRDepartmentFrom = objDepDL.GetByDepType("PRPD"); objMR.MREnterdBy = CurrentUser.EmployeeID; objMR.MRStatus = MR.Status.Initial; objMR.MRStore = objStore; objMR.MRType = MR.Type.Material; objMR.MRRemarks = "Material Requition(Materials) for PRPD Batch NO " + objPRPD.PRPDBatchID.ToString(); objMR.OriginType = MR.Origin.ToBatch; MRMaterial obj = new MRMaterial(); obj.Description = "PRPD Batch Material Requition"; obj.Material = objPRPD.PRPDBatchMaterial; obj.MRBINNo = ""; obj.ReqdQty = objPRPD.PRPDBatchQty; long MRNO = objMRDL.Add_M(objMR); if (MRNO > 0) { objMR.MRNO = MRNO; obj.MR = objMR; objMRMaterialDL.Add(obj); } return(MRNO); } catch (Exception ex) { return(0); } }
public MRFinishProductCollec Get(long MRNO) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", MRNO) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRFinishProducts_ByMRNO", paramList); MRFinishProductCollec objMRFinishProductCollec = new MRFinishProductCollec(); for (int i = 0; i < dt.Rows.Count; i++) { MRFinishProduct objMRFinishProduct = new MRFinishProduct(); objMRFinishProduct.FinishProduct = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[i]["MRFinishProductID"])); objMRFinishProduct.Description = Convert.ToString(dt.Rows[i]["MRDescription"]); objMRFinishProduct.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[i]["MRNO"])); objMRFinishProduct.MRBINNo = Convert.ToString(dt.Rows[i]["MRBINNo"]); objMRFinishProduct.ReqdQty = Convert.ToDecimal(dt.Rows[i]["ReqdQty"]); objMRFinishProduct.IssuedQty = Convert.ToDecimal(dt.Rows[i]["IssuedQty"]); objMRFinishProduct.UnitCode = "Nos"; if (dt.Rows[i]["MRUnitRate"] != DBNull.Value) { objMRFinishProduct.UniRate = Convert.ToDecimal(dt.Rows[i]["MRUnitRate"]); } else { objMRFinishProduct.UniRate = 0; } objMRFinishProductCollec.Add(objMRFinishProduct); } return(objMRFinishProductCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public MRFinishProductCollec Get() { try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRFinishProduct"); MRFinishProductCollec objMRFinishProductCollec = new MRFinishProductCollec(); for (int i = 0; i < dt.Rows.Count; i++) { MRFinishProduct objMRFinishProduct = new MRFinishProduct(); objMRFinishProduct.FinishProduct = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[i]["MRFinishProductID"])); objMRFinishProduct.Description = Convert.ToString(dt.Rows[i]["MRDescription"]); objMRFinishProduct.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[i]["MRIssuedQty"])); objMRFinishProduct.MRBINNo = Convert.ToString(dt.Rows[i]["MRIssuedQty"]); objMRFinishProduct.ReqdQty = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]); objMRFinishProduct.IssuedQty = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]); //objMRFinishProduct.UniRate = Convert.ToDecimal(dr.MRUnitRate); if (dt.Rows[i]["MRIssuedQty"] != null) { objMRFinishProduct.UniRate = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]); } else { objMRFinishProduct.UniRate = 0; } objMRFinishProductCollec.Add(objMRFinishProduct); } return(objMRFinishProductCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }