/// <summary>
/// Gets all the parks form the SQL Database.
/// </summary>
/// <returns>An <see cref="List{T}"/> of <see cref="ParkData"/>.</returns>
public IList <ParkData> GetParks()
{
List <ParkData> parks = new List <ParkData>();
string sqlQuery = "SELECT p.*, COALESCE(s.cnt, 0) AS SurveyCount " +
"FROM park AS p " +
"LEFT JOIN (SELECT parkCode, COUNT(parkCode) AS cnt " +
"FROM survey_result " +
"GROUP BY parkCode" +
") AS s ON p.parkCode = s.parkCode " +
"ORDER BY p.parkCode;";
try
{
using (SqlConnection conn = new SqlConnection(this.connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlQuery, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ParkData park = this.ConvertSqlToPark(reader);
parks.Add(park);
}
}
}
catch (SqlException)
{
throw;
}
return(parks);
}
private void GeneratePark(ParkData[] parks)
{
for (int i = 1; i < 5; i++)
{
string name = "";
switch (i)
{
case 1:
name = "Backyard";
break;
case 2:
name = "Boneyard";
break;
case 3:
name = "Junkyard";
break;
case 4:
name = "Rockyard";
break;
default:
throw new System.ArgumentException("No name for Park[" + i + "]", "original");;
}
Locations[i] = new ParkData(name, i);
}
}
/// <summary>
/// Gets a Single park from the SQL Database via the park code.
/// </summary>
/// <param name="code">The park's unique code.</param>
/// <returns>a <see cref="ParkData"/> model.</returns>
public ParkData GetPark(string code)
{
ParkData park = new ParkData();
string sqlQuery = "SELECT p.*, COALESCE(s.cnt, 0) AS SurveyCount " +
"FROM park AS p LEFT JOIN (SELECT parkCode, COUNT(parkCode) AS cnt " +
"FROM survey_result " +
"GROUP BY parkCode" +
") AS s ON p.parkCode = s.parkCode " +
"WHERE p.parkCode = @parkCode " +
"ORDER BY p.parkCode;";
try
{
using (SqlConnection conn = new SqlConnection(this.connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlQuery, conn);
cmd.Parameters.AddWithValue("@parkCode", code);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
park = this.ConvertSqlToPark(reader);
}
}
}
catch (SqlException)
{
throw;
}
return(park);
}
public ParkManager(Random RNG, int players)
{
Locations = new ParkData[6];
GeneratePark(Locations);
Locations[0] = new ParkData("Lab", 0);
Locations[5] = new ParkData("Arena", 0);
AddParts(RNG, players);
}
public string[] Execute(VehiclePark vehiclePark)
{
var layout = new ParkLayout(Int32.Parse(_parameters["sectors"]), Int32.Parse(_parameters["placesPerSector"]));
var data = new ParkData(Int32.Parse(_parameters["sectors"]));
vehiclePark.VehicleParkCreated = true;
vehiclePark.Layout = layout;
vehiclePark.Data = data;
return(new[] { "Vehicle park created" });
}
public IActionResult DailySurvey()
{
if (this.Request.Cookies["SurveyComplete"] != null)
{
return(this.RedirectToAction("FavoriteParks"));
}
ParkData park = new ParkData();
IList <ParkData> parks = this.parkDAO.GetParks();
this.ViewData["ParkList"] = parks;
return(this.View());
}
public IActionResult Detail(string code)
{
ParkData park = this.parkDAO.GetPark(code);
string advisories = string.Empty;
IList <DailyWeather> forecast = this.weatherDAO.GetWeather(code);
if (forecast[0].Forecast == "snow")
{
advisories += "Snow advisory. Pack snowshoes. ";
}
if (forecast[0].Forecast == "rain" || forecast[0].Forecast == "thunderstorms")
{
advisories += "Rain advisory. Pack rain gear and wear waterproof shoes. ";
}
if (forecast[0].Forecast == "thunderstorms")
{
advisories += "Thunderstorm advisory. Seek shelter and avoid hiking on exposed ridges. ";
}
if (forecast[0].Forecast == "sunny")
{
advisories += "Weather advisory. Pack sunblock. ";
}
if (forecast[0].HiTemp > 75)
{
advisories += "Heat advisory. Bring an extra gallon of water. ";
}
if (forecast[0].HiTemp - forecast[0].LowTemp > 20)
{
advisories += "Temperature differential advisory. Wear breathable layers. ";
}
if (forecast[0].LowTemp < 20)
{
advisories += "Cold advisory. Beware of exposure to frigid temperatures. ";
}
ParkDetailViewModel model = new ParkDetailViewModel
{
Park = park,
Forecast = forecast,
WeatherAdvisories = advisories
};
return(this.View(model));
}
private ParkData getPark(dynamic json, string parkName)
{
for (int i = 1; i < json.Count; i++)//0 is timestamp
{
if (json[i].Nome.ToString().Equals(parkName))
{
ParkData park = new ParkData(mapping[parkName], true);
park.Capacidade = int.Parse(json[i].Capacidade.ToString());
park.Ocupado = int.Parse(json[i].Ocupado.ToString());
park.Livre = int.Parse(json[i].Livre.ToString());
return(park);
}
}
return(new ParkData(parkName, false));
}
private List <ParkData> getAllPark(dynamic json)
{
List <ParkData> list = new List <ParkData>();
for (int i = 1; i < json.Count; i++)
{//0 is timestamp
if (!invalidParks.Contains(json[i].Nome.ToString()))
{
ParkData park = new ParkData(mapping[json[i].Nome.ToString()], true);
park.Capacidade = int.Parse(json[i].Capacidade.ToString());
park.Ocupado = int.Parse(json[i].Ocupado.ToString());
park.Livre = int.Parse(json[i].Livre.ToString());
list.Add(park);
}
}
return(list);
}
public void manageDialogueSAS(ParkData park, string[] args)
{
string phrase = "";
if (park.Found)
{
switch (args[1])
{
case ("SUBTYPE1"):
case ("SUBTYPE2"):
if (park.Livre > 0)
{
phrase = answers.getParkIsFree(park);
}
else
{
phrase = answers.getParkIsNotFree(park);
}
break;
case ("SUBTYPE3"):
if (park.Livre > 0)
{
phrase = answers.getParkFreeSpots(park);
}
else
{
phrase = answers.getParkNoFreeSpots(park);
}
break;
}
}
else
{
phrase = answers.getParkNotFound(park.Nome);
}
t.Speak(phrase);
}
private bool addParkName(string name)
{
ParkData pd = _data.currentPark;
bool success = false;
if (name != "Unnamed Park" &&
(pd.names.Count == 0 || pd.names[pd.names.Count - 1] != name))
{
Debug.LogMT("New park name " + name);
pd.names.Add(name);
if (_settings.updateParkSessionData)
{
pd.sessions[pd.sessionIdx].names.Add(name);
}
success = true;
}
else
{
Debug.LogMT("No new park name");
}
return(success);
}
private void handleResponse(string response, string[] args)
{
dynamic json = JsonConvert.DeserializeObject(response);
//Console.WriteLine(json.ToString());
switch (args[0])
{
case "TYPE1":
case "TYPE3":
dManager.manageDialogueSAS(getAllPark(json), args);
dManager.displayParks(getAllPark(json));
break;
case "TYPE2":
ParkData park = getPark(json, args[2]);
dManager.displayParks(new List <ParkData>(1)
{
park
});
dManager.manageDialogueSAS(park, args);
break;
}
}
/// <summary>
/// Converts the reader data into a <see cref="ParkData"/> model.
/// </summary>
/// <param name="reader">A <see cref="SqlDataReader"/></param>
/// <returns>A <see cref="ParkData"/> model.</returns>
private ParkData ConvertSqlToPark(SqlDataReader reader)
{
ParkData park = new ParkData
{
Name = Convert.ToString(reader["parkName"]),
Code = Convert.ToString(reader["parkCode"]),
State = Convert.ToString(reader["state"]),
Climate = Convert.ToString(reader["climate"]),
Campsites = Convert.ToInt32(reader["numberOfCampsites"]),
Acreage = Convert.ToInt32(reader["acreage"]),
AnnualVisitorCount = Convert.ToInt32(reader["annualVisitorCount"]),
Description = Convert.ToString(reader["parkDescription"]),
Elevation = Convert.ToInt32(reader["elevationInFeet"]),
EntryFee = Convert.ToDecimal(reader["entryFee"]),
TrailMiles = Convert.ToInt32(reader["milesOfTrail"]),
YearFounded = Convert.ToInt32(reader["yearFounded"]),
Quote = Convert.ToString(reader["inspirationalQuote"]),
QuoteAuthor = Convert.ToString(reader["inspirationalQuoteSource"]),
NumSpecies = Convert.ToInt32(reader["numberOfAnimalSpecies"]),
SurveyCount = Convert.ToInt32(reader["SurveyCount"])
};
return(park);
}
public string getParkNoFreeSpots(ParkData park)
{
return(parkNoFreeSpots[random.Next(0, parkNoFreeSpots.Length)].Replace("<NOME_PARQUE_ESTACIONAMENTO>", park.Nome));
}
public string getParkFreeSpots(ParkData park)
{
return(parkFreeSpots[random.Next(0, parkFreeSpots.Length)].Replace("<NOME_PARQUE_ESTACIONAMENTO>", park.Nome).Replace("<NUM_LIVRES>", park.Livre.ToString()));
}
public string getParkIsNotFree(ParkData park)
{
return(parkIsNotFree[random.Next(0, parkIsNotFree.Length)].Replace("<NOME_PARQUE_ESTACIONAMENTO>", park.Nome));
}
