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));
}
}
