public List <T> DisplayRestaurants <T>(List <T> rest) { using (var db = new RestDbContent()) { var query = from r in db.restaurants select r; foreach (var item in query) { Console.WriteLine(item); } return(rest); } }
public void RestNames <T>(List <T> rest) { using (var db = new RestDbContent()) { var query = from r in db.restaurants select r.Restaurant; foreach (var item in query) { Console.WriteLine(item); } } }
public void SortCuisine <T>(List <T> type) { using (var db = new RestDbContent()) { var data = (from name in db.restaurants orderby name.Cuisine ascending select name); foreach (var item in data) { Console.WriteLine(item); } } }
public void DisplayTop3 <T>(List <T> datainfo) { using (var db = new RestDbContent()) { var query = (from r in db.restaurants orderby r.Rating descending select r).Take(3); Console.WriteLine("These are the top 3 Restaurants:"); foreach (var item in query) { Console.WriteLine(item); } } }
public decimal DisplayAvg <T>(List <T> rating) { Console.WriteLine("Which restaurant would you like to see averaged?"); var desired = Console.ReadLine(); using (var db = new RestDbContent()) { var result = (from r in db.reviews where r.Restaurant.Equals(desired) select r.Rating).Average(); Console.WriteLine(result); return(result); } }
public void DisplayReviews <T>(List <T> review) //Could be used similarilly for displaying details as well { Console.WriteLine("Which reviews would you like to see: "); var desired = Console.ReadLine(); using (var db = new RestDbContent()) { var query = from r in db.reviews where r.Restaurant.Contains(desired) select r; foreach (var item in query) { Console.WriteLine(item); } } }
public void SortDescend <T>(List <T> content) { List <string> content1 = new List <string>(); using (var db = new RestDbContent()) { var data = (from name in db.restaurants orderby name.Restaurant descending select name); foreach (var item in data) { Console.WriteLine(item); } } }
public List <T> SortAscend <T>(List <T> content) { using (var db = new RestDbContent()) { var data = (from name in db.restaurants orderby name.Restaurant ascending select name); foreach (var item in data) { Console.WriteLine(item); } return(content); } }
public void SearchFunc <T>(List <T> rlist) { Console.WriteLine("Please type what you want to search"); string desired = Console.ReadLine(); using (var db = new RestDbContent()) { var query = from part in db.restaurants where part.Cuisine.Contains(desired) || part.Restaurant.Contains(desired) || part.City.Contains(desired) select part; foreach (var item in query) { Console.WriteLine(item); } } }
public static RestaurantsClass ToWeb(DataLayer.Models.RestaurantModel dataRestaurant) { decimal rating = 0; using (var db = new RestDbContent()) { var review = db.reviews.Where(r => r.RestID == dataRestaurant.RestID); if (review.Count() != 0) { rating = review.Average(r => r.Rating); } } var webRest = new RestaurantsClass() { RestID = dataRestaurant.RestID, Restaurant = dataRestaurant.Restaurant, Address = dataRestaurant.Address, City = dataRestaurant.City, Rating = rating, Cuisine = dataRestaurant.Cuisine, ReviewModel = new List <ReviewModel>() }; foreach (var review in dataRestaurant.ReviewModel) { var temp = new ReviewModel { RevID = review.RevID, RestID = review.RestID, UserID = review.UserID, Review = review.Review, Rating = review.Rating, Restaurant = review.Restaurant }; webRest.ReviewModel.Add(temp); } return(webRest); }