public static List<Cuisine> GetAll()
{
List<Cuisine> allCuisines = new List<Cuisine>{};
SqlConnection conn = DB.Connection();
SqlDataReader rdr = null;
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM cuisines;", conn);
rdr = cmd.ExecuteReader();
while(rdr.Read())
{
int cuisineId = rdr.GetInt32(0);
string cuisineName = rdr.GetString(1);
Cuisine newCuisine = new Cuisine(cuisineId, cuisineName);
allCuisines.Add(newCuisine);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return allCuisines;
}
public static Cuisine Find(int id)
{
SqlConnection conn = DB.Connection();
SqlDataReader rdr = null;
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM cuisines WHERE id = @CuisineId;", conn);
SqlParameter cuisineIdParameter = new SqlParameter();
cuisineIdParameter.ParameterName = "@CuisineId";
cuisineIdParameter.Value = id.ToString();
cmd.Parameters.Add(cuisineIdParameter);
rdr = cmd.ExecuteReader();
int foundCuisineId = 0;
string foundCuisineName = null;
while(rdr.Read())
{
foundCuisineId = rdr.GetInt32(0);
foundCuisineName = rdr.GetString(1);
}
Cuisine foundCuisine = new Cuisine(foundCuisineId, foundCuisineName);
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return foundCuisine;
}
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(0, Request.Form["cuisine-name"]);
newCuisine.Save();
return View["success.cshtml"];
};
Get["/restaurants/new"] = _ => {
List<Cuisine> AllCuisines = Cuisine.GetAll();
return View["restaurant_form.cshtml", AllCuisines];
};
Post["/restaurants/new"] = _ => {
Restaurant newRestaurant = new Restaurant(Request.Form["cuisine-id"], Request.Form["restaurant-name"], Request.Form["restaurant-image"]);
newRestaurant.Save();
return View["success.cshtml"];
};
Post["/restaurants/delete"] = _ => {
Restaurant.DeleteAll();
return View["cleared.cshtml"];
};
Post["/cuisines/delete"] = _ => {
Cuisine.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("cuisine", SelectedCuisine);
model.Add("restaurants", CuisineRestaurants);
return View["cuisine.cshtml", model];
};
Get["/cuisine/edit/{id}"] = parameters => {
Cuisine SelectedCuisine = Cuisine.Find(parameters.id);
return View["cuisine_edit.cshtml", SelectedCuisine];
};
Patch["/cuisine/edit/{id}"] = parameters => {
Cuisine SelectedCuisine = Cuisine.Find(parameters.id);
SelectedCuisine.Update(Request.Form["cuisine-name"]);
return View["success.cshtml"];
};
Get["/cuisine/delete/{id}"] = parameters => {
Cuisine SelectedCuisine = Cuisine.Find(parameters.id);
return View["cuisine_delete.cshtml", SelectedCuisine];
};
Delete["/cuisine/delete/{id}"] = parameters => {
Cuisine SelectedCuisine = Cuisine.Find(parameters.id);
SelectedCuisine.Delete();
return View["success.cshtml"];
};
Get["/restaurant/review/{id}"] = parameters => {
var SelectedRestaurant = Restaurant.Find(parameters.id);
return View["review_form.cshtml", SelectedRestaurant];
};
Post["/new-review/{id}"] = parameters => {
var SelectedRestaurant = Restaurant.Find(parameters.id);
Review newReview = new Review(Request.Form["stars"], Request.Form["restaurant-review"], SelectedRestaurant.GetId());
newReview.Save();
return View["review_success.cshtml", newReview.GetComment()];
};
Get["/restaurants/{id}"] = parameters => {
Dictionary<string, object> model = new Dictionary<string, object>();
var SelectedRestaurant = Restaurant.Find(parameters.id);
var RestaurantReviews = SelectedRestaurant.GetReviews();
model.Add("restaurant", SelectedRestaurant);
model.Add("reviews", RestaurantReviews);
return View["restaurant.cshtml", model];
};
}
