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