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); } }