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 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 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; } }