public static Quiz_Comprehension GetQuiz_CourseByCourseID(int CourseID)
{
Quiz_Comprehension quiz_Comprehension = new Quiz_Comprehension();
SqlQuiz_ComprehensionProvider sqlQuiz_ComprehensionProvider = new SqlQuiz_ComprehensionProvider();
quiz_Comprehension = sqlQuiz_ComprehensionProvider.GetQuiz_ComprehensionByCourseID(CourseID);
return quiz_Comprehension;
}
public static Quiz_Comprehension GetQuiz_SubjectBySubjectID(int SubjectID)
{
Quiz_Comprehension quiz_Comprehension = new Quiz_Comprehension();
SqlQuiz_ComprehensionProvider sqlQuiz_ComprehensionProvider = new SqlQuiz_ComprehensionProvider();
quiz_Comprehension = sqlQuiz_ComprehensionProvider.GetQuiz_ComprehensionBySubjectID(SubjectID);
return quiz_Comprehension;
}
public static List<Quiz_Comprehension> GetQuiz_ComprehensionsRandomly(int courseID, int subjectID, int chapterID, int count)
{
List<Quiz_Comprehension> comprehensions = new List<Quiz_Comprehension>();
SqlQuiz_ComprehensionProvider sqlQuiz_ComprehensionProvider = new SqlQuiz_ComprehensionProvider();
comprehensions = sqlQuiz_ComprehensionProvider.GetQuiz_ComprehensionsRandomly(courseID, subjectID, chapterID, count);
return comprehensions;
}
public static DataSet GetDropDownListAllQuiz_Comprehension()
{
DataSet quiz_Comprehensions = new DataSet();
SqlQuiz_ComprehensionProvider sqlQuiz_ComprehensionProvider = new SqlQuiz_ComprehensionProvider();
quiz_Comprehensions = sqlQuiz_ComprehensionProvider.GetDropDownLisAllQuiz_Comprehension();
return quiz_Comprehensions;
}
public static DataSet GetAllQuiz_ComprehensionsWithRelation()
{
DataSet quiz_Comprehensions = new DataSet();
SqlQuiz_ComprehensionProvider sqlQuiz_ComprehensionProvider = new SqlQuiz_ComprehensionProvider();
quiz_Comprehensions = sqlQuiz_ComprehensionProvider.GetAllQuiz_Comprehensions();
return quiz_Comprehensions;
}
public List<Quiz_Comprehension> GetMockTest_Comprehension(string studentID, int courseID, int subjectID, int chapterID, int count)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand command = new SqlCommand("GetMockTest_Comprehension", 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("@Count", SqlDbType.Int).Value = count;
connection.Open();
IDataReader reader = command.ExecuteReader();
SqlQuiz_ComprehensionProvider comprehensionProvider = new SqlQuiz_ComprehensionProvider();
return comprehensionProvider.GetQuiz_ComprehensionsFromReader(reader);
}
}
public static void LoadQuiz_ComprehensionPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount=0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlQuiz_ComprehensionProvider sqlQuiz_ComprehensionProvider = new SqlQuiz_ComprehensionProvider();
DataSet ds = sqlQuiz_ComprehensionProvider.GetQuiz_ComprehensionPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
quiz_ComprehensionsPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static int InsertQuiz_Comprehension(Quiz_Comprehension quiz_Comprehension)
{
SqlQuiz_ComprehensionProvider sqlQuiz_ComprehensionProvider = new SqlQuiz_ComprehensionProvider();
return sqlQuiz_ComprehensionProvider.InsertQuiz_Comprehension(quiz_Comprehension);
}
public static bool DeleteQuiz_Comprehension(int quiz_ComprehensionID)
{
SqlQuiz_ComprehensionProvider sqlQuiz_ComprehensionProvider = new SqlQuiz_ComprehensionProvider();
return sqlQuiz_ComprehensionProvider.DeleteQuiz_Comprehension(quiz_ComprehensionID);
}
public static bool UpdateQuiz_Comprehension(Quiz_Comprehension quiz_Comprehension)
{
SqlQuiz_ComprehensionProvider sqlQuiz_ComprehensionProvider = new SqlQuiz_ComprehensionProvider();
return sqlQuiz_ComprehensionProvider.UpdateQuiz_Comprehension(quiz_Comprehension);
}
