protected void Page_Load(object sender, EventArgs e) { bool valid = true; string classid = Request.QueryString["classid"]; if (String.IsNullOrEmpty(classid)) { valid = false; } try { Int32.Parse(classid); } catch (Exception ex) { //catching invalid URL ID entries valid = false; } if (valid) { var db = new SCHOOLDB(); //SCHOOLDB.FindClass() is not actually needed since that method can't do inner joins. Only used in this case to check that there is an entry at the given ID Dictionary <String, String> class_record = db.FindTeacher(Int32.Parse(classid)); List <Dictionary <String, String> > rs = db.List_Query("select CLASSES.*, TEACHERS.TEACHERFNAME, TEACHERS.TEACHERLNAME, TEACHERS.EMPLOYEENUMBER from CLASSES inner join TEACHERS on CLASSES.TEACHERID = TEACHERS.TEACHERID " + "where CLASSID = " + classid + " order by CLASSCODE asc"); if (class_record.Count > 0) { foreach (Dictionary <String, String> row in rs) { classTitle.InnerHtml = row["CLASSCODE"] + ": " + row["CLASSNAME"]; classCode.Text = row["CLASSCODE"]; className.Text = row["CLASSNAME"]; employeeNumber.Text = row["EMPLOYEENUMBER"]; startDate.Text = row["STARTDATE"]; finishDate.Text = row["FINISHDATE"]; } } else { valid = false; } } if (!valid) { updateClassForm.InnerHtml = "There was an error finding that Class. <br />"; updateClassForm.InnerHtml += "<button type=\"button\" onclick=\"location.href = 'Classes.aspx' \">Go Back</button>"; } }
protected void Page_Load(object sender, EventArgs e) { bool valid = true; string teacherid = Request.QueryString["teacherid"]; if (String.IsNullOrEmpty(teacherid)) { valid = false; } try { Int32.Parse(teacherid); } catch (Exception ex) { //catching invalid URL ID entries valid = false; } if (valid) { var db = new SCHOOLDB(); Dictionary <String, String> teacher_record = db.FindTeacher(Int32.Parse(teacherid)); List <Dictionary <String, String> > rs = db.List_Query("select * from teachers order by teacherfname asc"); if (teacher_record.Count > 0) { teacher_title_fname.InnerHtml = teacher_record["TEACHERFNAME"] + " " + teacher_record["TEACHERLNAME"]; teacher_fname.InnerHtml = teacher_record["TEACHERFNAME"]; teacher_lname.InnerHtml = teacher_record["TEACHERLNAME"]; employee_number.InnerHtml = teacher_record["EMPLOYEENUMBER"]; hire_date.InnerHtml = teacher_record["HIREDATE"]; } else { valid = false; } } if (!valid) { error.InnerHtml = "There was an error finding that student."; teacher.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { bool valid = true; string teacherid = Request.QueryString["teacherid"]; if (String.IsNullOrEmpty(teacherid)) { valid = false; } try { Int32.Parse(teacherid); } catch (Exception ex) { //catching invalid URL ID entries valid = false; } if (valid) { var db = new SCHOOLDB(); Dictionary <String, String> teacher_record = db.FindTeacher(Int32.Parse(teacherid)); List <Dictionary <String, String> > rs = db.List_Query("select * from teachers order by teacherfname asc"); if (teacher_record.Count > 0) { teacher_FullName.InnerHtml = teacher_record["TEACHERFNAME"] + " " + teacher_record["TEACHERLNAME"]; teacher_FName.Text = teacher_record["TEACHERFNAME"]; teacher_LName.Text = teacher_record["TEACHERLNAME"]; employee_Number.Text = teacher_record["EMPLOYEENUMBER"]; hire_Date.Text = teacher_record["HIREDATE"]; } else { valid = false; } } if (!valid) { updateTeacherForm.InnerHtml = "There was an error finding that teacher. <br />"; updateTeacherForm.InnerHtml += "<button type=\"button\" onclick=\"location.href = 'Teachers.aspx' \">Go Back</button>"; } }