public void Add(Review model)
{
using (var dbcontext = new ResturantDBEntities())
{
dbcontext.Reviews.Add(model);
dbcontext.SaveChanges();
}
}
public void addResturant(Models.Resturant model)
{
using (var dbcontext = new ResturantDBEntities())
{
dbcontext.Resturants.Add(ModelToData(model));
dbcontext.SaveChanges();
}
}
public void Delete(Resturant model)
{
using (var dbcontext = new ResturantDBEntities())
{
dbcontext.Resturants.Attach(model);
dbcontext.Resturants.Remove(model);
dbcontext.SaveChanges();
}
}
public IEnumerable <Review> GetReviews()
{
IEnumerable <Review> reviewEntities;
using (var dbcontext = new ResturantDBEntities())
{
reviewEntities = dbcontext.Reviews.ToList();
}
return(reviewEntities.ToList());
}
public IEnumerable <Models.Resturant> GetResturants()
{
IEnumerable <Models.Resturant> result;
using (var dbcontext = new ResturantDBEntities())
{
var entities = dbcontext.Resturants.ToList();
result = entities.Select(x => DataToModel(x)).ToList();
}
return(result.ToList());
}
public void Update(Review model)
{
using (var dbcontext = new ResturantDBEntities())
{
foreach (var rev in dbcontext.Reviews)
{
if (rev.rv_id == model.rv_id)
{
rev.Author = model.Author;
rev.Rating = model.Rating;
rev.Comment = model.Comment;
}
}
dbcontext.SaveChanges();
}
}
public void Update(Resturant model)
{
using (var dbcontext = new ResturantDBEntities())
{
foreach (var res in dbcontext.Resturants)
{
if (res.rs_id == model.rs_id)
{
res.Name = model.Name;
res.Address = model.Address;
res.City = model.City;
res.State = model.State;
res.FoodType = model.FoodType;
break;
}
}
dbcontext.SaveChanges();
}
}
public IEnumerable <Resturant> GetResturants()
{
// This function takes a long time to run to completion. Why?
IEnumerable <Resturant> result;
using (var dbcontext = new ResturantDBEntities())
{
int i = 0;
var entities = dbcontext.Resturants.ToList();
// due to Lazy loading, the Reviews seem to have to
// be explictly loaded ???
foreach (var ent in dbcontext.Resturants)
{
entities[i].Reviews = ent.Reviews.ToList();
i++;
}
result = entities.ToList();
}
return(result.ToList());
}