public IList <Diagnostics> FetchDiagnosticsFromDate(DateTime fromDate)
{
using (IPrompterDiagnosticsDbContext context = _diagnosticsDbContextFactory.Create())
{
return(context.Diagnostics
.Where(diagnostic => diagnostic.Date >= fromDate)
.ToList());
}
}
public void ClearUserActivityHistory()
{
using (_diagnosticContext = _diagnosticFactory.Create())
{
var adapter = (IObjectContextAdapter)_diagnosticContext;
var objectContext = adapter.ObjectContext;
objectContext.ExecuteStoreCommand(SqlCommandToDeleteAllRows + TableName);
}
}
public void ClearUserActivityHistory()
{
using (_diagnosticContext = _diagnosticFactory.Create())
{
var adapter = (IObjectContextAdapter)_diagnosticContext;
var objectContext = adapter.ObjectContext;
objectContext.ExecuteStoreCommand(SqlCommandToDeleteAllRows + TableName);
}
}
public IList <Diagnostics> FetchLastDiagnostics()
{
using (IPrompterDiagnosticsDbContext context = _diagnosticsDbContextFactory.Create())
{
var delta = DateTime.Now.
Subtract(TimeSpan.FromDays(7));
return(context.Diagnostics
.Where(diagnostic => diagnostic.Date >= delta)
.ToList());
}
}
public IList <UserActivity> FetchAllLogs()
{
using (_diagnosticContext = _diagnosticFactory.Create())
{
var result = (from log
in _diagnosticContext.UserActivities
select log)
.OrderByDescending(l => l.Date)
.ToList();
return(result);
}
}
public IList<UserActivity> FetchAllLogs()
{
using (_diagnosticContext = _diagnosticFactory.Create())
{
var result = (from log
in _diagnosticContext.UserActivities
select log)
.OrderByDescending(l => l.Date)
.ToList();
return result;
}
}
public async Task SaveActivityAsync(UserActivity log)
{
if (log == null)
{
throw new ArgumentNullException("log");
}
using (_diagnosticContext = _diagnosticFactory.Create())
{
_diagnosticContext.UserActivities
.Add(log);
await _diagnosticContext.SaveChangesAsync();
}
}
public async Task SaveActivityAsync(UserActivity log)
{
if (log == null)
{
throw new ArgumentNullException("log");
}
using (_diagnosticContext = _diagnosticFactory.Create())
{
_diagnosticContext.UserActivities
.Add(log);
await _diagnosticContext.SaveChangesAsync();
}
}
public IList <UserActivity> FetchLogPage(int page)
{
var previousPages = page <= 0
? 0
: page - 1;
using (_diagnosticContext = _diagnosticFactory.Create())
{
var result = (from log
in _diagnosticContext.UserActivities
select log)
.OrderByDescending(l => l.Date)
.Skip(PageSize * previousPages)
.Take(PageSize)
.ToList();
return(result);
}
}
public IList<UserActivity> FetchLogPage(int page)
{
var previousPages = page <= 0
? 0
: page - 1;
using (_diagnosticContext = _diagnosticFactory.Create())
{
var result = (from log
in _diagnosticContext.UserActivities
select log)
.OrderByDescending(l => l.Date)
.Skip(PageSize * previousPages)
.Take(PageSize)
.ToList();
return result;
}
}
