public ParkListModel GetPark(string parkCode, char unit)
{
ParkListModel output = new ParkListModel();
// output = null;
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand(SQL_GetPark, connection);
cmd.Parameters.AddWithValue("@parkCode", parkCode);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{ //output = new ParkListModel
string pCode = Convert.ToString(reader["parkCode"]);
string parkName = Convert.ToString(reader["parkName"]);
string state = Convert.ToString(reader["state"]);
string parkDescription = Convert.ToString(reader["parkDescription"]);
int acreage = Convert.ToInt32(reader["acreage"]);
int elevation = Convert.ToInt32(reader["elevationInFeet"]);
int milesOfTrail = Convert.ToInt32(reader["milesOfTrail"]);
int numberOfCampsites = Convert.ToInt32(reader["numberOfCampsites"]);
int yearFounded = Convert.ToInt32(reader["yearFounded"]);
int annualVisitorCount = Convert.ToInt32(reader["annualVisitorCount"]);
string inspirationalQuote = Convert.ToString(reader["inspirationalQuote"]);
string inspirationalQuoteSource = Convert.ToString(reader["inspirationalQuoteSource"]);
int entryFee = Convert.ToInt32(reader["entryFee"]);
int numberOfAnimalSpecies = Convert.ToInt32(reader["numberOfAnimalSpecies"]);
string climate = Convert.ToString(reader["climate"]);
output.ParkCode = pCode;
output.ParkName = parkName;
output.State = state;
output.ParkDescription = parkDescription;
output.Acreage = acreage;
output.Elevation = elevation;
output.MilesOfTrail = milesOfTrail;
output.NumberOfCampsites = numberOfCampsites;
output.YearFounded = yearFounded;
output.AnnualVisitorCount = annualVisitorCount;
output.InspirationalQuote = inspirationalQuote;
output.InspirationalQuoteSource = inspirationalQuoteSource;
output.EntryFee = entryFee;
output.NumberOfAnimalSpecies = numberOfAnimalSpecies;
output.Climate = climate;
output.Unit = unit; //assign the unit passed in from Home Controller
}
return(output);
}
}
catch (SqlException ex)
{
throw;
}
}
public List <ParkListModel> GetAllParks()
{
List <ParkListModel> output = new List <ParkListModel>();
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand(SQL_GetAllParks, connection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string parkCode = Convert.ToString(reader["parkCode"]);
string parkName = Convert.ToString(reader["parkName"]);
string state = Convert.ToString(reader["state"]);
string parkDescription = Convert.ToString(reader["parkDescription"]);
ParkListModel park = new ParkListModel();
park.ParkCode = parkCode;
park.ParkName = parkName;
park.State = state;
park.ParkDescription = parkDescription;
output.Add(park);
}
return(output);
}
}
catch (SqlException ex)
{
throw;
}
}