Example #1
0
        private void View_BalanceSheetUpdated(object sender, AccountBalanceEntry e)
        {
            // Check if the Account No exists
            using (var context = new FinPlannerEntities())
            {
                BalanceSheetCheck(context);

                var account = context.Account.SingleOrDefault(
                    x => x.AccountNo == e.AccountNo && x.DocumentID == _balanceSheetDocumentID);

                // If account is not found
                if (account == null)
                {
                    throw new CoreException(_exAccountNoNotFound);
                }

                var month = DateTime.Now.Month;
                var year  = DateTime.Now.Year;

                // Look for the exisiting account record this month
                var balance = context.Balance.SingleOrDefault(
                    x => x.AccountID == account.AccountID &&
                    x.PostingDate.Year == year && x.PostingDate.Month == month);

                // Update the existing record
                balance.Amount = e.Amount;

                context.SaveChanges();
            }
        }
Example #2
0
        private void View_BudgetUpdated(object sender, AccountBalanceEntry e)
        {
            // Check if the Account No exists
            using (var context = new FinPlannerEntities())
            {
                var account = context.Account.SingleOrDefault(
                    x => x.AccountNo == e.AccountNo && x.DocumentID == _cashflowDocumentID);

                // If account is not found
                if (account == null)
                {
                    throw new CoreException(_exAccountNoNotFound);
                }

                var month = DateTime.Now.Month;
                var year  = DateTime.Now.Year;

                // Look for the exisiting account record in this month
                var budget = context.Budget.SingleOrDefault(
                    x => x.AccountID == account.AccountID &&
                    x.PostingDate.Year == year && x.PostingDate.Month == month);

                // if the record is found
                if (budget != null)
                {
                    // Update the existing record
                    budget.Amount = e.Amount;
                }
                else
                {
                    // Add a new budget record as of the first day of the month
                    context.Budget.Add(new Budget()
                    {
                        AccountID   = account.AccountID,
                        Amount      = e.Amount,
                        PostingDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1)
                    });
                }

                context.SaveChanges();
            }
        }