public void Transform() { //if (Stop == true) return; //Console.WriteLine("Transform"); if (RefId == Guid.Empty) { return; } ETLEntryObjectHistoryBO _ETLEntryObjectHistoryBO = new ETLEntryObjectHistoryBO(); ObjectEntryLogBO _ObjectEntryLogBO = new ObjectEntryLogBO(); ETLJobBO _ETLJobBO = new ETLJobBO(); ETLLogBO _ETLLogBO = new ETLLogBO(); BusinessObjectBO _BusinessObjectBO = new BusinessObjectBO(); _ETLLogBO.JobLog(session, JobId, "Running", "Status1"); ETLInventoryBO etlBO = new ETLInventoryBO(); etlBO.RepairCOGSByTransaction(session, RefId); //etlBO.RepairCOGS(session, RefId); }
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); }