protected void DoDeleteCourse(string courseID)
{
Course t = new Course();
t._courseID = Int32.Parse(courseID);
DBManager db = null;
try {
db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC);
db.Connect();
// Check if payment id paid all
// If no, unable to delete this course
// Else
// Update status=1 (invalid)
Payment payment = new Payment();
if (payment.LoadFromDB(db, " course_id=" + courseID))
{
if (payment._sumPaidCost < payment._sumAllCost) // not yet paid all
{
errorText = "ยังมีเงินที่เบิกจ่ายไม่หมด " + (payment._sumAllCost - payment._sumPaidCost);
return;
}
else
{
payment._status = Payment.STATUS_INVALID;
payment.UpdateToDB(db);
}
}
// Delete course
t.DeleteToDB(db);
} finally {
if (db!=null) db.Close();
}
}
