private void GetAllCampgrounds() { ParksDAL pdal = new ParksDAL(DatabaseConnection); List <Park> parks = pdal.GetAllParks(); if (parks.Count > 0) { foreach (Park park in parks) { Console.WriteLine("(" + park.Park_id + ") " + park.Name); Console.WriteLine(); } CampgroundDAL cdal = new CampgroundDAL(DatabaseConnection); int parkId = CLIHelper.GetInteger("Please select a Park Id : "); Console.WriteLine(); List <Campground> campground = cdal.GetAllCampgrounds(parkId); foreach (Campground camp in campground) { Console.WriteLine("(" + camp.CampgroundId + ") " + camp.Name.PadRight(30) + "Opening Month " + months[camp.OpenFromMM].ToString().PadRight(10) + "Closing Month " + months[camp.OpenToMM].ToString().PadRight(10) + "Daily Fee " + camp.DailyFee.ToString("c")); Console.WriteLine(); } } else { Console.WriteLine("**** NO RESULTS ****"); } Console.ReadLine(); }
private void GetAllParks() { ParksDAL pdal = new ParksDAL(DatabaseConnection); List <Park> parks = pdal.GetAllParks(); if (parks.Count > 0) { foreach (Park park in parks) { Console.WriteLine(park.Name.PadRight(20) + "Park Id: " + park.Park_id.ToString().PadRight(20) + "Park Location: " + park.Location.PadRight(20) + "Park Establish Date: " + park.Establish_date.ToString("yyyy").PadRight(20) + "Park Area In Miles: " + park.Area.ToString("N0").PadRight(20) + "Park Visitors: " + park.Visitors.ToString("N0")); Console.WriteLine(); } } else { Console.WriteLine("**** NO RESULTS ****"); } Console.ReadLine(); }
public List <Site> MakeReservation(ParksDAL parkObject, string campgroundNumber, DateTime reservationStartDate, DateTime reservationEndDate) { List <Site> siteList = new List <Site>(); List <Site> openSiteList = new List <Site>(); List <Reservation> resList = new List <Reservation>(); //GetAvailableReservations is misnomer. Should be "GetPremadeReservations" or something along the lines of an earlier //reservation. THEN we compare against the current input for reservation request. resList = parkObject.GetAvailableReservations(campgroundNumber, reservationStartDate, reservationEndDate); //now we get all the sites for the available campground siteList = parkObject.GetAvailableSites(campgroundNumber); if (resList.Count == 0) { openSiteList = siteList; } else { for (int i = 0; i < siteList.Count; i++) { foreach (Reservation item in resList.Where(r => r.SiteID == siteList[i].ID)) //'r=>' is simply declaring an alias for resList { if (reservationStartDate >= item.FromDate && reservationStartDate <= item.ToDate || reservationEndDate >= item.FromDate && reservationEndDate <= item.ToDate || reservationEndDate >= item.ToDate && reservationStartDate <= item.FromDate) //if (item.FromDate < reservationStartDate && item.ToDate > reservationStartDate && item.SiteID == siteList[i].ID // || item.FromDate < reservationEndDate && item.ToDate > reservationEndDate && item.SiteID == siteList[i].ID // || item.FromDate < reservationStartDate && item.ToDate > reservationEndDate && item.SiteID == siteList[i].ID // || item.FromDate > reservationStartDate && item.ToDate < reservationEndDate && item.SiteID == siteList[i].ID { siteList.RemoveAt(i); } } } openSiteList = siteList; } return(openSiteList); }