public IEnumerable <ExpensesCategory> GetAll()
{
using (var db = new JohannaContext())
{
return(Categories);
}
}
protected override void Seed(JohannaContext context)
{
//var Food = new ExpensesCategory { id = 1, name = "Food" };
//var Transport = new ExpensesCategory { id = 2, name = "Transport" };
//var Entertainment = new ExpensesCategory { id = 3, name = "Entertainment" };
//context.ExpensesCategories.AddOrUpdate(Food, Transport, Entertainment);
//var ICA = new Expenses { id = 1, name = "ICA", price = 200, new ExpensesCategories() { 1 } };
//context.Expenses.AddOrUpdate(ICA);
//context.Users.AddOrUpdate(new User
//{
// username = "******",
// password = "******"
//});
//context.Expenses.AddOrUpdate(new Expenses
//{
// id = 1,
// name = "ica",
// price = 200,
// expensesCategories = ExpensesCategoryManager.Instance.GetExpensesCategoryById(1)
//});
//context.ExpensesCategories.AddOrUpdate(new ExpensesCategory
//{
// id = 1,
// name = "Mat"
//});
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
}
public void CreateIncome(Income incomes)
{
using (var db = new JohannaContext())
{
db.Incomes.Add(incomes);
db.SaveChanges();
}
}
public List <Income> GetIncome()
{
using (var db = new JohannaContext())
{
var incomes = db.Incomes.ToList();
return(incomes);
}
}
public void CreateExpensesCategory(ExpensesCategory expensesCategory)
{
using (var db = new JohannaContext())
{
db.ExpensesCategories.Add(expensesCategory);
db.SaveChanges();
}
}
public List <ExpensesCategory> GetExpensesCategories()
{
using (var db = new JohannaContext())
{
//var categories = db.ExpensesCategories.Include("Expenses").ToList();
return(db.ExpensesCategories.ToList());
}
}
public ExpensesCategory GetExpensesCategoryById(int id)
{
using (var db = new JohannaContext())
{
var expensesCategory = db.ExpensesCategories.Find(id);
return(expensesCategory);
}
}
public User GetUserByUsername(string username)
{
using (var db = new JohannaContext())
{
var user = db.Users.Find(username);
return(user);
}
}
public Expenses GetExpensesById(int id)
{
using (var db = new JohannaContext())
{
var expenses = db.Expenses.Find(id);
return(expenses);
}
}
public List <Expenses> GetExpenses()
{
using (var db = new JohannaContext())
{
var expenses = db.Expenses.Include(e => e.expensesCategories).ToList();
//var expenses = db.Expenses.ToList();
return(expenses);
}
}
public void CreateExpenses(Expenses expenses)
{
using (var db = new JohannaContext())
{
var category = db.ExpensesCategories.FirstOrDefault(e => e.name == expenses.expensesCategories.name);
if (category != null)
{
expenses.expensesCategories = category;
}
db.Expenses.AddOrUpdate(expenses);
db.SaveChanges();
}
}
public bool CreateUser(User user)
{
using (var db = new JohannaContext())
{
try
{
db.Users.Add(user);
db.SaveChanges();
return(true);
}
catch (DbUpdateException ex)
{
return(false);
}
}
}
