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