public void Test2_Equal_ReturnsTrueIfRestaurantsAreTheSame() { //Arrange, Act Restaurant firstRestaurant = new Restaurant("Burger King", "Seattle", 1); Restaurant secondRestaurant = new Restaurant("Burger King", "Seattle", 1); //Assert Assert.Equal(firstRestaurant, secondRestaurant); }
public void Test5_Find_FindsRestaurantInDatabase() { //Arrange Restaurant testRestaurant = new Restaurant("Burger King", "Seattle", 2); testRestaurant.Save(); //Act Restaurant foundRestaurant = Restaurant.Find(testRestaurant.GetId()); //Assert Assert.Equal(testRestaurant, foundRestaurant); }
public void Test3_Save_SavesToDatabase() { //Arrange Restaurant testRestaurant = new Restaurant("Burger King", "Seattle", 0); // Act testRestaurant.Save(); List<Restaurant> result = Restaurant.GetAll(); List<Restaurant> testList = new List<Restaurant>{testRestaurant}; //Assert Assert.Equal(testList, result); }
public void Test4_AssignedIDTOObjects() { //Arrange, Act Restaurant testRestaurant = new Restaurant("Burger King", "Seattle", 1); //Act testRestaurant.Save(); Restaurant saveRestaurant = Restaurant.GetAll()[0]; int result = saveRestaurant.GetId(); int testId = testRestaurant.GetId(); //Assert Assert.Equal(testId, result); }
public HomeModule() { Get ["/"] = _ => { List<Cuisine> AllCuisines = Cuisine.GetAll(); return View["index.cshtml", AllCuisines]; }; Get["/restaurants"] = _ => { List<Restaurant> AllRestaurants = Restaurant.GetAll(); return View["restaurants.cshtml", AllRestaurants]; }; Get["/cuisines"] = _ => { List<Cuisine> AllCuisines = Cuisine.GetAll(); return View["cuisines.cshtml", AllCuisines]; }; Get["/cuisines/new"] = _ => { return View["cuisines_form.cshtml"]; }; Post["/cuisines/new"] = _ =>{ Cuisine newCuisine = new Cuisine(Request.Form["cuisine-name"]); newCuisine.Save(); return View["success.cshtml"]; }; Get["/restaurants/new"] = _ => { List<Cuisine> AllCuisines = Cuisine.GetAll(); return View["restaurants_form.cshtml", AllCuisines]; }; Post["/restaurants/new"] = _ => { Restaurant newRestaurant = new Restaurant(Request.Form["restaurant-name"], Request.Form["restaurant-city"], Request.Form["cuisine-id"]); newRestaurant.Save(); return View["success.cshtml"]; }; Post["/restaurants/delete"] = _ => { Restaurant.DeleteAll(); return View["cleared.cshtml"]; }; Get["/cuisines/{id}"] = parameters => { Dictionary<string, object> model = new Dictionary<string, object>(); var SelectedCuisine = Cuisine.Find(parameters.id); var CuisineRestaurants = SelectedCuisine.GetRestaurants(); model.Add("restaurants", CuisineRestaurants); return View["cuisine.cshtml", model]; }; }
public static Restaurant Find(int id) { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM restaurants WHERE id = @RestaurantId;", conn); SqlParameter RestaurantIdParameter = new SqlParameter(); RestaurantIdParameter.ParameterName = "@RestaurantId"; RestaurantIdParameter.Value = id.ToString(); cmd.Parameters.Add(RestaurantIdParameter); SqlDataReader rdr = cmd.ExecuteReader(); int foundRestaurantId = 0; string foundRestaurantname = null; string foundRestaurantcity = null; int foundRestaurantCuisineId = 0; while(rdr.Read()) { foundRestaurantId = rdr.GetInt32(0); foundRestaurantname = rdr.GetString(1); foundRestaurantcity = rdr.GetString(2); foundRestaurantCuisineId = rdr.GetInt32(3); } Restaurant foundRestaurant = new Restaurant(foundRestaurantname, foundRestaurantcity, foundRestaurantCuisineId, foundRestaurantId); if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return foundRestaurant; }
public void Test8_GetRestaurants_RetrievesAllRestaurantsWithCategory() { Cuisine testCuisine = new Cuisine("Sushi"); testCuisine.Save(); Restaurant firstRestaurant = new Restaurant("Burger King", "Seattle", testCuisine.GetId()); firstRestaurant.Save(); Restaurant secondRestaurant = new Restaurant("Trappers", "Bonney Lake", testCuisine.GetId()); secondRestaurant.Save(); List<Restaurant> testRestaurantList = new List<Restaurant> {firstRestaurant, secondRestaurant}; List<Restaurant> resultRestaurantList = testCuisine.GetRestaurants(); Assert.Equal(testRestaurantList, resultRestaurantList); }
public static List<Restaurant> GetAll() { List<Restaurant> allRestaurants = new List<Restaurant>{}; SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM restaurants;", conn); SqlDataReader rdr = cmd.ExecuteReader(); while(rdr.Read()) { int restaurantId = rdr.GetInt32(0); string restaurantName = rdr.GetString(1); string restaurantCity = rdr.GetString(2); int restaurantCuisineId = rdr.GetInt32(3); Restaurant newRestaurant = new Restaurant(restaurantName, restaurantCity, restaurantCuisineId, restaurantId); allRestaurants.Add(newRestaurant); } if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return allRestaurants; }
public List<Restaurant> GetRestaurants() { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM restaurants WHERE cuisine_id = @CuisineId;", conn); SqlParameter cuisineIdParameter = new SqlParameter(); cuisineIdParameter.ParameterName = "@CuisineId"; cuisineIdParameter.Value = this.GetId(); cmd.Parameters.Add(cuisineIdParameter); SqlDataReader rdr = cmd.ExecuteReader(); List<Restaurant> restaurants = new List<Restaurant> {}; while(rdr.Read()) { int restaurantId = rdr.GetInt32(0); string restaurantName = rdr.GetString(1); string restaurantCity = rdr.GetString(2); int restaurantCuisineId = rdr.GetInt32(3); Restaurant newRestaurant = new Restaurant(restaurantName, restaurantCity,restaurantCuisineId, restaurantId); restaurants.Add(newRestaurant); } if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return restaurants; }