public void sua1hopdonxuat(string mahdxuat, DateTime ngaylaphoadon, string makh)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
HoaDon_Xuat hdxuat = new HoaDon_Xuat();
hdxuat = data.HoaDon_Xuats.Where(t => t.MAHD_Xuat == mahdxuat).FirstOrDefault();
if (hdxuat != null)
{
hdxuat.NgayLap_Xuat = ngaylaphoadon;
hdxuat.MAKH = makh;
data.SubmitChanges();
}
}
}
public void them1HoaDonXuat(string maHDN, string MaKH, string MaNV, DateTime NgayLap, string Tinhtrang, float vat)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
HoaDon_Xuat hdXuat = new HoaDon_Xuat();
hdXuat.MAHD_Xuat = maHDN;
hdXuat.MAKH = MaKH;
hdXuat.MANV = MaNV;
hdXuat.NgayLap_Xuat = NgayLap;
hdXuat.TinhTrangXuat = Tinhtrang;
hdXuat.TongTien = 0;
hdXuat.Vat = vat;
data.HoaDon_Xuats.InsertOnSubmit(hdXuat);
data.SubmitChanges();
}
}
public void sua1hoadonnhapxuat(string mahdx)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
HoaDon_Xuat HoaDon = new HoaDon_Xuat();
HoaDon = data.HoaDon_Xuats.Where(t => t.MAHD_Xuat == mahdx).SingleOrDefault();
if (HoaDon != null)
{
HoaDon.TinhTrangXuat = "Đã Thanh Toán";
data.SubmitChanges();
}
}
}
public void xoa1HoadonNhap(string maHD)
{
using (QLBanHangDataContext data = new QLBanHangDataContext())
{
HoaDon_Xuat HoaDon = new HoaDon_Xuat();
HoaDon = data.HoaDon_Xuats.Where(t => t.MAHD_Xuat == maHD).FirstOrDefault();
if (HoaDon != null)
{
data.HoaDon_Xuats.DeleteOnSubmit(HoaDon);
data.SubmitChanges();
}
else
{
return;
}
}
}
