public List <ConsumablesDTO> GetConsumableRequestDocByRiseId(int pIntRiseId) { List <ConsumablesDTO> lLstConsumablesDTO = new List <ConsumablesDTO>(); Recordset lObjRecordset = null; try { lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset); string lStrQuery = this.GetSQL("GetConsubamleRequestDocByRiseId").InjectSingleValue("RiseId", pIntRiseId.ToString()); lObjRecordset.DoQuery(lStrQuery); if (lObjRecordset.RecordCount > 0) { for (int i = 0; i < lObjRecordset.RecordCount; i++) { ConsumablesDTO lObjConsumablesDTO = new ConsumablesDTO { Code = lObjRecordset.Fields.Item("Code").Value.ToString() == "0" ? string.Empty : lObjRecordset.Fields.Item("Code").Value.ToString(), DocEntry = int.Parse(lObjRecordset.Fields.Item("DocEntry").Value.ToString()), IdRise = int.Parse(lObjRecordset.Fields.Item("FolioRise").Value.ToString()), TransferFolio = int.Parse(lObjRecordset.Fields.Item("StockTransferDocEntry").Value.ToString()), DocDate = DateTime.Parse(lObjRecordset.Fields.Item("DocDate").Value.ToString()), DocNum = int.Parse(lObjRecordset.Fields.Item("DocNum").Value.ToString()), }; lLstConsumablesDTO.Add(lObjConsumablesDTO); lObjRecordset.MoveNext(); } } } catch (Exception lObjException) { LogService.WriteError(string.Format("[ConsumablesDAO - GetConsumableRequestDocByRiseId: {0}]", lObjException.Message)); throw new DAOException(lObjException.Message, lObjException); } finally { MemoryUtility.ReleaseComObject(lObjRecordset); } return(lLstConsumablesDTO); }
public ConsumablesDTO GetInventoryRequest(int pIntDocEntry) { ConsumablesDTO lObjConsumablesDTO = null; Recordset lObjRecordset = null; try { lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset); Dictionary <string, string> lLstStrParameters = new Dictionary <string, string>(); lLstStrParameters.Add("DocEntry", pIntDocEntry.ToString()); string lStrQuery = this.GetSQL("GetInventoryRequestById").Inject(lLstStrParameters); lObjRecordset.DoQuery(lStrQuery); if (lObjRecordset.RecordCount > 0) { lObjConsumablesDTO = new ConsumablesDTO { DocEntry = int.Parse(lObjRecordset.Fields.Item("DocEntry").Value.ToString()), IdRise = int.Parse(lObjRecordset.Fields.Item("FolioRise").Value.ToString()), TransferFolio = int.Parse(lObjRecordset.Fields.Item("StockTransferDocEntry").Value.ToString()), DocDate = DateTime.Parse(lObjRecordset.Fields.Item("DocDate").Value.ToString()), DocNum = int.Parse(lObjRecordset.Fields.Item("DocNum").Value.ToString()), }; } } catch (Exception lObjException) { LogService.WriteError(string.Format("[ConsumablesDAO - GetInventoryRequest: {0}]", lObjException.Message)); throw new DAOException(lObjException.Message, lObjException); } finally { MemoryUtility.ReleaseComObject(lObjRecordset); } return(lObjConsumablesDTO); }