public IEnumerable <ArchiveListItem> GetTodaysArchive() { using (var ctx = new ApplicationDbContext()) { var activityService = new ActivityService(_userId); var archives = ctx .Archives .Where(e => e.Id == _userId) .Select( e => new ArchiveListItem() { ArchiveId = e.ArchiveId, ActivityId = e.ActivityId, CreatedUtc = e.CreatedUtc, }) .ToList(); List <ArchiveListItem> toReturn = new List <ArchiveListItem>(); foreach (ArchiveListItem archive in archives) { if (archive.CreatedUtc.Date == DateTime.Now.Date) { archive.Name = activityService.GetActivityById(archive.ActivityId).Name; archive.Category = activityService.GetActivityById(archive.ActivityId).Category; toReturn.Add(archive); } } return(toReturn); } }
public IEnumerable <ArchiveListItem> GetActivityHistory() { using (var ctx = new ApplicationDbContext()) { var archive = ctx .Archives .Where(e => e.Id == _userId) .Select( e => new ArchiveListItem() { ArchiveId = e.ArchiveId, ActivityId = e.ActivityId, CreatedUtc = e.CreatedUtc, }); var complete = archive.ToList(); var activityService = new ActivityService(_userId); foreach (var activity in complete) { activity.Name = activityService.GetActivityById(activity.ActivityId).Name; activity.Category = activityService.GetActivityById(activity.ActivityId).Category; } return(complete); } }
public IEnumerable <ArchiveListItem> GetTodaysArchive() { using (var ctx = new ApplicationDbContext()) { var activityService = new ActivityService(_userId); return (ctx .Archives .Where(e => e.CreatedUtc == DateTime.Now.Date && e.Id == _userId) .Select( e => new ArchiveListItem() { ArchiveId = e.ArchiveId, ActivityId = e.ActivityId, Name = activityService.GetActivityById(e.ActivityId).Name, Category = activityService.GetActivityById(e.ActivityId).Category, CreatedUtc = e.CreatedUtc, }) .ToList()); } }