public IEnumerable<Activity> GetActivities() { using (var entities = new UserActivityLogEntities()) { return entities.Activities.Include(a => a.Parent).ToList(); } }
public IEnumerable <Activity> GetActivities() { using (var entities = new UserActivityLogEntities()) { return(entities.Activities.Include(a => a.Parent).ToList()); } }
public IEnumerable<ActivityRecord> GetActivityLog(DateTime date) { using (var entities = new UserActivityLogEntities()) { return GetActivityLog(entities, date).ToList(); } }
public IEnumerable<ActivityRecord> GetRecords() { using (var entities = new UserActivityLogEntities()) { return entities.ActivityRecords.Include(r => r.Activity).Select(Clone).ToList(); } }
public IEnumerable<ActivityRecord> GetActivityLog(DateTime date, Expression<Func<ActivityRecord, bool>> filter) { using (var entities = new UserActivityLogEntities()) { return GetActivityLog(entities, date).Where(filter).ToList(); } }
private static IQueryable <ActivityRecord> GetActivityLog(UserActivityLogEntities entities, DateTime date) { date = date.Date; return(entities.ActivityRecords.Include(r => r.Activity) .Where(s => s.StartTime >= date || s.EndTime >= date)); }
public IEnumerable <ActivityRecord> GetRecords() { using (var entities = new UserActivityLogEntities()) { return(entities.ActivityRecords.Include(r => r.Activity).Select(Clone).ToList()); } }
public IEnumerable <ActivityRecord> GetActivityLog(DateTime date, Expression <Func <ActivityRecord, bool> > filter) { using (var entities = new UserActivityLogEntities()) { return(GetActivityLog(entities, date).Where(filter).ToList()); } }
public IEnumerable <ActivityRecord> GetActivityLog(DateTime date) { using (var entities = new UserActivityLogEntities()) { return(GetActivityLog(entities, date).ToList()); } }
public TimeSpan GetRemainingWorkTime(TimeSpan workDayDuration) { using (var entities = new UserActivityLogEntities()) { IEnumerable<ActivityRecord> activityLog = GetActivityLog(entities, DateTime.Now).Where(r => r.Activity.IsWork); long duration = activityLog.Sum(r => r.DurationTicks); return workDayDuration - TimeSpan.FromTicks(duration); } }
public TimeSpan GetRemainingWorkTime(TimeSpan workDayDuration) { using (var entities = new UserActivityLogEntities()) { IEnumerable <ActivityRecord> activityLog = GetActivityLog(entities, DateTime.Now).Where(r => r.Activity.IsWork); long duration = activityLog.Sum(r => r.DurationTicks); return(workDayDuration - TimeSpan.FromTicks(duration)); } }
public ActivityRecord GetLastRecord() { using (var entities = new UserActivityLogEntities()) { return entities.ActivityRecords.Include(r => r.Activity) .OrderByDescending(s => s.EndTime) .Take(1) .ToList() .FirstOrDefault(); } }
public ActivityRecord GetLastRecord() { using (var entities = new UserActivityLogEntities()) { return (entities.ActivityRecords.Include(r => r.Activity) .OrderByDescending(s => s.EndTime) .Take(1) .ToList() .FirstOrDefault()); } }
public void Add(ActivityRecord activityRecord) { using (var entities = new UserActivityLogEntities()) { if (activityRecord.Activity != null) { activityRecord.Activity = entities.Activities.Single(a => a.ActivityId == activityRecord.Activity.ActivityId); } var record = entities.ActivityRecords.Add(activityRecord); entities.SaveChanges(); activityRecord.ActivityRecordId = record.ActivityRecordId; } }
public void Update(ActivityRecord activityRecord) { using (var entities = new UserActivityLogEntities()) { var existingState = entities.ActivityRecords.Single(s => s.ActivityRecordId == activityRecord.ActivityRecordId); existingState.StartTime = activityRecord.StartTime; existingState.EndTime = activityRecord.EndTime; existingState.Idle = activityRecord.Idle; if (activityRecord.Activity != null) { existingState.Activity = entities.Activities.Single(a => a.ActivityId == activityRecord.Activity.ActivityId); } entities.SaveChanges(); } }
private static IQueryable<ActivityRecord> GetActivityLog(UserActivityLogEntities entities, DateTime date) { date = date.Date; return entities.ActivityRecords.Include(r => r.Activity) .Where(s => s.StartTime >= date || s.EndTime >= date); }