示例#1
0
        //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);
            }
        }
示例#3
0
        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());
        }
示例#4
0
        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);
        }
示例#6
0
        /// <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);
        }
示例#7
0
        /// <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);
        }
示例#8
0
        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);
        }
示例#11
0
        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);
        }
示例#13
0
        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);
        }
示例#15
0
        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));
        }
示例#17
0
        /// <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;
                }
            }
        }
示例#18
0
        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);
        }
示例#20
0
        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);
        }
示例#21
0
        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);
        }
示例#23
0
        /// <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);
        }
示例#24
0
 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();
     }
 }
示例#25
0
        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);
        }
示例#26
0
        /// <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);
        }
示例#27
0
        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;
            }
        }
示例#29
0
        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());
        }
示例#30
0
        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);
        }
示例#31
0
 public IEnumerator<ITask> ParkHandler(Park update)
 {
     _biclops.park();
     update.ResponsePort.Post(new DefaultUpdateResponseType());
     yield break;
 }
示例#32
0
 public ParkingBoy()
 {
     park = ParkStrategy.NormalPark;
 }
 public Generator(Park park)
 {
     this.park = park;
 }
示例#34
0
 public ParkingManager()
 {
     park = ParkStrategy.NormalPark;
 }
示例#35
0
 private ParkingBoy(Park<ParkingLot> park)
 {
     this.park = park;
 }