protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { mvTeacherSubjects.ActiveViewIndex = 0; } using (DatabaseDataContext db = new DatabaseDataContext()) { List <tblSubject> subjects = db.tblSubjects.SortBy("subjectTitle").Where(x => x.isVisible).ToList(); ControlManager.populateControl(subjects, subjectListRepeater); } }
protected void btnEnroll_Click(object sender, EventArgs e) { int hash = sender.GetHashCode(); for (int i = 0; i < subjectsCatalogRepeater.Items.Count; i++) { Button button = (Button)subjectsCatalogRepeater.Items[i].FindControl("btnEnroll"); if (button.GetHashCode() == hash) { Label label = (Label)subjectsCatalogRepeater.Items[i].FindControl("lblSubjectCode"); DropDownList ddl = (DropDownList)subjectsCatalogRepeater.Items[i].FindControl("ddlChangeTeacher"); TextBox textBox = (TextBox)subjectsCatalogRepeater.Items[i].FindControl("txtCurrentTeacher"); using (DatabaseDataContext db = new DatabaseDataContext()) { var teachers = db.tblTeachers.Where(x => x.subjectCode == Convert.ToInt32(label.Text)); ddl.DataTextField = "teacherFullName"; ddl.DataValueField = "teacherID"; textBox.Text = "No current teacher"; ControlManager.populateControl(teachers, ddl); } if (ddl.Items.Count == 0) { ddl.Enabled = false; Button confirmButton = (Button)subjectsCatalogRepeater.Items[i].FindControl("btnEnrollConfirmEnroll"); confirmButton.Enabled = false; } //AsyncPostBackTrigger trigger = new AsyncPostBackTrigger(); //trigger.ControlID = button.UniqueID; //trigger.EventName = "Click"; //upRepeater.Triggers.Add(trigger); MultiView mv = (MultiView)subjectsCatalogRepeater.Items[i].FindControl("mvPanelFooter"); mv.ActiveViewIndex = 4; mv = (MultiView)subjectsCatalogRepeater.Items[i].FindControl("mvPanelBody"); mv.ActiveViewIndex = 1; } } }
protected void subjectsCatalogRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e) { Label label = (Label)e.Item.FindControl("lblSubjectCode"); DropDownList ddl = (DropDownList)e.Item.FindControl("ddlChangeTeacher"); TextBox textBox = (TextBox)e.Item.FindControl("txtCurrentTeacher"); using (DatabaseDataContext db = new DatabaseDataContext()) { tblStudentSubject teacher = db.tblStudentSubjects.Where(x => x.studentID == SessionManager.StudentID && x.subjectCode == Convert.ToInt32(label.Text) && x.isVisible).FirstOrDefault(); tblTeacher currentTeacher; int? teacherID; object teachers; if (teacher == null) { teacherID = null; textBox.Text = "No current teacher"; teachers = db.tblTeachers.Where(x => x.subjectCode == Convert.ToInt32(label.Text)).ToList(); } else { currentTeacher = db.tblTeachers.Where(x => x.teacherID == teacher.teacherID).FirstOrDefault(); textBox.Text = currentTeacher.teacherFullName; teacherID = teacher.teacherID; teachers = db.tblTeachers.Where(x => x.subjectCode == Convert.ToInt32(label.Text) && x.teacherID != teacherID).ToList(); } ddl.DataTextField = "teacherFullName"; ddl.DataValueField = "teacherID"; ControlManager.populateControl(teachers, ddl); if (ddl.Items.Count == 0) { ddl.Enabled = false; Button confirmButton = (Button)e.Item.FindControl("btnChangeConfirmTeacher"); confirmButton.Enabled = false; confirmButton = (Button)e.Item.FindControl("btnEnrollConfirmEnroll"); confirmButton.Enabled = false; } } }
protected void btnViewAssignments_Click(object sender, EventArgs e) { using (DatabaseDataContext db = new DatabaseDataContext()) { Session["panelShow"] = null; List <tblAssignment> assignments = db.tblAssignments.Where(x => x.teacherID == SessionManager.TeacherID && x.isArchived == false).SortBy("assignmentEndDate").ToList(); Session["assignmentList"] = assignments; btnViewAssignments.Visible = false; btnViewArchives.Visible = true; ControlManager.populateControl(assignments, rAssignment); panelSetup(assignments); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] != null) { tblUser user = (tblUser)Session["User"]; using (DatabaseDataContext db = new DatabaseDataContext()) { string userFullName; if (user.userType.ToString().Equals("T")) { userFullName = db.tblTeachers.Where(x => x.userID == user.userID).FirstOrDefault().teacherFullName; } else { userFullName = db.tblStudents.Where(x => x.userID == user.userID).FirstOrDefault().studentFullName; } lblUser.Text = userFullName; } } else { Response.Redirect("Login.aspx"); } using (DatabaseDataContext db = new DatabaseDataContext()) { var list = db.tblNotifications.Where(x => x.userID == SessionManager.UserID).SortBy("notificationID").ToList(); list.Reverse(); ControlManager.populateControl(list, rNotifications); } lNotifications.Text = NotificationManager.unseenNotificationCount(); aNotifications.ServerClick += ANotifications_ServerClick; }
protected void btnNewSubjectAdd_Click(object sender, EventArgs e) { using (DatabaseDataContext db = new DatabaseDataContext()) { if (db.tblSubjects.Where(x => x.subjectCode == Convert.ToInt32(txtSubjectCode.Text)).FirstOrDefault() != null) { lblSubjectCode.Visible = true; return; } } tblSubject subject = new tblSubject { subjectCode = Convert.ToInt32(txtSubjectCode.Text), subjectTitle = txtSubjectTitle.Text, subjectGroup = ddlSubjectGroup.SelectedItem.Text, subjectDescription = txtSubjectDescription.Text, isVisible = true }; using (DatabaseDataContext db = new DatabaseDataContext()) { db.tblSubjects.InsertOnSubmit(subject); db.SubmitChanges(); List <tblSubject> subjects = db.tblSubjects.SortBy("subjectTitle").Where(x => x.isVisible).ToList(); ControlManager.populateControl(subjects, subjectListRepeater); } ControlManager.clearTextBoxes(vForm); lblSubjectCode.Visible = false; mvTeacherSubjects.ActiveViewIndex = 0; pAdd.Visible = true; }
protected void btnNewSubjectEdit_Click(object sender, EventArgs e) { int id = Convert.ToInt32(txtSubjectCode.Text); using (DatabaseDataContext db = new DatabaseDataContext()) { tblSubject subject = db.tblSubjects.Where(x => x.subjectCode == id).FirstOrDefault(); subject.subjectTitle = txtSubjectTitle.Text; subject.subjectGroup = ddlSubjectGroup.SelectedValue; subject.subjectDescription = txtSubjectDescription.Text; db.SubmitChanges(); List <tblSubject> subjects = db.tblSubjects.SortBy("subjectTitle").Where(x => x.isVisible).ToList(); ControlManager.populateControl(subjects, subjectListRepeater); } ControlManager.clearTextBoxes(vForm); mvTeacherSubjects.ActiveViewIndex = 0; pEdit.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { using (DatabaseDataContext db = new DatabaseDataContext()) { var list = db.tblUsers.Join( db.tblStudents, x => x.userID, y => y.userID, (x, y) => new { tblUser = x, tblStudent = y }).Join( db.tblStudentSubjects, y => y.tblStudent.studentID, z => z.studentID, (y, z) => new { tblStudent = y, tblStudentSubject = z }).Where( x => x.tblStudentSubject.teacherID == SessionManager.TeacherID && x.tblStudentSubject.isVisible && x.tblStudentSubject.teacherID != null).Select(s => new { s.tblStudent.tblStudent.studentFullName, s.tblStudent.tblUser.userEmail, s.tblStudentSubject.joiningDate }); ControlManager.populateControl(list, studentListRepeater); } }
// ------------- Buttons on the Panel --------------- // protected void btnChangeTeacher_Click(object sender, EventArgs e) { int hash = sender.GetHashCode(); for (int i = 0; i < subjectsCatalogRepeater.Items.Count; i++) { Button button = (Button)subjectsCatalogRepeater.Items[i].FindControl("btnChangeTeacher"); if (button.GetHashCode() == hash) { Label label = (Label)subjectsCatalogRepeater.Items[i].FindControl("lblSubjectCode"); DropDownList ddl = (DropDownList)subjectsCatalogRepeater.Items[i].FindControl("ddlChangeTeacher"); using (DatabaseDataContext db = new DatabaseDataContext()) { var teachers = db.tblTeachers.Where(x => x.subjectCode == Convert.ToInt32(label.Text)); ddl.DataTextField = "teacherFullName"; ddl.DataValueField = "teacherID"; ControlManager.populateControl(teachers, ddl); Session["ddl"] = Convert.ToInt32(ddl.Items[0].Value); } MultiView mv = (MultiView)subjectsCatalogRepeater.Items[i].FindControl("mvPanelFooter"); mv.ActiveViewIndex = 2; mv = (MultiView)subjectsCatalogRepeater.Items[i].FindControl("mvPanelBody"); mv.ActiveViewIndex = 1; } } }
// -------------- Form View --------------- // protected void btnSubmit_Click(object sender, EventArgs e) { if (DateTime.Parse(dtStartDate.Text).Date <= DateTime.Now.Date) { regStartDate.Visible = true; return; } else { regStartDate.Visible = false; } if (DateTime.Parse(dtStartDate.Text).Date >= DateTime.Parse(dtEndDate.Text).Date) { regEndDate.Visible = true; return; } else { regEndDate.Visible = false; } string extension; var postedFileExtension = Path.GetExtension(fuSupplementaryFiles.FileName); if (!string.Equals(postedFileExtension, ".pdf", StringComparison.OrdinalIgnoreCase) && !string.Equals(postedFileExtension, ".docx", StringComparison.OrdinalIgnoreCase)) { lSupplementaryFiles.Visible = true; return; } else { if (string.Equals(postedFileExtension, ".pdf", StringComparison.OrdinalIgnoreCase)) { extension = ".pdf"; } else { extension = ".docx"; } lSupplementaryFiles.Visible = false; } using (DatabaseDataContext db = new DatabaseDataContext()) { string fileName = fuSupplementaryFiles.HasFile ? (txtAssignmentTitle.Text + SessionManager.TeacherID + extension) : null; tblAssignment assignment = new tblAssignment { assignmentQuestionStatement = txtQuestionStatement.Text, assignmentTitle = txtAssignmentTitle.Text, assignmentStartDate = DateTime.Parse(dtStartDate.Text), assignmentEndDate = DateTime.Parse(dtEndDate.Text), isGraded = false, isArchived = false, assignmentMaximumMarks = Convert.ToInt32(txtMaximumMarks.Text), teacherID = SessionManager.TeacherID, fileName = fileName }; db.tblAssignments.InsertOnSubmit(assignment); if (assignment.fileName != null) { //Saves file to a folder located inside the server string savePath = Server.MapPath("~/Files/SupplementaryFiles"); //Renames the file such that there cannot be any duplicates string saveFileName = fileName; string imgSavePath = Path.Combine(savePath, saveFileName); fuSupplementaryFiles.SaveAs(imgSavePath); } db.SubmitChanges(); //assignment = (tblAssignment)db.GetChangeSet().Inserts.FirstOrDefault(); var assignments = db.tblAssignments.ToList(); int assignmentID = assignments.LastOrDefault().assignmentID; var students = db.tblStudentSubjects.Where(x => x.teacherID == SessionManager.TeacherID && x.isVisible); int userID; foreach (tblStudentSubject student in students) { userID = db.tblStudents.Where(x => x.studentID == student.studentID).FirstOrDefault().userID; tblStudentAssignment studentAssignment = new tblStudentAssignment { studentID = student.studentID, assignmentID = assignmentID, studentAssignmentStatus = false, studentAssignmentMarks = null }; db.tblStudentAssignments.InsertOnSubmit(studentAssignment); db.SubmitChanges(); NotificationManager.assignmentCreateNotification(userID); } var list = db.tblAssignments.Where(x => x.teacherID == SessionManager.TeacherID).SortBy("assignmentEndDate"); assignments = db.tblAssignments.Where(x => x.teacherID == SessionManager.TeacherID && x.isArchived == false).SortBy("assignmentEndDate").ToList(); Session["assignmentList"] = assignments; ControlManager.populateControl(assignments, rAssignment); } ControlManager.clearTextBoxes(vForm); mvTeacherAssignments.ActiveViewIndex = 0; pCreate.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { } using (DatabaseDataContext db = new DatabaseDataContext()) { var list = db.tblStudents.Join( db.tblStudentSubjects, x => x.studentID, y => y.studentID, (x, y) => new { tblStudent = x, tblStudentSubject = y }).Join( db.tblSubjects, y => y.tblStudentSubject.subjectCode, z => z.subjectCode, (y, z) => new { tblStudentSubject = y, tblSubject = z } ).Where(x => x.tblStudentSubject.tblStudentSubject.isVisible && x.tblStudentSubject.tblStudent.studentID == SessionManager.StudentID).Select(s => new { s.tblSubject.subjectCode, s.tblSubject.subjectGroup, s.tblSubject.subjectDescription, s.tblSubject.subjectTitle }); ControlManager.populateControl(list, subjectsCatalogRepeater); tblUser user = (tblUser)Session["User"]; var studentSubjects = db.tblStudentSubjects.Where(x => x.studentID == SessionManager.StudentID).ToList(); for (int i = 0; i < subjectsCatalogRepeater.Items.Count; i++) { Label label = (Label)subjectsCatalogRepeater.Items[i].FindControl("lblSubjectCode"); if (studentSubjects.Where(x => x.subjectCode == Convert.ToInt32(label.Text) && x.isVisible).FirstOrDefault() == null) { MultiView mv = (MultiView)subjectsCatalogRepeater.Items[i].FindControl("mvPanelFooter"); mv.ActiveViewIndex = 1; } else { MultiView mv = (MultiView)subjectsCatalogRepeater.Items[i].FindControl("mvPanelFooter"); Button button = (Button)subjectsCatalogRepeater.Items[i].FindControl("btnChangeTeacher"); if (studentSubjects.Where(x => x.subjectCode == Convert.ToInt32(label.Text) && x.isVisible && x.studentID == SessionManager.StudentID && x.teacherID != null).FirstOrDefault() == null) { button = (Button)subjectsCatalogRepeater.Items[i].FindControl("btnChangeTeacher"); button.Text = "Choose teacher"; button.CssClass += "btn btn-info"; } else { button.CssClass += "btn btn-orange"; } mv.ActiveViewIndex = 0; } MultiView mvBody = (MultiView)subjectsCatalogRepeater.Items[i].FindControl("mvPanelBody"); mvBody.ActiveViewIndex = 0; } } }
protected void btnStudentNext_Click(object sender, EventArgs e) { tblUser user = new tblUser { userEmail = txtRegisterEmail.Text, userPassword = txtRegisterPassword.Text, userType = 'S' }; using (DatabaseDataContext db = new DatabaseDataContext()) { //Check if the field that has been entered already exists if (db.tblUsers.Where(x => x.userEmail.Equals(txtRegisterEmail.Text)).FirstOrDefault() != null) { //Make the label visible and break the onClick() function lblRegisterEmail.Visible = true; return; } lblRegisterEmail.Visible = false; db.tblUsers.InsertOnSubmit(user); db.SubmitChanges(); tblStudent student = new tblStudent { studentFullName = txtRegisterName.Text, userID = db.tblUsers.Where(x => x.userEmail == txtRegisterEmail.Text).FirstOrDefault().userID }; db.tblStudents.InsertOnSubmit(student); db.SubmitChanges(); //Populating the Repeater in the next View //for (int i = 0; i < rRegisterTeachers.Items.Count; i++) //{ // DropDownList ddl = (DropDownList)rRegisterTeachers.Items[i].FindControl("ddlRegisterTeacher"); // Label label = (Label)rRegisterTeachers.Items[i].FindControl("lblSubjectName"); // int subjectCode = Convert.ToInt32(label.Text.Substring(label.Text.Length - 4)); // var teachers = db.tblTeachers.Where(x => x.subjectCode == subjectCode); // ddl.DataTextField = "teacherFullName"; // ddl.DataValueField = "teacherID"; // ControlManager.populateControl(teachers, ddl); // if (teachers.FirstOrDefault() == null) // { // ddl.Items.Insert(0, new ListItem("There are no teachers available for this subject", "0")); // ddl.Enabled = false; // } //} ControlManager.populateControl(getSubjectsQuery(db), rRegisterSubjects); mvRegister.ActiveViewIndex = 2; mvRegisterStudentButton.ActiveViewIndex = 0; } }