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