public List <lodgedata> alllodges(int locationid) { TAmodel data = new TAmodel(); var dblodges = from i in data.Lodges where i.LOCATION_ID == locationid select i; List <lodgedata> lodges = new List <lodgedata>(); foreach (var i in dblodges) { lodgedata l = new lodgedata(); l.LODGE_ID = i.LODGE_ID; l.LODGE_NAME = i.LODGE_NAME; l.LODGE_ADD = i.LODGE_ADD; l.LOCATION_ID = i.LOCATION_ID; l.PRICE = i.PRICE; var ratings = (from k in data.ratings where k.itemtype == "lodge" && k.itemid == i.LODGE_ID select k.Rating); if (ratings.Any()) { l.rating = ratings.Average(); } else { l.rating = 0; } lodges.Add(l); } return(lodges); }
public lodgedata lodge(int lodgeid) { TAmodel data = new TAmodel(); var lodge = (from i in data.Lodges where i.LODGE_ID == lodgeid select i).FirstOrDefault(); lodgedata l = new lodgedata(); var ratings = (from k in data.ratings where k.itemtype == "lodge" && k.itemid == lodgeid select k.Rating); if (ratings.Any()) { l.rating = ratings.Average(); } else { l.rating = 0; } l.LODGE_ID = lodge.LODGE_ID; l.LODGE_NAME = lodge.LODGE_NAME; l.LODGE_ADD = lodge.LODGE_ADD; l.LOCATION_ID = lodge.LOCATION_ID; l.PRICE = lodge.PRICE; //l.rating = rating; return(l); }