public Restaurantdata restaurant(int restaurantid)
{
TAmodel data = new TAmodel();
var restaurant = (from i in data.Restaurants where i.RESTAURANT_ID == restaurantid select i).FirstOrDefault();
var ratings = (from i in data.ratings where i.itemtype == "Restaurant" && i.itemid == restaurantid select i.Rating);
Restaurantdata r = new Restaurantdata();
r.RESTAURANT_ID = restaurant.RESTAURANT_ID;
r.RESTAURANT_NAME = restaurant.RESTAURANT_NAME;
r.ADRESS = restaurant.ADRESS;
r.LOCATION_ID = restaurant.LOCATION_ID;
r.PRICE = restaurant.PRICE;
if (ratings.Any())
{
r.rating = ratings.Average();
}
return(r);
}
public List <Restaurantdata> allrestaurants(int locationid)
{
TAmodel data = new TAmodel();
var dbrestaurant = from i in data.Restaurants where i.LOCATION_ID == locationid select i;
List <Restaurantdata> restaurants = new List <Restaurantdata>();
foreach (var i in dbrestaurant)
{
Restaurantdata r = new Restaurantdata();
r.RESTAURANT_ID = i.RESTAURANT_ID;
r.RESTAURANT_NAME = i.RESTAURANT_NAME;
r.ADRESS = i.ADRESS;
r.LOCATION_ID = i.LOCATION_ID;
r.PRICE = i.PRICE;
var ratings = (from k in data.ratings where k.itemtype == "restaurant" && k.itemid == i.RESTAURANT_ID select k.Rating);
if (ratings.Any())
{
r.rating = ratings.Average();
}
restaurants.Add(r);
}
return(restaurants);
}
