Esempio n. 1
0
        //Methods

        /// <summary>
        /// Override of ToString method.
        /// </summary>
        /// <returns>Properly formatted site information</returns>
        /// Method pulls database information for campground name and campground cost.
        public string ToString(int numDays)
        {
            string        connectionString = ConfigurationManager.ConnectionStrings["CapstoneDatabase"].ConnectionString;
            CampgroundDAL cgDAL            = new CampgroundDAL(connectionString);
            Campground    cg = cgDAL.GetCampgroundByID(this.CampgroundID);

            string result;

            result  = cg.Name.PadRight(35);
            result += this.SiteNumber.ToString().PadRight(10);
            result += this.MaxOccupancy.ToString().PadRight(12);
            result += this.Accessible ? "YES".PadRight(15) : "NO".PadRight(15);

            if (this.MaxRVLength > 0)
            {
                result += this.MaxRVLength.ToString().PadRight(10);
            }
            else
            {
                result += "N/A".PadRight(10);
            }

            result += this.Utilities ? "YES".PadRight(11) : "N/A".PadRight(11);
            result += cg.CalculateFee(numDays);

            return(result);
        }
Esempio n. 2
0
        public Campground GetCampgroundFromReader(SqlDataReader reader)
        {
            Campground item = new Campground();

            item.CampgroundID = Convert.ToInt32(reader["campground_id"]);
            item.ParkID       = Convert.ToInt32(reader["park_id"]);
            item.Name         = Convert.ToString(reader["name"]);
            item.OpenMonth    = Convert.ToInt32(reader["open_from_mm"]);
            item.CloseMonth   = Convert.ToInt32(reader["open_to_mm"]);
            item.DailyFee     = Convert.ToInt32(reader["daily_fee"]);

            return(item);
        }
