public void DoAddTeacher() { DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); groupList = PaidGroup.LoadListFromDB(db, ""); db.Close(); }
public void DoAddPaidGroup() { DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); groupList = PaidGroup.LoadListFromDB(db, ""); //teacherList = Teacher.LoadListFromDB(db, " WHERE is_active=1 ORDER BY firstname"); db.Close(); }
public void DoAddCourse() { DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); roomList = Room.LoadListFromDBCustom(db, "SELECT r.room_id, r.name, b.branch_name as branch_name FROM room r, branch b WHERE r.branch_id=b.branch_id"); teacherList = Teacher.LoadListFromDB(db, " ORDER BY firstname"); paidGroupList = paidGroupList = PaidGroup.LoadListFromDB(db, " ORDER BY paid_group_id"); db.Close(); }
public void DoEditCourse(string courseID) { DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); theCourse = new Course(); if (!theCourse.LoadFromDB(db, "course_id=" + courseID)) { theCourse = null; } roomList = Room.LoadListFromDBCustom(db, "SELECT r.room_id, r.name, b.branch_name as branch_name FROM room r, branch b WHERE r.branch_id=b.branch_id"); teacherList = Teacher.LoadListFromDB(db, " ORDER BY firstname"); paidGroupList = PaidGroup.LoadListFromDB(db, " ORDER BY paid_group_id"); db.Close(); }
public void DoEditTeacher(string teacherID) { DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); //Load GroupList groupList = PaidGroup.LoadListFromDB(db, ""); theTeacher = new Teacher(); if (!theTeacher.LoadFromDB(db, "teacher_id=" + teacherID)) { theTeacher = null; } // List Course History string[,] bgclass = new string[, ] { { "class=\"spec\"", "class=\"td1\"" }, { "class=\"specalt\"", "class=\"alt\"" } }; string query = "SELECT * from course "; query = query + "WHERE teacher_id='"; query = query + teacherID + "' order by start_date desc"; OdbcDataReader reader = db.Query(query); int i = 0; while (reader.Read()) { Course course = Course.CreateForm(reader); outBuf3.Append("<tr>"); outBuf3.Append("<th scope=\"row\" abbr=\"Model\" " + bgclass[i % 2, 0] + " align=center>" + course._startdate.ToString("dd MMM yyyy", ci) + " </th>"); outBuf3.Append("<td " + bgclass[i % 2, 1] + " align=center>" + course._btsCourseID + " </td>"); outBuf3.Append("<td " + bgclass[i % 2, 1] + " align=left>" + course._courseName + " </td>"); outBuf3.Append("<td " + bgclass[i % 2, 1] + " >" + course._cost + " </td>"); outBuf3.Append("</tr>\n"); i++; } db.Close(); }
public void PrintCourseOption(DBManager db) { // validate course filter int a; if ((filterCourseID == null) || (filterCourseID.Length == 0) || (!Int32.TryParse(filterCourseID, out a))) { filterCourseID = "all"; } // load all courses String whereClause = filterCourseID.Equals("all") ? "" : " AND paid_group_id=" + filterCourseID + " "; PaidGroup[] pgroups = PaidGroup.LoadListFromDB(db, " ORDER BY name"); Course[] courses = Course.LoadListFromDB(db, " WHERE is_active=1 " + whereClause + " ORDER BY bts_course_id"); // paint course list fullCost = 0; int numCoursesPerRow = 5; outBuf.Append("<table border=0>"); // print filter courses if (actPage.Equals("add")) { outBuf.Append("<tr><td colspan=\"" + numCoursesPerRow + "\">"); outBuf.Append("แสดงรายการคอร์ส <select name=\"filter_courseid\" id=\"filter_courseid\" onchange=\"doChangeFilterCourse()\">"); outBuf.Append("<option value=\"all\">ทั้งหมด</option>"); foreach (PaidGroup pg in pgroups) { string selected = (filterCourseID.Equals(pg._paidGroupID.ToString())) ? "selected" : ""; outBuf.Append("<option value=\"" + pg._paidGroupID + "\" " + selected + " >" + pg._name + "</option>"); } outBuf.Append("</select>"); outBuf.Append("</td></tr>"); } for (int i = 0; i < courses.Length; i++) { string name = "course" + courses[i]._courseID; string isChecked = ""; string className = " class=\"td2\" "; if ((thePromotion != null) && (thePromotion._courses != null)) { for (int j = 0; j < thePromotion._courses.Length; j++) { if (thePromotion._courses[j]._courseID == courses[i]._courseID) { fullCost += courses[i]._cost; isChecked = " checked "; className = " class=\"td2_2\" "; break; } } } if (i % numCoursesPerRow == 0) { outBuf.Append("<tr>\n"); // outBuf.Append("<th scope=row abbr=Model class=spec>xxx</th>"); } string t = "document.getElementById('" + name + "').checked"; string t2 = t + "=!" + t + ";"; t2 = t2 + " if (document.getElementById('" + name + "').checked) {this.className='td2_2';}"; t2 = t2 + " sumFullCost(); "; string t1 = " if (!" + t + ") {this.className='td2'; }; hideDiv('divdetail');"; outBuf.Append("<td " + className + " onMouseover=\"this.className='td2_2';queryCourseDetail('" + courses[i]._courseID + "')\" onMouseout=\"" + t1 + "\" onclick=\"" + t2 + "\"; return;\" >"); outBuf.Append("<input type=checkbox id=" + name + " name=" + name + " " + isChecked + " onclick=\"" + t + "=!" + t + ";" + "\" ><font class=font01> " + courses[i]._btsCourseID + "</font></td>"); if (i % numCoursesPerRow == numCoursesPerRow - 1) { outBuf.Append("</tr>\n"); } outBuf.Append("<input type=hidden id=cost_" + name + " name=cost_" + name + " value=\"" + courses[i]._cost + "\" >"); } outBuf.Append("</table>"); }