protected void Page_Load(object sender, EventArgs e) { bool valid = true; string classid = Request.QueryString["classid"]; //if (String.IsNullOrEmpty(classid)) valid = false; if (valid) { var db = new Schooldb(); Dictionary <String, String> class_info = db.FindClass(int.Parse(classid)); if (class_info.Count > 0) { class_code.InnerHtml = class_info["CLASSCODE"]; class_name.InnerHtml = class_info["CLASSNAME"]; class_start.InnerHtml = class_info["STARTDATE"]; class_end.InnerHtml = class_info["FINISHDATE"]; teacher_name.InnerHtml = class_info["TEACHERNAME"]; } else { valid = false; } } if (!valid) { classinfo.InnerHtml = "Wrong details entered!!"; } }
protected void Page_Load(object sender, EventArgs e) { bool valid = true; string teacherid = Request.QueryString["teacherid"]; if (String.IsNullOrEmpty(teacherid)) { valid = false; } if (valid) { var db = new Schooldb(); Dictionary <String, String> teacher_data = db.FindTeacher(Int32.Parse(teacherid)); if (teacher_data.Count > 0) { teacher_fname.InnerHtml = teacher_data["TEACHERFNAME"]; teacher_lname.InnerHtml = teacher_data["TEACHERLNAME"]; employee_number.InnerHtml = teacher_data["EMPLOYEENUMBER"]; hire_date.InnerHtml = teacher_data["HIREDATE"]; salary.InnerHtml = teacher_data["SALARY"]; } else { valid = false; } } if (!valid) { teacher_data.InnerHtml = "Wrong details entered!!"; } }
protected void Page_Load(object sender, EventArgs e) { bool valid = true; string studentid = Request.QueryString["studentid"]; if (String.IsNullOrEmpty(studentid)) { valid = false; } if (valid) { var db = new Schooldb(); Dictionary <String, String> student_record = db.FindStudent(Int32.Parse(studentid)); if (student_record.Count > 0) { student_fname.InnerHtml = student_record["STUDENTFNAME"]; student_lname.InnerHtml = student_record["STUDENTLNAME"]; student_number.InnerHtml = student_record["STUDENTNUMBER"]; enrolment_date.InnerHtml = student_record["ENROLMENTDATE"]; } else { valid = false; } } if (!valid) { student.InnerHtml = "Wrong details entered!!"; } }
protected void Page_Load(object sender, EventArgs e) { classes_result.InnerHtml = ""; string Semester = "all"; string search_key = ""; if (Page.IsPostBack) { search_key = classes_search.Text; Semester = semester.SelectedValue; } string query = "select * from CLASSES"; if (Semester != "all") { query += " WHERE (MONTH(STARTDATE) = " + Semester + ")"; //INITIAL WHERE SO BOTH SEARCH AND SEMESTER CAN RUN WITHOUT REPEATING THE WHERE IN THE SEARCH KEY IF } else { query += " WHERE (MONTH(STARTDATE) =01 OR MONTH(STARTDATE) =09) "; } if (search_key != "") { query += " AND (CLASSID LIKE '%" + search_key + "%'"; query += " OR CLASSCODE LIKE '%" + search_key + "%'"; query += " OR CLASSNAME LIKE '%" + search_key + "%')"; } //sql_debugger.InnerHtml = query; var db = new Schooldb(); List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { classes_result.InnerHtml += "<div class=\"listitem\">"; string classid = row["CLASSID"]; string classcode = row["CLASSCODE"]; classes_result.InnerHtml += "<div class=\"col4\"><a href=\"ClassInfo.aspx?classid=" + classid + "\">" + classcode + "</a></div>";; string classname = row["CLASSNAME"]; classes_result.InnerHtml += "<div class=\"col4\">" + classname + "</div>"; string classstartdate = row["STARTDATE"]; classes_result.InnerHtml += "<div class=\"col4\">" + classstartdate + "</div>"; string classenddate = row["FINISHDATE"]; classes_result.InnerHtml += "<div class=\"col4last\">" + classenddate + "</div>"; classes_result.InnerHtml += "</div>"; } }
protected void Page_Load(object sender, EventArgs e) { teachers_result.InnerHtml = ""; string search_key = ""; if (Page.IsPostBack) { search_key = teachers_search.Text; } string query = "select TEACHERID, concat(TEACHERFNAME,\", \",TEACHERLNAME) AS 'TEACHERNAME',EMPLOYEENUMBER,HIREDATE,SALARY from TEACHERS "; if (search_key != "") { query += " WHERE TEACHERID LIKE '%" + search_key + "%'"; query += " OR TEACHERFNAME LIKE '%" + search_key + "%'"; query += " OR TEACHERLNAME LIKE '%" + search_key + "%'"; query += " OR EMPLOYEENUMBER LIKE '%" + search_key + "%'"; query += " OR HIREDATE LIKE '%" + search_key + "%'"; query += " OR SALARY LIKE '%" + search_key + "%'"; } var db = new Schooldb(); List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { teachers_result.InnerHtml += "<div class=\"listitem\">"; string teacherid = row["TEACHERID"]; // teachers_result.InnerHtml += "<div class=\"col4\">" + teacherid + "</div>"; string teachername = row["TEACHERNAME"]; teachers_result.InnerHtml += "<div class=\"col4\"><a href=\"teacherData.aspx?teacherid=" + teacherid + "\">" + teachername + "</a></div>"; //string teacherlname = row["TEACHERLNAME"]; //teachers_result.InnerHtml += "<div class=\"col4\">" + teacherlname + "</div>"; string employeenumber = row["EMPLOYEENUMBER"]; teachers_result.InnerHtml += "<div class=\"col4\">" + employeenumber + "</div>"; string hiredate = row["HIREDATE"]; teachers_result.InnerHtml += "<div class=\"col4last\">" + hiredate + "</div>"; string salary = row["SALARY"]; teachers_result.InnerHtml += "<div class=\"col4last\">" + salary + "</div>"; teachers_result.InnerHtml += "</div>"; } }
//refference taken from in class example done by chrintine bittle protected void Page_Load(object sender, EventArgs e) { students_result.InnerHtml = ""; string search_key = ""; if (Page.IsPostBack) { search_key = student_search.Text; } string query = "select * from STUDENTS"; if (search_key != "") { query += " WHERE STUDENTFNAME LIKE '%" + search_key + "%'"; query += " OR STUDENTLNAME LIKE '%" + search_key + "%'"; query += " OR STUDENTNUMBER LIKE '%" + search_key + "%'"; } var db = new Schooldb(); List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { students_result.InnerHtml += "<div class=\"listitem\">"; string studentid = row["STUDENTID"]; string studentfirstname = row["STUDENTFNAME"]; students_result.InnerHtml += "<div class=\"col4\"><a href=\"ShowStudent.aspx?studentid=" + studentid + "\">" + studentfirstname + "</a></div>"; string studentlastname = row["STUDENTLNAME"]; students_result.InnerHtml += "<div class=\"col4\">" + studentlastname + "</div>"; string studentnumber = row["STUDENTNUMBER"]; students_result.InnerHtml += "<div class=\"col4\">" + studentnumber + "</div>"; string enrolmentdate = row["ENROLMENTDATE"]; students_result.InnerHtml += "<div class=\"col4last\">" + enrolmentdate + "</div>"; students_result.InnerHtml += "</div>"; } }