///
/// <summary>
/// Returns the CTA Stops associated with a given station,
/// ordered by name.
/// </summary>
/// <returns>Read-only list of CTAStop objects</returns>
///
public IReadOnlyList <CTAStop> GetStops(int stationID)
{
List <CTAStop> list = new List <CTAStop>();
try
{
String sql = string.Format(@"
Select *
From Stops
Where StationID = {0}
Order by Name
", stationID);
DataSet stops = dataTier.ExecuteNonScalarQuery(sql);
foreach (DataRow row in stops.Tables["TABLE"].Rows)
{
var stop = new BusinessTier.CTAStop(Convert.ToInt32(row["StopID"]), Convert.ToString(row["Name"]), Convert.ToInt32(row["StationID"]),
Convert.ToString(row["Direction"]), Convert.ToBoolean(row["ADA"]), Convert.ToDouble(row["Latitude"]), Convert.ToDouble(row["Longitude"]));
list.Add(stop);
}
}
catch (Exception ex)
{
string msg = string.Format("Error in Business.GetStops: '{0}'", ex.Message);
throw new ApplicationException(msg);
}
return(list);
}
///
/// <summary>
/// Returns the CTA Stops associated with a given station,
/// ordered by name.
/// </summary>
/// <returns>Read-only list of CTAStop objects</returns>
///
public IReadOnlyList <CTAStop> GetStops(int stationID)
{
List <CTAStop> stops = new List <CTAStop>();
DataSet result;
try
{
//
// TODO!
//
DataAccessTier.Data dataTier = new DataAccessTier.Data(_DBFile);
string sql = string.Format(@"SELECT * FROM Stops
WHERE Stops.StationID = '{0}'; ", stationID);
result = dataTier.ExecuteNonScalarQuery(sql);
foreach (DataRow row in result.Tables["TABLE"].Rows)
{
int Stationid = Convert.ToInt32(row["StationID"]);
int Stopid = Convert.ToInt32(row["StopID"]);
string name = string.Format("{0}", Convert.ToString(row["Name"]));
string direction = string.Format("{0}", Convert.ToString(row["Direction"]));
bool ada = Convert.ToBoolean(row["ADA"]);
double lat = Convert.ToDouble(row["Latitude"]);
double lon = Convert.ToDouble(row["Longitude"]);
var s = new BusinessTier.CTAStop(Stopid, name, Stationid, direction, ada, lat, lon);
stops.Add(s);
}
}
catch (Exception ex)
{
string msg = string.Format("Error in Business.GetStops: '{0}'", ex.Message);
throw new ApplicationException(msg);
}
return(stops);
}
