public new void Add(Review entity)
{
RRRavesDBEntities.Set <Review>().Add(entity);
int RestId = (int)entity.Restaurant;
this.AverageRatingsAdd(RestId, entity.Rating);
}
public void EditRestaurant(int id, string field, string newvalue)
{
switch (field)
{
case "Name":
RRRavesDBEntities.Set <Restaurant>().Find(id).Name = newvalue;
break;
case "Address":
RRRavesDBEntities.Set <Restaurant>().Find(id).Address = newvalue;
break;
case "City":
RRRavesDBEntities.Set <Restaurant>().Find(id).City = newvalue;
break;
case "ZipCode":
RRRavesDBEntities.Set <Restaurant>().Find(id).Zipcode = newvalue;
break;
case "Phone":
RRRavesDBEntities.Set <Restaurant>().Find(id).Phone = newvalue;
break;
case "Website":
RRRavesDBEntities.Set <Restaurant>().Find(id).Website = newvalue;
break;
default:
break;
}
}
public new void RemoveRange(IEnumerable <Review> entities)
{
RRRavesDBEntities.Set <Review>().RemoveRange(entities);
foreach (var item in entities)
{
int RestId = (int)item.Restaurant;
}
}
public new void AddRange(IEnumerable <Review> entities)
{
RRRavesDBEntities.Set <Review>().AddRange(entities);
foreach (var item in entities)
{
int RestId = (int)item.Restaurant;
this.AverageRatingsAdd(RestId, item.Rating);
}
}
public new void Remove(Review entity)
{
int RestId = entity.Restaurant.Value;
int OldRate = entity.Rating;
this.AverageRatingsRemove(RestId, OldRate);
RRRavesDBEntities.Set <Review>().Remove(entity);
}
public new void RemoveRange(IEnumerable <Review> entities)
{
foreach (var item in entities)
{
int RestId = (int)item.Restaurant;
int OldRate = (int)item.Rating;
this.AverageRatingsRemove(RestId, OldRate);
RRRavesDBEntities.Set <Review>().Remove(item);
}
}
public void AverageRatingsRemove(int RestaurantID, int OldRating)
{
var temp = RRRavesDBEntities.Set <Review>().Where(x => x.Restaurant == RestaurantID);
var temp2 = temp.Select(x => x.Rating).ToList();
temp2.Remove(OldRating);
var temp3 = Convert.ToDecimal(temp2.DefaultIfEmpty().Average());
RRRavesDBEntities.Set <Restaurant>().Find(RestaurantID).AveRating = temp3;
}
public void EditReview(int id, Review r)
{
//var rest = RRRavesDBEntities.Set<Review>().Single(i => i.ID_Review == id);
//if (rest != null)
//{
// rest.Rating = r.Rating;
// rest.ReviewText = r.ReviewText;
//}
var oldReview = RRRavesDBEntities.Reviews.Find(id);
var oldRate = oldReview.Rating;
RRRavesDBEntities.Entry(oldReview).CurrentValues.SetValues(r);
this.AverageRatingsEdit(r.Restaurant.Value, oldRate, r.Rating);
}
public void EditRestaurant(int id, Restaurant restaurant)
{
//var rest = RRRavesDBEntities.Set<Restaurant>().Single(i => i.ID_Restaurant == id);
//if (rest != null)
//{
// rest.Name = restaurant.Name;
// rest.Address = restaurant.Address;
// rest.City = restaurant.City;
// rest.Zipcode = restaurant.Zipcode;
// rest.Phone = restaurant.Phone;
// rest.Website = restaurant.Website;
//}
var oldRest = RRRavesDBEntities.Restaurants.Find(id);
RRRavesDBEntities.Entry(oldRest).CurrentValues.SetValues(restaurant);
}
public void EditReview(int id, string field, string newvalue)
{
switch (field)
{
case "Rating":
var oldRating = RRRavesDBEntities.Set <Review>().Find(id).Rating;
RRRavesDBEntities.Set <Review>().Find(id).Rating = Convert.ToInt32(newvalue);
var rid = (int)RRRavesDBEntities.Set <Review>().Find(id).Restaurant;
this.AverageRatingsEdit(rid, oldRating, Convert.ToInt32(newvalue));
break;
case "ReviewText":
RRRavesDBEntities.Set <Review>().Find(id).ReviewText = newvalue;
break;
default:
break;
}
}
public new void Remove(Review entity)
{
RRRavesDBEntities.Set <Review>().Remove(entity);
int RestId = (int)entity.Restaurant;
}
public ReviewRepository(RRRavesDBEntities db) : base(db)
{
}
public IEnumerable <Restaurant> GetTopThree()
{
return(RRRavesDBEntities.Set <Restaurant>().OrderByDescending(x => x.AveRating).Take(3));
}
public RestaurantRepository(RRRavesDBEntities db) : base(db)
{
}
public new void Remove(Restaurant entity)
{
RRRavesDBEntities.Set <Restaurant>().Remove(entity);
}