public ICollection <Query> Search(Func <Query, bool> predicate)
{
using (QueriesContext context = new QueriesContext())
{
var query = context.Queries.Where(predicate).ToList();
return(query);
}
}
public ICollection <Query> GetAllForUser(int userId)
{
using (QueriesContext context = new QueriesContext())
{
var query = context.Queries.Where(u => u.Users.Where(q => q.Id == userId).FirstOrDefault() != null);
return(query.ToList());
}
}
public ICollection <Query> GetAllNotExecuted()
{
using (QueriesContext context = new QueriesContext())
{
var query = context.Queries.Where(q => q.IsExecuted == false);
return(query.ToList());
}
}
public Query Get(int id)
{
using (QueriesContext context = new QueriesContext())
{
var query = context.Queries.Find(id);
return(query);
}
}
public ICollection <Query> GetAll()
{
using (QueriesContext context = new QueriesContext())
{
var query = context.Queries;
return(query.ToList());
}
}
public ICollection <User> Search(Func <User, bool> predicate)
{
using (QueriesContext context = new QueriesContext())
{
var users = context.Users.Where(predicate).ToList();
return(users);
}
}
public ICollection <User> GetAllForQuery(int queryId)
{
using (QueriesContext context = new QueriesContext())
{
var users = context.Users.Where(u => u.Queries.Where(q => q.Id == queryId).FirstOrDefault() != null).ToList();
return(users);
}
}
public ICollection <User> GetAll()
{
using (QueriesContext context = new QueriesContext())
{
var users = context.Users.ToList();
return(users);
}
}
public User Get(Func <User, bool> predicate)
{
using (QueriesContext context = new QueriesContext())
{
var user = context.Users.Where(predicate).FirstOrDefault();
return(user);
}
}
public User Get(int id)
{
using (QueriesContext context = new QueriesContext())
{
var user = context.Users.Find(id);
return(user);
}
}
public Query SetExecuted(Query query)
{
using (QueriesContext context = new QueriesContext())
{
context.Queries.Attach(query);
query.IsExecuted = true;
context.SaveChanges();
return(query);
}
}
public Query Add(Query newQuery)
{
using (QueriesContext context = new QueriesContext())
{
newQuery.CreationDate = DateTime.Now;
var query = context.Queries.Add(newQuery);
context.SaveChanges();
return(query);
}
}
public ICollection <User> Add(Query query, params User[] newUsers)
{
using (QueriesContext context = new QueriesContext())
{
context.Queries.Attach(query);
foreach (var newUser in newUsers)
{
User userExistCheck = context.Users.Find(newUser.Id);
if (userExistCheck == null)
{
userExistCheck = newUser;
context.Users.Add(newUser);
}
userExistCheck.Queries.Add(query);
}
context.SaveChanges();
}
return(newUsers);
}
