public static int KiemTraTaiKhoan(string user, string password) { Data.m_strLogin = user; Data.m_strPassword = password; if (DataProvider.ConnectDatabase() == false) { return(0); } Data.m_strLoginDN = Data.m_strLogin; Data.m_strPasswordDN = Data.m_strPassword; string str = "EXEC SP_DANGNHAP'" + Data.m_strLogin + "'"; SqlDataReader myReader; myReader = DataProvider.ExecSQLDataReader(str); if (myReader == null) { return(0); } myReader.Read(); Data.m_strMaGV = myReader.GetString(0); if (Convert.IsDBNull(Data.m_strMaGV)) { return(1);//Tài khoản ko có quyền truy cập } else { Data.m_strHoten = myReader.GetString(1); Data.m_strGroup = myReader.GetString(2); Data.m_objConnection.Close(); return(2);//Đăng nhập thành công } }
public static SqlDataReader LoadBangDiemMonHoc(string x_strMaLop, string x_strMaMH, int x_nLanThi) { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLDataReader(string.Format("EXEC sp_BangDiemMonHoc '{0}', '{1}', {2}", x_strMaLop, x_strMaMH, x_nLanThi))); } return(null); }
public static SqlDataReader LoadLanThi(string x_strMaMonHoc, string x_strMaLop) { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLDataReader(string.Format("EXEC sp_SoLanThi '{0}', '{1}'", x_strMaMonHoc, x_strMaLop))); } return(null); }
public static SqlDataReader LoadMonHoc() { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLDataReader(string.Format("SELECT MAMH, TENMH FROM MONHOC"))); } return(null); }
public static SqlDataReader LoadLop() { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLDataReader(string.Format("SELECT MALOP, TENLOP FROM LOP"))); } return(null); }
public static SqlDataReader GetTenLop(string x_strMaLop) { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLDataReader(string.Format("SELECT TENLOP FROM LOP WHERE MALOP = '{0}'", x_strMaLop))); } return(null); }
public static SqlDataReader LoadDanhSachThiHetMon(string x_strMaLop, string x_strMaMonHoc, int x_nLanThi) { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLDataReader(string.Format("EXEC sp_DanhSachThiHetMon '{0}', '{1}', {2}", x_strMaLop, x_strMaMonHoc, x_nLanThi))); } return(null); }
public static SqlDataReader LoadHocPhi(string x_strMaSinhVien) { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLDataReader(string.Format("EXEC sp_LoadHocPhi '{0}'", x_strMaSinhVien))); } return(null); }
public static SqlDataReader LoadSinhVien() { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLDataReader(string.Format("SELECT MASV FROM SINHVIEN"))); } return(null); }
public static SqlDataReader GetMaLop(string x_strMaSV) { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLDataReader(string.Format("SELECT MALOP FROM SINHVIEN WHERE MASV = '{0}'", x_strMaSV))); } return(null); }
public static SqlDataReader GetHoTen(string x_strMaSV) { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLDataReader(string.Format("SELECT HOTEN = HO + ' ' + TEN FROM SINHVIEN WHERE MASV = '{0}'", x_strMaSV))); } return(null); }
public static SqlDataReader LoadPhieuDiem(string x_strMaSV) { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLDataReader(string.Format("EXEC sp_PhieuDiem '{0}'", x_strMaSV))); } return(null); }
public static SqlDataReader GetTenMonHoc(string x_strMaMH) { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLDataReader(string.Format("SELECT TENMH FROM MONHOC WHERE MAMH = '{0}'", x_strMaMH))); } return(null); }
public static SqlDataReader KiemTraMaSinhVien(string masv) { if (DataProvider.ConnectDatabase()) { string str = "EXEC SP_KiemTraMaSinhVien '" + masv + "'"; return(DataProvider.ExecSQLDataReader(str)); } return(null); }
public static SqlDataReader KiemTraTenLop(string tenlop) { if (DataProvider.ConnectDatabase()) { string str = "EXEC SP_KiemTraTenLop N'" + tenlop + "'"; return(DataProvider.ExecSQLDataReader(str)); } return(null); }
public static SqlDataReader TaoTaiKhoan(string login, string password, string user, string role) { if (DataProvider.ConnectDatabase()) { string str = " declare @res int " + "EXEC @res = SP_TAOTAIKHOAN '" + login + "','" + password + "','" + user + "','" + role + "'" + " select KETQUA = @res"; return(DataProvider.ExecSQLDataReader(str)); } return(null); }
public static bool IsExistedAtTableDiem(string x_strMaMonHoc) { if (DataProvider.ConnectDatabase()) { SqlDataReader objReader = DataProvider.ExecSQLDataReader(string.Format("EXEC sp_IsExistMaMonHoc '{0}'", x_strMaMonHoc)); if (objReader.Read()) { if (int.Parse(objReader.GetValue(0).ToString()) == 0) { return(false); } } } return(true); }
public static SqlDataReader LoadPhanManh() { try { Data.m_objConnection.Close(); string strConnectionString = "Data Source=" + Constant.SERVER_NAME + ";Initial Catalog=" + Constant.DATABASE_NAME + ";Integrated Security=True"; Data.m_objConnection.ConnectionString = strConnectionString; Data.m_objConnection.Open(); return(DataProvider.ExecSQLDataReader("SELECT * FROM V_DS_PHANMANH")); } catch { return(null); } }