public static Quiz_TrueFalse GetQuiz_CourseByCourseID(int CourseID)
{
Quiz_TrueFalse quiz_TrueFalse = new Quiz_TrueFalse();
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
quiz_TrueFalse = sqlQuiz_TrueFalseProvider.GetQuiz_TrueFalseByCourseID(CourseID);
return quiz_TrueFalse;
}
public static Quiz_TrueFalse GetQuiz_SubjectBySubjectID(int SubjectID)
{
Quiz_TrueFalse quiz_TrueFalse = new Quiz_TrueFalse();
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
quiz_TrueFalse = sqlQuiz_TrueFalseProvider.GetQuiz_TrueFalseBySubjectID(SubjectID);
return quiz_TrueFalse;
}
public static DataSet GetQuiz_DrCrByComprehensionID(int ComprehensionID)
{
DataSet quiz_TrueFalses = new DataSet();
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
quiz_TrueFalses = sqlQuiz_TrueFalseProvider.GetQuiz_DrCrByComprehensionID(ComprehensionID);
return quiz_TrueFalses;
}
public static DataSet GetAllQuiz_TrueFalsesWithRelation()
{
DataSet quiz_TrueFalses = new DataSet();
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
quiz_TrueFalses = sqlQuiz_TrueFalseProvider.GetAllQuiz_TrueFalses();
return quiz_TrueFalses;
}
public static DataSet GetDropDownListAllQuiz_TrueFalse()
{
DataSet quiz_TrueFalses = new DataSet();
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
quiz_TrueFalses = sqlQuiz_TrueFalseProvider.GetDropDownLisAllQuiz_TrueFalse();
return quiz_TrueFalses;
}
public List<Quiz_TrueFalse> GetMockTest_TrueFalses(string studentID, int courseID, int subjectID, int chapterID, bool isDrCr, int count)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand command = new SqlCommand("GetMockTest_TrueFalse", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = studentID;
command.Parameters.Add("@CourseID", SqlDbType.Int).Value = courseID;
command.Parameters.Add("@SubjectID", SqlDbType.Int).Value = subjectID;
command.Parameters.Add("@ChapterID", SqlDbType.Int).Value = chapterID;
command.Parameters.Add("@IsDrCr", SqlDbType.Bit).Value = isDrCr;
command.Parameters.Add("@Count", SqlDbType.Int).Value = count;
connection.Open();
IDataReader reader = command.ExecuteReader();
SqlQuiz_TrueFalseProvider trueFalseProvider = new SqlQuiz_TrueFalseProvider();
return trueFalseProvider.GetQuiz_TrueFalsesFromReader(reader);
}
}
public static List<Quiz_TrueFalse> GetQuiz_DrCrListByComprehensionID(int ComprehensionID)
{
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
return sqlQuiz_TrueFalseProvider.GetQuiz_DrCrListByComprehensionID(ComprehensionID);
}
public static bool DeleteQuiz_TrueFalse(int quiz_TrueFalseID)
{
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
return sqlQuiz_TrueFalseProvider.DeleteQuiz_TrueFalse(quiz_TrueFalseID);
}
public static bool UpdateQuiz_TrueFalse(Quiz_TrueFalse quiz_TrueFalse)
{
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
return sqlQuiz_TrueFalseProvider.UpdateQuiz_TrueFalse(quiz_TrueFalse);
}
public static void LoadQuiz_TrueFalsePage(System.Web.UI.WebControls.GridView gv, bool isDrCr, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize, int courseID, int subjectID, int chapterID)
{
int recordCount=0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
DataSet ds = sqlQuiz_TrueFalseProvider.GetQuiz_TrueFalsePageWise(isDrCr,pageIndex, PageSize, out recordCount, courseID, subjectID, chapterID);
gv.DataSource = ds;
gv.DataBind();
quiz_TrueFalsesPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static int InsertQuiz_TrueFalse(Quiz_TrueFalse quiz_TrueFalse)
{
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
return sqlQuiz_TrueFalseProvider.InsertQuiz_TrueFalse(quiz_TrueFalse);
}
public static List<Quiz_TrueFalse> GetQuiz_TrueFalsesRandomly(int courseID, int subjectID, int chapterID, bool isDrCr, int count)
{
//DataSet quiz_TrueFalses = new DataSet();
List<Quiz_TrueFalse> quiz_TrueFalses = new List<Quiz_TrueFalse>();
SqlQuiz_TrueFalseProvider sqlQuiz_TrueFalseProvider = new SqlQuiz_TrueFalseProvider();
quiz_TrueFalses = sqlQuiz_TrueFalseProvider.GetQuiz_TrueFalsesRandomly(courseID, subjectID, chapterID, isDrCr, count);
return quiz_TrueFalses;
}
