public DataTable BangTaiKhoan()
{
ConvertClass convert = new ConvertClass();
var query = doiCTXH.fu_Ds_TaiKhoan();
return(convert.ToDataTable(doiCTXH, query));
}
public DataTable TimKiemDoiVien(string hoten)
{
ConvertClass convert = new ConvertClass();
var query = doiCTXH.fu_TimKiemDoiVien_TheoTen(hoten);
return(convert.ToDataTable(doiCTXH, query));
}
public DataTable BangDoiVien()
{
ConvertClass convert = new ConvertClass();
var query = doiCTXH.fu_ds_Doivien();
return(convert.ToDataTable(doiCTXH, query));
}
public DataTable DanhsachNhiemky()
{
ConvertClass convert = new ConvertClass();
var query = doiCTXH.fu_Ds_Nhiemki();
return(convert.ToDataTable(doiCTXH, query));
}
public DataTable XemBDHTheoNhiemKy(int nhiemki)
{
ConvertClass convert = new ConvertClass();
var query = doiCTXH.fu_ds_BDH_Nhiemky(nhiemki);
return(convert.ToDataTable(doiCTXH, query));
}
public DataTable BangVatDung()
{
ConvertClass convert = new ConvertClass();
var query = doiCTXH.fu_Ds_KhoVatDung();
return(convert.ToDataTable(doiCTXH, query));
}
public DataTable LoadDsThamgiaCT(string MaCT)
{
ConvertClass convert = new ConvertClass();
var query = doiCTXH.fu_DS_SVthamgiaCT(MaCT);
return(convert.ToDataTable(doiCTXH, query));
}
public DataTable BangChuongTrinh()
{
ConvertClass convert = new ConvertClass();
var query = doiCTXH.fu_Ds_Chuongtrinh();
return(convert.ToDataTable(doiCTXH, query));
}
//public DataTable LocTheoKhoaDV(string makhoadv)
//{
// ConvertClass convert = new ConvertClass();
// var query = doiCTXH.fu_Loc_TheoKhoaDV(makhoadv);
// return convert.ToDataTable(doiCTXH, query);
//}
//public DataTable LocTheoKhoa(string khoadaotao)
//{
// ConvertClass convert = new ConvertClass();
// var query = doiCTXH.fu_Loc_TheoKhoahoc(khoadaotao);
// return convert.ToDataTable(doiCTXH, query);
//}
//public DataTable LocTheoNamSinh(string namsinh)
//{
// int temp = int.Parse(namsinh);
// ConvertClass convert = new ConvertClass();
// var query = doiCTXH.fu_Loc_TheoNamsinh(temp);
// return convert.ToDataTable(doiCTXH, query);
//}
//Hàm dùng xóa Toàn bộ thông tin của một sinh viên, trừ BĐH
public DataTable LocDoiVien(string Namsinh, string MaKhoa, string MaKhoaDV)
{
ConvertClass convert = new ConvertClass();
if (Namsinh != "")
{
var query = doiCTXH.fu_Loc_DoiVien(int.Parse(Namsinh), MaKhoa, MaKhoaDV);
return(convert.ToDataTable(doiCTXH, query));
}
else
{
var query = doiCTXH.fu_Loc_DoiVien(null, MaKhoa, MaKhoaDV);
return(convert.ToDataTable(doiCTXH, query));
}
}