public void ADDHoaDon(string maNhanVien, string MaDatHang, string SDT)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
HOADON hd = new HOADON();
string mahd = getNextMaHDon();
hd.maHoaDon = mahd;
hd.ngayLapHoaDon = DateTime.Now;
hd.maNhanVien = maNhanVien;
hd.DatHangID = MaDatHang;
hd.SDTKhachHang = SDT;
db.HOADONs.Add(hd);
db.SaveChanges();
DATHANGCHITIET dhct = new DATHANGCHITIET();
List <DATHANGCHITIET> listDatHangChiTiet = db.DATHANGCHITIETs.Where(x => x.DatHangID == MaDatHang).ToList();
double Tong = 0;
foreach (var item in listDatHangChiTiet)
{
List <CHITIETSANPHAM> ctsp = db.CHITIETSANPHAMs.Where(x => x.maSanPham == item.MaHangHoa).ToList();
Tong += (double)ctsp[0].donGiaXuat;
new ModifierChiTietHD().AddChiTietHD(mahd, item.MaHangHoa, (int)item.SoLuong, (float)ctsp[0].donGiaXuat);
}
List <HOADON> hoadon = db.HOADONs.Where(x => x.maHoaDon == mahd).ToList();
hoadon[0].TongTien = Tong;
db.SaveChanges();
}
public void AddDatHangChiTiet(string idDatHang, string listProduct, int listQuantity)
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
DATHANGCHITIET dhct = new DATHANGCHITIET();
dhct.ID = getNextIdOrDerDetail();
dhct.DatHangID = idDatHang;
dhct.MaHangHoa = listProduct;
dhct.SoLuong = listQuantity;
db.DATHANGCHITIETs.Add(dhct);
db.SaveChanges();
}
public List <XuatKhoDHvaCTDT> getListDatHangVaCTDH()
{
QLQuanAoDBContent db = new QLQuanAoDBContent();
DATHANG dh = new DATHANG();
DATHANGCHITIET dhct = new DATHANGCHITIET();
List <XuatKhoDHvaCTDT> list = new List <XuatKhoDHvaCTDT>();
List <DATHANG> listDH = db.DATHANGs.Where(x => x.statusID == 2).ToList();
List <DATHANGCHITIET> listDHCT = db.DATHANGCHITIETs.ToList();
return(db.DATHANGCHITIETs.Where(x => x.DATHANG.statusID == 2).Select(x => new XuatKhoDHvaCTDT {
MaDH = x.DATHANG.MaDonHang, TenHangHoa = x.SANPHAM.tenSanPham,
tenKH = x.DATHANG.TenKhachHang, SDT = x.DATHANG.SoDienThoai, DiaChi = x.DATHANG.DiaChi, Sluong = (int)x.SoLuong
}).ToList());
}
