public VisitDetail GetVisitByID(int visitID) { using (var ctx = new ApplicationDbContext()) { var entity = ctx.Visits.FirstOrDefault(visit => visit.VisitID == visitID && visit.OwnerID == _userID); if (entity != null) { VisitorService visitorService = new VisitorService(_userID, _userIsAdmin); GameService gameService = new GameService(_userID, _userIsAdmin); return(new VisitDetail { VisitID = entity.VisitID, GotPin = entity.GotPin, TookPhoto = entity.TookPhoto, Game = gameService.GetGameByID(entity.GameID), Visitor = visitorService.GetVisitorByID(entity.VisitorID) }); } else { return(null); } } }
public IEnumerable <VisitListItem> GetAllVisits() { using (var ctx = new ApplicationDbContext()) { VisitorService visitorService = new VisitorService(_userID, _userIsAdmin); GameService gameService = new GameService(_userID, _userIsAdmin); var visits = ctx.Visits .Where(visit => visit.OwnerID == _userID) .Select( entity => new VisitListItem { VisitID = entity.VisitID, GotPin = entity.GotPin, TookPhoto = entity.TookPhoto, VisitorID = entity.VisitorID, GameID = entity.GameID } ).ToArray(); foreach (var visit in visits) { visit.Visitor = visitorService.GetVisitorByID(visit.VisitorID); visit.Game = gameService.GetGameByID(visit.GameID); } var orderedVisits = visits.OrderBy(visit => visit.Game.DateOfGame).ToArray(); return(orderedVisits); } }