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 static void DataProcessor(byte[] bytes) { var resultString = Encoding.Default.GetString(bytes); using (var stream = new MemoryStream()) using (var writer = new StreamWriter(stream)) using (var reader = new StreamReader(stream)) using (var csv = new CsvReader(reader)) { writer.Write(resultString); writer.Flush(); stream.Position = 0; csv.Configuration.Delimiter = ";"; List <csvStop> csvStops = csv.GetRecords <csvStop>().ToList(); List <tir.web.Models.Station> stations = new List <tir.web.Models.Station>(); for (int i = 0; i < csvStops.Count(); i++) { csvStops[i].desc = StopType(csvStops[i].desc); if (csvStops[i].desc != "Unknown") { stations.Add(new tir.web.Models.Station() { Name = csvStops[i].name, Type = csvStops[i].desc, Longitude = csvStops[i].longitude.Replace(",", "."), Latitude = csvStops[i].latitude.Replace(",", ".") }); } } stations = stations. GroupBy(o => new { o.Name, o.Type }) .Select(o => o.FirstOrDefault()) .ToList(); //saving _dataTables = new dsTirCache(); var taStation = new StationsTableAdapter(); var tblStations = _dataTables.Stations; foreach (var station in stations) { var newRow = tblStations.NewStationsRow(); newRow.Name = station.Name; newRow.Type = station.Type; newRow.Longitude = station.Longitude; newRow.Latitude = station.Latitude; tblStations.AddStationsRow(newRow); } taStation.Update(tblStations); } }
public static string GetLocations() { _dataTables = new dsTirCache(); 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("yolo"); }
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")); }