public int AddRestaurant(Model.Restaurant restaurant)
{
using (var context = new RestaurantDBEntities())
{
Restaurant newRest = context.Restaurants.Add(new Restaurant()
{
restname = restaurant.Name,
food = restaurant.Food
});
context.SaveChanges();
log.Info("Added restaurant: " + newRest.restid + ": " + newRest.restname);
return(newRest.restid);
}
}
public int AddReview(Model.Review review)
{
using (var context = new RestaurantDBEntities())
{
Review newRev = context.Reviews.Add(new Review()
{
revscore = review.Score,
reviewer = review.Reviewer,
comment = review.Comment,
revsubject = review.Subject
});
context.SaveChanges();
log.Info("Added review: " + newRev.revid);
return(newRev.revid);
}
}
public bool UpdateRestaurant(Model.Restaurant r)
{
using (var context = new RestaurantDBEntities())
{
var std = context.Restaurants.Find(r.Id);
if (std == null)
{
log.Error("Update failed to locate restaurant: " + r.Id);
return(false);
}
std.restname = r.Name;
std.food = r.Food;
context.SaveChanges();
log.Info("Updated restaurant " + r.Id);
return(true);
}
}
public bool RemoveRestaurant(int id)
{
using (var context = new RestaurantDBEntities())
{
var std = context.Restaurants.Find(id);
context.Restaurants.Remove(std);
context.SaveChanges();
if (std != null)
{
log.Info("Removed restaurant " + id);
}
else
{
log.Info("Failed to remove restaurant " + id);
}
return(std != null);
}
}
public bool UpdateReview(Model.Review rev)
{
using (var context = new RestaurantDBEntities())
{
var std = context.Reviews.Find(rev.Id);
if (std == null)
{
log.Error("Update failed to locate Review: " + rev.Id);
return(false);
}
std.revscore = rev.Score;
std.reviewer = rev.Reviewer;
std.comment = rev.Comment;
std.revsubject = rev.Subject;
context.SaveChanges();
log.Info("Updated review " + rev.Id);
return(true);
}
}
