public IList <CampsiteModel> GetCampsites(int campground_id)
{
List <CampsiteModel> campsites = new List <CampsiteModel>();
try
{
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("select * from site where campground_id = @campground_id", conn);
cmd.Parameters.AddWithValue("@campground_id", campground_id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CampsiteModel campsite = ConvertReaderToCampsite(reader);
campsites.Add(campsite);
}
}
}
catch (SqlException ex)
{
Console.WriteLine("There was an error getting campsites.");
Console.WriteLine(ex.Message);
throw;
}
return(campsites);
}
public void BeforeAll()
{
var kernel = new StandardKernel();
IoC.Configure(kernel);
_source = Builder<Campsite>
.CreateNew()
.Do(c=>c.Review = Builder<Review>.CreateNew().Build())
.Do(c=>c.Location = Builder<Location>.CreateNew().Build())
.Build();
var mapper = kernel.Get<IMapper<Campsite, CampsiteModel>>();
_result = mapper.Map(_source);
}
private CampsiteModel ConvertReaderToCampsite(SqlDataReader reader)
{
CampsiteModel campsite = new CampsiteModel();
campsite.Site_Id = Convert.ToInt32(reader["site_id"]);
campsite.Campground_Id = Convert.ToInt32(reader["campground_id"]);
campsite.Site_Number = Convert.ToInt32(reader["site_number"]);
campsite.Max_Occupancy = Convert.ToInt32(reader["max_occupancy"]);
campsite.Accessible = Convert.ToBoolean(reader["accessible"]);
campsite.Max_RV_Length = Convert.ToInt32(reader["max_rv_length"]);
campsite.Utilities = Convert.ToBoolean(reader["utilities"]);
return(campsite);
}
public IList <CampsiteModel> GetAvailableReservations(CampgroundModel campground, DateTime fromDate, DateTime toDate)
{
// Start out by getting all reservations for the campsites at that campground
IList <CampsiteModel> availableReservations = GetCampsites(campground.Campground_Id);
try
{
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
{
conn.Open();
//This SQL returns all reservations conflicting with requested dates
SqlCommand cmd = new SqlCommand("select * from site s join reservation r on s.site_id = r.site_id where from_date between @fromDate and @toDate or to_date between @fromDate and @toDate", conn);
cmd.Parameters.AddWithValue("@fromDate", fromDate);
cmd.Parameters.AddWithValue("@toDate", toDate);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CampsiteModel campsite = ConvertReaderToCampsite(reader);
// So if the possible reservation conflicts, remove it.
if (availableReservations.Contains(campsite))
{
availableReservations.Remove(campsite);
}
}
// And only display the first 5 reservations, at most
while (availableReservations.Count > 5)
{
availableReservations.RemoveAt(5);
}
}
}
catch (SqlException ex)
{
Console.WriteLine("There was an error getting available reservations.");
Console.WriteLine(ex.Message);
throw;
}
return(availableReservations);
}
public void Display()
{
while (true)
{
Console.Clear();
Console.WriteLine("Campground Reservations");
Console.WriteLine("-----------------------");
Console.WriteLine();
Console.WriteLine("# Name".PadRight(40) + "Open".PadRight(10) + "Close".PadRight(10) + "Daily Rate");
Console.WriteLine("".PadRight(70, '-'));
IList <CampgroundModel> cmpg = new List <CampgroundModel>();
cmpg = this.CampgroundSqlDAO.GetCampgrounds(Park.Park_Id);
for (int i = 0; i < cmpg.Count; i++)
{
Console.WriteLine($"{i + 1}) {cmpg[i].Name.PadRight(35)} {MonthNames[cmpg[i].Open_From_MM].PadRight(10)}{MonthNames[cmpg[i].Open_To_MM].PadRight(10)}{cmpg[i].Daily_Fee:C2}");
}
Console.WriteLine();
Console.WriteLine("Pick a campground: ");
Console.WriteLine("Q) Return to Previous Screen");
string campgroundChoice = Console.ReadLine();
try
{
if (campgroundChoice.ToUpper() == "Q")
{
break;
}
else if (int.Parse(campgroundChoice) > cmpg.Count || int.Parse(campgroundChoice) < 1)
{
Console.WriteLine("Invalid input, try again.");
Console.WriteLine("Press any key to continue.");
Console.ReadKey();
continue;
}
Console.WriteLine();
Console.Write("What is the arrival date? (YYYY-MM-DD): ");
string fromDateChoice = Console.ReadLine();
Console.WriteLine();
Console.Write("What is the departure date? (YYYY-MM-DD): ");
string toDateChoice = Console.ReadLine();
int campgroundID = int.Parse(campgroundChoice);
DateTime fromDate = DateTime.Parse(fromDateChoice);
DateTime toDate = DateTime.Parse(toDateChoice);
if (toDate < fromDate)
{
Console.WriteLine("The end date must be after the beginning date!");
Console.Write("Press any key to try again.");
Console.ReadKey();
continue;
}
if (!CampgroundSqlDAO.IsOpen(cmpg[campgroundID - 1], fromDate, toDate))
{
Console.WriteLine("The campground is closed during the time you have selected.");
Console.Write("Press any key to re-select.");
Console.ReadKey();
continue;
}
Console.Clear();
int reservationDays = (int)(toDate - fromDate).TotalDays + 1;
decimal reservationCost = (decimal)reservationDays * cmpg[campgroundID - 1].Daily_Fee;
Console.WriteLine("Results Matching Your Search Criteria");
Console.WriteLine($"Site No.".PadRight(10) + "Max Occup.".PadRight(12) + "Accessible?".PadRight(13) + "Max RV Length".PadRight(15) + "Utility".PadRight(9) + "Cost");
Console.WriteLine("".PadRight(63, '-'));
IList <CampsiteModel> availableReservations = new List <CampsiteModel>();
availableReservations = this.CampsiteSqlDAO.GetAvailableReservations(cmpg[campgroundID - 1], fromDate, toDate);
if (availableReservations.Count == 0)
{
Console.WriteLine("There are no reservations matching your criteria.");
Console.Write("Please press any key to make new selections.");
Console.ReadKey();
continue;
}
for (int i = 0; i < availableReservations.Count; i++)
{
CampsiteModel res = availableReservations[i];
Console.WriteLine($"{res.Site_Id}".PadRight(10) + $"{res.Max_Occupancy}".PadRight(12) + $"{((res.Accessible) ? "Yes" : "No")}".PadRight(13) + $"{res.Max_RV_Length}".PadRight(15) + $"{((res.Utilities) ? "Yes" : "No")}".PadRight(9) + $"{reservationCost:C2}");
}
Console.WriteLine();
Console.WriteLine("Please pick a Site No.: ");
Console.WriteLine("Q) Return to Previous Screen");
string choice = Console.ReadLine();
if (choice.ToUpper() == "Q")
{
continue;
}
int whichCampsite = int.Parse(choice);
bool validCampsite = false;
foreach (CampsiteModel csite in availableReservations)
{
if (whichCampsite == csite.Site_Id)
{
validCampsite = true;
}
}
if (!validCampsite)
{
throw new Exception("Invalid campsite.");
}
Console.WriteLine();
Console.Write("Please enter the name for the reservation: ");
string camperName = Console.ReadLine();
if (camperName == "")
{
throw new Exception("A name must be entered.");
}
int reservationId = this.ReservationSqlDAO.PlaceReservation(camperName, whichCampsite, fromDate, toDate);
Console.WriteLine();
Console.WriteLine("Your reservation has been successfuly placed.");
Console.WriteLine($"The reservation ID is: {reservationId}");
Console.Write("Thank you for using the National Parks Reservation System!");
Console.ReadKey();
break;
}
catch (Exception ex)
{
Console.WriteLine("Invalid input, try again.");
Console.WriteLine(ex.Message);
Console.WriteLine("Press any key to continue.");
Console.ReadKey();
continue;
}
}
}
