protected void Page_Load(object sender, EventArgs e) { //Adds entry to database DB dB = new DB(); String query = "SELECT project_ID, project_name, files.file_name, users.first_name, users.last_name, users.department, RIS_ID FROM PROJECTS JOIN users ON researcher_ID = users.staff_no JOIN files ON projects.file_ID = files.file_ID WHERE (dean_accepted = 0 OR dean_accepted is NULL) AND ass_dean_accepted = 1"; //CHECK FOR LOGIN string LI = (string)(Session["loggedin"]); if (LI != "Loggedin") { Response.Redirect("Index.aspx", false); } else //Ensure that user is a Dean { DB db = new DB(); string staffID = (string)(Session["StaffNo"]); Redirect(getDetails(db, staffID)); } int i = 0; try // Breaks up the query into seperate variables stored in array { reader = dB.Select(query); if (reader.HasRows) { while (reader.Read()) { for (int n = 0; n < 6; n++) { data[i] += reader.GetString(n) + ','; } i++; Array.Resize <String>(ref data, i + 1); } } } catch { // nothing } // String info = new String[][]; for (int j = 0; j < i; j++) { System.Diagnostics.Debug.WriteLine("++++++++++++++++++++++++++++++++++"); //Resizes arrays based on hpw many projects are added Array.Resize <String>(ref projectID, j + 1); Array.Resize <String>(ref projectName, j + 1); Array.Resize <String>(ref fileName, j + 1); Array.Resize <String>(ref firstName, j + 1); Array.Resize <String>(ref lastName, j + 1); Array.Resize <String>(ref department, j + 1); Array.Resize <String>(ref risID, j + 1); System.Diagnostics.Debug.WriteLine(data[j]); String[] words = data[j].Split(','); projectID[j] = words[0]; projectName[j] = words[1]; fileName[j] = words[2]; firstName[j] = words[3]; lastName[j] = words[4]; department[j] = words[5]; //risID[j] = words[6]; System.Diagnostics.Debug.WriteLine(projectID[j]); System.Diagnostics.Debug.WriteLine(projectName[j]); System.Diagnostics.Debug.WriteLine(fileName[j]); System.Diagnostics.Debug.WriteLine(firstName[j]); System.Diagnostics.Debug.WriteLine(lastName[j]); System.Diagnostics.Debug.WriteLine(department[j]); } }
protected void Page_Load(object sender, EventArgs e) { DB dB = new DB(); String query = "SELECT project_ID, project_name, files.file_name, users.first_name, users.last_name, users.department, projects.RIS_accepted, projects.ass_dean_accepted, projects.dean_accepted, projects.RIS_denied FROM PROJECTS JOIN users ON researcher_ID = users.staff_no JOIN files ON projects.file_ID = files.file_ID WHERE projects.researcher_ID ='" + (string)Session["StaffNo"] + "'"; //(RIS_accepted = 0 OR RIS_accepted is NULL) // String queryImage = "SELECT RIS_accepted, ass_dean_accepted, dean_accepted FROM projects"; //CHECK FOR LOGIN string LI = (string)(Session["loggedin"]); if (LI != "Loggedin") { Response.Redirect("Index.aspx", false); } else //CHECK & ENSURE USER IS RESEARCHER { DB db = new DB(); string staffID = (string)(Session["StaffNo"]); Redirect(getDetails(db, staffID)); } int i = 0; try { reader = dB.Select(query); if (reader.HasRows) { while (reader.Read()) { for (int n = 0; n < 10; n++) { data[i] += reader.GetString(n) + ','; } i++; Array.Resize <String>(ref data, i + 1); } } } catch { // nothing } // String info = new String[][]; for (int j = 0; j < i; j++) { System.Diagnostics.Debug.WriteLine("++++++++++++++++++++++++++++++++++"); //System.Diagnostics.Debug.WriteLine(data[j]); Array.Resize <String>(ref projectID, j + 1); Array.Resize <String>(ref projectName, j + 1); Array.Resize <String>(ref fileName, j + 1); Array.Resize <String>(ref firstName, j + 1); Array.Resize <String>(ref lastName, j + 1); Array.Resize <String>(ref department, j + 1); Array.Resize <String>(ref RIS_accepted, j + 1); Array.Resize <String>(ref ass_dean_accepted, j + 1); Array.Resize <String>(ref dean_accepted, j + 1); Array.Resize <String>(ref RIS_denied, j + 1); System.Diagnostics.Debug.WriteLine(data[j]); String[] words = data[j].Split(','); projectID[j] = words[0]; projectName[j] = words[1]; fileName[j] = words[2]; firstName[j] = words[3]; lastName[j] = words[4]; department[j] = words[5]; RIS_accepted[j] = words[6]; ass_dean_accepted[j] = words[7]; dean_accepted[j] = words[8]; RIS_denied[j] = words[9]; //risID[j] = words[6]; System.Diagnostics.Debug.WriteLine(projectID[j]); System.Diagnostics.Debug.WriteLine(projectName[j]); System.Diagnostics.Debug.WriteLine(fileName[j]); System.Diagnostics.Debug.WriteLine(firstName[j]); System.Diagnostics.Debug.WriteLine(lastName[j]); System.Diagnostics.Debug.WriteLine(department[j]); } }
protected void Page_Load(object sender, EventArgs e) { //Connect to database and pick the data we want to use from int DB database = new DB(); String query = "SELECT users.first_name, users.last_name, users.department, projects.project_name, projects.RIS_accepted, projects.ass_dean_accepted, projects.dean_accepted, files.file_name FROM users, projects, files WHERE projects.RIS_accepted = 1 AND projects.ass_dean_accepted = 1 AND projects.dean_accepted = 1 AND users.staff_no = projects.researcher_ID AND files.file_ID = projects.file_ID; "; //CHECK FOR LOGIN string LI = (string)(Session["loggedin"]); if (LI != "Loggedin") { Response.Redirect("Index.aspx", false); } int i = 0; reader = database.Select(query); //Reads the data try { if (reader.HasRows) { while (reader.Read()) { for (int n = 0; n < 8; n++) { data[i] += reader.GetString(n) + ','; } i++; Array.Resize <String>(ref data, i + 1); } } } catch { // nothing } //Save all the data that was read into a variable that will be used to print their values on the browser for (int p = 0; p < i; p++) { System.Diagnostics.Debug.WriteLine("++++++++++++++++++++++++++++++++++"); Array.Resize <String>(ref firstName, p + 1); Array.Resize <String>(ref lastName, p + 1); Array.Resize <String>(ref department, p + 1); Array.Resize <String>(ref projectName, p + 1); Array.Resize <String>(ref RIS_accepted, p + 1); Array.Resize <String>(ref ass_dean_accepted, p + 1); Array.Resize <String>(ref dean_accepted, p + 1); Array.Resize <String>(ref fileName, p + 1); System.Diagnostics.Debug.WriteLine(data[p]); String[] info = data[p].Split(','); firstName[p] = info[0]; lastName[p] = info[1]; department[p] = info[2]; projectName[p] = info[3]; RIS_accepted[p] = info[4]; ass_dean_accepted[p] = info[5]; dean_accepted[p] = info[6]; fileName[p] = info[7]; System.Diagnostics.Debug.WriteLine(firstName[p]); System.Diagnostics.Debug.WriteLine(lastName[p]); System.Diagnostics.Debug.WriteLine(department[p]); System.Diagnostics.Debug.WriteLine(projectName[p]); System.Diagnostics.Debug.WriteLine(RIS_accepted[p]); System.Diagnostics.Debug.WriteLine(ass_dean_accepted[p]); System.Diagnostics.Debug.WriteLine(dean_accepted[p]); System.Diagnostics.Debug.WriteLine(fileName[p]); } }