public String UpdateAlteration(int id, FundsAlteration newAlteration)
{
using (var context = new SystemDbContext())
{
String msg = "";
if (!IsValid(newAlteration, UPDATE, out msg))
{
return(msg);
}
var fundsAlterations = context.Set <FundsAlteration>();
var fundsAlteration = fundsAlterations.Where(x => x.Id == id).FirstOrDefault();
fundsAlteration.Amount = newAlteration.Amount;
fundsAlteration.Comment = newAlteration.Comment;
fundsAlteration.Date = newAlteration.Date;
fundsAlteration.Type = newAlteration.Type;
fundsAlteration.Periodic = newAlteration.Periodic;
if (!IsValid(fundsAlteration, UPDATE, out msg))
{
return(msg);
}
context.SaveChanges();
return(msg);
}
}
public double CalcBalance()
{
double balance = 0;
using (var context = new SystemDbContext())
{
var fundsAlterations = context.Set <FundsAlteration>();
List <Double> income = fundsAlterations
.Where(x => x.Type == FundsAlterationTypes.INCOME)
.Select(x => x.Amount)
.ToList();
List <Double> expense = fundsAlterations
.Where(x => x.Type == FundsAlterationTypes.EXPENSE)
.Select(x => x.Amount)
.ToList();
foreach (var item in income)
{
balance += item;
}
foreach (var item in expense)
{
balance -= item;
}
return(balance);
}
}
public String AddAlteration(double amount, String type, bool isPeriodic, DateTime?dateTime, String comment = null)
{
using (var context = new SystemDbContext())
{
if (amount <= 0 ||
(!type.Equals(FundsAlterationTypes.INCOME) && !type.Equals(FundsAlterationTypes.EXPENSE)))
{
return("Грешка! Невалидни данни.");
}
if (isPeriodic)
{
return("Грешка!"); //to be implemented
}
if (type.Equals(FundsAlterationTypes.EXPENSE))
{
double balance = this.CalcBalance();
if (amount > balance)
{
return("Недостатъчни средства!");
}
}
var fundsAlterations = context.Set <FundsAlteration>();
DateTime?dt = (dateTime != null ? dateTime : DateTime.Now);
fundsAlterations.Add(new FundsAlteration(amount, type, dt, isPeriodic));
context.SaveChanges();
return("Успешно добавен запис.");
}
}
public List <FundsAlteration> GetAlterations()
{
using (var context = new SystemDbContext())
{
var fundsAlterations = context.Set <FundsAlteration>();
return(fundsAlterations.ToList());
}
}
public void MarkChecked(DateTime?date)
{
using (var context = new SystemDbContext())
{
var checks = context.Set <PeriodicCheck>();
checks.Add(new PeriodicCheck(date));
context.SaveChanges();
}
}
public void DeleteAlteration(int id)
{
using (var context = new SystemDbContext())
{
var fundsAlterations = context.Set <FundsAlteration>();
FundsAlteration fundsAlteration = fundsAlterations
.Where(x => x.Id == id)
.FirstOrDefault();
if (fundsAlteration != null)
{
fundsAlterations.Remove(fundsAlteration);
}
}
}
public String AddAlteration(double amount, String type, bool isPeriodic, DateTime?dateTime, String comment = null)
{
using (var context = new SystemDbContext())
{
var fundsAlterations = context.Set <FundsAlteration>();
DateTime?dt = (dateTime != null ? dateTime : DateTime.Now);
String msg = "";
FundsAlteration fa = new FundsAlteration(amount, type, dt, isPeriodic);
if (IsValid(fa, CREATE, out msg))
{
fundsAlterations.Add(fa);
context.SaveChanges();
}
return(msg);
}
}
public bool IsChecked(DateTime?date)
{
using (var context = new SystemDbContext())
{
var checks = context.Set <PeriodicCheck>();
var checkToday = checks
.Where(x => x.Date.Value.Year == date.Value.Year &&
x.Date.Value.Month == date.Value.Month &&
x.Date.Value.Day == date.Value.Day)
.FirstOrDefault();
if (checkToday != null)
{
return(true);
}
return(false);
}
}
public String DeleteAlteration(int id)
{
using (var context = new SystemDbContext())
{
String msg = "";
var fundsAlterations = context.Set <FundsAlteration>();
FundsAlteration fundsAlteration = fundsAlterations
.Where(x => x.Id == id)
.FirstOrDefault();
if (fundsAlteration != null && IsValid(fundsAlteration, DELETE, out msg))
{
fundsAlterations.Remove(fundsAlteration);
}
context.SaveChanges();
return(msg);
}
}