public static DataSet GetQuiz_FillInTheBlanksByComprehensionID(int ComprehensionID)
{
DataSet quiz_FillInTheBlankss = new DataSet();
SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider();
quiz_FillInTheBlankss = sqlQuiz_FillInTheBlanksProvider.GetQuiz_FillInTheBlanksByComprehensionID(ComprehensionID);
return quiz_FillInTheBlankss;
}
public static List<Quiz_FillInTheBlanks> GetQuiz_FillInTheBlanksByExamID(int courseID, int subjectID, int chapterID, int count,int examID)
{
List<Quiz_FillInTheBlanks> quiz_FillInTheBlankss = new List<Quiz_FillInTheBlanks>();
SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider();
quiz_FillInTheBlankss = sqlQuiz_FillInTheBlanksProvider.GetQuiz_FillInTheBlanksByExamID(courseID, subjectID, chapterID, count,examID);
return quiz_FillInTheBlankss;
}
public static Quiz_FillInTheBlanks GetQuiz_CourseByCourseID(int CourseID)
{
Quiz_FillInTheBlanks quiz_FillInTheBlanks = new Quiz_FillInTheBlanks();
SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider();
quiz_FillInTheBlanks = sqlQuiz_FillInTheBlanksProvider.GetQuiz_FillInTheBlanksByCourseID(CourseID);
return quiz_FillInTheBlanks;
}
public static DataSet GetAllQuiz_FillInTheBlankssWithRelation()
{
DataSet quiz_FillInTheBlankss = new DataSet();
SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider();
quiz_FillInTheBlankss = sqlQuiz_FillInTheBlanksProvider.GetAllQuiz_FillInTheBlankss();
return quiz_FillInTheBlankss;
}
public static DataSet GetDropDownListAllQuiz_FillInTheBlanks()
{
DataSet quiz_FillInTheBlankss = new DataSet();
SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider();
quiz_FillInTheBlankss = sqlQuiz_FillInTheBlanksProvider.GetDropDownLisAllQuiz_FillInTheBlanks();
return quiz_FillInTheBlankss;
}
public List<Quiz_FillInTheBlanks> GetMockTest_FillInTheBlanks(string studentID, int courseID, int subjectID, int chapterID, int count)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand command = new SqlCommand("GetMockTest_FillInTheBlank", 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_FillInTheBlanksProvider fillInTheBanksProvider = new SqlQuiz_FillInTheBlanksProvider();
return fillInTheBanksProvider.GetQuiz_FillInTheBlankssFromReader(reader);
}
}
public static List<Quiz_FillInTheBlanks> GetQuiz_FillInTheBlankListByComprehensionID(int ComprehensionID)
{
SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider();
return sqlQuiz_FillInTheBlanksProvider.GetQuiz_FillInTheBlankListByComprehensionID(ComprehensionID);
}
public static bool DeleteQuiz_FillInTheBlanks(int quiz_FillInTheBlanksID)
{
SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider();
return sqlQuiz_FillInTheBlanksProvider.DeleteQuiz_FillInTheBlanks(quiz_FillInTheBlanksID);
}
public static bool UpdateQuiz_FillInTheBlanks(Quiz_FillInTheBlanks quiz_FillInTheBlanks)
{
SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider();
return sqlQuiz_FillInTheBlanksProvider.UpdateQuiz_FillInTheBlanks(quiz_FillInTheBlanks);
}
public static void LoadQuiz_FillInTheBlanksPageByChapterID(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_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider();
DataSet ds = sqlQuiz_FillInTheBlanksProvider.GetQuiz_FillInTheBlanksPageWiseByChapterID(answerString,chapterID, pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
quiz_FillInTheBlankssPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public static int InsertQuiz_FillInTheBlanks(Quiz_FillInTheBlanks quiz_FillInTheBlanks)
{
SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider();
return sqlQuiz_FillInTheBlanksProvider.InsertQuiz_FillInTheBlanks(quiz_FillInTheBlanks);
}
public static Quiz_FillInTheBlanks GetQuiz_SubjectBySubjectID(int SubjectID)
{
Quiz_FillInTheBlanks quiz_FillInTheBlanks = new Quiz_FillInTheBlanks();
SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider();
quiz_FillInTheBlanks = sqlQuiz_FillInTheBlanksProvider.GetQuiz_FillInTheBlanksBySubjectID(SubjectID);
return quiz_FillInTheBlanks;
}
public static List<Quiz_FillInTheBlanks> GetQuiz_FillInTheBlanksRandomlyTable(int courseID, int subjectID, int chapterID, int count)
{
List<Quiz_FillInTheBlanks> quiz_FillInTheBlankss = new List<Quiz_FillInTheBlanks>();
SqlQuiz_FillInTheBlanksProvider sqlQuiz_FillInTheBlanksProvider = new SqlQuiz_FillInTheBlanksProvider();
quiz_FillInTheBlankss = sqlQuiz_FillInTheBlanksProvider.GetQuiz_FillInTheBlanksRandomlyTable(courseID, subjectID, chapterID, count);
return quiz_FillInTheBlankss;
}
