public IList<UniUser> GetUsersByYear(int year) { try { using (UniUserDbContext db = new UniUserDbContext(ConnectionString)) { return db.UniUsers.Where(u => u.EnrolementYear.Year == year && u.IsActive) .Include(u => u.PermissionLevel) .Include(u => u.Photographs) .ToList(); } } catch (Exception e) { throw new Exception("Error Returning All Users For Year:" + year, e); } }
public IList<UniUser> GetAll() { try { using (UniUserDbContext db = new UniUserDbContext(ConnectionString)) { return db.UniUsers .Include(u => u.PermissionLevel) .Include(u => u.Photographs) .ToList(); } } catch (Exception e) { throw new Exception("Error Returning All Users", e); } }
public UniUser GetById(int userId) { try { using (UniUserDbContext db = new UniUserDbContext(ConnectionString)) { UniUser usr = db.UniUsers.Where(u => u.UserId == userId) .Include(u => u.PermissionLevel) .Include(u => u.Photographs) .SingleOrDefault(); return usr; } } catch (Exception e) { throw new Exception("Error Returning User for Id:" + userId, e); } }
public int AddOrUpdate(UniUser user) { try { using (UniUserDbContext db = new UniUserDbContext(ConnectionString)) { db.UniUsers.AddOrUpdate(user); db.SaveChanges(); return user.UserId; } } catch (Exception e) { if (user == null) { throw new Exception("Error Adding Updating User: User null", e); } throw new Exception( "Error Adding/Updating User: {Id:" + user.UserId + " Email:" + user.EmailAddress + "}", e); } }
public bool Remove(UniUser user) { try { using (UniUserDbContext db = new UniUserDbContext(ConnectionString)) { db.UniUsers.Attach(user); db.UniUsers.Remove(user); db.SaveChanges(); return true; } } catch (Exception e) { if (user == null) { throw new Exception("Error Removing User: User null", e); } throw new Exception("Error Removing User: {Id:" + user.UserId + " Email:" + user.EmailAddress + "}", e); } }