public void Add(Query query)
{
using(var db = new QueryContext())
{
db.Queries.Add(query);
db.SaveChanges();
}
}
public void Add(Query query)
{
using (var db = new QueryContext())
{
db.Queries.Add(query);
db.SaveChanges();
}
}
public void Add(QueryResult queryResult, string name)
{
using (var db = new QueryContext())
{
queryResult.Query = db.Queries.FirstOrDefault(x => x.Name == name);
db.QueryResults.Add(queryResult);
db.SaveChanges();
}
}
public void UpdateRunDates(string name, DateTime lastRun, DateTime? nextRun)
{
using (var db = new QueryContext())
{
var query = db.Queries.FirstOrDefault(x => x.Name == name);
if (query == null)
return;
if( query.LastRun == null || lastRun > query.LastRun )
query.LastRun = lastRun;
query.NextRun = nextRun;
db.SaveChanges();
}
}
public void UpdateQuery(Query query)
{
using (var db = new QueryContext())
{
var q = db.Queries.Find(query.QueryId);
q.Name = query.Name;
q.DatabaseName = query.DatabaseName;
q.AlertEmailTo = query.AlertEmailTo;
q.AlertIfAboveThreshold = query.AlertIfAboveThreshold;
q.CronExpression = query.CronExpression;
q.QueryText = query.QueryText;
q.ThresholdMilliseconds = query.ThresholdMilliseconds;
db.SaveChanges();
}
}
