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