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