public async Task <CreateProcessStatus> CreateLedgerFromView(GeneralLedgerView view)
{
try
{
GeneralLedger ledger = new GeneralLedger();
var query = await(from e in _dbContext.GeneralLedgers
where e.AccountId == view.AccountId &&
e.Amount == view.Amount &&
e.GLDate == view.GLDate &&
e.DocNumber == view.DocNumber &&
e.CheckNumber == view.CheckNumber
select e
).FirstOrDefaultAsync <GeneralLedger>();
if (query == null)
{
applicationViewFactory.MapGeneralLedgerEntity(ref ledger, view);
AddObject(ledger);
return(CreateProcessStatus.Insert);
}
return(CreateProcessStatus.AlreadyExists);
}
catch (Exception ex)
{ throw new Exception(GetMyMethodName(), ex); }
}
public async Task <GeneralLedgerView> GetLedgerByDocNumber(long?docNumber, string docType)
{
try
{
var query = await(from a in _dbContext.GeneralLedgers
where a.DocNumber == docNumber &&
a.DocType == docType
select a).FirstOrDefaultAsync <GeneralLedger>();
GeneralLedgerView view = applicationViewFactory.MapGeneralLedgerView(query);
return(view);
}
catch (Exception ex)
{ throw new Exception(GetMyMethodName(), ex); }
}
public async Task TestCreateIncomeRevenue()
{
int addressId = 1;
decimal income = 2800M;
long incomeDocumentNumber = 20; //manually extracted
UnitOfWork unitOfWork = new UnitOfWork();
GeneralLedgerModule ledgerMod = new GeneralLedgerModule();
ChartOfAccts coa = await unitOfWork.generalLedgerRepository.GetChartofAccount("1000", "1200", "300", "");
Udc udcLedgerType = await unitOfWork.generalLedgerRepository.GetUdc("GENERALLEDGERTYPE", "AA");
Udc udcDocType = await unitOfWork.generalLedgerRepository.GetUdc("DOCTYPE", "PV");
AddressBook addressBook = await unitOfWork.addressBookRepository.GetAddressBookByAddressId(addressId);
GeneralLedgerView glView = new GeneralLedgerView();
glView.DocNumber = incomeDocumentNumber;
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 = addressBook.AddressId;
glView.Comment = "Week end 8/31/2018";
glView.DebitAmount = income;
glView.CreditAmount = 0;
glView.FiscalPeriod = 9;
glView.FiscalYear = 2018;
ledgerMod.GeneralLedger.CreateGeneralLedger(glView).Apply();
ledgerMod.GeneralLedger.UpdateAccountBalances(glView);
ChartOfAccts coa2 = await unitOfWork.generalLedgerRepository.GetChartofAccount("1000", "1200", "101", "");
long cashDocumentNumber = 21;
GeneralLedgerView glView2 = new GeneralLedgerView();
glView2.DocNumber = cashDocumentNumber;
glView2.DocType = udcDocType.KeyCode;
glView2.AccountId = coa2.AccountId;
glView2.Amount = income;
glView2.LedgerType = udcLedgerType.KeyCode;
glView2.GLDate = DateTime.Parse("9/20/2018");
glView2.CreatedDate = DateTime.Parse("9/20/2018");
glView2.AddressId = addressBook.AddressId;
glView2.Comment = "Week end 8/31/2018";
glView2.DebitAmount = income;
glView2.CreditAmount = 0;
glView2.FiscalPeriod = 9;
glView2.FiscalYear = 2018;
ledgerMod.GeneralLedger.CreateGeneralLedger(glView2).Apply();
ledgerMod.GeneralLedger.UpdateAccountBalances(glView2);
GeneralLedgerView glViewLookup =
ledgerMod.GeneralLedger.Query().GetGeneralLedgerView(glView2.DocNumber, glView2.DocType);
Assert.True(glViewLookup != null);
}
public async Task TestCreatePersonalExpenseAndPayment()
{
//ToDo
UnitOfWork unitOfWork = new UnitOfWork();
long addressId = 1;
long expenseDocumentNumber = 19;
decimal expense = 768M;
ChartOfAccts coa = await unitOfWork.generalLedgerRepository.GetChartofAccount("1000", "1200", "502", "01");
Udc udcLedgerType = await unitOfWork.generalLedgerRepository.GetUdc("GENERALLEDGERTYPE", "AA");
Udc udcDocType = await unitOfWork.generalLedgerRepository.GetUdc("DOCTYPE", "PV");
AddressBook addressBook = await unitOfWork.addressBookRepository.GetAddressBookByAddressId(addressId);
GeneralLedgerView glView = new GeneralLedgerView();
GeneralLedgerModule ledgerMod = new GeneralLedgerModule();
glView.DocNumber = expenseDocumentNumber;
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 = addressBook.AddressId;
glView.Comment = "Mortgage Payment";
glView.DebitAmount = 0;
glView.CreditAmount = expense;
glView.FiscalPeriod = 9;
glView.FiscalYear = 2018;
ledgerMod.GeneralLedger.CreateGeneralLedger(glView).Apply();
ledgerMod.GeneralLedger.UpdateAccountBalances(glView);
GeneralLedgerView glViewLookup =
ledgerMod.GeneralLedger.Query().GetGeneralLedgerView(glView.DocNumber, glView.DocType);
ChartOfAccts coaCash = await unitOfWork.generalLedgerRepository.GetChartofAccount("1000", "1200", "101", "");
GeneralLedgerView glCashView = new GeneralLedgerView();
long cashDocumentNumber = 22;
glCashView.DocNumber = cashDocumentNumber;
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 = addressBook.AddressId;
glCashView.Comment = "Mortgage Payment";
glCashView.DebitAmount = 0;
glCashView.CreditAmount = expense;
glCashView.FiscalPeriod = 9;
glCashView.FiscalYear = 2018;
ledgerMod.GeneralLedger.CreateGeneralLedger(glCashView).Apply();
ledgerMod.GeneralLedger.UpdateAccountBalances(glCashView);
GeneralLedgerView glCashViewLookup =
ledgerMod.GeneralLedger.Query().GetGeneralLedgerView(glCashView.DocNumber, glCashView.DocType);
Assert.True(glCashViewLookup != null);
}