/// <summary> /// Return all users in the system /// </summary> /// <returns></returns> public List <User> GetAll() { using (var context = new LobsterContext()) { var users = context.User.ToList(); return(users); } }
/// <summary> /// Return a user for the provided email and password /// </summary> /// <param name="email"></param> /// <param name="password"></param> /// <returns></returns> public User ForEmailAndPassword(string email, string password) { using (var context = new LobsterContext()) { var user = context.User.FirstOrDefault(x => x.Email == email && x.Password == password); return(user); } }
/// <summary> /// Dynamic search /// </summary> /// <param name="user"></param> /// <returns></returns> public List <Invoice> All(User user) { using (var context = new LobsterContext()) { var invoices = context.Invoice .Include(x => x.User) .Where(x => x.UserId == user.Id) .ToList(); return(invoices); } }
/// <summary> /// Dynamic search /// </summary> /// <param name="user"></param> /// <param name="column"></param> /// <param name="value"></param> /// <returns></returns> public List <Invoice> Search(User user, string column, string value) { using (var context = new LobsterContext()) { var invoices = context.Invoice .Include(x => x.User) .Where($"UserId={user.Id} AND {column} = \"{value}\"") .ToList(); return(invoices); } }
public DecisionsController(LobsterContext context, IDataRepository <Decision> repo) { _context = context; _repo = repo; }