// UPDATE
public async Task UpdateReviewAsync(int id, string reviewerName,
string comment, int foodRating, int serviceRating, int priceRating,
int atmosphereRating, int restaurantID)
{
DL.Review r;
try
{
using (var db = new LocalGourmetDBEntities())
{
r = db.Reviews.Find(id);
if (r == null)
{
throw new ArgumentOutOfRangeException("id");
}
r.ReviewerName = reviewerName;
r.Comment = comment;
r.FoodRating = foodRating;
r.ServiceRating = serviceRating;
r.PriceRating = priceRating;
r.AtmosphereRating = atmosphereRating;
r.RestaurantID = restaurantID;
await db.SaveChangesAsync();
}
}
catch
{
throw;
}
}
// UPDATE
public async Task UpdateRestaurantAsync(int id, string name,
string location, string cuisine, string specialty,
string phoneNumber, string webAddress, string type, string hours)
{
DL.Restaurant r;
try
{
using (var db = new LocalGourmetDBEntities())
{
r = db.Restaurants.Find(id);
if (r == null)
{
throw new ArgumentOutOfRangeException("id");
}
r.Name = name;
r.Location = location;
r.Cuisine = cuisine;
r.Specialty = specialty;
r.PhoneNumber = phoneNumber;
r.WebAddress = webAddress;
r.Type = type;
r.Hours = hours;
await db.SaveChangesAsync();
}
}
catch
{
throw;
}
}
// CREATE
public async Task AddRestaurantAsync(DL.Restaurant item)
{
using (var db = new LocalGourmetDBEntities())
{
db.Restaurants.Add(item);
await db.SaveChangesAsync();
}
}
// READ
// Does not return inactive ("deleted") restaurants
public IEnumerable <DL.Restaurant> GetRestaurants()
{
IEnumerable <DL.Restaurant> dataList;
using (var db = new LocalGourmetDBEntities())
{
dataList = db.Restaurants.Where(x => x.Active == true).ToList();
}
return(dataList);
}
public IEnumerable <DL.Review> GetReviewsByRestaurantID(int restID)
{
IEnumerable <DL.Review> dataList;
using (var db = new LocalGourmetDBEntities())
{
dataList = db.Reviews.Where(x => x.RestaurantID == restID).ToList();
}
return(dataList);
}
// READ
public IEnumerable <DL.Review> GetReviews()
{
IEnumerable <DL.Review> dataList;
using (var db = new LocalGourmetDBEntities())
{
dataList = db.Reviews.ToList();
}
return(dataList);
}
// Does return inactive ("deleted") restaurants
public DL.Restaurant GetRestaurantByID(int id)
{
DL.Restaurant r;
using (var db = new LocalGourmetDBEntities())
{
try
{
r = db.Restaurants.Find(id);
}
catch
{
throw;
}
}
if (r == null)
{
throw new ArgumentOutOfRangeException("id");
}
return(r);
}
// DELETE
public async Task DeleteRestaurantAsync(int id)
{
DL.Restaurant r;
try
{
using (var db = new LocalGourmetDBEntities())
{
r = db.Restaurants.Find(id);
if (r == null)
{
throw new ArgumentOutOfRangeException("id");
}
db.Restaurants.Remove(r);
await db.SaveChangesAsync();
}
}
catch
{
throw;
}
}
public ReviewRepository(LocalGourmetDBEntities db)
{
crud = new ReviewAccessor(db);
}
public RestaurantRepository(LocalGourmetDBEntities db)
{
crud = new RestaurantAccessor(db);
}
public RestaurantAccessor(LocalGourmetDBEntities testDb)
{
db = testDb;
}
public RestaurantAccessor()
{
db = new LocalGourmetDBEntities();
}
public ReviewAccessor(LocalGourmetDBEntities testDb)
{
db = testDb;
}
public ReviewAccessor()
{
db = new LocalGourmetDBEntities();
}
