public static DataTable loadDSMon()
{
dataProvider = new CDataProvider_DAL();
string selectTenMon = "select * from MonHoc";
return(dataProvider.getDataTableExcuteQuery("tbTenMon", selectTenMon));
}
public static string loadTenMon(string strMaMon)
{
dataProvider = new CDataProvider_DAL();
string selectTenMon = "select TenMon from MonHoc where MaMon='" + strMaMon + "'";
return(dataProvider.getDataTableExcuteQuery("tbTenMon", selectTenMon).Rows[0]["TenMon"].ToString());
}
public static DataTable loadSinhVienInfor(string strMaSV)
{
dataProvider = new CDataProvider_DAL();
DataTable tb;
string strSelectHoTen = string.Format("select * from SinhVien where MaSV='{0}'", strMaSV);
tb = dataProvider.getDataTableExcuteQuery("tbTenSinhVien", strSelectHoTen);
return(tb);
}
public static DataTable loadLichHocTrongNgay(string strMaSV, int iThu)
{
dataProvider = new CDataProvider_DAL();
iThu++;
DataTable dtb = new DataTable();
string strSelectCmd = string.Format("exec [dbo].[spLichHocTrongNgay] @MaSV={0}, @Thu={1}", strMaSV, iThu);
dtb = dataProvider.getDataTableExcuteQuery("LichHocNgay" + iThu, strSelectCmd);
return(dtb);
}
public static DataTable loadLichHocTrongNgay(string strMaSV)
{
dataProvider = new CDataProvider_DAL();
int iThu = DateTime.Now.DayOfWeek.GetHashCode() + 1;
DataTable dtb = new DataTable();
string strSelectCmd = string.Format("exec [dbo].[spLichHocTrongNgay] @MaSV={0}, @Thu={1}", strMaSV, iThu);
dtb = dataProvider.getDataTableExcuteQuery("LichHocNgay", strSelectCmd);
return(dtb);
}
public static DataTable loadSuKienTrongNgay(string strMaSV)
{
dataProvider = new CDataProvider_DAL();
DateTime date = DateTime.Now;
DataTable dtb = new DataTable();
string strSelectCmd = string.Format("exec [dbo].[spHoatDongTuongLai] @MaSV={0}, @ThoiGianHienTai='{1}'", strMaSV, date.ToShortDateString());
dtb = dataProvider.getDataTableExcuteQuery("LichHocNgay", strSelectCmd);
return(dtb);
}
public static string loadTenSinhVien(string strMaSV)
{
dataProvider = new CDataProvider_DAL();
string strSelectHoTen = string.Format("select HoTen from SinhVien where MaSV='{0}'", strMaSV);
string strHoTenSV = "";
DataTable tb = dataProvider.getDataTableExcuteQuery("tbTenSinhVien", strSelectHoTen);
strHoTenSV = tb.Rows[0]["HoTen"].ToString();
return(strHoTenSV);
}
public static DataTable loaDSHocKy()
{
dataProvider = new CDataProvider_DAL();
string strSelectHocKy = "select * from HocKy";
DataTable dtb = new DataTable();
dtb = dataProvider.getDataTableExcuteQuery("tbHocKy", strSelectHocKy);
return(dtb);
}
public static DataTable loadDSMonHK(string strMaSV, string strMaHK)
{
dataProvider = new CDataProvider_DAL();
string strSelectMon =
@"select MonHoc.MaMon, MonHoc.TenMon from DanhSachMon inner join MonHoc on DanhSachMon.MaMon=MonHoc.MaMon where DanhSachMon.MaSV='" + strMaSV + "' and DanhSachMon.MaHK='" + strMaHK + "'";
DataTable tbl = new DataTable();
tbl = dataProvider.getDataTableExcuteQuery("tbMonHocTheoHK", strSelectMon);
return(tbl);
}