public static List <PhanManhDTO> LoadPhanManh() { SqlDataReader objReader = NhapDiemDAL.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 bool ChangeServer() { if (NhapDiemDAL.ChangeServer()) { return(true); } return(false); }
public static List <string> LoadLanThi(string x_strMaMonHoc, string x_strMaLop) { SqlDataReader objReader = NhapDiemDAL.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 = NhapDiemDAL.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 = NhapDiemDAL.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); }
public static List <BangDiemSinhVienDTO> LoadBangDiemSinhVien(string x_strMaLop, string x_strMaMonHoc, int x_nLanThi) { SqlDataReader objReader = NhapDiemDAL.LoadBangDiemSinhVien(x_strMaLop, x_strMaMonHoc, x_nLanThi); if (objReader == null) { return(null); } List <BangDiemSinhVienDTO> lstBDSV = new List <BangDiemSinhVienDTO>(); BangDiemSinhVienDTO objBDSV; while (objReader.Read()) { objBDSV = new BangDiemSinhVienDTO(); objBDSV.MaSinhVien = objReader[0].ToString(); objBDSV.HoTen = objReader[1].ToString(); objBDSV.Diem = Convert.ToSingle(objReader[2]); lstBDSV.Add(objBDSV); } return(lstBDSV); }
public static bool UpdateBangDiemSinhVien(List <BangDiemSinhVienDTO> x_lstBangDiem, string x_strMaMonHoc, int x_nLan) { return(NhapDiemDAL.UpdateBangDiemSinhVien(x_lstBangDiem, x_strMaMonHoc, x_nLan)); }