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