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