public IEnumerable <resturant_info> GetResturantInfo()
{
IEnumerable <resturant_info> result;
using (var db = new ResturantsEntities())
{
var dataList = db.resturant_info.ToList();
result = dataList.Select(x => DataToLibrary(x)).ToList();
}
return(result);
}
public IEnumerable <resturant_info> SortingByRating()
{
IEnumerable <resturant_info> result;
IEnumerable <resturant_info> sortedListRating;
using (var db = new ResturantsEntities())
{
var dataList = db.resturant_info.ToList();
result = dataList.Select(x => DataToLibrary(x)).ToList();
sortedListRating = result.OrderBy(x => x.rest_rating);
}
return(sortedListRating);
}
public IEnumerable <resturant_info> SortingByNameDesc()
{
IEnumerable <resturant_info> result;
IEnumerable <resturant_info> sortedListDesc;
using (var db = new ResturantsEntities())
{
var dataList = db.resturant_info.ToList();
result = dataList.Select(x => DataToLibrary(x)).ToList();
sortedListDesc = result.OrderByDescending(x => x.rest_name);
}
return(sortedListDesc);
}
//NEED TO IMPLEMENT SOMETHING TO WORK WITH REVIEWS
//ADDING NEW RESTURANT
public resturant_info AddResturant(resturant_info item)
{
try
{
using (var db = new ResturantsEntities())
{
db.resturant_info.Add(LibraryToData(item));
db.SaveChanges();
}
}
catch (Exception e)
{
LogError(e.ToString());
}
return(item);
}
