public async Task TestCreateIncomeRevenue() { int addressId = 1; decimal income = 2800M; //long incomeDocumentNumber = 20; //manually extracted //UnitOfWork unitOfWork = new UnitOfWork(); GeneralLedgerModule ledgerMod = new GeneralLedgerModule(); //Income GL GeneralLedgerView glView = new GeneralLedgerView(); glView.DocNumber = -1; //glView.DocType = udcDocType.KeyCode; //glView.AccountId = coa.AccountId; glView.Amount = income; //glView.LedgerType = udcLedgerType.KeyCode; glView.GLDate = DateTime.Parse("9/20/2018"); //glView.CreatedDate = DateTime.Parse("9/20/2018"); glView.AddressId = addressId; glView.Comment = "Week end 8/31/2018"; //glView.DebitAmount = income; //glView.CreditAmount = 0; //glView.FiscalPeriod = 9; //glView.FiscalYear = 2018; glView.CheckNumber = "T2"; bool result = await ledgerMod.CreateIncomeAndCash(glView); Assert.True(result); }
public async Task TestCreatePersonalExpenseAndPayment() { GeneralLedgerModule ledgerMod = new GeneralLedgerModule(); long addressId = 1; decimal expense = 768M; GeneralLedgerView glView = new GeneralLedgerView(); glView.DocNumber = -1; //glView.DocType = udcDocType.KeyCode; //glView.AccountId = coa.AccountId; glView.Amount = expense * -1; //glView.LedgerType = udcLedgerType.KeyCode; glView.GLDate = DateTime.Parse("9/19/2018"); //glView.CreatedDate = DateTime.Parse("9/19/2018"); glView.AddressId = addressId; glView.Comment = "Mortgage Payment"; glView.CheckNumber = "T1"; glView.GeneralLedgerNumber = (await ledgerMod.GeneralLedger.Query().GetNextNumber()).NextNumberValue; //glView.DebitAmount = 0; //glView.CreditAmount = expense; //glView.FiscalPeriod = 9; //glView.FiscalYear = 2018; bool result1 = await ledgerMod.CreatePersonalExpense(glView); GeneralLedgerView glViewLookup = await ledgerMod.GeneralLedger.Query().GetViewByDocNumber(glView.DocNumber, glView.DocType); //ChartOfAccts coaCash = await unitOfWork.generalLedgerRepository.GetChartofAccount("1000", "1200", "101", ""); //ChartOfAccts coaCash = ledgerMod.ChartOfAccounts.Query().GetChartofAccount("1000", "1200", "101", ""); GeneralLedgerView glCashView = new GeneralLedgerView(); //long cashDocumentNumber = 22; glCashView.DocNumber = -1; //glCashView.DocType = udcDocType.KeyCode; //glCashView.AccountId = coaCash.AccountId; glCashView.Amount = expense * -1; //glCashView.LedgerType = udcLedgerType.KeyCode; glCashView.GLDate = DateTime.Parse("9/20/2018"); //glCashView.CreatedDate = DateTime.Parse("9/20/2018"); glCashView.AddressId = addressId; glCashView.Comment = "Mortgage Payment"; glCashView.CheckNumber = "T1"; //glCashView.DebitAmount = 0; //glCashView.CreditAmount = expense; //glCashView.FiscalPeriod = 9; //glCashView.FiscalYear = 2018; bool result2 = await ledgerMod.CreateCashPayment(glCashView); GeneralLedgerView glCashViewLookup = await ledgerMod.GeneralLedger.Query().GetViewByDocNumber(glCashView.DocNumber, glCashView.DocType); Assert.True(glCashViewLookup != null && glViewLookup != null); }
public async Task TestGeneralLedgerPaging() { long generalLedgerId = 1; GeneralLedgerModule glMod = new GeneralLedgerModule(); PageListViewContainer <GeneralLedgerView> container = await glMod.GeneralLedger.Query().GetViewsByPage(predicate: e => e.GeneralLedgerId == generalLedgerId, order: e => e.GeneralLedgerId, pageSize: 1, pageNumber: 1); Assert.True(container.TotalItemCount > 0); }
public async Task TestIncomeStatementViews() { GeneralLedgerModule glMod = new GeneralLedgerModule(); IList <IncomeStatementView> list = await glMod.GeneralLedger.Query().GetIncomeStatementViews(2018); foreach (var item in list) { System.Diagnostics.Debug.WriteLine($"{item.Description}{item.Amount}"); } }
public async Task TestIncomeViews() { GeneralLedgerModule glMod = new GeneralLedgerModule(); IList <IncomeView> list = await glMod.GeneralLedger.Query().GetIncomeViews(); foreach (var item in list) { Console.WriteLine("{0}", item.Description); } Assert.True(list.Count > 0); }
public void TestGetLedgersByFiscalYear() { long fiscalYear = 2018; GeneralLedgerModule glMod = new GeneralLedgerModule(); IEnumerable <AccountSummaryView> list = glMod.GeneralLedger.Query().GetAccountSummaryByFiscalYearViews(fiscalYear); decimal?amount = 0; foreach (var item in list) { Console.Write($"{0} {1}", item.Description, item.Amount); amount += item.Amount; foreach (var ledger in item.ledgers) { Console.Write($"{0} {1} {2} {3}", ledger.DocType, ledger.GLDate, ledger.DebitAmount, ledger.CreditAmount); } } if (amount > 0) { Assert.True(true); } }