Ejemplo n.º 1
0
        public void LoadPages()
        {
            CatalogPage listPage = new CatalogPage(htmlWeb.Load(HOMEPAGE_URL));

            Repository.Clean();

            var prevPageNumber = 0;

            while (listPage.PageNumber > prevPageNumber)
            {
                foreach (var link in listPage.Rides)
                {
                    RidePage ridePage = new RidePage(htmlWeb.Load(link), link);

                    var index = Repository.AddRide(ridePage);
                    Console.WriteLine($"{index}) " + ridePage.Vehicle.ToString());
                }

                prevPageNumber = listPage.PageNumber;
                listPage       = new CatalogPage(htmlWeb.Load(listPage.NextPage));
            }

            Console.WriteLine("No more pages found. Press any key to exit...");
            Console.ReadKey();
        }
Ejemplo n.º 2
0
        public int AddRide(RidePage page)
        {
            MySqlCommand command = new MySqlCommand(@"INSERT INTO `rides` (`uri`, `price`, `vehicle_brand`, `vehicle_model`, `vehicle_year`, `driver_username`, `driver_uri`) 
                VALUES (@Uri, @Price, @VehicleBrand, @VehicleModel, @VehicleYear, @DriverUsername, @DriverUri);", Connection);

            command.Parameters.AddWithValue("Uri", page.PageUri.ToString());
            command.Parameters.AddWithValue("Price", page.Price);
            command.Parameters.AddWithValue("VehicleBrand", page.Vehicle.Brand);
            command.Parameters.AddWithValue("VehicleModel", page.Vehicle.Model);
            command.Parameters.AddWithValue("VehicleYear", page.Vehicle.Year);
            command.Parameters.AddWithValue("DriverUsername", page.Driver.Username);
            command.Parameters.AddWithValue("DriverUri", page.Driver.UserPage.ToString());

            command.ExecuteNonQuery();
            return((int)command.LastInsertedId);
        }
Ejemplo n.º 3
0
        public List <RidePage> GetVehicleRides(int page, Vehicle vehicle)
        {
            MySqlCommand command = new MySqlCommand($@"SELECT * FROM `rides` WHERE `vehicle_brand` = @vehicle_brand AND `vehicle_model` = @vehicle_model AND `vehicle_year` = @vehicle_year LIMIT 25 OFFSET {page * 25};", Connection);

            command.Parameters.AddWithValue("vehicle_brand", vehicle.Brand);
            command.Parameters.AddWithValue("vehicle_model", vehicle.Model);
            command.Parameters.AddWithValue("vehicle_year", vehicle.Year);

            var result = command.ExecuteReader();

            var rides = new List <RidePage>();

            while (result.Read())
            {
                var ride = new RidePage()
                {
                    Id      = result.GetInt32(0),
                    PageUri = new Uri(result.GetString(1)),
                    Price   = result.GetString(2),
                    Vehicle = new Vehicle()
                    {
                        Brand = result.GetString(3),
                        Model = result.GetString(4),
                        Year  = result.GetInt32(5)
                    },
                    Driver = new Driver()
                    {
                        Username = result.GetString(6),
                        UserPage = new Uri(result.GetString(7))
                    }
                };

                rides.Add(ride);
            }

            return(rides);
        }