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