public void DeleteStaff(int id) { var db = new QLNV1Entities(); var staff = db.NHANVIENs.Find(id); db.NHANVIENs.Remove(staff); db.SaveChanges(); }
public void UpdateStaff(int id, string name, string gender, DateTime dateofbirth, string phonenumber, string address, int room) { var db = new QLNV1Entities(); var oldStaff = db.NHANVIENs.Find(id); oldStaff.name = name; oldStaff.gender = gender; oldStaff.dateofbirth = dateofbirth; oldStaff.phonenumber = phonenumber; oldStaff.address = address; oldStaff.room = room; db.Entry(oldStaff).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); }
public void CreateStaff(string name, string gender, DateTime dateofbirth, string phonenumber, string address, int room) { var db = new QLNV1Entities(); var newStaff = new NHANVIEN(); newStaff.name = name; newStaff.gender = gender; newStaff.dateofbirth = dateofbirth; newStaff.phonenumber = phonenumber; newStaff.address = address; newStaff.room = room; db.NHANVIENs.Add(newStaff); db.SaveChanges(); }