public void xoapphieu(string id) { pchi pt = (from c in db.pchis select c).Single(x => x.id == id); db.pchis.DeleteOnSubmit(pt); db.pchis.Context.SubmitChanges(); }
public void suaphieu(string id, DateTime ngaychi, string iddt, string ghichu, int so, string link, string loaichi, string tiente, double tygia) { pchi pn = (from c in db.pchis select c).Single(x => x.id == id); pn.ngaychi = ngaychi; pn.iddt = iddt; pn.ghichu = ghichu; pn.so = so; pn.tiente = tiente; pn.tygia = tygia; pn.loaichi = loaichi; pn.link = link; db.pchis.Context.SubmitChanges(); }
public void moiphieu(string id, DateTime ngaychi, string iddt, string iddv, string idnv, string ghichu, int so, string link, string loaichi, string tiente, double tygia, string dv) { pchi pt = new pchi(); pt.id = id; pt.ngaychi = ngaychi; pt.iddt = iddt; pt.iddv = iddv; pt.idnv = idnv; pt.loaichi = loaichi; pt.ghichu = ghichu; pt.so = so; pt.tiente = tiente; pt.tygia = tygia; pt.link = link; pt.dv = dv; db.pchis.InsertOnSubmit(pt); db.pchis.Context.SubmitChanges(); }