public override bool UpdateToDB(DBManager db)
{
if (_paidGroupID <= 0) return false;
String[] key = { "paid_group_id", "name", "current_round", "rate_info" };
String[] val = { _paidGroupID.ToString(), _name, _currentRound.ToString(), PaidRateInfo.ToString(_rateInfo) };
return (db.Update("paid_group", key, val, "paid_group_id=" + _paidGroupID) > 0) ? true : false;
}
public override bool UpdateToDB(DBManager db)
{
if (_teacherID <= 0) return false;
String[] key = { "firstname", "surname", "citizen_id", "tel", "email", "sex", "birthday", "addr", "image", "subject" };
String[] val = { _firstname, _surname, _citizenID, _tel, _email, _sex, StringUtil.ConvertYearToEng(_birthday, "yyyy/MM/dd"), _addr, _img, _subject };
return (db.Update("teacher", key, val, "teacher_id="+_teacherID) > 0) ? true : false;
}
public override bool UpdateToDB(DBManager db)
{
if (_courseID <= 0) return false;
String[] key = { "course_id", "sum_all_cost", "sum_max_payable", "sum_paid_cost", "last_paid_date", "paid_round", "status" };
String[] val = { _courseID.ToString(), _sumAllCost.ToString(), _sumMaxPayable.ToString(), _sumPaidCost.ToString()
,StringUtil.ConvertYearToEng( _lastPaidDate, "yyyy/MM/dd HH:mm:ss"), _paidRound.ToString(), _status.ToString() };
return (db.Update("payment", key, val, "course_id=" + _courseID) > 0) ? true : false;
}
public override bool UpdateToDB(DBManager db)
{
if (_branchID <= 0) return false;
String[] key = { "branch_name", "branch_code", "address", "tel", "img", "supervisor" };
String[] val = { _branchName, _branchCode, _address, _tel, _img, _supervisor };
return (db.Update("branch", key, val, "branch_id=" + _branchID) > 0) ? true : false;
}
public override bool UpdateToDB(DBManager db)
{
if (String.IsNullOrEmpty(_username)) return false;
String[] key = { "passwd", "firstname", "surname", "role_id", "branch_id" };
String[] val = { _passwd, _firstname, _surname, _roleId.ToString(), _branchID.ToString() };
return (db.Update("user", key, val, "username='******'") > 0) ? true : false;
}
public override bool UpdateToDB(DBManager db)
{
if (_roomID <= 0) return false;
String[] key = { "branch_id", "name", "seat_no", "img", "description" };
String[] val = { _branchID.ToString(), _name, _seatNo.ToString(), _img, _description};
return (db.Update("room", key, val, "room_id="+_roomID) > 0) ? true : false;
}
public override bool UpdateToDB(DBManager db)
{
if (_courseID <= 0) return false;
String[] key = { "bts_course_id", "course_name", "short_name", "course_desc", "course_type", "room_id", "teacher_id", "paid_group_id", "category", "start_date", "end_date", "day_of_week", "open_time", "cost", "seat_limit", "bank_regis_limit", "image", "is_active" };
String[] val = { _btsCourseID, _courseName, _shortName, _courseDesc, _courseType, _roomID.ToString(), _teacherID.ToString(), _paidGroupID.ToString(), _category
,StringUtil.ConvertYearToEng(_startdate, "yyyy/MM/dd"), StringUtil.ConvertYearToEng(_enddate, "yyyy/MM/dd"), _dayOfWeek, _opentime
,_cost.ToString(), _seatLimit.ToString(), _bankRegisLimit.ToString(), _img, _isActive?"0":"1" };
return (db.Update("course", key, val, "course_id=" + _courseID) > 0) ? true : false;
}
public override bool UpdateToDB(DBManager db)
{
if (_roleId <= 0) return false;
String[] key = { "name", "role_id" };
String[] val = { _name, _roleId.ToString() };
return (db.Update("Role", key, val, "role_id=" + _roleId) > 0) ? true : false;
}
public override bool UpdateToDB(DBManager db)
{
// update only the paid method
// so just update the first char of transcode
UpdateTransactionCode();
if (_regisID <= 0) return false;
String[] key = { "transaction_id", "transaction_code", "regis_date", "student_id", "promotion_id", "course_id", "branch_id", "full_cost", "discounted_cost", "seat_no", "note", "paid_method", "paid_round", "paid_date", "username", "status", "is_paid" };
String[] val = { _transactionID.ToString(), _transactionCode, StringUtil.ConvertYearToEng(_regisdate, "yyyy/MM/dd HH:mm:ss ")
, _studentID.ToString(), _promotionID.ToString(), _courseID.ToString(), _branchID.ToString(), _fullCost.ToString(), _discountedCost.ToString()
, _seatNo, _note, _paidMethod.ToString(), _paidRound.ToString(), StringUtil.ConvertYearToEng(_paiddate, "yyyy/MM/dd HH:mm:ss "), _username, _status.ToString(), _isPaid?"0":"1" };
return (db.Update("registration", key, val, "regis_id=" + _regisID) > 0) ? true : false;
}
public override bool UpdateToDB(DBManager db)
{
if (_paymentID <= 0) return false;
String[] key = { "course_id", "paid_cost", "sum_all_cost", "sum_max_payable", "sum_paid_cost", "cost_info", "paid_date", "paid_round", "receiver_teacher_id", "username", "branch_id" };
String[] val = { _courseID.ToString(), _paidCost.ToString(), _sumAllCost.ToString(), _sumMaxPayable.ToString(), _sumPaidCost.ToString(), _costInfo
,StringUtil.ConvertYearToEng( _paidDate, "yyyy/MM/dd HH:mm:ss"), _paidRound.ToString(), _receiverTeacherID.ToString(), _username, _branchID.ToString() };
return (db.Update("payment_history", key, val, "payment_id=" + _paymentID) > 0) ? true : false;
}
