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); }