public void MakeSureReservationIsInTheDatabase()
{
VenueAccess va = new VenueAccess(connectionString);
bool result = va.AddReservation(1, 1, "2020-06-28", "2020-07-04", "Matt Eland");
Assert.IsTrue(result);
}
public void ReserveSpace(Venue userVenue, HashSet <VenueSpace> venueSpaces, int peopleAmt, string startDate, string endDate)
{
VenueAccess va = new VenueAccess(connectionString);
DateTime start = Convert.ToDateTime(startDate);
DateTime end = Convert.ToDateTime(endDate);
int diff = (end.Date - start.Date).Days;
bool done = false;
while (!done)
{
Console.WriteLine("Which Space would you like to reserve?");
string choice = Console.ReadLine();
Console.WriteLine("Who is this reservation for?");
string reservationName = Console.ReadLine();
foreach (VenueSpace item in venueSpaces)
{
if (item.Name == choice)
{
va.AddReservation(item.SpaceId, peopleAmt, startDate, endDate, reservationName);
Random generator = new Random();
int randomNumber = generator.Next(10000000, 99999999);
Console.WriteLine("Thanks for submitting your reservation! The details for your event are listed below:");
Console.WriteLine();
Console.WriteLine("Confirmation #: " + randomNumber);
Console.WriteLine("Venue: " + userVenue.Name);
Console.WriteLine("Space: " + item.Name);
Console.WriteLine("Reserved For: " + reservationName);
Console.WriteLine("Attendees: " + peopleAmt);
Console.WriteLine("Arrival Date: " + startDate);
Console.WriteLine("Depart Date: " + endDate);
Console.WriteLine("Total Cost: " + (item.DailyRate * diff));
done = true;
}
}
if (!done)
{
Console.WriteLine("please make a valid selection. Check your spelling.");
}
}
Console.WriteLine("Press enter to return to the main menu.");
Console.ReadLine();
Console.Clear();
Run();
}