public IActionResult Detail_Bill([FromQuery] billdetailParam modelParam)
{
getBillAndBilldetailViewModel model = new getBillAndBilldetailViewModel();
model.bill = repository_transaction.Get_Data_Bill(modelParam);
model.detail = repository_transaction.Get_Data_Detailbill(modelParam);
return(Json(model));
}
public billViewModel Get_Data_Bill(billdetailParam modelParam)
{
IQueryable <billViewModel> bill = from a in context.Bill
where a.IdBill == modelParam.IdBill
select new billViewModel
{
DateTime = a.Date,
NumberBill = a.NumberBill,
PriceBefore = a.PriceBefore,
PriceAfter = a.PriceAfter,
TotalDiscount = a.TotalDiscount
};
return(bill.SingleOrDefault());
}
public List <billdetailViewModel> Get_Data_Detailbill(billdetailParam modelParam)
{
IQueryable <billdetailViewModel> detailbill = from b in context.BillDetail
where b.IdBill == modelParam.IdBill
join p in context.Product on b.IdProduct equals p.IdProduct
join u in context.Unit on p.IdUnit equals u.IdUnit
select new billdetailViewModel
{
NameUnit = u.NameUnit,
NameProduct = p.ProductName,
ProductPrice = p.ProductPrice,
Count = b.Count,
Discount = b.Discount,
totalPrice = b.TotalPrice,
lastPrice = b.LastPrice
};
return(detailbill.ToList());
}
