public bool AddTeacherToDB(DBManager db, String teacherID)
{
String[] key = { "paid_group_id", "teacher_id" };
String[] val = { _paidGroupID.ToString(), teacherID };
return (db.Insert("paid_group_teacher_mapping", key, val) > 0) ? true : false;
}
public override bool AddToDB(DBManager db)
{
String[] key = { "paid_group_id", "name", "current_round", "rate_info" };
String[] val = { _paidGroupID.ToString(), _name, _currentRound.ToString(), PaidRateInfo.ToString(_rateInfo) };
return (db.Insert("paid_group", key, val) > 0) ? true : false;
}
public override bool AddToDB(DBManager db)
{
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.Insert("teacher", key, val) > 0) ? true : false;
}
public override bool AddToDB(DBManager db)
{
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.Insert("payment", key, val) > 0) ? true : false;
}
public override bool AddToDB(DBManager db)
{
String[] key = { "branch_name", "branch_code", "address", "tel", "img", "supervisor" };
String[] val = { _branchName, _branchCode, _address, _tel, _img, _supervisor };
return (db.Insert("branch", key, val) > 0) ? true : false;
}
public override bool AddToDB(DBManager db)
{
//username at param????
String[] key = { "username", "passwd", "firstname", "surname", "role_id", "branch_id" };
String[] val = { _username, _passwd, _firstname, _surname, _roleId.ToString(), _branchID.ToString() };
return (db.Insert("user", key, val) > 0) ? true : false;
}
public override bool AddToDB(DBManager db)
{
String[] key = { "branch_id", "name", "seat_no", "img", "description" };
String[] val = { _branchID.ToString(), _name, _seatNo.ToString(), _img, _description};
return (db.Insert("room", key, val) > 0) ? true : false;
}
public override bool AddToDB(DBManager db)
{
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.Insert("course", key, val) > 0) ? true : false;
}
public override bool AddToDB(DBManager db)
{
String[] key = { "name" };
String[] val = { _name };
return (db.Insert("role", key, val) > 0) ? true : false;
}
public override bool AddToDB(DBManager db)
{
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.Insert("registration", key, val) > 0) ? true : false;
}
public override bool AddToDB(DBManager db)
{
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.Insert("payment_history", key, val) > 0) ? true : false;
}
