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