protected void Page_Load(object sender, EventArgs e)
{
if (Site1.loggedInLecturer == null) // Redirect to login page if not user is logged in
{
Response.Redirect("LoginWithMasterPage.aspx");
}
if (!IsPostBack)
{
Site1.MainGridView = StudentsGrid.gridView;
// Create the treeview representing the Courses and their Assignments
using (var db = new WebProjectEntities())
{
var courses = db.courses;
foreach (var course in courses)
{
var courseTreeNode = new TreeNode()
{
Text = course.courseName
};
courseTreeNode.SelectAction = TreeNodeSelectAction.None;
var courseAssignments = db.assignments.Where(a => a.courseID == course.courseID);
foreach (var assignment in courseAssignments)
{
var assingmentTreeNode = new TreeNode();
assingmentTreeNode.Text = assignment.assignmentName;
assingmentTreeNode.Value = courseTreeNode.Text + assignment.assignmentName;
//assingmentTreeNode.SelectAction = TreeNodeSelectAction.Select;
courseTreeNode.ChildNodes.Add(assingmentTreeNode);
}
treeView.Nodes.Add(courseTreeNode);
}
}
// Restore the previously selected assignment node if one exists
if (Site1.SelectedTreeNode != null)
{
foreach (TreeNode courseNode in treeView.Nodes)
{
foreach (TreeNode assingmentNode in courseNode.ChildNodes)
{
if (assingmentNode.Value == Site1.SelectedTreeNode.Value)
{
assingmentNode.Select();
this.SelectedNodeChanged(this, EventArgs.Empty);
}
}
}
}
}
else
{
StudentsGrid.gridView.DataSource = (DataTable)ViewState["data"]; // restore the state in case of postback
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string enteredUsername = this.user.Text;
string enteredPassword = this.password.Text;
using (var db = new WebProjectEntities())
{
var lecturers = db.lecturers;
foreach (var lecturer in lecturers)
{
if (lecturer.userName.Equals(enteredUsername) && lecturer.password.Equals(enteredPassword))
{
Site1.loggedInLecturer = lecturer; // Save the logged in lecturer
Response.Redirect(nameof(WebProject.SecondPageWithMasterPage) + ".aspx");
return;
}
}
errorMessage.Visible = true;
this.lblError.Visible = true;
}
}
/// <summary>
/// When an assignment tree node is selected, load the relevant grades to the gridView
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SelectedNodeChanged(object sender, EventArgs e)
{
var selectedNode = treeView.SelectedNode;
using (var db = new WebProjectEntities())
{
int parentEndIndex = selectedNode.ValuePath.IndexOf('/');
var course = db.courses.Where(c => c.courseName == selectedNode.ValuePath.Substring(0, parentEndIndex)).ToList()[0];
var studentsInCourse = db.studentsInCourses.Where(s => s.courseID == course.courseID).ToList();
var assignment = db.assignments.Where(a => a.assignmentName == selectedNode.Text && a.courseID == course.courseID).ToList().First();
var grades = db.grades.Where(g => g.assignmentID == assignment.assignmentID).ToList();
var students = db.students.ToList();
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[4] {
new DataColumn("AssignmentID"), new DataColumn("StudentID"), new DataColumn("StudentName"), new DataColumn("Grade")
});
foreach (var student in studentsInCourse)
{
var row = new GridRow()
{
AssignmentID = assignment.assignmentID,
StudentID = student.studentID ?? 0,
StudentName = students.Where(s => s.studentID == student.studentID).First().studentName,
Grade = grades.Where(g => g.studentID == student.studentID).First().grade1 ?? 0
};
dt.Rows.Add(row.AssignmentID, row.StudentID, row.StudentName, row.Grade);
}
ViewState["data"] = dt; // Retain the state for postbacks
Site1.SelectedTreeNode = selectedNode; // retain the selected node for resoration
StudentsGrid.gridView.DataSource = (DataTable)ViewState["data"];
StudentsGrid.gridView.DataBind();
}
}