public void XoaTaiKhoan(string tentk)
{
TaiKhoanNhomNV nhom = qlcf.TaiKhoanNhomNVs.Where(t => t.TaiKhoan == tentk).FirstOrDefault();
qlcf.TaiKhoanNhomNVs.DeleteOnSubmit(nhom);
TaiKhoan tk = qlcf.TaiKhoans.Where(t => t.TenTaiKhoan == tentk).FirstOrDefault();
qlcf.TaiKhoans.DeleteOnSubmit(tk);
qlcf.SubmitChanges();
}
public void ThemTaiKhoan(string tentk, string matkhau, string manhom)
{
TaiKhoan tk = new TaiKhoan();
tk.TenTaiKhoan = tentk;
tk.MatKhau = matkhau;
qlcf.TaiKhoans.InsertOnSubmit(tk);
TaiKhoanNhomNV nhom = new TaiKhoanNhomNV();
nhom.MaNhomNV = manhom;
nhom.TaiKhoan = tentk;
qlcf.TaiKhoanNhomNVs.InsertOnSubmit(nhom);
qlcf.SubmitChanges();
}
public void CapNhatTaiKhoan(string tentk, string matkhau, string manhom)
{
TaiKhoan tk = qlcf.TaiKhoans.Where(t => t.TenTaiKhoan == tentk).FirstOrDefault();
tk.MatKhau = matkhau;
TaiKhoanNhomNV nhom = qlcf.TaiKhoanNhomNVs.Where(t => t.TaiKhoan == tentk).FirstOrDefault();
qlcf.TaiKhoanNhomNVs.DeleteOnSubmit(nhom);
TaiKhoanNhomNV nhom1 = new TaiKhoanNhomNV();
nhom1.MaNhomNV = manhom;
nhom1.TaiKhoan = tentk;
qlcf.TaiKhoanNhomNVs.InsertOnSubmit(nhom1);
qlcf.SubmitChanges();
}
