public void Save(CashBookTransaction cashbookTransaction) { using (var core = new StandardBusinessLayer(this)) { core.Connect(); bool newVerification = cashbookTransaction.No == 0; core.Save(cashbookTransaction); if (newVerification) { CashBookTransactions.Add(cashbookTransaction); } else { for (int i = 0; i < CashBookTransactions.Count(); i++) { if (CashBookTransactions[i].No == cashbookTransaction.No) { CashBookTransactions[i] = cashbookTransaction; break; } } } FillVerification(Verifications.First(v => v.No == cashbookTransaction.VerificationNo)); } }
public void Load(int year) { using (var core = new StandardBusinessLayer(this)) { core.Connect(); Settings = core.GetCashBoxSettings(CashBoxSettingsNo.CurrentApplicationNo); //Verifications = core.GetVerificationsByYear(year); Verifications = core.GetVerifications(); //Condition isThisYear = new Condition(AccountTransaction.fTransactionTime, CompareOperator.GreaterThanOrEqualTo, new DateTime(year, 1, 1), DateTimeResolution.Day); //AccountTransactions = core.GetAccountTransactions(isThisYear); AccountTransactions = core.GetAccountTransactions(); //isThisYear = new Condition(CashBookTransaction.fTransactionTime, CompareOperator.GreaterThanOrEqualTo, new DateTime(year, 1, 1), DateTimeResolution.Day); //CashBookTransactions = core.GetCashBookTransactions(isThisYear); CashBookTransactions = core.GetCashBookTransactions(); Condition isEarlier = new Condition(AccountTransaction.fTransactionTime, CompareOperator.LessThan, new DateTime(year, 1, 1)); EarlierAccountTransactions = core.GetAccountTransactions(isEarlier); isEarlier = new Condition(CashBookTransaction.fTransactionTime, CompareOperator.LessThan, new DateTime(year, 1, 1)); EarlierCashBookTransactions = core.GetCashBookTransactions(isEarlier); foreach (var verification in Verifications) { FillVerification(verification); } } }
public void Save(AccountTransaction accountTransaction) { using (var core = new StandardBusinessLayer(this)) { core.Connect(); bool newTransaction = accountTransaction.No == 0; core.Save(accountTransaction); if (newTransaction) { AccountTransactions.Add(accountTransaction); } else { for (int i = 0; i < AccountTransactions.Count(); i++) { if (AccountTransactions[i].No == accountTransaction.No) { AccountTransactions[i] = accountTransaction; break; } } } FillVerification(Verifications.First(v => v.No == accountTransaction.VerificationNo)); } }
public void Save(CashBoxSettings settings) { using (var core = new StandardBusinessLayer(this)) { core.Connect(); core.Save(settings); Settings = settings; } }
public TagHandler(DataCache dataCache, int accountNo) { DataCache = dataCache; using (var core = new StandardBusinessLayer(DataCache)) { core.Connect(); AccountTags = core.GetAccountTagsByAccountNo(accountNo); } AccountBalance = DataCache.CalculateAccountBalance(accountNo); CreateComboBoxItems(); }
public void DeleteVerification(int no) { using (var core = new StandardBusinessLayer(this)) { core.Connect(); Verification verification = Verifications.FirstOrDefault(v => v.No == no); if (verification != null) { core.DeleteVerification(no); Verifications.Remove(verification); } } }
public void Save(Verification verification) { using (var core = new StandardBusinessLayer(this)) { core.Connect(); bool newVerification = verification.No == 0; core.Save(verification); FillVerification(verification); if (newVerification) { Verifications.Add(verification); } else { for (int i = 0; i < Verifications.Count(); i++) { if (Verifications[i].No == verification.No) { Verifications[i] = verification; break; } } for (int i = 0; i < AccountTransactions.Count(); i++) { if (AccountTransactions[i].VerificationNo == verification.No) { AccountTransactions[i].SetTransactionTime(verification.Date); AccountTransactions[i].SetAccountingDate(verification.AccountingDate); break; } } for (int i = 0; i < CashBookTransactions.Count(); i++) { if (CashBookTransactions[i].VerificationNo == verification.No) { CashBookTransactions[i].SetTransactionTime(verification.Date); CashBookTransactions[i].SetAccountingDate(verification.AccountingDate); break; } } } } }
public void DeleteCashBookTransaction(int no) { using (var core = new StandardBusinessLayer(this)) { core.Connect(); var transaction = CashBookTransactions.FirstOrDefault(t => t.No == no); if (transaction != null) { Verification verification = Verifications.FirstOrDefault(v => v.No == transaction.VerificationNo); core.DeleteCashBookTransaction(no); CashBookTransactions.Remove(transaction); FillVerification(verification); } } }
public decimal CalculateAccountBalance(int accountNo) { Account account = null; using (var core = new StandardBusinessLayer(this)) { core.Connect(); account = core.GetAccount(accountNo); } //var earlierTransactions = EarlierAccountTransactions.Where(t => t.AccountNo == accountNo).ToList(); var transactions = AccountTransactions.Where(t => t.AccountNo == accountNo).ToList(); //var earlierTotalAmount = earlierTransactions.Sum(t => t.Amount); var transactionsTotalAmount = transactions.Sum(t => t.Amount); //return account.BalanceBroughtForwardAmount + earlierTotalAmount + transactionsTotalAmount; return(account.BalanceBroughtForwardAmount + transactionsTotalAmount); }
public void DeleteCashBookTransactionsByVerificationNo(int verificationNo) { using (var core = new StandardBusinessLayer(this)) { core.Connect(); var transactions = CashBookTransactions.Where(t => t.VerificationNo == verificationNo).ToList(); if (transactions.Count() > 0) { var verification = Verifications.FirstOrDefault(v => v.No == transactions[0].VerificationNo); core.DeleteCashBookTransactionsByVerificationNo(verificationNo); foreach (var transaction in transactions) { CashBookTransactions.Remove(transaction); } FillVerification(verification); } } }