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 Query SetExecuted(Query query)
{
using (QueriesContext context = new QueriesContext())
{
context.Queries.Attach(query);
query.IsExecuted = true;
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);
}
