public static List <Station> GetStations()
{
List <Station> stations = new List <Station>();
using (SqlConnection c = new SqlConnection(Settings.connString))
{
SqlCommand cmd = new SqlCommand(Queries.q_GetStations, c);
c.Open();
SqlDataAdapter a = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
a.Fill(dt);
stations = Transformer.ConvertDTtoStations(dt);
}
return(stations);
}
