public static STD_ComprehensionQuestion GetSTD_QuestionByQuestionID(int QuestionID)
 {
     STD_ComprehensionQuestion sTD_ComprehensionQuestion = new STD_ComprehensionQuestion();
     SqlSTD_ComprehensionQuestionProvider sqlSTD_ComprehensionQuestionProvider = new SqlSTD_ComprehensionQuestionProvider();
     sTD_ComprehensionQuestion = sqlSTD_ComprehensionQuestionProvider.GetSTD_ComprehensionQuestionByQuestionID(QuestionID);
     return sTD_ComprehensionQuestion;
 }
 public static DataSet GetDropDownListAllSTD_ComprehensionQuestion()
 {
     DataSet sTD_ComprehensionQuestions = new DataSet();
     SqlSTD_ComprehensionQuestionProvider sqlSTD_ComprehensionQuestionProvider = new SqlSTD_ComprehensionQuestionProvider();
     sTD_ComprehensionQuestions = sqlSTD_ComprehensionQuestionProvider.GetDropDownListAllSTD_ComprehensionQuestion();
     return sTD_ComprehensionQuestions;
 }
 public static void LoadSTD_ComprehensionQuestionPage(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);
     SqlSTD_ComprehensionQuestionProvider sqlSTD_ComprehensionQuestionProvider = new SqlSTD_ComprehensionQuestionProvider();
     DataSet ds =  sqlSTD_ComprehensionQuestionProvider.GetSTD_ComprehensionQuestionPageWise(pageIndex, PageSize, out recordCount);
     gv.DataSource = ds;
     gv.DataBind();
      sTD_ComprehensionQuestionsPaggination(rptPager,recordCount, pageIndex, PageSize);
 }
 public static int InsertSTD_ComprehensionQuestion(STD_ComprehensionQuestion sTD_ComprehensionQuestion)
 {
     SqlSTD_ComprehensionQuestionProvider sqlSTD_ComprehensionQuestionProvider = new SqlSTD_ComprehensionQuestionProvider();
     return sqlSTD_ComprehensionQuestionProvider.InsertSTD_ComprehensionQuestion(sTD_ComprehensionQuestion);
 }
 public static bool DeleteSTD_ComprehensionQuestion(int sTD_ComprehensionQuestionID)
 {
     SqlSTD_ComprehensionQuestionProvider sqlSTD_ComprehensionQuestionProvider = new SqlSTD_ComprehensionQuestionProvider();
     return sqlSTD_ComprehensionQuestionProvider.DeleteSTD_ComprehensionQuestion(sTD_ComprehensionQuestionID);
 }
 public static bool UpdateSTD_ComprehensionQuestion(STD_ComprehensionQuestion sTD_ComprehensionQuestion)
 {
     SqlSTD_ComprehensionQuestionProvider sqlSTD_ComprehensionQuestionProvider = new SqlSTD_ComprehensionQuestionProvider();
     return sqlSTD_ComprehensionQuestionProvider.UpdateSTD_ComprehensionQuestion(sTD_ComprehensionQuestion);
 }