protected void Page_Load(object sender, EventArgs e)
{
((HtmlControl)Master.FindControl("Cor")).Attributes.Add("class", "active");
((HtmlControl)Master.FindControl("CorS")).Attributes.Add("class", "active");
((Literal)Master.FindControl("pagetitle")).Text = " - Staff Details";
RecordsDataControl.BindViewData(StudentRecordsDAL.Query("SELECT * FROM Staff"));
RecordsDataControl.BindEditData(StudentRecordsDAL.Query("SELECT * FROM Staff"));
RecordsDataControl.SetTableName("Staff");
RecordsDataControl.SetDisplayMetadata(displayTypes);
RecordsDataControl.SetEditMetadata(validationTypes);
RecordsDataControl.SetFunction(updateDB);
RecordsDataControl.BuildControl();
}
protected void Page_Load(object sender, EventArgs e)
{
((HtmlControl)Master.FindControl("Cor")).Attributes.Add("class", "active");
((HtmlControl)Master.FindControl("CorU")).Attributes.Add("class", "active");
((Literal)Master.FindControl("pagetitle")).Text = " - Unit Details";
RecordsDataControl.BindViewData(StudentRecordsDAL.Query("SELECT * FROM Unit_Coord"));
RecordsDataControl.BindEditData(StudentRecordsDAL.Query("SELECT * FROM Unit"));
RecordsDataControl.SetTableName("Unit");
RecordsDataControl.SetDisplayMetadata(displayTypes);
RecordsDataControl.SetEditMetadata(validationTypes);
RecordsDataControl.SetFunction(updateDB);
RecordsDataControl.AddValidationMethod("Unit_ID", setID);
RecordsDataControl.AddValidationMethod("Unit_Code", unitCodeUnique);
RecordsDataControl.BuildControl();
}
protected void Page_Load(object sender, EventArgs e)
{
((HtmlControl)Master.FindControl("Stu")).Attributes.Add("class", "active");
((HtmlControl)Master.FindControl("StuR")).Attributes.Add("class", "active");
((Literal)Master.FindControl("pagetitle")).Text = " - Student Results";
RecordsDataControl.BindViewData(StudentRecordsDAL.Query("SELECT * FROM Course_Attempt_Details"));
RecordsDataControl.BindEditData(StudentRecordsDAL.Query("SELECT * FROM Course_Attempt"));
RecordsDataControl.SetTableName("Course_Attempt");
RecordsDataControl.SetDisplayMetadata(displayTypes);
RecordsDataControl.SetEditMetadata(validationTypes);
RecordsDataControl.AddValidationMethod("Attempt_ID", setAttemptID);
RecordsDataControl.AddValidationMethod("Student_ID", setStudentID);
RecordsDataControl.AddValidationMethod("Course_ID", checkEnrolment);
RecordsDataControl.SetFunction(updateDB);
RecordsDataControl.BuildControl();
}
protected void Page_Load(object sender, EventArgs e)
{
((HtmlControl)Master.FindControl("Stu")).Attributes.Add("class", "active");
((HtmlControl)Master.FindControl("StuU")).Attributes.Add("class", "active");
((Literal)Master.FindControl("pagetitle")).Text = " - Unit Attempts";
Dictionary <string, string> students = new Dictionary <string, string>();
students.Add("0", "All Students");
foreach (Dictionary <string, object> studentsData in StudentRecordsDAL.Query("SELECT * FROM Student"))
{
students.Add(studentsData["Student_ID"].ToString(), studentsData["Student_Number"].ToString() + " - " + studentsData["Student_Name"]);
}
filterBox.ID = "filterdrop_";
filterBox.DataSource = students;
filterBox.DataValueField = "Key";
filterBox.DataTextField = "Value";
filterBox.DataBind();
if (IsPostBack)
{
foreach (string key in Request.Form)
{
if (key.EndsWith("addButton") || Regex.Match(key, "edit([0-9]+)$").Success || key.EndsWith("editRow"))
{
filterBox.Visible = false;
}
else
{
if (key.EndsWith("filterdrop_"))
{
filterBox.SelectedValue = Request.Form[key];
}
}
}
if (filterBox.SelectedValue != "0")
{
RecordsDataControl.BindViewData(StudentRecordsDAL.Query("SELECT * FROM Unit_Attempt_Details WHERE Student_ID=" + filterBox.SelectedValue));
}
else
{
RecordsDataControl.BindViewData(StudentRecordsDAL.Query("SELECT * FROM Unit_Attempt_Details"));
}
}
else
{
filterBox.SelectedValue = "0";
RecordsDataControl.BindViewData(StudentRecordsDAL.Query("SELECT * FROM Unit_Attempt_Details"));
}
RecordsDataControl.BindEditData(StudentRecordsDAL.Query("SELECT * FROM Unit_Attempt"));
RecordsDataControl.SetTableName("Unit_Attempt");
RecordsDataControl.SetDisplayMetadata(displayTypes);
RecordsDataControl.SetEditMetadata(validationTypes);
RecordsDataControl.AddValidationMethod("Unit_Att_ID", setUnitAttemptID);
RecordsDataControl.AddValidationMethod("Attempt_ID", setAttemptID);
RecordsDataControl.AddValidationMethod("Unit_ID", unitAttemptChecks);
RecordsDataControl.AddValidationMethod("Semester_Attempted", multipleSemesterAttempts);
RecordsDataControl.SetFunction(updateDB);
RecordsDataControl.BuildControl();
}
