public List <Category> GetCategories()
{
using (var context = new ActivityCenterContext(_connectionString))
{
return(context.Categories.OrderBy(c => c.Name).ToList());
}
}
public List <Activity> GetActivities()
{
using (var context = new ActivityCenterContext(_connectionString))
{
return(context.Activities.OrderByDescending(a => a.DatePosted).ToList());
}
}
public void AddCategory(Category category)
{
using (var context = new ActivityCenterContext(_connectionString))
{
context.Categories.Add(category);
context.SaveChanges();
}
}
public void AddActivity(Activity activity)
{
using (var context = new ActivityCenterContext(_connectionString))
{
context.Activities.Add(activity);
context.SaveChanges();
}
}
public void AddUser(User user)
{
user.Password = BCrypt.Net.BCrypt.HashPassword(user.Password);
using (var context = new ActivityCenterContext(_connectionString))
{
context.Users.Add(user);
context.SaveChanges();
}
}
public int GetIdForEmail(string email)
{
int id = 0;
using (var context = new ActivityCenterContext(_connectionString))
{
id = context.Users.FirstOrDefault(u => u.Email == email).Id;
}
return(id);
}
public string GetPasswordForEmail(string email)
{
string password = "";
using (var context = new ActivityCenterContext(_connectionString))
{
password = context.Users.FirstOrDefault(u => u.Email == email).Password;
}
return(password);
}
