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);
}
