public DataTable GetAllClass()
{
string query = "SELECT * FROM LOP";
return(SqlProvider.ExecuteQuery(query));
}
// lấy các lớp thuộc khối
public DataTable GetClassInGrade(string MaKhoi)
{
string query = string.Format("SELECT * FROM LOP JOIN KHOI ON LOP.MaKhoi = KHOI.MaKhoi WHERE LOP.MaKhoi = {0}", MaKhoi);
return(SqlProvider.ExecuteQuery(query));
}
public DataTable GetGRadeIdbyName(string name)
{
string query = string.Format("SELECT * FROM KHOI WHERE {0}", name);
return(SqlProvider.ExecuteQuery(query));
}
public DataTable GetAllGRade()
{
string query = "SELECT * FROM KHOI";
return(SqlProvider.ExecuteQuery(query));
}
public DataTable GetAllHocSinh()
{
string query = "SELECT * FROM HOCSINH";
return(SqlProvider.ExecuteQuery(query));
}
public void DeleteHocSinh(string id)
{
string query = string.Format("DELETE FROM HOCSINH WHERE MaHocSinh = '{0}'", id);
DataTable dt = SqlProvider.ExecuteQuery(query);
}
public DataTable GetAllStudentNotInClass()
{
string query = " SELECT * FROM DBO.HOCSINH HS WHERE HS.MaHocSinh NOT IN( SELECT HS1.MaHocSinh FROM DBO.HOCSINH HS1 JOIN PHANLOP PL ON HS1.MaHocSinh = PL.MaHocSinh JOIN LOP L ON L.MaLop = PL.MaLop)";
return(SqlProvider.ExecuteQuery(query));
}