public List <ReviewFoodViewModel> getReviewsForCustomer(Customer cust)
{
List <Food_Order> food_Orders = _context.Food_Orders.Where(m => m.booking.customer_Id == cust.UserId).ToList();
List <int> foodIdslist = new List <int>();
foreach (var item in food_Orders)
{
foodIdslist.Add(item.food_Id.Value);
}
List <int> uniquefoodList = (from t in foodIdslist
group t by t into nGroup
where nGroup.Count() >= 1
select nGroup.Key).ToList();
List <ReviewFoodViewModel> reviews = new List <ReviewFoodViewModel>();
foreach (var item in uniquefoodList)
{
ReviewFoodViewModel model = new ReviewFoodViewModel();
model.foodName = _context.Foods.Where(n => n.Id == item).Select(n => n.Name).FirstOrDefault();
model.food_Id = _context.Foods.Where(n => n.Id == item).Select(n => n.Id).FirstOrDefault();
model.reviewContent = _context.Reviews.Where(r => r.customer_Id == cust.UserId && r.food_Id == item).Select(r => r.ReviewContent).FirstOrDefault();
model.postingDate = _context.Reviews.Where(r => r.customer_Id == cust.UserId && r.food_Id == item).Select(r => r.PostingDate).FirstOrDefault();
model.id = _context.Reviews.Where(r => r.customer_Id == cust.UserId && r.food_Id == item).Select(r => r.Id).FirstOrDefault();
reviews.Add(model);
}
return(reviews);
}
public ActionResult Create()
{
ReviewFoodViewModel viewModel = new ReviewFoodViewModel
{
Categories = db.Categories.ToList()
};
return(View(viewModel));
}
public async Task <ActionResult> Create([Bind(Include = "Id,TenBaiReview,ThongtinFood,DanhGiaFood,ImageCover,IdCategory")] ReviewFoodViewModel viewModel)
{
if (ModelState.IsValid)
{
viewModel.Categories = db.Categories.ToList();
var reviewFood = new ReviewFood
{
TenBaiReview = viewModel.TenBaiReview,
ThongtinFood = viewModel.ThongtinFood,
DanhGiaFood = viewModel.DanhGiaFood,
IdCategory = viewModel.Category,
ImageCover = viewModel.ImageCover
};
db.ReviewFoods.Add(reviewFood);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(viewModel));
}
