public void PerformInitialize()
{
//SqlCeEngine engine = new SqlCeEngine("Data Source = AdventureWorks.sdf");
//engine.Shrink();
var context = new CashBookContainer();
//context.ContextOptions.UseLegacyPreserveChangesBehavior
}
protected void Commit(CashBookContainer context)
{
context.SaveChanges();
}
private decimal GetPreviousBalance(CashBookContainer context, DateTime currentDate, long selectedCashBookId)
{
//get all the previous registers
var previousRegisters = context.DailyCashBooks.Where(p => p.Data < currentDate && p.RegistruCasaId == selectedCashBookId).ToList();
decimal totalSum = 0;
previousRegisters.ForEach(p => totalSum += p.DeltaBalance);
//take the initial balance of the cashbook into account
var currentCashBook = context.UserCashBooks.FirstOrDefault(p => p.Id == selectedCashBookId);
if (currentCashBook.InitialBalanceDate < currentDate)
{
totalSum += currentCashBook.InitialBalance;
}
return totalSum;
}
private CashBookEntry GetCashBookEntry(long id, CashBookContainer context)
{
return context.CashBookEntries.FirstOrDefault(p => p.Id == id);
}
private UserCashBook GetCashBook(long id, CashBookContainer context)
{
return context.UserCashBooks.FirstOrDefault(p => p.Id == id);
}