public void Update(Category item)
{
category = GetById(item.Id);
if (category == null)
{
throw new ArgumentNullException("Spending Category not found");
}
defaultCategory = defaultCategoryRepo.GetByName(category);
if (defaultCategory != null)
{
throw new Exception("You cannot change Default Category");
}
category.Name = item.Name;
category.IsActive = true;
using (var context = new BudgetWatcherContext())
{
context.Categories.Attach(category);
context.Entry(category).State = EntityState.Modified;
context.SaveChanges();
}
}
public Category GetById(int id)
{
using (var context = new BudgetWatcherContext())
{
category = context.Categories.FirstOrDefault(x => x.Id == id);
}
return(category);
}
public DefaultCategory GetByName(Category item)
{
using (var context = new BudgetWatcherContext())
{
defaultCategory = context.DefaultCategories.FirstOrDefault(x => x.Name == item.Name);
}
return(defaultCategory);
}
public ICollection <Budget> GetAll()
{
ICollection <Budget> budgets = new HashSet <Budget>();
using (var context = new BudgetWatcherContext())
{
budgets = context.Budgets.ToList();
}
return(budgets);
}
public ICollection <User> GetAll()
{
ICollection <User> users = new HashSet <User>();
using (var context = new BudgetWatcherContext())
{
users = context.Users.ToList();
}
return(users);
}
public decimal GetBalance(Budget item)
{
decimal balance;
using (var context = new BudgetWatcherContext())
{
balance = context.Budgets.FirstOrDefault(x => x.Id == item.Id).Balance;
}
return(balance);
}
public ICollection <DefaultCategory> GetAll()
{
ICollection <DefaultCategory> defaultCategories = new HashSet <DefaultCategory>();
using (var context = new BudgetWatcherContext())
{
defaultCategories = context.DefaultCategories.ToList();
}
return(defaultCategories);
}
public ICollection <Spending> GetAll()
{
ICollection <Spending> spendings = new HashSet <Spending>();
using (var context = new BudgetWatcherContext())
{
spendings = context.Spendings.ToList();
}
return(spendings);
}
public ICollection <Category> GetAll()
{
ICollection <Category> categories = new HashSet <Category>();
using (var context = new BudgetWatcherContext())
{
categories = context.Categories.ToList();
}
return(categories);
}
public void Add(Spending item)
{
spending.Description = item.Description;
spending.SpendingDate = DateTime.Now;
spending.MoneySpent = item.MoneySpent;
using (var context = new BudgetWatcherContext())
{
context.Spendings.Add(spending);
context.SaveChanges();
}
}
public void Add(Budget item)
{
budget.InitialBalance = item.InitialBalance;
budget.StartDate = item.StartDate;
budget.EndDate = item.EndDate;
budget.Balance = item.InitialBalance;
using (var context = new BudgetWatcherContext())
{
context.Budgets.Add(budget);
}
}
public void Delete(Category item)
{
category = GetById(item.Id);
category.IsActive = false;
category.IsChosen = false;
using (var context = new BudgetWatcherContext())
{
context.Categories.Attach(category);
context.Entry(category).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Add(User item)
{
user.Email = item.Email;
user.Password = item.Password;
user.FirstName = item.FirstName;
user.LastName = item.LastName;
using (var context = new BudgetWatcherContext())
{
context.Users.Add(user);
context.SaveChanges();
}
}
public Budget GetById(int id)
{
using (var context = new BudgetWatcherContext())
{
budget = context.Budgets.FirstOrDefault(x => x.Id == id);
}
if (budget == null)
{
throw new ArgumentNullException("Budget not found");
}
return(budget);
}
public Spending GetById(int id)
{
using (var context = new BudgetWatcherContext())
{
spending = context.Spendings.FirstOrDefault(x => x.Id == id);
}
if (spending == null)
{
throw new ArgumentNullException("Oops, spending does not exist :)");
}
return(spending);
}
public User GetById(int id)
{
using (var context = new BudgetWatcherContext())
{
user = context.Users.FirstOrDefault(x => x.Id == id);
}
if (user == null)
{
throw new ArgumentNullException("The user is not found");
}
return(user);
}
public User GetUserByEmailAndPassword(string Email, string Password)
{
using (var context = new BudgetWatcherContext())
{
user = context.Users.FirstOrDefault(x => x.Email == Email && x.Password == Password);
}
if (user == null)
{
throw new ArgumentNullException("The user is not found");
}
return(user);
}
public void Delete(User item)
{
user = GetById(item.Id);
if (user == null)
{
throw new ArgumentNullException("Please choose existing user to delete");
}
using (var context = new BudgetWatcherContext())
{
context.Users.Attach(user);
context.Users.Remove(user);
context.SaveChanges();
}
}
public void Delete(Budget item)
{
budget = GetById(item.Id);
if (budget == null)
{
throw new ArgumentNullException("Budget not found");
}
using (var context = new BudgetWatcherContext())
{
context.Budgets.Attach(budget);
context.Budgets.Remove(budget);
context.SaveChanges();
}
}
public void ChangeBalance(Budget item)
{
budget = GetById(item.Id);
if (budget == null)
{
throw new ArgumentNullException("Budget not found");
}
budget.Balance = item.Balance;
using (var context = new BudgetWatcherContext())
{
context.Budgets.Attach(budget);
context.Entry(budget).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Update(Spending item)
{
spending = GetById(item.Id);
if (spending == null)
{
throw new ArgumentNullException("Ooops, something wrong occured :)");
}
spending.Description = item.Description;
spending.SpendingDate = DateTime.Now;
spending.MoneySpent = item.MoneySpent;
using (var context = new BudgetWatcherContext())
{
context.Spendings.Attach(spending);
context.Entry(spending).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Add(Category item)
{
defaultCategory = defaultCategoryRepo.GetByName(item);
if (defaultCategory != null)
{
item.DefaultCategories.Add(defaultCategory);
}
else
{
item.DefaultCategories.Add(null);
}
category.Name = item.Name;
category.IsActive = true;
category.IsChosen = item.IsChosen;
using (var context = new BudgetWatcherContext())
{
context.Categories.Add(category);
context.SaveChanges();
}
}
public void Update(User item)
{
user = GetById(item.Id);
if (user != null)
{
user.Email = item.Email;
user.Password = item.Password;
user.FirstName = item.FirstName;
user.LastName = item.LastName;
}
else
{
throw new ArgumentNullException("The user is not found");
}
using (var context = new BudgetWatcherContext())
{
context.Users.Attach(user);
context.Entry(user).State = EntityState.Modified;
context.SaveChanges();
}
}
