public static void SaveQuery(Query query)
{
using (var context = new RandomizerDBContext())
{
context.Entry(query).State = EntityState.Modified;
context.SaveChanges();
}
}
public static void AddUser(User user)
{
using (var context = new RandomizerDBContext())
{
context.Users.Add(user);
context.SaveChanges();
}
}
public static void AddQuery(Query query)
{
using (var context = new RandomizerDBContext())
{
query.DeleteDatabaseValues();
context.Queries.Add(query);
context.SaveChanges();
}
}
public static void DeleteQuery(Query selectedQuery)
{
using (var context = new RandomizerDBContext())
{
selectedQuery.DeleteDatabaseValues();
context.Queries.Attach(selectedQuery);
context.Queries.Remove(selectedQuery);
context.SaveChanges();
}
}