protected void cfmSubmit_Click(object sender, EventArgs e) { //to do validations Course_elearnDAO ceDAO = new Course_elearnDAO(); int courseID = Convert.ToInt32(Request.QueryString["id"]); Course_elearn currentCourse = ceDAO.get_course_by_id(courseID); //change to MM-dd-yyyy string fromDate = fromDateInput.Text.Substring(3, 2) + "/" + fromDateInput.Text.Substring(0, 2) + "/" + fromDateInput.Text.Substring(6, 4); string toDate = toDateInput.Text.Substring(3, 2) + "/" + toDateInput.Text.Substring(0, 2) + "/" + toDateInput.Text.Substring(6, 4); ceDAO.updateCourse(courseID, Convert.ToInt32(moduleType.SelectedValue), nameOfModuleInput.Text, descriptionModuleInput.Text, Convert.ToDouble(hoursInput.Text), DateTime.ParseExact(fromDate, "MM/dd/yyyy", CultureInfo.InvariantCulture), DateTime.ParseExact(toDate, "MM/dd/yyyy", CultureInfo.InvariantCulture)); //update prerequisites //delete all prereq first ceDAO.deletePrerequisitesByCourseID(courseID); //insert all new prereq List <int> prereqIDlist = (List <int>)Session["selectedPrereq"]; foreach (int prereqID in prereqIDlist) { ceDAO.insertPrerequisite(courseID, prereqID); } //set audit User currentUser = (User)Session["currentUser"]; setAudit(currentUser, "course", "update", courseID.ToString(), "course name: " + currentCourse.getCourseName()); Response.Redirect($"viewModuleInfo.aspx?id={courseID}"); }
protected void Page_Load(object sender, EventArgs e) { //Response.Write(DateTime.Now.ToShortDateString()); Course_elearnDAO cdao = new Course_elearnDAO(); string id_str = null; if (Request.QueryString["id"] != null) { id_str = Request.QueryString["id"]; int id_num = int.Parse(id_str); current = cdao.get_course_by_id(id_num); TestimonialDAO t = new TestimonialDAO(); testimonials = t.get_testimonials_by_course(current); } else { return; } if (!IsPostBack) { int id_num = int.Parse(id_str); current = cdao.get_course_by_id(id_num); lblCourseNameHeader.Text = current.getCourseName(); lblBreadcrumbCourseName.Text = current.getCourseName(); lblCourseName.Text = current.getCourseName(); lblCourseDescription.Text = current.getDescription(); hoursOutput.Text = current.getHoursAwarded().ToString(); if (!current.getTargetAudience().Equals("")) { lblTargetAudience.Text = current.getTargetAudience(); } else { lblTargetAudience.Text = "-"; } lblCoursePeriodStart.Text = "Start: " + current.getStartDate().ToLongDateString(); lblCoursePeriodEnd.Text = "End: " + current.getExpiryDate().ToLongDateString(); DateTime currentDateTime = DateTime.Now; if (current.getStatus().Equals("Inactive") || !(DateTime.Compare(current.getStartDate(), currentDateTime) < 0 && DateTime.Compare(current.getExpiryDate(), currentDateTime) > 0)) { panelInactive.Visible = true; } Page.Form.Attributes.Add("enctype", "multipart/form-data"); } }
protected void Page_Load(object sender, EventArgs e) { User currentUser = (User)Session["currentUser"]; if (currentUser == null) { Response.Redirect("Login.aspx"); } else { Boolean superuser = false; Boolean course_creator = false; foreach (string s in currentUser.getRoles()) { if (s.Equals("superuser")) { superuser = true; } else if (s.Equals("course creator")) { course_creator = true; } } if (superuser || course_creator) { if (!IsPostBack) { Course_elearnDAO cdao = new Course_elearnDAO(); String id_str = Request.QueryString["id"]; int id_num = int.Parse(id_str); lblBreadcrumbCourseName.Text = cdao.get_course_by_id(id_num).getCourseName(); List <QuizQuestion> allQuestions = new List <QuizQuestion>(); Session["allQuestions"] = allQuestions; Session["questionNumber"] = 1; lblQuestionNumber.Text = "Question " + 1; lblAddedMsg.Visible = false; } else { int counter = (int)Session["questionNumber"]; lblQuestionNumber.Text = "Question " + counter; lblAddedMsg.Visible = false; } } else { Response.Redirect("errorPage.aspx"); } /* * if (Page.IsPostBack) * { * // reshow * ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal();", true); * }*/ } }
protected void gvPrereq_RowCommand(object sender, GridViewCommandEventArgs e) { List <int> prereqIDlist = (List <int>)Session["selectedPrereq"]; int id = Convert.ToInt32(e.CommandArgument); //to get course and add any prereq related to the course Course_elearnDAO ceDAO = new Course_elearnDAO(); Course_elearn selectedCourse = ceDAO.get_course_by_id(id); ArrayList allPrereq = getAllPrerequisites(id); ArrayList allPrereqNoDup = new ArrayList(); foreach (int prereqID in allPrereq) { if (!allPrereqNoDup.Contains(prereqID) && !prereqIDlist.Contains(prereqID)) { allPrereqNoDup.Add(prereqID); } } foreach (int prereqID in allPrereqNoDup) { prereqIDlist.Add(prereqID); } prereqIDlist.Add(id); Session["selectedPrereq"] = prereqIDlist; var itemIDs = string.Join(",", ((IList <int>)Session["selectedPrereq"]).ToArray()); var sqlQueryCourseList = ""; if (itemIDs.Length > 0) { sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.courseType='Online Learning'", itemIDs); } else { sqlQueryCourseList = "SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.courseType='Online Learning'"; } SqlDataSource1.SelectCommand = sqlQueryCourseList; gvPrereq.DataSource = SqlDataSource1; gvPrereq.DataBind(); gvPrereq.UseAccessibleHeader = true; if (gvPrereq.Rows.Count > 0) { gvPrereq.HeaderRow.TableSection = TableRowSection.TableHeader; } var sqlQuery = String.Format("SELECT * FROM [Elearn_course] WHERE [elearn_courseID] IN ({0})", itemIDs); SqlDataSourcePrereqCart.SelectCommand = sqlQuery; gvPrereqCart.DataSource = SqlDataSourcePrereqCart; gvPrereqCart.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { //Response.Write(DateTime.Now.ToShortDateString()); Course_elearnDAO cdao = new Course_elearnDAO(); string id_str = null; if (Request.QueryString["id"] != null) { id_str = Request.QueryString["id"]; int id_num = int.Parse(id_str); current = cdao.get_course_by_id(id_num); TestimonialDAO t = new TestimonialDAO(); testimonials = t.get_testimonials_by_course(current); } else { return; } if (!IsPostBack) { int id_num = int.Parse(id_str); current = cdao.get_course_by_id(id_num); lblCourseNameHeader.Text = current.getCourseName(); lblBreadcrumbCourseName.Text = current.getCourseName(); lblCourseName.Text = current.getCourseName(); lblCourseDescription.Text = current.getDescription(); hoursOutput.Text = current.getHoursAwarded().ToString(); if (!current.getTargetAudience().Equals("")) { lblTargetAudience.Text = current.getTargetAudience(); } else { lblTargetAudience.Text = "-"; } lblCoursePeriodStart.Text = "Start: " + current.getStartDate().ToLongDateString(); lblCoursePeriodEnd.Text = "End: " + current.getExpiryDate().ToLongDateString(); } }
protected void cfmActivate_Click(object sender, EventArgs e) { Course_elearnDAO ceDAO = new Course_elearnDAO(); Course_elearn currentCourse = ceDAO.get_course_by_id(Convert.ToInt32(Request.QueryString["id"])); ceDAO.activateCourse(Convert.ToInt32(Request.QueryString["id"])); int cat = currentCourse.getCategoryID(); //set audit User currentUser = (User)Session["currentUser"]; setAudit(currentUser, "course", "activate", currentCourse.getCourseID().ToString(), "course name: " + currentCourse.getCourseName()); Response.Redirect($"viewAllModule.aspx"); }
protected void Page_Load(object sender, EventArgs e) { User currentUser = (User)Session["currentUser"]; if (currentUser == null) { Response.Redirect("Login.aspx"); } else { Boolean superuser = false; Boolean course_creator = false; foreach (string s in currentUser.getRoles()) { if (s.Equals("superuser")) { superuser = true; } else if (s.Equals("course creator")) { course_creator = true; } } if (superuser || course_creator) { if (!IsPostBack) { Course_elearnDAO cdao = new Course_elearnDAO(); string id_str = Request.QueryString["id"]; int id_num = int.Parse(id_str); lblBreadcrumbCourseName.Text = cdao.get_course_by_id(id_num).getCourseName(); } } else { Response.Redirect("errorPage.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { User currentUser = (User)Session["currentUser"]; if (currentUser == null) { Response.Redirect("Login.aspx"); } else { Boolean superuser = false; Boolean course_creator = false; foreach (string s in currentUser.getRoles()) { if (s.Equals("superuser")) { superuser = true; } else if (s.Equals("course creator")) { course_creator = true; } } if (!superuser || !course_creator) { Response.Redirect("errorPage.aspx"); } if (!IsPostBack) { QuizDAO quizDAO = new QuizDAO(); Course_elearnDAO cdao = new Course_elearnDAO(); int quizID = Convert.ToInt32(Request.QueryString["id"]); Quiz currentQuiz = quizDAO.getQuizByID(quizID); int courseID = currentQuiz.getMainCourse().getCourseID(); lblBreadcrumbCourseName.Text = cdao.get_course_by_id(courseID).getCourseName(); } } }
protected void Page_Load(object sender, EventArgs e) { User currentUser = (User)Session["currentUser"]; if (currentUser == null) { Response.Redirect("Login.aspx"); } else { Boolean superuser = false; Boolean course_creator = false; foreach (string s in currentUser.getRoles()) { if (s.Equals("superuser")) { superuser = true; } else if (s.Equals("course creator")) { course_creator = true; } } if (superuser || course_creator) { if (!IsPostBack) { Course_elearnDAO cdao = new Course_elearnDAO(); string id_str = Request.QueryString["id"]; int id_num = int.Parse(id_str); lblBreadcrumbCourseName.Text = cdao.get_course_by_id(id_num).getCourseName(); List <int> prereqIDlist = new List <int>(); List <string> part1 = new List <string>(); Session["createQuiz1"] = part1; Session["selectedPrereq"] = prereqIDlist; var itemIDs = string.Join(",", ((IList <int>)Session["selectedPrereq"]).ToArray()); //to load course list var sqlQueryCourseList = ""; if (itemIDs.Length > 0) { sqlQueryCourseList = String.Format("SELECT * FROM [Quiz] WHERE status='active' and elearn_courseID='{0}' and quizID NOT IN ({1})", id_str, itemIDs); } else { sqlQueryCourseList = "SELECT * FROM [Quiz] WHERE status='active' and elearn_courseID = '" + id_str + "'"; } SqlDataSource1.SelectCommand = sqlQueryCourseList; gvPrereq.DataSource = SqlDataSource1; gvPrereq.DataBind(); gvPrereq.UseAccessibleHeader = true; if (gvPrereq.Rows.Count > 0) { gvPrereq.HeaderRow.TableSection = TableRowSection.TableHeader; } //to load prereq cart var sqlQuery = ""; if (itemIDs.Length > 0) { sqlQuery = String.Format("SELECT * FROM [Quiz] WHERE [quizID] IN ({0})", itemIDs); } else { sqlQuery = "SELECT * FROM [Quiz] WHERE [quizID] = -1"; } SqlDataSourcePrereqCart.SelectCommand = sqlQuery; gvPrereqCart.DataSource = SqlDataSourcePrereqCart; gvPrereqCart.DataBind(); } } else { Response.Redirect("errorPage.aspx"); } } }
protected void btnConfirmSubmit_Click(object sender, EventArgs e) { //to do validation Page.Validate("ValidateFormTwo"); if (!Page.IsValid) { } else { //add the last question List <QuizQuestion> allQuestions = (List <QuizQuestion>)Session["allQuestions"]; QuizQuestion newQuestion = new QuizQuestion(); newQuestion.setQuestion(txtQuizQuestion.Text); QuizAnswer answer1 = new QuizAnswer(); answer1.setAnswer(txtOptionOne.Text); QuizAnswer answer2 = new QuizAnswer(); answer2.setAnswer(txtOptionTwo.Text); QuizAnswer answer3 = new QuizAnswer(); answer3.setAnswer(txtOptionThree.Text); QuizAnswer answer4 = new QuizAnswer(); answer4.setAnswer(txtOptionFour.Text); List <QuizAnswer> allAnswersForLastQn = new List <QuizAnswer>(); allAnswersForLastQn.Add(answer1); allAnswersForLastQn.Add(answer2); allAnswersForLastQn.Add(answer3); allAnswersForLastQn.Add(answer4); newQuestion.setAllAnswers(allAnswersForLastQn); if (ddlCorrectAns.SelectedValue.Equals("1")) { newQuestion.setQuizAnswer(answer1); } else if (ddlCorrectAns.SelectedValue.Equals("2")) { newQuestion.setQuizAnswer(answer2); } else if (ddlCorrectAns.SelectedValue.Equals("3")) { newQuestion.setQuizAnswer(answer3); } else { newQuestion.setQuizAnswer(answer4); } allQuestions.Add(newQuestion); QuizDAO quizDAO = new QuizDAO(); QuizAnswerDAO qaDAO = new QuizAnswerDAO(); QuizQuestionDAO qqDAO = new QuizQuestionDAO(); Course_elearnDAO ceDAO = new Course_elearnDAO(); Course_elearn currentCourse = ceDAO.get_course_by_id(Convert.ToInt32(Request.QueryString["id"])); //create quiz List <string> part1 = (List <string>)Session["createQuiz1"]; Quiz newQuiz = new Quiz(); newQuiz.setTitle(part1[0]); newQuiz.setDescription(part1[1]); newQuiz.setMainCourse(currentCourse); newQuiz.setPassingGrade(Convert.ToInt32(txtNumCorrectAns.Text)); newQuiz.setStatus("active"); if (ddlRandomize.SelectedValue.Equals("y")) { newQuiz.setRandomOrder("y"); } else { newQuiz.setRandomOrder("n"); } newQuiz.setTimeLimit(Convert.ToInt32(txtTimeLimit.Text)); if (rdlAttempt.SelectedValue.Equals("unlimited")) { newQuiz.setMultipleAttempts("y"); newQuiz.setNumberOfAttempts(0); } else { newQuiz.setMultipleAttempts("n"); newQuiz.setNumberOfAttempts(Convert.ToInt32(txtNoOfAttempt.Text)); } newQuiz.setDisplayAnswer(ddlDisplayAnswer.SelectedValue); int quizID = quizDAO.createQuiz(newQuiz); //add prerequisites List <int> prereqIDlist = (List <int>)Session["selectedPrereq"]; foreach (int prereqID in prereqIDlist) { quizDAO.insertPrerequisite(quizID, prereqID); } //create question and answer foreach (QuizQuestion question in allQuestions) { question.setQuiz(quizDAO.getQuizByID(quizID)); int questionID = qqDAO.createQuizQuestion(question); QuizQuestion currentQuestion = qqDAO.getQuizQuestionByID(questionID); List <QuizAnswer> allAnswers = question.getAllAnswers(); foreach (QuizAnswer answer in allAnswers) { answer.setQuizQuestion(currentQuestion); int answerID = qaDAO.createQuizAnswer(answer); if (question.getQuizAnswer().getAnswer().Equals(answer.getAnswer())) { qqDAO.updateCorrectAnswerID(questionID, answerID); } } } //set audit User currentUser = (User)Session["currentUser"]; setAudit(currentUser, "quiz", "create", quizID.ToString(), "quiz title: " + newQuiz.getTitle()); Response.Redirect($"quizSummary.aspx?id={quizID}"); } }
protected void gvPrereqCart_RowCommand(object sender, GridViewCommandEventArgs e) { List <int> prereqIDlist = (List <int>)Session["selectedPrereq"]; int id = Convert.ToInt32(e.CommandArgument); Course_elearnDAO ceDAO = new Course_elearnDAO(); Course_elearn currentCourse = ceDAO.get_course_by_id(Convert.ToInt32(Request.QueryString["id"])); List <int> allLinkedCourses = ceDAO.getAllCourseLinkedToPrerequisite(id); foreach (int linkedID in allLinkedCourses) { if (prereqIDlist.Contains(linkedID)) { prereqIDlist.Remove(linkedID); } } prereqIDlist.Remove(id); Session["selectedPrereq"] = prereqIDlist; var itemIDs = string.Join(",", ((IList <int>)Session["selectedPrereq"]).ToArray()); var itemIDs2 = string.Join(",", ((IList <int>)Session["selectedPostreq"]).ToArray()); var sqlQueryCourseList = ""; if (itemIDs.Length > 0 && itemIDs2.Length > 0) { sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.elearn_courseID NOT IN ({1}) and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID(), itemIDs, itemIDs2); } else if (itemIDs.Length > 0 && itemIDs2.Length < 1) { sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID(), itemIDs); } else if (itemIDs.Length < 1 && itemIDs2.Length > 0) { sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID(), itemIDs2); } else { sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID()); } SqlDataSource1.SelectCommand = sqlQueryCourseList; gvPrereq.DataSource = SqlDataSource1; gvPrereq.DataBind(); gvPrereq.UseAccessibleHeader = true; if (gvPrereq.Rows.Count > 0) { gvPrereq.HeaderRow.TableSection = TableRowSection.TableHeader; } var sqlQuery = ""; if (itemIDs.Length > 0) { sqlQuery = String.Format("SELECT * FROM [Elearn_course] WHERE [elearn_courseID] IN ({0}) and elearn_courseID != " + currentCourse.getCourseID(), itemIDs); } else { sqlQuery = "SELECT * FROM [Elearn_course] WHERE [elearn_courseID] = -1"; } SqlDataSourcePrereqCart.SelectCommand = sqlQuery; gvPrereqCart.DataSource = SqlDataSourcePrereqCart; gvPrereqCart.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["currentUser"] == null) { Response.Redirect("Login.aspx"); } else { User currentUser = (User)Session["currentUser"]; Course_elearnDAO ceDAO = new Course_elearnDAO(); Course_elearn currentCourse = ceDAO.get_course_by_id(Convert.ToInt32(Request.QueryString["id"])); Boolean superuser = false; Boolean course_creator = false; foreach (string s in currentUser.getRoles()) { if (s.Equals("superuser")) { superuser = true; } else if (s.Equals("course creator")) { course_creator = true; } } if (currentUser.getUserID() != currentCourse.getCourseCreator().getUserID() && !(superuser || course_creator)) { Response.Redirect("errorPage.aspx"); } else { if (!IsPostBack) { moduleType.SelectedValue = currentCourse.getCategoryID().ToString(); ddlCourseType.SelectedValue = currentCourse.getCourseType(); nameOfModuleInput.Text = currentCourse.getCourseName(); lblBreadcrumbCourseName.Text = currentCourse.getCourseName(); descriptionModuleInput.Text = currentCourse.getDescription(); hoursInput.Text = currentCourse.getHoursAwarded().ToString(); if (currentCourse.getTargetAudience() != null) { txtTargetAudience.Text = currentCourse.getTargetAudience().ToString(); } fromDateInput.Text = currentCourse.getStartDate().ToString("dd/MM/yyyy"); toDateInput.Text = currentCourse.getExpiryDate().ToString("dd/MM/yyyy"); //prerequisites ArrayList allPrerequisites = currentCourse.getPrerequisite(); List <int> prereqIDlist = new List <int>(); foreach (Course_elearn prereq in allPrerequisites) { prereqIDlist.Add(prereq.getCourseID()); } Session["selectedPrereq"] = prereqIDlist; var itemIDs = string.Join(",", ((IList <int>)Session["selectedPrereq"]).ToArray()); //postrequisites List <int> postReqIDList = getAllPostRequisiteCourses(currentCourse.getCourseID()); List <int> postReqIDListNoDup = new List <int>(); foreach (int postreqID in postReqIDList) { if (!postReqIDListNoDup.Contains(postreqID) && postReqIDList.Contains(postreqID)) { postReqIDListNoDup.Add(postreqID); } } Session["selectedPostreq"] = postReqIDListNoDup; var itemIDs2 = string.Join(",", ((IList <int>)Session["selectedPostreq"]).ToArray()); //to load course list var sqlQueryCourseList = ""; if (itemIDs.Length > 0 && itemIDs2.Length > 0) { sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.elearn_courseID NOT IN ({1}) and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID(), itemIDs, itemIDs2); } else if (itemIDs.Length > 0 && itemIDs2.Length < 1) { sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID(), itemIDs); } else if (itemIDs.Length < 1 && itemIDs2.Length > 0) { sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID(), itemIDs2); } else { sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID()); } SqlDataSource1.SelectCommand = sqlQueryCourseList; gvPrereq.DataSource = SqlDataSource1; gvPrereq.DataBind(); gvPrereq.UseAccessibleHeader = true; if (gvPrereq.Rows.Count > 0) { gvPrereq.HeaderRow.TableSection = TableRowSection.TableHeader; } //to load prereq cart var sqlQuery = ""; if (itemIDs.Length > 0) { sqlQuery = String.Format("SELECT * FROM [Elearn_course] WHERE [elearn_courseID] IN ({0}) and elearn_courseID != " + currentCourse.getCourseID(), itemIDs); } else { sqlQuery = "SELECT * FROM [Elearn_course] WHERE [elearn_courseID] = -1"; } SqlDataSourcePrereqCart.SelectCommand = sqlQuery; gvPrereqCart.DataSource = SqlDataSourcePrereqCart; gvPrereqCart.DataBind(); Session["currentMod"] = nameOfModuleInput.Text; } } } }