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