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