public IList <InvoiceRowDTO> GetGroupedLines(int pDocEntry)
{
SAPbobsCOM.Recordset lObjResults = (SAPbobsCOM.Recordset)DIApplication.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
IList <InvoiceRowDTO> lLstObjInvoiceRows = new List <InvoiceRowDTO>();
try
{
string lStrQuery = this.GetSQL("GetGroupedLines").InjectSingleValue("DocEntry", pDocEntry);
lObjResults.DoQuery(lStrQuery);
if (lObjResults.RecordCount > 0)
{
for (int i = 0; i < lObjResults.RecordCount; i++)
{
InvoiceRowDTO lObjInvoiceRowDTO = new InvoiceRowDTO();
lObjInvoiceRowDTO.LineTotal = Convert.ToDouble(lObjResults.Fields.Item("LineTotal").Value.ToString());
lObjInvoiceRowDTO.TaxCode = lObjResults.Fields.Item("TaxCode").Value.ToString();
lObjInvoiceRowDTO.OcrCode = lObjResults.Fields.Item("OcrCode").Value.ToString();
lObjInvoiceRowDTO.OcrCode2 = lObjResults.Fields.Item("OcrCode2").Value.ToString();
lObjInvoiceRowDTO.OcrCode3 = lObjResults.Fields.Item("OcrCode3").Value.ToString();
lLstObjInvoiceRows.Add(lObjInvoiceRowDTO);
lObjResults.MoveNext();
}
}
return(lLstObjInvoiceRows);
}
catch (Exception e)
{
return(lLstObjInvoiceRows);
}
finally
{
MemoryUtility.ReleaseComObject(lObjResults);
}
}
public InvoiceRow Transform(InvoiceRowDTO dto)
{
if (dto == null)
{
return(null);
}
return(new InvoiceRow
{
InvoiceRowId = dto.InvoiceRowId,
Price = dto.Price,
RowTax = dto.RowTax,
TicketId = dto.TicketId
});
}
public IList <InvoiceRowDTO> GetInvoiceLinesByGroup(int pDocEntry)
{
SAPbobsCOM.Recordset lObjResults = (SAPbobsCOM.Recordset)DIApplication.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
IList <InvoiceRowDTO> lLstObjInvoiceRows = new List <InvoiceRowDTO>();
try
{
string lStrQuery = this.GetSQL("GetGroupedLines").InjectSingleValue("DocEntry", pDocEntry);
lObjResults.DoQuery(lStrQuery);
if (lObjResults.RecordCount > 0)
{
for (int i = 0; i < lObjResults.RecordCount; i++)
{
InvoiceRowDTO lObjInvoiceRowDTO = new InvoiceRowDTO();
lObjInvoiceRowDTO.LineTotal = Convert.ToDouble(lObjResults.Fields.Item("LineTotal").Value.ToString());
lObjInvoiceRowDTO.TaxCode = lObjResults.Fields.Item("TaxCode").Value.ToString();
lObjInvoiceRowDTO.OcrCode = lObjResults.Fields.Item("OcrCode").Value.ToString();
lObjInvoiceRowDTO.OcrCode2 = lObjResults.Fields.Item("OcrCode2").Value.ToString();
lObjInvoiceRowDTO.OcrCode3 = lObjResults.Fields.Item("OcrCode3").Value.ToString();
lObjInvoiceRowDTO.BagsBales = lObjResults.Fields.Item("U_GLO_BagsBales").Value.ToString();
lLstObjInvoiceRows.Add(lObjInvoiceRowDTO);
lObjResults.MoveNext();
}
}
return(lLstObjInvoiceRows);
}
catch (Exception e)
{
LogUtility.WriteError(string.Format("[DocumentDAO - GetInvoiceLinesByGroup] Error al obtener las lineas de la factura con DocEntry {0}: {1}", pDocEntry, e.Message));
throw new Exception(string.Format("Error al obtener las lineas de la factura con DocEntry {0}: {1}", pDocEntry, e.Message));
}
finally
{
MemoryUtility.ReleaseComObject(lObjResults);
}
}
