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(); } }