public ActionResult DetailBills(int?bid) { using (DataContext db = new DataContext()) { if (bid != null) { var detailBill = (from d in db.DetailBills join b in db.Books on d.Book_ID equals b.Book_ID join c in db.Categories on b.category_id equals c.Category_ID where d.Bill_ID == bid select new { d.quantity, c.categoryName, b.price, b.bookName, b.image }).ToList(); List <DetailBills_ViewModels> details = new List <DetailBills_ViewModels>(); foreach (var d in detailBill) { DetailBills_ViewModels detail = new DetailBills_ViewModels(); detail.bookName = d.bookName; detail.categoryName = d.categoryName; detail.image = d.image; detail.quantity = (int)d.quantity; detail.price = d.price; details.Add(detail); } return(View(details)); } else { return(PartialView("_Partial404NotFoundAdmin")); } } }
public ActionResult SuccessView() { using (DataContext db = new DataContext()) { var bill_id_max = db.Bills.Max(x => x.Bill_ID); var bookbill = (from b in db.Books join d in db.DetailBills on b.Book_ID equals d.Book_ID join bi in db.Bills on d.Bill_ID equals bi.Bill_ID where d.Book_ID == b.Book_ID && d.Bill_ID == bill_id_max select new { b.statusSaleOff, b.saleOffPrice, b.bookName, b.image, d.quantity, b.price, bi.customerName, bi.phoneNumber, bi.total, bi.payment_method }).ToList(); List <DetailBills_ViewModels> detailsBill = new List <DetailBills_ViewModels>(); foreach (var b in bookbill) { DetailBills_ViewModels detailBills = new DetailBills_ViewModels(); detailBills.bookName = b.bookName; detailBills.image = b.image; detailBills.quantity = (int)b.quantity; detailBills.price = b.price; detailBills.customerName = b.customerName; detailBills.phone = b.phoneNumber; detailBills.total = (double)b.total; detailBills.payment_method = (int)b.payment_method; detailBills.saleOffPrice = b.saleOffPrice; detailBills.statusSaleOff = b.statusSaleOff; detailsBill.Add(detailBills); } return(View(detailsBill)); } }