public void Block_NhanVien(int id, int hoatdong) { NV_TuVan nv = spa.NV_TuVans.Where(t => t.ID == id).FirstOrDefault(); if (nv != null) { nv.HoatDong_TV = hoatdong; spa.SubmitChanges(); } }
public void deleteNhanVien(int id) { NV_TuVan nv = spa.NV_TuVans.Where(t => t.ID == id).FirstOrDefault(); if (nv != null) { spa.NV_TuVans.DeleteOnSubmit(nv); spa.SubmitChanges(); } }
public void addnew_NhanVien(string name, DateTime namsinh, string sdt, string gioitinh, string diachi, string cmnd, int loainv, int hoatdong) { NV_TuVan nv = new NV_TuVan(); nv.NAME = name; nv.NamSinh = namsinh; nv.GioiTinh = gioitinh; nv.DIACHI = diachi; nv.CMND = cmnd; nv.SDT = sdt; nv.ID_LOAINV = loainv; nv.HoatDong_TV = hoatdong; spa.NV_TuVans.InsertOnSubmit(nv); spa.SubmitChanges(); }
public void SuaNhanVien(int id, string name, DateTime namsinh, string sdt, string gioitinh, string diachi, string cmnd, int loainv, int hoatdong) { NV_TuVan nv = spa.NV_TuVans.Where(t => t.ID == id).FirstOrDefault(); if (nv != null) { nv.NAME = name; nv.NamSinh = namsinh; nv.GioiTinh = gioitinh; nv.DIACHI = diachi; nv.CMND = cmnd; nv.SDT = sdt; nv.ID_LOAINV = loainv; nv.HoatDong_TV = hoatdong; spa.SubmitChanges(); } }