private void HienThiChiTietHoaDonTheoBan(int id)
{
QuanLyQuanCafeDataContext db = new QuanLyQuanCafeDataContext();
var result = (from c in db.ChiTietHoaDons
join t in db.ThucPhams on c.maTP equals t.maTP
where c.maBan == id
select new
{
TenTP = t.tenTP,
DonGia = t.donGia,
SoLuong = c.soLuong,
ThanhTien = (c.soLuong * c.donGia)
}).ToList();
dgvDanhSachMonDaGoi.DataSource = result;
decimal total = 0;
foreach (var item in result)
{
total += (decimal)item.ThanhTien;
}
CultureInfo culture = new CultureInfo("vi-VN");
txtTongTien.Text = total.ToString("c", culture);
}
//Hiển thị danh sách các món đã chọn trong bàn
private void HienThiChiTietHoaDonTheoBan(int id)
{
QuanLyQuanCafeDataContext db = new QuanLyQuanCafeDataContext();
var result = (from c in db.ChiTietHoaDons
join t in db.ThucPhams on c.maTP equals t.maTP
where c.maBan == id
select new
{
TenTP = t.tenTP,
DonGia = t.donGia,
SoLuong = c.soLuong,
ThanhTien = (c.soLuong * c.donGia)
}).ToList();
dataGridView1.DataSource = result;
}