Esempio n. 3
0
        // LEVEL: CAMPGROUND  /////////////////////////////////////////
        private int[] GetCampgroundAvailability_View(int campgroundID, DateTime startDate, DateTime endDate)
        {
            CampgroundSqlDAL campDAL            = new CampgroundSqlDAL(DatabaseConnection);
            IList <Campsite> availableCampsites = campDAL.CampgroundAvailability(campgroundID, startDate, endDate);
            int lengthOfStay = (int)(endDate - startDate).TotalDays;

            Campground campground = campDAL.CampgroundDetails(campgroundID);

            if (availableCampsites.Count > 0)
            {
                int[]   output = new int[availableCampsites.Count];
                decimal cost   = 0;
                decimal fee    = 0;
                Console.WriteLine(
                    "Campground".PadRight(30)
                    + "Site No.".PadRight(15)
                    + "Max Occup.".ToString().PadRight(15)
                    + "Accessible".PadRight(15)
                    + "RV Len".PadRight(15)
                    + "Utility".PadRight(15)
                    + "Cost".PadLeft(20));

                int i = 0;
                foreach (Campsite campsite in availableCampsites)
                {
                    output[i] = campsite.Site_Number;
                    fee       = campground.Daily_Fee;
                    cost      = fee * lengthOfStay;
                    this.PrintCampsiteAvailability(
                        campground.Name,
                        campsite.Site_Number,
                        campsite.Max_Occupancy,
                        campsite.IsAccessible,
                        campsite.Max_RV_Length,
                        campsite.HasUtilities,
                        cost);
                    i++;
                }

                return(output);
            }
            else
            {
                Console.WriteLine("**** NO RESULTS ****");
                return(new int[0]);
            }
        }
        public void GetAvailableSites()
        {
            Console.Write($"Please enter the desired campground ID number (enter 0 to cancel)?:   ");  //TODO Site Id Num
            bool parsedToInt;
            int  campgroundSelection;

            parsedToInt = int.TryParse(Console.ReadLine().Trim(), out campgroundSelection);

            if (!parsedToInt || campgroundSelection < 0 || !campgroundList.Contains(campgroundSelection))
            {
                Console.Clear();
                menu.PrintHeader();

                DisplayParkCampgrounds(parkID);
                Console.WriteLine("Invalid option. Please try again.");
                GetAvailableSites();
            }
            else if (campgroundSelection == 0)
            {
                Console.Clear();
                menu.PrintHeader();
                SelectPark(parkID);
            }
            else
            {
                do
                {
                    Console.Write($"What is the arrival date? (MM/DD/YYYY):   ");
                    arrivalDate = CLIHelper.GetDateTime(Console.ReadLine().Trim());
                    Console.Write($"What is the departure date? (MM/DD/YYYY):  ");
                    departureDate = CLIHelper.GetDateTime(Console.ReadLine().Trim());
                    if (departureDate < arrivalDate)
                    {
                        Console.SetCursorPosition(0, Console.CursorTop - 1);
                        Console.Write("\r" + new string(' ', Console.WindowWidth - 1) + "\r");
                        Console.SetCursorPosition(0, Console.CursorTop - 1);
                        Console.Write("\r" + new string(' ', Console.WindowWidth - 1) + "\r");
                        Console.WriteLine("Departure date must be after arrival date.");
                    }
                } while (departureDate < arrivalDate);

                IList <Site> sites = siteDAO.GetAvailableSites(campgroundSelection, arrivalDate, departureDate);

                if (sites.Count == 0)
                {
                    Console.Clear();
                    Console.Write("There are no campsites available for those dates. Would you like to try again (Y/N)?:   ");
                    string tryAgain;// = Console.ReadLine();
                    bool   validAnswer = false;
                    do
                    {
                        switch (tryAgain = Console.ReadLine().ToUpper())
                        {
                        case "Y":
                            validAnswer = true;
                            GetAvailableSites();
                            break;

                        case "N":
                            validAnswer = true;
                            RunCLI();
                            break;

                        default:
                            Console.WriteLine("Please answer Y or N.");
                            break;
                        }
                    } while (!validAnswer);
                }
                else
                {
                    Console.Clear();
                    List <int> siteIds = new List <int>();
                    do
                    {
                        menu.PrintHeader();
                        Campground campground = campgroundDAO.SelectCampground(campgroundSelection);
                        Console.WriteLine("Sites are listed in order of popularity.");
                        Console.WriteLine();
                        foreach (Site site in sites)
                        {
                            Console.WriteLine($"Site No.:".PadRight(15) + "Max Occupancy:".PadRight(20) + "Accessible?:".PadRight(15) + "Max RV Length:".PadRight(20) + "Utility:".PadRight(15) + "Daily Fee:");
                            Console.WriteLine($"#{site.Id,-14}{site.MaxOccupancy,-20}{(site.Accessible ? "Yes" : "No"),-15}{(site.MaxRVLength > 0 ? site.MaxRVLength.ToString() : "N/A"),-20}{(site.Utilities ? "Yes" : "No"),-15}{campground.DailyFee:C2}");                                                                                                                                                                                                                       //Pad Right 20 after names
                            Console.WriteLine();
                            siteIds.Add(site.Id);
                        }
                        Console.Write("Which site would you like to reserve (enter 0 to cancel)?:   ");
                        bool couldParse;
                        couldParse = int.TryParse(Console.ReadLine().Trim(), out siteID);

                        if (siteID == 0)
                        {
                            Console.Clear();
                            RunCLI();
                        }
                        else if (!siteIds.Contains(siteID))
                        {
                            Console.WriteLine("Please select a site ID from the list above.");
                        }
                    } while (!siteIds.Contains(siteID));
                    Console.Write("What name should the reservation be made under?:   ");
                    reservationName = Console.ReadLine().Trim();
                }
            }
            AddReservations();
        }
        //Method to calculate cost of a stay based on daily rate x price:
        public decimal CalculateCost(Campground campground, int numDays)
        {
            decimal cost = campground.DailyFee * numDays;

            return(cost);
        }