public void GetSpecificVenueTest()
{
//Arrange
VenuesDAL testObj = new VenuesDAL(connectionString);
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
string sqlInsertVenue = "INSERT INTO venue (name, city_id, description) VALUES ('ZZZZ', 3, 'XXXX')";
string sqlGetInsertedVenueID = "SELECT id FROM venue WHERE name = 'ZZZZ'";
string sqlInsertCategories = "INSERT INTO category_venue (venue_id, category_id) VALUES (@id, 1)"
+ "INSERT INTO category_venue (venue_id, category_id) VALUES (@id, 2);";
SqlCommand cmd = new SqlCommand(sqlInsertVenue, conn);
int count = cmd.ExecuteNonQuery();
cmd = new SqlCommand(sqlGetInsertedVenueID, conn);
SqlDataReader reader = cmd.ExecuteReader();
int newId = 0;
while (reader.Read())
{
newId = Convert.ToInt32(reader["id"]);
}
reader.Close();
cmd = new SqlCommand(sqlInsertCategories, conn);
cmd.Parameters.AddWithValue("@id", newId);
cmd.ExecuteNonQuery();
}
//Act
Venue temp = testObj.GetSpecificVenue("Hidden Owl Eatery");
//Assert
Assert.AreEqual(2, temp.Category.Count);
}
// VenuesDAL venueIO;
private void VenueInfoMenu(string venueName)
{
Venue venueInfo = venueIO.GetSpecificVenue(venueName);
List <string> categories = venueInfo.Category;
bool viewSpaces = false;
bool searchSpaces = false;
bool done = false;
while (!done)
{
Console.WriteLine("\n" + venueName);//inserted new line here JB
Console.WriteLine("Location: " + venueInfo.Location);
Console.Write("Categories: ");
int commaCounter = 0;
foreach (string uniqueCat in categories)
{
if (commaCounter == 0)
{
Console.Write(uniqueCat);
}
else
{
Console.Write(", " + uniqueCat);
}
commaCounter++;
}
Console.WriteLine("\n");
Console.WriteLine(venueInfo.Description);
Console.WriteLine("\n");
Console.WriteLine("What would you like to do next?");
Console.WriteLine("\t 1) View Spaces");
Console.WriteLine("\t 2) Search for Reservation");
Console.WriteLine("\t R) Return to Previous Screen");
string menuInput = Console.ReadLine();
switch (menuInput)
{
case "1":
viewSpaces = true;
done = true;
break;
case "2":
searchSpaces = true;
done = true;
break;
case "R":
done = true;
break;
default:
break;
}
}
if (viewSpaces)
{
ViewSpaces(venueInfo);
}
else if (searchSpaces)
{
SearchSpacesMenu(venueInfo);
}
else
{
Console.WriteLine("Invalid Entry, please enter 1, 2, or R"); //inseted error message JB
ViewVenuesMenu();
}
}