public IList <RandomExamStrategy> GetTotalRandomExamStrategys(int SubjectID)
{
SystemVersionDAL systemVersionDal = new SystemVersionDAL();
int usePlace = systemVersionDal.GetUsePlace();
IList <RandomExamStrategy> items = new List <RandomExamStrategy>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Random_Exam_Strategy_Q_T";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_subject_id", DbType.Int32, SubjectID);
db.AddInParameter(dbCommand, "p_range_id", DbType.Int32, 0);
db.AddInParameter(dbCommand, "p_range_type", DbType.Int32, 0);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
RandomExamStrategy item = CreateModelObject(dataReader);
if (usePlace == 3)
{
item.MaxItemDifficultyID = Convert.ToInt32(dataReader[GetMappingFieldName("MaxItemDifficultyID")].ToString());
item.MaxItemDifficultyName = dataReader[GetMappingFieldName("MaxItemDifficultyName")].ToString();
}
item.TotalItemCount = Convert.ToInt32(dataReader[GetMappingFieldName("TotalItemCount")].ToString());
item.SelectCount = Convert.ToInt32(dataReader[GetMappingFieldName("SelectCount")].ToString());
items.Add(item);
}
}
return(items);
}
public IList <RandomExamStrategy> GetRandomExamStrategysByExamID(int RandomExamID)
{
SystemVersionDAL systemVersionDal = new SystemVersionDAL();
int usePlace = systemVersionDal.GetUsePlace();
IList <RandomExamStrategy> items = new List <RandomExamStrategy>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Random_Exam_Strategy_F";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_RANDOM_EXAM_ID", DbType.Int32, RandomExamID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
RandomExamStrategy item = CreateModelObject(dataReader);
if (usePlace == 3)
{
item.MaxItemDifficultyID = Convert.ToInt32(dataReader[GetMappingFieldName("MaxItemDifficultyID")].ToString());
item.MaxItemDifficultyName = dataReader[GetMappingFieldName("MaxItemDifficultyName")].ToString();
}
items.Add(item);
}
}
return(items);
}
public RandomExamStrategy GetRandomExamStrategy(int ExamStrategyId)
{
SystemVersionDAL systemVersionDal = new SystemVersionDAL();
int usePlace = systemVersionDal.GetUsePlace();
RandomExamStrategy item = null;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Random_Exam_Strategy_g";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_Random_Exam_Strategy_Id", DbType.Int32, ExamStrategyId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
item = CreateModelObject(dataReader);
if (usePlace == 3)
{
item.MaxItemDifficultyID = Convert.ToInt32(dataReader[GetMappingFieldName("MaxItemDifficultyID")].ToString());
item.MaxItemDifficultyName = dataReader[GetMappingFieldName("MaxItemDifficultyName")].ToString();
}
break;
}
}
return(item);
}