//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));
}
