public static string GetLocations()
{
_sqlConn = new SqlConnection(Properties.Settings.Default.TirCache);
_sqlConn.Open();
_dataTables = new webTirCache();
var taStations = new StationsTableAdapter();
var tblStations = _dataTables.Stations;
taStations.Fill(tblStations);
string stationArray = "";
for (int i = 0; i < tblStations.Count; i++)
{
//six positions
stationArray += string.Format(@"[""{0}"",""<strong>{0}</strong><p>{1}</p>"",{2},{3},{4},""{1}""]",
tblStations[i].Name,
tblStations[i].Type,
tblStations[i].Latitude,
tblStations[i].Longitude,
tblStations[i].Id);
if (i != tblStations.Count)
{
stationArray += ",";
}
}
stationArray = string.Format(@"[{0}]", stationArray);
return(stationArray);
}
public ActionResult GetLocations()
{
_dataTables = new webTirCache();
var taStations = new StationsTableAdapter();
var tblStations = _dataTables.Stations;
taStations.Fill(tblStations);
List <StationsRow> Stations = new List <StationsRow>();
foreach (var row in tblStations)
{
Stations.Add(row);
}
return(Content("yolo"));
}