//Get the most popular park public Park MostPopularBySurvey() { Park park = new Park(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(mostPopularBySurvey, conn); SqlDataReader results = cmd.ExecuteReader(); while (results.Read()) { park = CreatPark(results); } } } catch (SqlException ex) { throw; } return(park); }
/// <summary> /// Gets all the campgrounds and stores them as a list in the park object if they are in that park. /// </summary> /// <param name="parkID"></param> /// <returns></returns> public void GetCampgroundInfo(Park park) { try { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM campground WHERE park_id = @ID;", conn); cmd.Parameters.AddWithValue("ID", park.Id); SqlDataReader reader = cmd.ExecuteReader(); // Reading through all the rows and collecting each campgrounds information in the park. while (reader.Read()) { Campground campground = new Campground { ParkID = Convert.ToInt32(reader["park_id"]), CampgroundID = Convert.ToInt32(reader["campground_id"]), Name = Convert.ToString(reader["name"]), OpeningMonth = Convert.ToInt32(reader["open_from_mm"]), ClosingMonth = Convert.ToInt32(reader["open_to_mm"]), DailyFee = Convert.ToDecimal(reader["daily_fee"]) }; // Adding the campground to the list of campgrounds in the park object. park.Campgrounds.Add(campground); } } } catch (SqlException ex) { Console.WriteLine(ex.Message); } }
public TaskController() { // No parameter or return value Task task1_A = new Task(new Action(GetTheTime)); // Can have parameters and return values Task <int> task1_B = new Task <int>(() => GetTheTime("task1_B")); Task task2_A = new Task(delegate { Console.WriteLine("Hello {0}, The time is now {1}", "task2_A", DateTime.Now); }); Task task2_B = new Task(() => Console.WriteLine("Hello {0}, The time is now {1}", "task2_B", DateTime.Now)); task1_A.Start(); task1_B.Start(); Console.WriteLine(task1_B.Result); park = new Park(); // Using a Parallel.ForEach loop 10-9 Parallel.ForEach(park.Animals, animal => animal.MakeNoise()); //Using PLINQ 10-9 List <Animal> OlderThan5Animals = park.Animals.AsParallel().Where(e => e.Age > 5).ToList(); Parallel.ForEach(OlderThan5Animals, animal => animal.MakeNoise()); }
public List <Park> GetAllParks() { //Should be sorted alphabetically List <Park> parks = new List <Park>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM park", conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Park p = new Park(); p.ParkId = Convert.ToInt32(reader["park_id"]); p.Name = Convert.ToString(reader["name"]); p.Location = Convert.ToString(reader["location"]); p.EstablishDate = Convert.ToDateTime(reader["establish_date"]); p.Area = Convert.ToInt32(reader["area"]); p.Visitors = Convert.ToInt32(reader["visitors"]); p.Description = Convert.ToString(reader["description"]); parks.Add(p); } } } catch (SqlException ex) { Console.WriteLine("Unable to retrieve park data, please try again at a later time."); } return(parks); }
//returns list of all parks in system public List <Park> GetParks() { List <Park> output = new List <Park>(); using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT * FROM park ORDER BY park.name"; cmd.Connection = connection; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Park park = PopulateParkFromReader(reader); output.Add(park); } } return(output); }
/// <summary> /// Method to get a specific park from SQL DB based on parkID /// </summary> /// <param name="parkId"></param> /// <returns>Park object</returns> public Park GetPark(int parkId) { Park result = new Park(); using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); const string sqlGetPark = "SELECT name, location, establish_date, area, visitors, description, park_id FROM park WHERE park_id = @park_id;"; SqlCommand cmd = new SqlCommand(); cmd.CommandText = sqlGetPark; cmd.Connection = connection; cmd.Parameters.AddWithValue("@park_id", parkId); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Park park = PopulateParksFromReader(reader); result = park; } } return(result); }
/// <summary> /// Convert from DataReader to Park entitie. /// </summary> /// <returns>Park entitie.</returns> /// <param name="r">The reader component.</param> Park FromReader(SqliteDataReader r) { var t = new Park(); t.Id = Convert.ToInt32(r ["Id"]); t.Name = r ["Name"].ToString(); t.Company = r ["Company"].ToString(); t.Address = r ["Address"].ToString(); t.ZIPCode = r ["Name"].ToString(); t.Country = r ["Country"].ToString(); t.Latitude = Convert.ToDouble(r ["Latitude"]); t.Longitude = Convert.ToDouble(r ["Longitude"]); t.Phone = r ["Phone"].ToString(); t.OpeningHour = r ["OpeningHour"].ToString(); t.ClosingHour = r ["ClosingHour"].ToString(); t.PricePerHour = Convert.ToDouble(r ["PricePerHour"]); t.Floors = Convert.ToInt32(r ["Floors"]); t.DisabledSpaces = Convert.ToInt32(r ["DisabledSpaces"]); t.Capacity = Convert.ToInt32(r ["Capacity"]); t.Stocking = Convert.ToDouble(r ["Stocking"]); t.StockingRate = Convert.ToDouble(r ["StockingRate"]); return(t); }
public ActionResult ParkEvent(int id) { ParkEventViewModel parkEventView = new ParkEventViewModel() { Park = null, Sport = new Sport() { SportId = 1, sportName = "Soccer" } }; Park park = context.Parks.Where(p => p.ParkId == id).FirstOrDefault(); parkEventView.Park = park; List <ParkSport> parkSport = context.ParkSports.Where(p => p.ParkId == park.ParkId).ToList(); List <Sport> sportList = new List <Sport>(); foreach (ParkSport model in parkSport) { var sport = context.Sports.Where(s => s.SportId == model.SportId).FirstOrDefault(); sportList.Add(sport); } ViewBag.Results = sportList; parkEventView.SportsList = sportList; return(View(parkEventView)); }
public IList <Park> GetParks() { // Declare the result variable List <Park> list = new List <Park>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { // Open the connection conn.Open(); // Create the command for sql statement string sql = "Select * From park"; SqlCommand cmd = new SqlCommand(sql, conn); // Execute the query and get the result set in a reader SqlDataReader rdr = cmd.ExecuteReader(); // For each row, create a new department and add it to the list while (rdr.Read()) { Park park = RowToObject(rdr); list.Add(park); } } } catch (SqlException ex) { Console.WriteLine("An error occured when getting parks."); Console.WriteLine(ex.Message); } return(list); }
public List <Park> GetAllParksById() { List <Park> result = new List <Park>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_AllParksById, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Park p = new Park(); p.Park_Id = Convert.ToInt32(reader["park_id"]); p.Name = Convert.ToString(reader["name"]); p.Location = Convert.ToString(reader["location"]); p.Establish_Date = Convert.ToDateTime(reader["establish_date"]); p.Area = Convert.ToInt32(reader["area"]); p.Visitors = Convert.ToInt32(reader["visitors"]); p.Description = Convert.ToString(reader["description"]); result.Add(p); } } } catch (SqlException ex) { Console.WriteLine("Error!!!!"); } return(result); }
public IList <Park> GetAllParks() { IList <Park> parks = new List <Park>(); try { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); String Sql = "SELECT * FROM Park Order By name"; SqlCommand cmd = new SqlCommand(Sql, conn); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Park park = new Park(); park.ParkId = Convert.ToInt32(rdr["park_id"]); park.Name = Convert.ToString(rdr["name"]); park.Location = Convert.ToString(rdr["location"]); park.EstablishedDate = Convert.ToDateTime(rdr["establish_date"]); park.Area = Convert.ToInt32(rdr["area"]); park.Visitors = Convert.ToInt32(rdr["visitors"]); park.Description = Convert.ToString(rdr["description"]); parks.Add(park); } } } catch (SqlException ex) { throw new Exception(ex.Message); } return(parks); }
public IList <Park> GetParks() { List <Park> parksList = new List <Park>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("Select * From park", conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Park park = new Park(); park.ParkId = Convert.ToInt32(reader["park_id"]); park.Name = Convert.ToString(reader["name"]); park.Location = Convert.ToString(reader["location"]); park.EstablishDate = Convert.ToDateTime(reader["establish_date"]); park.Area = Convert.ToInt32(reader["area"]); park.Visitors = Convert.ToInt32(reader["visitors"]); park.Description = Convert.ToString(reader["description"]); parksList.Add(park); } } } catch (SqlException ex) { Console.WriteLine("There was a problem accessing the database."); throw; } return(parksList); }
public int AddPark(Park park) { const string sql = "INSERT park (" + "name, location, establish_date, area, visitors, description) " + "VALUES (" + "@name, @location, @establish_date, @area, @visitors, @description);"; using (SqlConnection conn = new SqlConnection(_connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(sql + _getLastIdSQL, conn); cmd.Parameters.AddWithValue("@name", park.Name); cmd.Parameters.AddWithValue("@location", park.Location); cmd.Parameters.AddWithValue("@establish_date", park.EstablishDate); cmd.Parameters.AddWithValue("@area", park.Area); cmd.Parameters.AddWithValue("@visitors", park.Visitors); cmd.Parameters.AddWithValue("@description", park.Description); park.ParkId = (int)cmd.ExecuteScalar(); } return(park.ParkId); }
public Park GetParkById(int parkId) { Park output = new Park(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("Select * From park Where park.park_id = @park_id", conn); cmd.Parameters.AddWithValue("@park_id", parkId); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Park park = new Park(); park.ParkId = Convert.ToInt32(reader["park_id"]); park.Name = Convert.ToString(reader["name"]); park.Location = Convert.ToString(reader["location"]); park.EstablishDate = Convert.ToDateTime(reader["establish_date"]); park.Area = Convert.ToInt32(reader["area"]); park.Visitors = Convert.ToInt32(reader["visitors"]); park.Description = Convert.ToString(reader["description"]); output = park; } } } catch (SqlException ex) { Console.WriteLine("There was a problem accessing the database."); throw; } return(output); }
public List <Park> GetAllParks() { List <Park> parks = new List <Park>(); try { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(SQL_GetAllParks, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Park park = new Park() { ParkID = Convert.ToInt32(reader["park_id"]), ParkName = Convert.ToString(reader["name"]), Location = Convert.ToString(reader["location"]), EstablishedDate = Convert.ToDateTime(reader["establish_date"]), AreaInAcres = Convert.ToInt32(reader["area"]), AnnualVisitors = Convert.ToInt32(reader["visitors"]), Description = Convert.ToString(reader["description"]) }; parks.Add(park); } } } catch (Exception) { throw; } return(parks); }
// GET: Home/Detail public ActionResult Detail(string parkCode, string scale) { if (scale == null) { scale = "true"; } else { Session["temp"] = scale; Session["button"] = scale; } ParkDetailViewModel model = new ParkDetailViewModel(); List <Weather> forecast = _weatherDAL.GetFiveDayForecast(parkCode); Park park = _parkdal.GetParkByCode(parkCode); model.PopulateParkProperties(park); model.PopulateForecast(forecast); model.IsFahrenheit = Convert.ToBoolean(Session["temp"]); return(View("Detail", model)); }
/// <summary> /// Campground selection menu /// </summary> /// <param name="park">Park object</param> private void DisplayCampgroundMenu(Park park) { bool quit = false; while (!quit) { List <Campground> campList = DisplayCampgroundInfo(park); Console.WriteLine(); Console.WriteLine("Select a Command"); Console.WriteLine("1) Search for Available Reservation"); Console.WriteLine("2) Return to Previous Screen"); int selection = CLIHelper.GetSingleInteger("Select an option...", 1, 2); if (selection == 1) { DisplayReservationMenu(park); } else if (selection == 2) { quit = true; } } }
public async Task <string> UpdatePark([FromBody] Park newpark) { if (!await DoesTokenOk()) { return("-1"); } //newpark._rev=(GetRev(newpark._id)).ToString(); var doesExist = await DoesParkExisted(newpark._id); if (!doesExist) { return("-1"); } newpark._rev = GetRev(newpark._id).Result; var hc = Helpers.CouchDBConnect.GetDB("parks"); string json = JsonConvert.SerializeObject(newpark); //var jsonObj = Newtonsoft.Json.Linq.JObject.Parse(json); //jsonObj.GetValue("_id"); //json = jsonObj.ToString(); HttpContent htc = new StringContent(json, System.Text.Encoding.UTF8, "application/json"); var response = await hc.PutAsync("parks/" + newpark._id, htc); //=============RRABITMQ========== //RabbitMQ Post new Log if there is no more room if (newpark.FreeSpots() == 0) { var wake = Helpers.CouchDBConnect.ConnectionMethod(5002); var up = await wake.GetAsync("LogActive/"); await RabbitMq.PublishAsync(new Email { details = "The park " + newpark.Name.ToString() + " is full" } ); } return("True"); }
/// <summary> /// Returns collection of all parks /// as Park data model objects /// </summary> /// <returns>Collection of Park data model objects</returns> public IList <Park> GetParks() { var parkList = new List <Park>(); const string sql = "SELECT * FROM park"; using (SqlConnection conn = new SqlConnection(_connectionString)) using (SqlCommand cmd = new SqlCommand(sql, conn)) { conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Park park = GetParkFromReader(reader); parkList.Add(park); } } } return(parkList); }
public void GetParkInfo() { // Arrange ParkSqlDAL dal = new ParkSqlDAL(ConnectionString); int ID = 0; using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); SqlCommand command = new SqlCommand("SELECT park_id FROM park", conn); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ID = Convert.ToInt32(reader["park_id"]); } } // Act Park test = dal.GetParkInfo(ID); // Assert Assert.AreEqual(250000, test.AnnualVisitorCount); }
public IList <Park> ListAllAvailableParks() { List <Park> parks = new List <Park>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); //Using SqlCommand to execute SQL query to get a list of parks SqlCommand cmd = new SqlCommand("SELECT * FROM park", conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Park park = new Park(); park.ParkId = Convert.ToInt32(reader["park_id"]); park.Name = Convert.ToString(reader["name"]); park.Location = Convert.ToString(reader["location"]); park.EstablishDate = Convert.ToDateTime(reader["establish_date"]); park.Area = Convert.ToInt32(reader["area"]); park.Visitors = Convert.ToInt32(reader["visitors"]); park.Description = Convert.ToString(reader["description"]); parks.Add(park); } } } catch (Exception e) { Console.WriteLine(e.Message); throw; } return(parks); }
public ActionResult Create([Bind(Include = "RegNum,Color,Brand,Model,NumberOfWheels,ParkedTime, MemberId,VehicleTypesId")] Park park) { var parkedVehicle = new ParkedVehicle(); if (ModelState.IsValid) { parkedVehicle.Color = park.Color; parkedVehicle.Brand = park.Brand; parkedVehicle.Model = park.Model; parkedVehicle.NumberOfWheels = park.NumberOfWheels; parkedVehicle.RegNum = park.RegNum; parkedVehicle.MemberId = park.MemberId; parkedVehicle.VehiclesTypeId = park.VehicleTypesId; parkedVehicle.ParkedTime = DateTime.Now; db.vehicles.Add(parkedVehicle); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(park)); //VehiclesViewModel s = new VehiclesViewModel(parkedVehicle.Id, parkedVehicle.RegNum, parkedVehicle.VehicleTypes, DateTime.Now, parkedVehicle.ParkedTime); }
/// <summary> /// Gets a list of parks /// </summary> /// <returns>A list of parks!</returns> public IList <Park> GetParks() { List <Park> parks = new List <Park>(); try { using (var conn = new SqlConnection(dbConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_GetParks, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Park p = new Park(); p.AnnualVisitorCount = Convert.ToInt32(reader["visitors"]); p.AreaInKmSquared = Convert.ToInt32(reader["area"]); p.DateEstablished = Convert.ToDateTime(reader["establish_date"]); p.Description = Convert.ToString(reader["description"]); p.Location = Convert.ToString(reader["location"]); p.Name = Convert.ToString(reader["name"]); p.ParkID = Convert.ToInt32(reader["park_id"]); parks.Add(p); } } } catch (SqlException ex) { Console.WriteLine("Looks like there is a problem reading or parsing your database!"); } return(parks); }
public static void InsertLocation() { using (var context = new LocationEntities()) { var park = new Park { Name = "11th Street Park", Address = "801 11th Street", City = "Aledo", State = "TX", ZIPCode = "76106" }; var loc = new Location { Address = "501 Main", City = "Weatherford", State = "TX", ZIPCode = "76201" }; park.Office = loc; context.Locations.Add(park); context.SaveChanges(); } }
private Park dbDeletePark(int id) { Park park = db.Parks.Find(id); if (park == null) { return(null); } foreach (var animalGenus in park.AnimalGenuses) { animalGenus.Parks.Remove(park); } foreach (var ringStation in park.RingStations) { ringStation.Park = null; } db.Parks.Remove(park); db.SaveChanges(); return(park); }
/// <summary> /// Fetches all national parks from the database. /// </summary> /// <returns></returns> public List <Park> GetAllParks() { List <Park> parkList = new List <Park>(); try { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM park ORDER BY name;", conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Park p = new Park(); p.Area = Convert.ToInt32(reader["area"]); p.Description = Convert.ToString(reader["description"]); p.Establish_Date = Convert.ToDateTime(reader["establish_date"]); p.Location = Convert.ToString(reader["location"]); p.Name = Convert.ToString(reader["name"]); p.Park_id = Convert.ToInt32(reader["park_id"]); p.Visitors = Convert.ToInt32(reader["visitors"]); parkList.Add(p); } } } catch (SqlException e) { Console.WriteLine("Something went wrong reading the database: \n" + e.Message); throw; } return(parkList); }
public IList <Park> GetParks() { List <Park> parks = new List <Park>(); try { // Create connection using (SqlConnection conn = new SqlConnection(connectionString)) { // Open the connection conn.Open(); // Create query and command object string sql = "SELECT * FROM park"; SqlCommand cmd = new SqlCommand(sql, conn); // Execute and get reader back SqlDataReader reader = cmd.ExecuteReader(); // Read each row while (reader.Read()) { // Create new object Park obj = RowToObject(reader); // Add Park to list parks.Add(obj); } } } catch (SqlException ex) { Console.WriteLine($"There was an error in GetParks: {ex.Message}"); } return(parks); }
public IList <Park> ViewParkDetails(int userInput) { try { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand($"SELECT * FROM park WHERE park_id = @userInput", connection); command.Parameters.AddWithValue("@userInput", userInput); command.ExecuteNonQuery(); SqlDataReader reader = command.ExecuteReader(); List <Park> parks = new List <Park>(); while (reader.Read()) { Park park = new Park(); park.Name = Convert.ToString(reader["name"]); park.Location = Convert.ToString(reader["location"]); park.EstablishDate = Convert.ToDateTime(reader["establish_date"]); park.Area = Convert.ToInt32(reader["area"]); park.Visitors = Convert.ToInt32(reader["visitors"]); park.Description = Convert.ToString(reader["description"]); parks.Add(park); } return(parks); } } catch (Exception exception) { Console.WriteLine(exception.Message); throw; } }
public IHttpActionResult GetParkInformation(int id) { Park park = new Park(); using (SqlConnection conn = new SqlConnection(strConn)) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT * FROM ParkingLots WHERE id = @idpark"; cmd.Parameters.AddWithValue("@idpark", id); cmd.CommandType = System.Data.CommandType.Text; cmd.Connection = conn; try { conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { park.Id = (int)reader["Id"]; park.Name = reader["Name"].ToString(); park.Description = reader["Description"].ToString(); park.NumberOfSpots = (int)reader["NumberOfSpots"]; park.OperatingHours = reader["OpeningHours"].ToString(); park.NumberOfSpecialSpots = (int)reader["NumberOfSpecialSpots"]; reader.Close(); return(Ok(park)); } } catch (Exception) { throw; } } return(NotFound()); }
public IList <Park> GetParks() { List <Park> parks = new List <Park>(); try { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_AllParks, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Park e = GetParkFromReader(reader); parks.Add(e); } } } catch (SqlException ex) { throw; } return(parks); }
public IEnumerator<ITask> ParkHandler(Park update) { _biclops.park(); update.ResponsePort.Post(new DefaultUpdateResponseType()); yield break; }
public ParkingBoy() { park = ParkStrategy.NormalPark; }
public Generator(Park park) { this.park = park; }
public ParkingManager() { park = ParkStrategy.NormalPark; }
private ParkingBoy(Park<ParkingLot> park) { this.park = park; }