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);
}
}
