//Dếm số bản ghi public int TongBanGhi(giangvien gv) { string str = "select count(magv) from giangvien where magv='" + gv.Magv + "'"; int tbg = trinh.KiemTraMaTrung(str); return(tbg); }
public int kiemtramatkhau(giangvien gv) { string str = "select count(*) from giangvien where magv='" + gv.Magv + "'and matkhau='" + gv.Matkhau + "'"; int tbg = trinh.KiemTraMaTrung(str); return(tbg); }
public DataTable timkiemtheokhoa(giangvien gv) { string strgiangvien = "select * from giangvien where khoa='" + trinh.chuanhoaxau(gv.Khoa) + "'"; return(trinh.LoadDuLieu(strgiangvien)); }
public void Xoagiangvien(giangvien gv) { string xoa = "delete from giangvien where magv='" + trinh.chuanhoaxau(gv.Magv) + "'"; trinh.ThucThi(xoa); }
//Sửa giang vien public void Suagiangvien(giangvien gv) { string sua = "update giangvien set magv='" + trinh.chuanhoaxau(gv.Magv) + "',tengv=N'" + trinh.chuanhoaxau(gv.Tengv) + "',anh='" + gv.Anh + "',khoa='" + gv.Khoa + "' ,gmail='" + gv.Gmail + "',sdt='" + gv.Sdt + "',tendangnhap='" + gv.Tendangnhap + "',matkhau='" + gv.Matkhau + "'where magv='" + trinh.chuanhoaxau(gv.Magv) + "'"; trinh.ThucThi(sua); }
//Thêm giang vien public void Themgiangvien(giangvien gv) { string strthem = "insert into giangvien values('" + trinh.chuanhoaxau(gv.Magv) + "',N'" + trinh.chuanhoaxau(gv.Tengv) + "','" + gv.Anh + "','" + gv.Khoa + "','" + gv.Gmail + "','" + gv.Sdt + "','" + gv.Tendangnhap + "','" + gv.Matkhau + "')"; trinh.ThucThi(strthem); }
public DataTable timkiemtheokhoa(giangvien gv) { return(trinh.timkiemtheokhoa(gv)); }
public int kiemtramatkhau(giangvien gv) { return(trinh.kiemtramatkhau(gv)); }
public DataTable timkiemtheoten(giangvien giangvien) { return(trinh.timkiemtheoten(giangvien)); }
public void Xoagiangvien(giangvien gv) { trinh.Xoagiangvien(gv); }
//Sửa giang vien public void Suagiangvien(giangvien gv) { trinh.Suagiangvien(gv); }
//Thêm giang vien public void Themgiangvien(giangvien gv) { trinh.Themgiangvien(gv); }
//Dếm số bản ghi public int TongBanGhi(giangvien gv) { return(TongBanGhi(gv)); }