protected void btnDetails_Click(object sender, EventArgs e) { mvSessionHistory.ActiveViewIndex = 1; int hash = sender.GetHashCode(); foreach (RepeaterItem item in rSessionHistories.Items) { LinkButton button = item.FindControl("btnDetails") as LinkButton; if (button.GetHashCode() == hash) { TableCell tc = item.FindControl("tcSessionID") as TableCell; int SessionID = Convert.ToInt32(tc.Text); using (DatabaseDataContext db = new DatabaseDataContext()) { tblSession session = db.tblSessions.Where(x => x.SessionID == SessionID).FirstOrDefault(); tblUser user = db.tblUsers.Where(x => x.UserID == session.UserID).FirstOrDefault(); lblSessionID.Text = session.SessionID.ToString(); lblUserID.Text = user.UserID.ToString(); lblSessionStart.Text = session.SessionBegin.ToString(); lblSessionLatitude.Text = session.SessionLatitude.ToString(); lblSessionLongitude.Text = session.SessionLongitude.ToString(); // SessionEnd can be empty because it has ALLOW NULL property in database. try { lblSessionEnd.Text = session.SessionEnd.ToString(); } catch (NullReferenceException) { lblSessionEnd.Text = "-"; } } } } }
protected void btnReject_Click(object sender, EventArgs e) { int hash = sender.GetHashCode(); foreach (RepeaterItem item in rRequests.Items) { LinkButton button = item.FindControl("btnReject") as LinkButton; if (button.GetHashCode() == hash) { Label label = item.FindControl("lblUserID") as Label; long UserID = Convert.ToInt64(label.Text); using (DatabaseDataContext db = new DatabaseDataContext()) { tblUser user = db.tblUsers.Where(x => x.UserID == UserID).FirstOrDefault(); user.IsVisible = false; db.SubmitChanges(); List <tblUser> users = db.tblUsers.Where(x => x.IsVisible && x.IsVerified == false).ToList(); //Populates the Panels ControlManager.populateControl(users, rRequests); users.Reverse(); } } break; } }
protected void btnDownloadFiles_Click(object sender, EventArgs e) { int hash = sender.GetHashCode(); foreach (RepeaterItem item in rAssignment.Items) { LinkButton button = item.FindControl("btnDownloadFiles") as LinkButton; if (button.GetHashCode() == hash) { using (DatabaseDataContext db = new DatabaseDataContext()) { string path = "Files/SupplementaryFiles/"; Label label = item.FindControl("lblAssignmentID") as Label; int assignmentID = Convert.ToInt32(label.Text); string fileName = db.tblAssignments.Where(x => x.assignmentID == assignmentID).FirstOrDefault().fileName; Response.Redirect(path + fileName); break; } } } }
protected void btnDetails_Click(object sender, EventArgs e) { mvEmergencies.ActiveViewIndex = 1; int hash = sender.GetHashCode(); foreach (RepeaterItem item in rEmergencies.Items) { LinkButton button = item.FindControl("btnDetails") as LinkButton; if (button.GetHashCode() == hash) { TableCell tc = item.FindControl("tcEmergencyID") as TableCell; int EmergencyID = Convert.ToInt32(tc.Text); using (DatabaseDataContext db = new DatabaseDataContext()) { tblEmergency emergency = db.tblEmergencies.Where(x => x.EmergencyID == EmergencyID).FirstOrDefault(); tblUser user = db.tblUsers.Where(x => x.UserID == emergency.UserID).FirstOrDefault(); lblEmergencyID.Text = emergency.EmergencyID.ToString(); lblUserID.Text = user.UserID.ToString(); lblTitle.Text = emergency.EmergencyTitle.ToString(); ddlStatus.SelectedValue = emergency.EmergencyStatus; emergency.IsSeen = true; db.SubmitChanges(); } } } }
protected void btnDetails_Click(object sender, EventArgs e) { mvFeedback.ActiveViewIndex = 1; int hash = sender.GetHashCode(); foreach (RepeaterItem item in rFeedback.Items) { LinkButton button = item.FindControl("btnDetails") as LinkButton; if (button.GetHashCode() == hash) { TableCell tc = item.FindControl("tcFeedbackID") as TableCell; int feedbackID = Convert.ToInt32(tc.Text); using (DatabaseDataContext db = new DatabaseDataContext()) { tblFeedback feedback = db.tblFeedbacks.Where(x => x.FeedbackID == feedbackID).FirstOrDefault(); tblUser user = db.tblUsers.Where(x => x.UserID == feedback.UserID).FirstOrDefault(); lblFeedbackID.Text = feedback.FeedbackID.ToString(); lblUserID.Text = user.UserID.ToString(); lblFeedbackDate.Text = feedback.FeedbackDate.ToString(); txtFeedbackDescription.Text = feedback.FeedbackDescription.ToString(); feedback.IsSeen = true; db.SubmitChanges(); } } } }
protected void btnSubjectDelete_Click(object sender, EventArgs e) { int hashCode = sender.GetHashCode(); for (int i = 0; i < subjectListRepeater.Items.Count; i++) { LinkButton button = (LinkButton)subjectListRepeater.Items[i].FindControl("btnSubjectDelete"); if (button.GetHashCode() == hashCode) { RepeaterItem items = subjectListRepeater.Items[i]; // Fetches the items in the row TableCell tc = (TableCell)items.FindControl("tcSubjectCode"); // Finds the item corresponding with the ID int id = Convert.ToInt32(tc.Text); // Gets the content of the TableCell using (DatabaseDataContext db = new DatabaseDataContext()) { tblSubject subject = db.tblSubjects.Where(x => x.subjectCode == id).FirstOrDefault(); subject.isVisible = false; db.SubmitChanges(); List <tblSubject> subjects = db.tblSubjects.SortBy("subjectTitle").Where(x => x.isVisible).ToList(); pDelete.Visible = true; pEdit.Visible = false; ControlManager.populateControl(subjects, subjectListRepeater); } break; } } }
protected void btnSubjectEdit_Click(object sender, EventArgs e) { ///TODO: Make a function out of this int hashCode = sender.GetHashCode(); for (int i = 0; i < subjectListRepeater.Items.Count; i++) { LinkButton button = (LinkButton)subjectListRepeater.Items[i].FindControl("btnSubjectEdit"); if (button.GetHashCode() == hashCode) { RepeaterItem items = subjectListRepeater.Items[i]; // Fetches the items in the row TableCell tc = (TableCell)items.FindControl("tcSubjectCode"); // Finds the item corresponding with the ID int id = Convert.ToInt32(tc.Text); // Gets the content of the TableCell using (DatabaseDataContext db = new DatabaseDataContext()) { tblSubject subject = db.tblSubjects.Where(x => x.subjectCode == id).FirstOrDefault(); txtSubjectCode.Text = Server.HtmlEncode(subject.subjectCode.ToString()); ddlSubjectGroup.SelectedValue = Server.HtmlEncode(subject.subjectGroup); txtSubjectTitle.Text = Server.HtmlEncode(subject.subjectTitle); txtSubjectDescription.Text = Server.HtmlEncode(subject.subjectDescription); txtSubjectCode.Enabled = false; mvTeacherSubjects.ActiveViewIndex = 1; mvForm.ActiveViewIndex = 1; } break; } } }
protected void btnStudentRemove_Click(object sender, EventArgs e) { int hash = sender.GetHashCode(); for (int i = 0; i < studentListRepeater.Items.Count; i++) { LinkButton button = (LinkButton)studentListRepeater.Items[i].FindControl("btnStudentRemove"); if (button.GetHashCode() == hash) { TableCell tc = (TableCell)studentListRepeater.Items[i].FindControl("tcUserEmail"); string userEmail = tc.Text; using (DatabaseDataContext db = new DatabaseDataContext()) { int userID = db.tblUsers.Where(x => x.userEmail.Equals(userEmail)).FirstOrDefault().userID; int studentID = db.tblUsers.Join( db.tblStudents, x => x.userID, y => y.userID, (x, y) => new { tblUser = x, tblStudent = y }).Where( x => x.tblUser.userID == userID).FirstOrDefault().tblStudent.studentID; tblStudentSubject studentSubject = db.tblStudentSubjects.Where(x => x.studentID == studentID && x.teacherID == SessionManager.TeacherID).FirstOrDefault(); studentSubject.teacherID = null; studentSubject.isVisible = false; db.SubmitChanges(); 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 }).SortBy("joiningDate"); list.Reverse(); ControlManager.populateControl(list, studentListRepeater); NotificationManager.removeStudentNotification(userID); } break; } } }
protected void btnDetails_Click(object sender, EventArgs e) { mvComplaints.ActiveViewIndex = 1; int hash = sender.GetHashCode(); foreach (RepeaterItem item in rComplaints.Items) { LinkButton button = item.FindControl("btnDetails") as LinkButton; if (button.GetHashCode() == hash) { TableCell tc = item.FindControl("tcComplaintID") as TableCell; int ComplaintID = Convert.ToInt32(tc.Text); using (DatabaseDataContext db = new DatabaseDataContext()) { tblComplaint complaint = db.tblComplaints.Where(x => x.ComplaintID == ComplaintID).FirstOrDefault(); tblCategory category = db.tblCategories.Where(x => x.CategoryID == complaint.CategoryID).FirstOrDefault(); tblUser user = db.tblUsers.Where(x => x.UserID == complaint.UserID).FirstOrDefault(); lblComplaintID.Text = complaint.ComplaintID.ToString(); lblUserID.Text = user.UserID.ToString(); lblComplaintTitle.Text = complaint.ComplaintTitle; lblUserName.Text = user.UserFName + " " + user.UserLName; lblComplaintCategory.Text = category.CategoryName; lblUserAddress.Text = user.UserAddress; txtComplaintDescription.Text = complaint.ComplaintDescription; lblUserContact.Text = user.UserContact + "<br />" + user.UserEmail; ddlStatus.SelectedValue = complaint.ComplaintStatus; complaint.IsSeen = true; db.SubmitChanges(); } } } }