// get a particular stop's info by its stop id
public Stops getStopInfo(int stopID)
{
var query = from stop in m_CTA.Stops
where stop.StopID == stopID
select stop;
Stops stopInfo;
if (query != null)
{
//format the data that was retrieved
foreach (FinalProject.Stop row in query)
{
stopInfo = new Stops(Convert.ToInt32(row.StopID), Convert.ToInt32(row.StationID), Convert.ToString(row.Name), Convert.ToString(row.Direction), Convert.ToInt32(row.ADA), Convert.ToDouble(row.Latitude), Convert.ToDouble(row.Longitude));
return(stopInfo);
}
}
return(null);
}
// get all the info for stops at a particular stations
public IReadOnlyList<Stops> getAllStopsbyLocation(double latitude, double longitude)
{
List<Stops> stops = new List<Stops>();
var query = from stop in m_CTA.Stops
where stop.Latitude == latitude && stop.Longitude == longitude
select stop;
// if we did retrieve data
if (query != null)
{
//format the data that was retrieved and add it to the list lines
foreach (var row in query)
{
Stops newAdd = new Stops(Convert.ToInt32(row.StopID), Convert.ToInt32(row.StationID), Convert.ToString(row.Name), Convert.ToString(row.Direction), Convert.ToInt32(row.ADA), Convert.ToInt32(row.Latitude), Convert.ToInt32(row.Longitude));
stops.Add(newAdd);
}
return stops;
}
return null;
}
// get all the info for stops at a particular stations
public IReadOnlyList <Stops> getAllStopsbyLocation(double latitude, double longitude)
{
List <Stops> stops = new List <Stops>();
var query = from stop in m_CTA.Stops
where stop.Latitude == latitude && stop.Longitude == longitude
select stop;
// if we did retrieve data
if (query != null)
{
//format the data that was retrieved and add it to the list lines
foreach (var row in query)
{
Stops newAdd = new Stops(Convert.ToInt32(row.StopID), Convert.ToInt32(row.StationID), Convert.ToString(row.Name), Convert.ToString(row.Direction), Convert.ToInt32(row.ADA), Convert.ToInt32(row.Latitude), Convert.ToInt32(row.Longitude));
stops.Add(newAdd);
}
return(stops);
}
return(null);
}
// get all the info for stops at a particular stations
public IReadOnlyList<Stops> getAllStopsbyStationID(int stationID)
{
// list that will contain stop objects
List<Stops> stops = new List<Stops>();
// query all stops' info
var query = from stop in m_CTA.Stops
where stop.StationID == stationID
select stop;
// if we did retrieve data
if(query != null)
{
//format the data that was retrieved and add it to the list lines
foreach (var row in query)
{
Stops newAdd = new Stops(Convert.ToInt32(row.StopID), Convert.ToInt32(row.StationID), Convert.ToString(row.Name), Convert.ToString(row.Direction), Convert.ToInt32(row.ADA), Convert.ToInt32(row.Latitude), Convert.ToInt32(row.Longitude));
stops.Add(newAdd);
}
// return list
return stops;
}
return null;
}
// get a particular stop's info by its stop id
public Stops getStopInfo(int stopID)
{
var query = from stop in m_CTA.Stops
where stop.StopID == stopID
select stop;
Stops stopInfo;
if (query != null)
{
//format the data that was retrieved
foreach (FinalProject.Stop row in query)
{
stopInfo = new Stops(Convert.ToInt32(row.StopID), Convert.ToInt32(row.StationID), Convert.ToString(row.Name), Convert.ToString(row.Direction), Convert.ToInt32(row.ADA), Convert.ToDouble(row.Latitude), Convert.ToDouble(row.Longitude));
return stopInfo;
}
}
return null;
}