public static List <PhanManhDTO> LoadPhanManh()
{
SqlDataReader objReader = DanhSachThiHetMonDAL.LoadPhanManh();
if (objReader == null)
{
return(null);
}
List <PhanManhDTO> lstPhanManh = new List <PhanManhDTO>();
PhanManhDTO objPM;
while (objReader.Read())
{
objPM = new PhanManhDTO();
objPM.TenKhoa = objReader[0].ToString();
objPM.TenServer = objReader[1].ToString();
if (objPM.TenKhoa.ToUpper().Trim().Equals(Constant.PUBLICATION_NAME_KT))
{
continue;
}
lstPhanManh.Add(objPM);
}
return(lstPhanManh);
}
public static List <DanhSachThiHetMonDTO> LoadDanhSachThiHetMon(string x_strMaLop, string x_strMaMonHoc, int x_nLanThi)
{
SqlDataReader objReader = DanhSachThiHetMonDAL.LoadDanhSachThiHetMon(x_strMaLop, x_strMaMonHoc, x_nLanThi);
if (objReader == null)
{
return(null);
}
List <DanhSachThiHetMonDTO> lstThiHetMon = new List <DanhSachThiHetMonDTO>();
DanhSachThiHetMonDTO objDSTHM;
int nSTT = 1;
while (objReader.Read())
{
objDSTHM = new DanhSachThiHetMonDTO();
objDSTHM.STT = nSTT;
objDSTHM.MaSinhVien = objReader[0].ToString();
objDSTHM.HoTen = objReader[1].ToString();
objDSTHM.SoTo = int.Parse(objReader[2].ToString());
objDSTHM.Diem = float.Parse(objReader[3].ToString());
objDSTHM.Chuky = objReader[4].ToString();
lstThiHetMon.Add(objDSTHM);
nSTT++;
}
return(lstThiHetMon);
}
public static bool ChangeServer()
{
if (DanhSachThiHetMonDAL.ChangeServer())
{
return(true);
}
return(false);
}
public static string GetTenMonHoc(string x_strMaMonHoc)
{
SqlDataReader objReader = DanhSachThiHetMonDAL.GetTenMonHoc(x_strMaMonHoc);
if (objReader == null)
{
return(null);
}
if (objReader.Read())
{
return(objReader[0].ToString());
}
return(null);
}
public static List <string> LoadLanThi(string x_strMaMonHoc, string x_strMaLop)
{
SqlDataReader objReader = DanhSachThiHetMonDAL.LoadLanThi(x_strMaMonHoc, x_strMaLop);
if (objReader == null)
{
return(null);
}
List <string> lstLanThi = new List <string>();
while (objReader.Read())
{
lstLanThi.Add(objReader[0].ToString());
}
return(lstLanThi);
}
public static List <MonHocDTO> LoadMonHoc()
{
SqlDataReader objReader = DanhSachThiHetMonDAL.LoadMonHoc();
if (objReader == null)
{
return(null);
}
List <MonHocDTO> lstMonHoc = new List <MonHocDTO>();
MonHocDTO objMonHoc;
while (objReader.Read())
{
objMonHoc = new MonHocDTO();
objMonHoc.MaMH = objReader[0].ToString();
objMonHoc.TenMH = objReader[1].ToString();
lstMonHoc.Add(objMonHoc);
}
return(lstMonHoc);
}
public static List <LopDTO> LoadLop()
{
SqlDataReader objReader = DanhSachThiHetMonDAL.LoadLop();
if (objReader == null)
{
return(null);
}
List <LopDTO> lstLop = new List <LopDTO>();
LopDTO objLop;
while (objReader.Read())
{
objLop = new LopDTO();
objLop.MALOP = objReader[0].ToString();
objLop.TENLOP = objReader[1].ToString();
lstLop.Add(objLop);
}
return(lstLop);
}
