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