public List <EventStaffModel> LoadEventStaff(int eventId) { List <EventStaffModel> eventStaff = new List <EventStaffModel>(); using (AECEventManagementEntities context = new AECEventManagementEntities()) { } return(eventStaff); }
public static DbContext Create() { DbContext dbContext = CallContext.GetData("DbContext") as DbContext; if (dbContext == null) { dbContext = new AECEventManagementEntities(); CallContext.SetData("DbContext", dbContext); } return(dbContext); }
public List <EventPitStopModel> LoadEventPitStop(int eventId) { List <EventPitStopModel> eventPit = new List <EventPitStopModel>(); using (AECEventManagementEntities context = new AECEventManagementEntities()) { eventPit = (from ep in context.EventPits join p in context.PitStops on ep.PitStopID equals p.PitStopID where ep.EventID == eventId select new EventPitStopModel { PitStopId = ep.PitStopID, PitStopName = p.PitName, CurrentLat = ep.Lat, CurrentLng = ep.Lng }).ToList(); } return(eventPit); }
public List <EventTeamModel> LoadEventTeams(int eventId) { List <EventTeamModel> eventTeams = new List <EventTeamModel>(); using (AECEventManagementEntities context = new AECEventManagementEntities()) { eventTeams = (from et in context.EventTeams join t in context.Teams on et.TeamID equals t.TeamID where et.EventID == eventId select new EventTeamModel { TeamId = t.TeamID, TeamName = t.TeamName, CurrentLat = et.CurrentLatitude, CurrentLng = et.CurrentLongtitude, DistanceToNextStop = et.DistanceToNext, NumOfClearedStop = et.NumOfClearned }).OrderByDescending(x => x.NumOfClearedStop).ThenBy(x => x.DistanceToNextStop).ToList(); } return(eventTeams); }