public IEnumerable <User> GetAllUsers()
{
using (var context = new RandomizerDBContext())
{
return(context.Users.Include(u => u.Requests).ToList());
}
}
public List <Request> GetAllRequests(Guid userGuid)
{
using (var context = new RandomizerDBContext())
{
var requests = context.Requests.Where(rec => rec.OwnerGuid == userGuid).ToList();
return(requests);
}
}
public void AddRequest(Guid userGuid, Request request)
{
using (var context = new RandomizerDBContext())
{
context.Users.FirstOrDefault(user1 => user1.Guid == userGuid)?.Requests.Add(request);
context.SaveChanges();
}
}
public void AddUser(User user)
{
using (var context = new RandomizerDBContext())
{
context.Users.Add(user);
context.SaveChanges();
}
}
public void ChangeUserDate(Guid userGuid)
{
using (var context = new RandomizerDBContext())
{
// ReSharper disable once PossibleNullReferenceException
context.Users.FirstOrDefault(user => user.Guid == userGuid).Time = DateTime.Now;
context.SaveChanges();
}
}
