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>";
}
}
