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