public ETL_Bill ExtractSalesInvoice(Session session, Guid BillId)
{
ETL_Bill result = null;
try
{
Util util = new Util();
SalesInvoice invoice = session.GetObjectByKey <SalesInvoice>(BillId);
if (invoice == null)
{
return(null);
}
result = new ETL_Bill();
result.BillId = BillId;
if (invoice.SourceOrganizationId == null)
{
result.CustomerOrgId = Guid.Empty;
}
else
{
result.CustomerOrgId = invoice.SourceOrganizationId.OrganizationId;
}
result.OwnerOrgId = util.GetXpoObjectByFieldName <Organization, string>(session, "Code", "QUASAPHARCO", DevExpress.Data.Filtering.BinaryOperatorType.Equal).OrganizationId;
result.IssueDate = invoice.IssuedDate;
result.BillItemList = new List <ETL_BillItem>();
foreach (BillItem billItem in invoice.BillItems)
{
ETL_BillItem temp = new ETL_BillItem();
temp.Asset = "VND";
temp.Amount = (billItem.Quantity * billItem.Price);
temp.item = billItem.ItemId;
temp.unit = billItem.UnitId;
result.BillItemList.Add(temp);
}
}
catch (Exception)
{
}
return(result);
}
public void CreateFinancialRevenueByItem(Session session,
ETL_Bill bill,
ETL_BillItem billItem)
{
SalesInvoice invoice = session.GetObjectByKey <SalesInvoice>(bill.BillId);
if (invoice == null)
{
return;
}
#region customerOrg
Guid customerOrgId = bill.CustomerOrgId;
#endregion
#region ownerOrg
Guid ownerOrgId = bill.OwnerOrgId;
#endregion
#region ItemUnit
Item item = billItem.item;
if (item == null)
{
return;
}
Unit unit = billItem.unit;
if (unit == null)
{
return;
}
#endregion
#region AssetDim
string assetDim = "VND";
#endregion
#region BillId
Guid billId = bill.BillId;
#endregion
CreateFinancialRevenueByItem(session, billId, customerOrgId, ownerOrgId, item, unit, assetDim);
}
