Esempio n. 1
0
        public CityForecast[] Get()
        {
            CityForecast namurForecast = new CityForecast("namur", 5);
            CityForecast monsForecast = new CityForecast("mons", 5);
            return new CityForecast[] { new CityForecast("namur", 5), new CityForecast("mons", 5) };

            //return (GetForecastFromDatabase());
        }
Esempio n. 2
0
        private CityForecast[] GetForecastFromDatabase()
        {
            SqlConnection connection = new SqlConnection(@"Data Source = (LocalDb)\MSSQLLocalDb; Initial Catalog = bobLeServeur; Integrated Security = True; Pooling = False");
            SqlCommand cmd = new SqlCommand("SELECT * FROM[Table]", connection);
            connection.Open();
            SqlDataReader reader;
            reader = cmd.ExecuteReader();

            List<CityForecast> forecasts = new List<CityForecast>();

            while (reader.Read())
            {
                CityForecast forecast = new CityForecast();
                forecast.City = (string)reader["City"];
                forecast.Tempe = (decimal)reader["tempe"];
                forecasts.Add(forecast);
            }
            reader.Close();
            connection.Close();

            return (forecasts.ToArray());
        }