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();
}
}
}
}
