public void CreateNewCategory(string name) { using (var context = new ExpenseEntities()) { ExpenseCategory category = new ExpenseCategory() { CategoryName = name }; context.ExpenseCategory.Add(category); context.SaveChanges(); } }
public void CreateNewUser(string name, string password) { using (var context = new ExpenseEntities()) { Users user = new Users() { Name = name, Password = password }; context.Users.Add(user); context.SaveChanges(); } }
public void CreateNewExpense(string description, DateTime date, string category, decimal price) { using (var context = new ExpenseEntities()) { ExpenseCategory cat = context.ExpenseCategory.Where(x => x.CategoryName == category).FirstOrDefault(); Expenses expense = new Expenses() { Description = description, Date = date, Price = price, Category = cat, Users_ID = Global.UserID }; context.Expenses.Add(expense); context.SaveChanges(); } }