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