/// <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);
}
