public void Extract()
{
//_ETLLogBO.JobLog(session, JobId, "Next", "Status1");
//Console.WriteLine("Extract");
RefId = _ETLJobBO.ETLGetNextProcessObject(session, JobId, BusinessObjectTypeId);
ETL_Bill_temp = _ETLBillBO.ExtractSalesInvoice(session, RefId);
//Console.WriteLine(RefId);
//Thread.Sleep(3000);
}
public void CreateFinancialRevenueByItem(Session session,
ETL_Bill bill)
{
try
{
foreach (ETL_BillItem billItem in bill.BillItemList)
{
CreateFinancialRevenueByItem(session, bill, billItem);
}
}
catch (Exception)
{
throw;
return;
}
}
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 ETL_Bill ExtractSalesInvoice(Session session, Guid BillId, bool ExtractFinancialTransaction, bool ExtractInventoryTransaction)
{
ETL_Bill result = null;
try
{
result = ExtractSalesInvoice(session, BillId);
if (result == null)
{
return(null);
}
SalesInvoice invoice = session.GetObjectByKey <SalesInvoice>(BillId);
if (ExtractFinancialTransaction)
{
ETLAccountingBO _ETLAccountingPeriodBO = new ETLAccountingBO();
result.FinancialTranSactionList = new List <ETL_Transaction>();
foreach (SaleInvoiceTransaction transaction in invoice.SaleInvoiceTransactions)
{
ETL_Transaction temp = _ETLAccountingPeriodBO.ExtractTransaction(session, transaction.TransactionId);
result.FinancialTranSactionList.Add(temp);
}
}
if (ExtractInventoryTransaction)
{
ETLInventoryBO _ETLInventoryBO = new ETLInventoryBO();
result.InventoryTranSactionList = new List <Inventory.TempData.ETL_InventoryTransaction>();
foreach (SalesInvoiceInventoryTransaction transaction in invoice.SalesInvoiceInventoryTransactions)
{
ETL_InventoryTransaction temp = _ETLInventoryBO.ExtractInventoryTransaction(session, transaction.InventoryTransactionId);
result.InventoryTranSactionList.Add(temp);
}
}
}
catch (Exception)
{
return(null);
}
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);
}
