public void DeleteLogs(Guid requestUuid)
{
using (var context = new SqlDbContext())
{
context.Logs
.Where(x => x.RequestUuid == requestUuid)
.Delete();
context.SaveChanges();
}
}
public IEnumerable <string> GetLogs(Guid requestUuid)
{
using (var context = new SqlDbContext())
{
return((from r in context.Requests
join l in context.Logs on r.RequestUuid equals l.RequestUuid
where r.RequestUuid == requestUuid
orderby l.LogId
select l.RawLog).ToList());
}
}
public void UpdateRequest(Guid requestUuid, IEnumerable <string> apps, IEnumerable <string> exceptionApps)
{
using (var context = new SqlDbContext())
{
var request = context.Requests.SingleOrDefault(r =>
r.RequestUuid == requestUuid);
if (request == null)
{
return;
}
request.Apps = apps;
request.ExceptionApps = exceptionApps;
context.SaveChanges();
}
}
public void UpdateRequest(Guid requestUuid, string status, bool completedSearch = false, bool success = false)
{
using (var context = new SqlDbContext())
{
var request = context.Requests.SingleOrDefault(r =>
r.RequestUuid == requestUuid);
if (request == null)
{
return;
}
request.StatusMessage = status;
if (completedSearch)
{
request.Success = success;
request.CompletedRequestTime = DateTime.UtcNow;
}
context.SaveChanges();
}
}
