public List <CAUHOIDTO> LayDanhSachCauHoiTheoNoiDungVaMucDo(string noiDung, int mucDo)
{
try
{
List <CAUHOIDTO> lstKQ = new List <CAUHOIDTO>();
SqlConnection connection = ConnectDB();
SqlCommand cmd = new SqlCommand("sp_LayDanhSachCauHoiTheoNoiDungVaMucDo_DEMO", connection);
SqlParameter sParam_noidung = cmd.Parameters.Add("@NOIDUNG", SqlDbType.NVarChar);
sParam_noidung.Direction = ParameterDirection.Input;
sParam_noidung.Value = noiDung;
SqlParameter sParam_mucdo = cmd.Parameters.Add("@MUCDO", SqlDbType.NVarChar);
sParam_mucdo.Direction = ParameterDirection.Input;
sParam_mucdo.Value = mucDo;
SqlParameter sParam_ketQua = cmd.Parameters.Add("@Return", SqlDbType.NVarChar, 500);
sParam_ketQua.Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
CAUHOIDTO d = new CAUHOIDTO();
d.MACH = (long)rdr["MACH"];
d.NOIDUNG = (string)rdr["NOIDUNG"];
d.THANGDIEM = (double)rdr["THANGDIEM"];
d.SOCAUTRALOI = (int)rdr["SOCAUTRALOI"];
if ((int)rdr["MUCDO"] == (int)Enums.MucDoCauHoi.De)
{
d.MUCDO = "Dễ";
}
else if ((int)rdr["MUCDO"] == (int)Enums.MucDoCauHoi.Vua)
{
d.MUCDO = "Vừa";
}
else
{
d.MUCDO = "Khó";
}
d.MAMH = (long)rdr["MAMH"];
lstKQ.Add(d);
}
return(lstKQ);
}
catch (Exception e)
{
throw e;
}
}
public List <CAUHOIDTO> LayDanhSachCauHoiTheoMonHocChuaCoTrongDeThi(long maMonHoc, long maDeThi)
{
try
{
List <CAUHOIDTO> lstKQ = new List <CAUHOIDTO>();
SqlConnection connection = ConnectDB();
SqlCommand cmd = new SqlCommand("sp_LayDanhSachCauHoiTheoMonHocChuaCoTrongDeThi", connection);
SqlParameter sParam_maMonHoc = cmd.Parameters.Add("@MAMH", SqlDbType.BigInt);
sParam_maMonHoc.Direction = ParameterDirection.Input;
sParam_maMonHoc.Value = maMonHoc;
SqlParameter sParam_maDeThi = cmd.Parameters.Add("@MADT", SqlDbType.BigInt);
sParam_maDeThi.Direction = ParameterDirection.Input;
sParam_maDeThi.Value = maDeThi;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
CAUHOIDTO d = new CAUHOIDTO();
d.MACH = (long)rdr["MACH"];
d.NOIDUNG = (string)rdr["NOIDUNG"];
d.THANGDIEM = (double)rdr["THANGDIEM"];
d.SOCAUTRALOI = (int)rdr["SOCAUTRALOI"];
if ((int)rdr["MUCDO"] == (int)Enums.MucDoCauHoi.De)
{
d.MUCDO = "Dễ";
}
else if ((int)rdr["MUCDO"] == (int)Enums.MucDoCauHoi.Vua)
{
d.MUCDO = "Vừa";
}
else
{
d.MUCDO = "Khó";
}
lstKQ.Add(d);
}
return(lstKQ);
}
catch (Exception e)
{
throw e;
}
}
public List <CAUHOIDTO> LayDanhSachCauHoi()
{
try
{
List <CAUHOIDTO> lstKQ = new List <CAUHOIDTO>();
SqlConnection connection = ConnectDB();
SqlCommand cmd = new SqlCommand("sp_LayDanhSachCauHoi_DEMO", connection);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
CAUHOIDTO d = new CAUHOIDTO();
d.MACH = (long)rdr["MACH"];
d.NOIDUNG = (string)rdr["NOIDUNG"];
d.THANGDIEM = (double)rdr["THANGDIEM"];
d.SOCAUTRALOI = (int)rdr["SOCAUTRALOI"];
if ((int)rdr["MUCDO"] == (int)Enums.MucDoCauHoi.De)
{
d.MUCDO = "Dễ";
}
else if ((int)rdr["MUCDO"] == (int)Enums.MucDoCauHoi.Vua)
{
d.MUCDO = "Vừa";
}
else
{
d.MUCDO = "Khó";
}
d.MAMH = (long)rdr["MAMH"];
d.TENMH = (string)rdr["TENMH"];
lstKQ.Add(d);
}
return(lstKQ);
}
catch (Exception e)
{
throw e;
}
}
