public async Task <IList <IncomeView> > GetIncomeViews()
{
GeneralLedgerModule glMod = new GeneralLedgerModule();
IList <IncomeView> list = await glMod.GeneralLedger.Query().GetIncomeViews();
return(list);
}
public async Task <IList <IncomeStatementView> > GetIncomeStatementView(int fiscalYear)
{
GeneralLedgerModule glMod = new GeneralLedgerModule();
IList <IncomeStatementView> list = await glMod.GeneralLedger.Query().GetIncomeStatementViews(fiscalYear);
return(list);
}
public IEnumerable <AccountSummaryView> GetSummary(int fiscalYear)
{
GeneralLedgerModule glMod = new GeneralLedgerModule();
IEnumerable <AccountSummaryView> list = glMod.GeneralLedger.Query().GetAccountSummaryByFiscalYearViews(fiscalYear);
return(list);
}
public async Task <string[]> GetIncomeStatementAccounts(int fiscalYear)
{
GeneralLedgerModule glMod = new GeneralLedgerModule();
IList <IncomeStatementView> list = await glMod.GeneralLedger.Query().GetIncomeStatementViews(fiscalYear);
string[] accounts = list.GroupBy(e => e.Account).Select(e => e.Key).ToArray <string>();
return(accounts);
}
public async Task <bool> PostIncome([FromBody] IncomeShortView incomeShortView)
{
int addressId = 1;
GeneralLedgerModule ledgerMod = new GeneralLedgerModule();
NextNumber DocNumber = await ledgerMod.GeneralLedger.Query().GetDocNumber();
//Income GL
GeneralLedgerView glView = new GeneralLedgerView();
glView.DocNumber = DocNumber.NextNumberValue;
glView.Amount = incomeShortView.Amount;
glView.GLDate = incomeShortView.GLDate;
glView.AddressId = addressId;
glView.Comment = incomeShortView.Comment;
glView.CheckNumber = incomeShortView.CheckNumber;
bool result = await ledgerMod.CreateIncomeAndCash(glView);
return(result);
}
public async Task <GeneralLedgerView> GetByAccountId(long generalLedgerId)
{
GeneralLedgerModule glMod = new GeneralLedgerModule();
return(await glMod.GeneralLedger.Query().GetViewById(generalLedgerId));
}
public async Task <bool> PostPayment([FromBody] PersonalBudgetView budget)
{
GeneralLedgerModule ledgerMod = new GeneralLedgerModule();
NextNumber nextNumberDocNumber = await ledgerMod.GeneralLedger.Query().GetDocNumber();
//long addressId = 1;
decimal expense = budget.BudgetAmount / (Decimal)budget.PayCycles ?? 0;
// ChartOfAccts coa = ledgerMod.ChartOfAccounts.Query().GetChartofAccount("1000", "1200", "502", "01");
//Udc udcLedgerType = ledgerMod.UDC.Query().GetUdc("GENERALLEDGERTYPE", "AA");
//Udc udcDocType = ledgerMod.UDC.Query().GetUdc("DOCTYPE", "PV");
//AddressBook addressBook = ledgerMod.AddressBook.Query().GetAddressBookByAddressId(addressId);
GeneralLedgerView glView = new GeneralLedgerView();
glView.DocNumber = nextNumberDocNumber.NextNumberValue;
//glView.DocType = udcDocType.KeyCode;
//glView.AccountId = coa.AccountId;
glView.Amount = expense * -1;
//glView.LedgerType = udcLedgerType.KeyCode;
glView.GLDate = budget.GLDate;
glView.CreatedDate = DateTime.Now;
//glView.AddressId = addressBook.AddressId;
//glView.Comment = "Mortgage Payment";
//glView.DebitAmount = 0;
//glView.CreditAmount = expense;
//glView.FiscalPeriod = budget.GLDate.Month;
//glView.FiscalYear = budget.GLDate.Year;
bool result1 = await ledgerMod.CreatePersonalExpense(glView);
//GeneralLedgerView glViewLookup =
//ledgerMod.GeneralLedger.Query().GetGeneralLedgerView(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();
NextNumber nextNumberDocNumber2 = await ledgerMod.GeneralLedger.Query().GetDocNumber();
//long cashDocumentNumber = 22;
glCashView.DocNumber = nextNumberDocNumber2.NextNumberValue;
//glCashView.DocType = udcDocType.KeyCode;
//glCashView.AccountId = coaCash.AccountId;
glCashView.Amount = budget.PaymentAmount ?? 0;
//glCashView.LedgerType = udcLedgerType.KeyCode;
glCashView.GLDate = budget.GLDate;
//glCashView.CreatedDate = DateTime.Now;
//glCashView.AddressId = addressBook.AddressId;
glCashView.Comment = glView.Comment;
// glCashView.DebitAmount = 0;
//glCashView.CreditAmount = expense;
//glCashView.FiscalPeriod = budget.GLDate.Month;
//glCashView.FiscalYear = budget.GLDate.Year;
bool result2 = await ledgerMod.CreateCashPayment(glCashView);
// GeneralLedgerView glCashViewLookup =
//ledgerMod.GeneralLedger.Query().GetGeneralLedgerView(glCashView.DocNumber, glCashView.DocType);
return(result2);
}
