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