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); }
public UserInterface(string connectionString) { this.connectionString = connectionString; venueIO = new VenuesDAL(connectionString); spaceIO = new SpacesDAL(connectionString); reservationIO = new ReservationsDAL(connectionString); bookingSystem = new BookingSystem(connectionString); }
public void GetAllVenuesTest() { //Arrange VenuesDAL testObj = new VenuesDAL(connectionString); //Act List <Venue> temp = testObj.GetAllVenues(); //Assert Assert.IsTrue(temp.Count > 0); }
public BookingSystem(string dbConnectionString) { connectionString = dbConnectionString; venueIO = new VenuesDAL(connectionString); reservationIO = new ReservationsDAL(connectionString); }