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