public static ICollection<Category> GetAllCategories()
{
// The using statement prevents read/write errors with database. - Parsons
// source: http://robertgreiner.com/2012/07/entity-framework-open-datareader-associated-with-command/
using (var ctx = new OrderingSystemDbContext())
{
return ctx.Categories.ToList();
}
}
public static User FindUserByEmailAndPassword(string email, string password, OrderingSystemDbContext db)
{
return db.Users.FirstOrDefault(x => x.Email.Equals(email) && x.Password.Equals(password));
}