protected void btnSubmit_Click(object sender, EventArgs e) { if (RadioButtonList1.SelectedIndex == -1 || RadioButtonList1.SelectedIndex == -1 || RadioButtonList3.SelectedIndex == -1 || RadioButtonList4.SelectedIndex == -1 || RadioButtonList5.SelectedIndex == -1) { ScriptManager.RegisterClientScriptBlock(btnSubmit, this.GetType(), "alertMessage", "alert('Submit unsuccessfully!')", true); } else { int userid = Convert.ToInt32(Session["UserID"]); int Lesson010101 = Convert.ToInt32(RadioButtonList1.SelectedValue); int Lesson010102 = Convert.ToInt32(RadioButtonList2.SelectedValue); int Lesson010103 = Convert.ToInt32(RadioButtonList3.SelectedValue); int Lesson010104 = Convert.ToInt32(RadioButtonList4.SelectedValue); int Lesson010105 = Convert.ToInt32(RadioButtonList5.SelectedValue); lessonbl = new LessonBL(); lessonbl.updateRate(userid, "010101", Lesson010101); lessonbl.updateRate(userid, "010102", Lesson010102); lessonbl.updateRate(userid, "010103", Lesson010103); lessonbl.updateRate(userid, "010104", Lesson010104); lessonbl.updateRate(userid, "010105", Lesson010105); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Submit successfully!')", true); Response.Redirect("Lesson01/index.htm"); } }
/// <summary> /// Retrieve Lesson data by lesson ID. /// </summary> /// <param name="ID"></param> /// <returns></returns> private DataTable GetLesson(int ID) { LessonBL lessonBL = new LessonBL(); DataTable table = lessonBL.GetLesson(LessonID); return(table); }
/// <summary> /// Binds data to the page. /// </summary> /// <param name="topicID"></param> private void BindQuestions() { LessonBL lessonBL = new LessonBL(); DataTable table = lessonBL.GetLesson(LessonID); lblLessonTitle.Text = table.Rows[0].Field <string>("Title"); AnswerBL answerBL = new AnswerBL(); // Check that the number of questions are 5 before binding to labels. if (Questions.Rows.Count == 5) { lblViewQ0.Text = Questions.Rows[0].Field <string>("Question"); ViewState["Q0"] = Questions.Rows[0].Field <int>("TopicID"); // Get the question answer and distractors. chkQuizList0.DataSource = answerBL.GetAnswersByQuestionID(Questions.Rows[0].Field <int>("QuestionID")); chkQuizList0.DataTextField = "Text"; chkQuizList0.DataValueField = "Correct"; chkQuizList0.DataBind(); lblViewQ1.Text = Questions.Rows[1].Field <string>("Question"); ViewState["Q1"] = Questions.Rows[1].Field <int>("TopicID"); chkQuizList1.DataSource = answerBL.GetAnswersByQuestionID(Questions.Rows[1].Field <int>("QuestionID")); chkQuizList1.DataTextField = "Text"; chkQuizList1.DataValueField = "Correct"; chkQuizList1.DataBind(); lblViewQ2.Text = Questions.Rows[2].Field <string>("Question"); ViewState["Q2"] = Questions.Rows[2].Field <int>("TopicID"); chkQuizList2.DataSource = answerBL.GetAnswersByQuestionID(Questions.Rows[2].Field <int>("QuestionID")); chkQuizList2.DataTextField = "Text"; chkQuizList2.DataValueField = "Correct"; chkQuizList2.DataBind(); lblViewQ3.Text = Questions.Rows[3].Field <string>("Question"); ViewState["Q3"] = Questions.Rows[3].Field <int>("TopicID"); chkQuizList3.DataSource = answerBL.GetAnswersByQuestionID(Questions.Rows[3].Field <int>("QuestionID")); chkQuizList3.DataTextField = "Text"; chkQuizList3.DataValueField = "Correct"; chkQuizList3.DataBind(); lblViewQ4.Text = Questions.Rows[4].Field <string>("Question"); ViewState["Q4"] = Questions.Rows[4].Field <int>("TopicID"); chkQuizList4.DataSource = answerBL.GetAnswersByQuestionID(Questions.Rows[4].Field <int>("QuestionID")); chkQuizList4.DataTextField = "Text"; chkQuizList4.DataValueField = "Correct"; chkQuizList4.DataBind(); } }
/// <summary> /// Create side navigation menu. /// </summary> private void BindSideMenu() { // Create an instance of lesson business logic. LessonBL lesson = new LessonBL(); // Get all lessons available in table "Lesson" DataTable lessons = lesson.GetLessons(); // Create an instance of UserLesson business logic. UserLessonBL userLesson = new UserLessonBL(); DataTable userLessonTable = null; // If records are present in table Lesson. if (lessons.Rows.Count > 0) { // Loop through the lessons rows. foreach (DataRow row in lessons.Rows) { // Create a list item. HtmlGenericControl listItem = new HtmlGenericControl("li"); // Create a link Button. LinkButton linkB = new LinkButton(); // Get the lesson ID from the record. int lessonID = Convert.ToInt32(row["ID"]); // Get the record from "User_Lesson" table that contains the user ID and Lesson ID userLessonTable = userLesson.GetRecord(UserID, lessonID); // If the record is blank, means that the lesson is not complete by the user, so put a white very good image. if (userLessonTable.Rows.Count == 0) { linkB.Text = "<img src=http://localhost:3787/image/c1.jpg> " + row[1].ToString(); } // If the record does not contain a complete date it also means that the lesson is not complete. else if (userLessonTable.Rows[0].Field <DateTime?>("DateCompleted") == null) { linkB.Text = "<img src=http://localhost:3787/image/c1.jpg> " + row[1].ToString(); } // If there is the record with a complete date mark the link button with a green very good sign. else { linkB.Text = "<img src=http://localhost:3787/image/c2.jpg> " + row[1].ToString(); } // Add runat server attribute to the link button. linkB.Attributes.Add("runat", "server"); // Pass the lesson ID to the link button. linkB.CommandArgument = lessonID.ToString(); // Add the Redirect event. linkB.Click += new EventHandler(Redirect); // Add the link button to the list item. listItem.Controls.Add(linkB); // Add the list item to the unsorted list. navSideMenu.Controls.Add(listItem); } } }