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