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