/// <summary> /// Retrieves park code, name, state, and description from Park table in NationalParkForecast DB /// </summary> /// <returns>ParkIndexModel List</returns> public List <ParkIndexModel> GetParks() { const string parkSQL = "SELECT parkCode, parkName, state, parkDescription FROM park;"; List <ParkIndexModel> parkList = new List <ParkIndexModel>(); try { using (SqlConnection conn = new SqlConnection(_connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(parkSQL, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ParkIndexModel parks = GetSingleParkIndexModel(reader); parkList.Add(parks); } } } catch (Exception) { throw; } return(parkList); }
// GET: Home public ActionResult Index() { ParkIndexModel parks = new ParkIndexModel(); parks.Fahrenheit = CheckTemp(); using (var context = new ParkSystemDatabaseEntities()) { parks.Parks = context.parks.ToList(); } return View(parks); }