public void CTPhieuGiaCong_Del(String sophieugc, String sophieudv, String stt)
{
CTGIACONG phieugc = (from phieu in vbdq.CTGIACONGs select phieu).Single(n =>
n.SoPhieuDV.CompareTo(sophieudv) == 0 &&
n.SoPhieuGiaCong.CompareTo(sophieugc) == 0 &&
n.STT.CompareTo(stt) == 0);
vbdq.CTGIACONGs.DeleteOnSubmit(phieugc);
vbdq.SubmitChanges();
}
public void CTPhieuGiaCong_Add(CTGiaCong_DTO pbh)
{
CTGIACONG obj = new CTGIACONG();
obj.SoPhieuGiaCong = pbh.SoPhieuGiaCong;
obj.SoPhieuDV = pbh.SoPhieuDV;
obj.STT = pbh.STT;
obj.SoLuong = pbh.SoLuong;
obj.DonGia = pbh.DonGia;
obj.ThanhTien = Decimal.Parse(pbh.ThanhTien.ToString());
obj.MaTho = pbh.MaTho;
vbdq.CTGIACONGs.InsertOnSubmit(obj);
//update tinh trang cho phieu dv
var phieudv = vbdq.CTPHIEUDICHVUs.Single(x => x.STT == pbh.STT && x.SoPhieuDV == pbh.SoPhieuDV);
phieudv.TinhTrang = 1;
vbdq.SubmitChanges();
}
