public void PhieuChi_del(String sophieuchi)
{
PHIEUCHI chi = (from phieuchi in vbdq.PHIEUCHIs select phieuchi).Single(n => n.SoPhieuChi.CompareTo(sophieuchi) == 0);
vbdq.PHIEUCHIs.DeleteOnSubmit(chi);
vbdq.SubmitChanges();
}
public static void giamno(PHIEUCHI pc)
{
var ncc = db.NCCs.Find(pc.IDNCC);
ncc.TIENNO -= pc.TIEN;
db.Entry(ncc).State = EntityState.Modified;
db.SaveChanges();
}
public void PhieuChi_them(PhieuChi_DTO a)
{
PHIEUCHI b = new PHIEUCHI();
b.SoPhieuChi = a.SoPhieuChi;
b.NoiDung = a.NoiDung;
b.SoTienChi = a.SoTienChi;
b.NgayChi = DateTime.Parse(a.NgayChi);
vbdq.PHIEUCHIs.InsertOnSubmit(b);
vbdq.SubmitChanges();
}
public void PhieuChi_Upd(PhieuChi_DTO a)
{
PHIEUCHI b = new PHIEUCHI();
var obj = vbdq.PHIEUCHIs.Single(x => x.SoPhieuChi == a.SoPhieuChi);
// obj.SoPhieuChi = a.SoPhieuChi;
obj.NoiDung = a.NoiDung;
obj.NgayChi = DateTime.Parse(a.NgayChi);
obj.SoTienChi = a.SoTienChi;
// vbdq.PHIEUCHIs.InsertOnSubmit(b);
vbdq.SubmitChanges();
}
public bool Update()
{
var ct = new PHIEUCHI()
{
ID = view.ID,
NgayLap = view.NgayLap,
NoiDung = view.NoiDung,
TongTien = view.TongTien,
GhiChu = view.GhiChu,
};
return(model.Update(ct));
}
public bool Inseart()
{
var phieuchi = new PHIEUCHI()
{
ID = 0,
NgayLap = view.NgayLap,
NoiDung = view.NoiDung,
TongTien = view.TongTien,
GhiChu = view.GhiChu
};
return(model.Insert(phieuchi));
}
public static int them(PHIEUCHI pc)
{
try
{
DAO.QLTHUCHI.them(pc);
DAO.QLDOITAC.giamno(pc);
return(1);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(0);
}
}
public static void xoa(PHIEUCHI pc)
{
db.PHIEUCHIs.Remove(pc);
db.SaveChanges();
}
public static void them(PHIEUCHI pc)
{
db.PHIEUCHIs.Add(pc);
db.SaveChanges();
}
public static void xoa(PHIEUCHI pc)
{
DAO.QLTHUCHI.xoa(pc);
}
