public GRN Get(long GRNNO) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@GRNNO", GRNNO) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRNByID", paramList); GRN objGRN = new GRN(); objGRN.GRNApprovedBy = Convert.ToString(dt.Rows[0]["GRNApprovedBy"]); objGRN.GRNApprovedDate = Convert.ToDateTime(dt.Rows[0]["GRNApproveDate"]); objGRN.GRNDate = Convert.ToDateTime(dt.Rows[0]["GRNDate"]); objGRN.GRNEnterdBy = Convert.ToString(dt.Rows[0]["GRNEnterdBy"]); objGRN.GRNMR = Convert.ToInt64(dt.Rows[0]["GRNMRNO"]); objGRN.GRNMTNNo = Convert.ToInt64(dt.Rows[0]["GRNMTNNO"]); objGRN.GRNNo = Convert.ToInt64(dt.Rows[0]["GRNNO"]); objGRN.GRNRPDBatch = null; objGRN.GRNStore = objStore_DL.Get(Convert.ToString(dt.Rows[0]["GRNStoreID"])); objGRN.DeliverNoteID = Convert.ToString(dt.Rows[0]["DeliverNoteID"]); return(objGRN); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public MTNCollec Get(long FromDepID, MTN.Status Status) { Employee_DL objEmployee_DL = new Employee_DL(Connection); Department_DL objDepartment_DL = new Department_DL(Connection); MTNCollec objMTNCollec = new MTNCollec(); Store_DL objStore_DL = new Store_DL(Connection); GRN_DL objGRN_DL = new GRN_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@DepID", FromDepID), new SqlParameter("@MTNStatus", Status) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTN_ByFromDep_Status", paramList); for (int i = 0; i < dt.Rows.Count; i++) { MTN objMTN = new MTN(); objMTN.MTNApprovedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["MTNApprovedBy"])); objMTN.MTNApprovedDate = Convert.ToDateTime(dt.Rows[i]["MTNApproveDate"]); objMTN.MTNBatch = "No"; objMTN.MTNDate = Convert.ToDateTime(dt.Rows[i]["MTNDate"]); objMTN.MTNDepartmentFrom = objDepartment_DL.Get(Convert.ToInt64(dt.Rows[i]["MTNFromDepID"])); objMTN.MTNDepartmentTo = objDepartment_DL.Get(Convert.ToInt64(dt.Rows[i]["MTNToDepID"])); objMTN.MTNEnterdBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["MTNEnterdBy"])); objMTN.MTNNo = Convert.ToInt64(dt.Rows[i]["MTNNo"]); objMTN.MTNReceivedBy = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["MTNReceivedBy"])); objMTN.MTNReceivedDate = Convert.ToDateTime(dt.Rows[i]["MTNReceivedDate"]); objMTN.MTNStatus = (MTN.Status)dt.Rows[i]["MTNStatus"]; objMTN.MTNType = (MTN.Type)dt.Rows[i]["MTNType"]; objMTN.MTNItemType = (MTN.ItemType)dt.Rows[i]["MTNItemType"]; objMTN.MTNStore = objStore_DL.Get(Convert.ToString(dt.Rows[i]["MTNStore"])); objMTNCollec.Add(objMTN); } return(objMTNCollec); } 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); } }
public MR Get(long MRNO) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", MRNO) }; MR objMR = new MR(); DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRByID", paramList); if (dt.Rows.Count > 0) { if (dt.Rows[0]["MRApprovedBy"] != null) { objMR.MRApprovedBy = Convert.ToString(dt.Rows[0]["MRApprovedBy"]); } if (dt.Rows[0]["MRApproveDate"] != null) { objMR.MRApprovedDate = Convert.ToDateTime(dt.Rows[0]["MRApproveDate"]); } objMR.MRDate = Convert.ToDateTime(dt.Rows[0]["MRDate"]); objMR.MRDepartmentFrom = objDepartment_DL.Get(Convert.ToInt64(dt.Rows[0]["MRFromDepID"])); objMR.MREnterdBy = Convert.ToString(dt.Rows[0]["MREnterdBy"]); if (dt.Rows[0]["MRIssuedBy"] != null) { objMR.MRIssuedBy = Convert.ToString(dt.Rows[0]["MRIssuedBy"]); } if (dt.Rows[0]["MRIssuedDate"] != null) { objMR.MRIssuedDate = Convert.ToDateTime(dt.Rows[0]["MRIssuedDate"]); } objMR.MRNO = Convert.ToInt64(dt.Rows[0]["MRNO"]); if (dt.Rows[0]["MRReceivedBy"] != null) { objMR.MRReceivedBy = Convert.ToString(dt.Rows[0]["MRReceivedBy"]); } if (dt.Rows[0]["MRReceivedDate"] != null) { objMR.MRReceivedDate = Convert.ToDateTime(dt.Rows[0]["MRReceivedDate"]); } objMR.MRRemarks = Convert.ToString(dt.Rows[0]["MRNO"]); objMR.MRStatus = (MR.Status)dt.Rows[0]["MRStatus"]; objMR.MRType = (MR.Type)dt.Rows[0]["MRType"]; objMR.MRStore = objStore_DL.Get(Convert.ToString(dt.Rows[0]["MRStore"])); if (dt.Rows[0]["MRSectionID"] != DBNull.Value) { objMR.SectionID = Convert.ToInt64(dt.Rows[0]["MRSectionID"]); } objMR.OriginType = (MR.Origin)dt.Rows[0]["OriginType"]; if (dt.Rows[0]["MRPrint"] != DBNull.Value) { objMR.Print = Convert.ToBoolean(dt.Rows[0]["MRPrint"]); } if (dt.Rows[0]["MRBulkPrint"] != DBNull.Value) { objMR.BulkPrint = Convert.ToBoolean(dt.Rows[0]["MRBulkPrint"]); } } return(objMR); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }