public static Quiz_MultipleQuestion GetQuiz_MultipleQuestionByMultipleQustionID(int MultipleQustionID)
{
Quiz_MultipleQuestion quiz_MultipleQuestion = new Quiz_MultipleQuestion();
SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
quiz_MultipleQuestion = sqlQuiz_MultipleQuestionProvider.GetQuiz_MultipleQuestionByMultipleQustionID(MultipleQustionID);
return quiz_MultipleQuestion;
}
public static Quiz_MultipleQuestion GetQuiz_CourseByCourseID(int CourseID)
{
Quiz_MultipleQuestion quiz_MultipleQuestion = new Quiz_MultipleQuestion();
SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
quiz_MultipleQuestion = sqlQuiz_MultipleQuestionProvider.GetQuiz_MultipleQuestionByCourseID(CourseID);
return quiz_MultipleQuestion;
}
//public static Quiz_MultipleQuestion GetQuiz_ComprehensionByComprehensionID(int ComprehensionID)
//{
// Quiz_MultipleQuestion quiz_MultipleQuestion = new Quiz_MultipleQuestion();
// SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
// quiz_MultipleQuestion = sqlQuiz_MultipleQuestionProvider.GetQuiz_MultipleQuestionByComprehensionID(ComprehensionID);
// return quiz_MultipleQuestion;
//}
public static DataSet GetQuiz_MultipleQuestionByComprehensionID(int ComprehensionID)
{
DataSet quiz_MultipleQuestions = new DataSet();
SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
quiz_MultipleQuestions = sqlQuiz_MultipleQuestionProvider.GetQuiz_MultipleQuestionByComprehensionID(ComprehensionID);
return quiz_MultipleQuestions;
}
public static DataSet GetAllQuiz_MultipleQuestionsWithRelation()
{
DataSet quiz_MultipleQuestions = new DataSet();
SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
quiz_MultipleQuestions = sqlQuiz_MultipleQuestionProvider.GetAllQuiz_MultipleQuestions();
return quiz_MultipleQuestions;
}
public static DataSet GetDropDownListAllQuiz_MultipleQuestion()
{
DataSet quiz_MultipleQuestions = new DataSet();
SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
quiz_MultipleQuestions = sqlQuiz_MultipleQuestionProvider.GetDropDownLisAllQuiz_MultipleQuestion();
return quiz_MultipleQuestions;
}
public static List<Quiz_MultipleQuestion> GetQuiz_MultipleQuestionsByExamID(int courseID, int subjectID, int chapterID, int count,int examID)
{
List<Quiz_MultipleQuestion> quiz_MultipleQuestions = new List<Quiz_MultipleQuestion>();
SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
quiz_MultipleQuestions = sqlQuiz_MultipleQuestionProvider.GetQuiz_MultipleQuestionsByExamID(courseID, subjectID, chapterID, count, examID);
return quiz_MultipleQuestions;
}
public static List<Quiz_MultipleQuestion> GetQuiz_MultipleQuestionListByComprehensionID(int comprehensionID)
{
SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
return sqlQuiz_MultipleQuestionProvider.GetQuiz_MultipleQuestionListByComprehensionID(comprehensionID);
}
public static bool UpdateQuiz_MultipleQuestion(Quiz_MultipleQuestion quiz_MultipleQuestion)
{
SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
return sqlQuiz_MultipleQuestionProvider.UpdateQuiz_MultipleQuestion(quiz_MultipleQuestion);
}
public static bool DeleteQuiz_MultipleQuestion(int quiz_MultipleQuestionID)
{
SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
return sqlQuiz_MultipleQuestionProvider.DeleteQuiz_MultipleQuestion(quiz_MultipleQuestionID);
}
public static void LoadQuiz_MultipleQuestionPageByChapterID(string AnswerString, int chapterID, 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_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
DataSet ds = sqlQuiz_MultipleQuestionProvider.GetQuiz_MultipleQuestionPageWiseByChapterID( AnswerString,chapterID, pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
quiz_MultipleQuestionsPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public static int InsertQuiz_MultipleQuestion(Quiz_MultipleQuestion quiz_MultipleQuestion)
{
SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
return sqlQuiz_MultipleQuestionProvider.InsertQuiz_MultipleQuestion(quiz_MultipleQuestion);
}
public static Quiz_MultipleQuestion GetQuiz_SubjectBySubjectID(int SubjectID)
{
Quiz_MultipleQuestion quiz_MultipleQuestion = new Quiz_MultipleQuestion();
SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
quiz_MultipleQuestion = sqlQuiz_MultipleQuestionProvider.GetQuiz_MultipleQuestionBySubjectID(SubjectID);
return quiz_MultipleQuestion;
}
public static List<Quiz_MultipleQuestion> GetQuiz_MultipleQuestionsRandomlyTable(int courseID, int subjectID, int chapterID, int count)
{
List<Quiz_MultipleQuestion> quiz_MultipleQuestions = new List<Quiz_MultipleQuestion>();
SqlQuiz_MultipleQuestionProvider sqlQuiz_MultipleQuestionProvider = new SqlQuiz_MultipleQuestionProvider();
quiz_MultipleQuestions = sqlQuiz_MultipleQuestionProvider.GetQuiz_MultipleQuestionsRandomlyTable(courseID, subjectID, chapterID, count);
return quiz_MultipleQuestions;
}
public List<Quiz_MultipleQuestion> GetMockTest_MCQ(string studentID, int courseID, int subjectID, int chapterID, int count)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand command = new SqlCommand("GetMockTest_MCQ", 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_MultipleQuestionProvider mcqProvider = new SqlQuiz_MultipleQuestionProvider();
return mcqProvider.GetQuiz_MultipleQuestionsFromReader(reader);
}
}