public void insert_resignLOG() { databaseClassLOG db = new databaseClassLOG(); string table = "tab_emp_resign"; string[] Columns = { "re_id", "re_ref_emp_id", "re_emp_code", "re_type", "re_detail", "re_resign_date", "re_submit_date", "re_admin_id", "event_status" }; string[] Value = { re_id, re_ref_emp_id, re_emp_code, re_type, re_detail, Convert.ToDateTime(re_resign_date).ToString("yyyy-MM-dd", en), Convert.ToDateTime(re_submit_date).ToString("yyyy-MM-dd HH:mm:ss",en), re_admin_id, event_status }; db.insert(table, Columns, Value); }
public void insertFundLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_emp_fundRegis"; string[] Columns = { "fr_id", "fr_ref_fund_id", "fr_date_start", "fr_date_end", "fr_ref_emp_id", "fr_admin_id", "fr_submit_date", "fr_status" }; string[] Value = { fr_id, fr_ref_fund_id, Convert.ToDateTime(fr_date_start).ToString("yyyy-MM-dd", en), Convert.ToDateTime(fr_date_end).ToString("yyyy-MM-dd", en), fr_ref_emp_id, fr_admin_id, Convert.ToDateTime(fr_submit_date).ToString("yyyy-MM-dd HH:mm:ss", en), fr_status }; dbl.insert(table, Columns, Value); }
public void insert_payLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_emp_pay"; string[] Columns = { "pay_id", "pay_ref_income_id", "pay_amount", "pay_ref_emp_id", "pay_admin_id", "pay_submit_date", "pay_start_date", "pay_end_date", "pay_status", "event_status" }; string[] Value = { pay_id, pay_ref_income_id, pay_amount, pay_ref_emp_id, pay_admin_id, Convert.ToDateTime(pay_submit_date).ToString("yyyy-MM-dd HH:mm:ss", EN), Convert.ToDateTime(pay_start_date).ToString("yyyy-MM-dd HH:mm:ss", EN), Convert.ToDateTime(pay_end_date).ToString("yyyy-MM-dd HH:mm:ss", EN), pay_status, event_status }; dbl.insert(table, Columns, Value); }
public void insertPositionLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_position"; string[] Columns = { "post_id", "post_name", "post_admin", "post_submit_date", "event_status" }; string[] Value = { post_id, post_name, post_admin, Convert.ToDateTime(post_submit_date).ToString("yyyy-MM-dd HH:mm:ss", en), event_status }; dbl.insert(table, Columns, Value); }
public void insertAdmLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_emp_admonish"; string[] Columns = { "adm_id", "adm_date", "adm_title", "adm_detail", "adm_ref_emp_id", "adm_admin_id", "adm_submit_date" }; string[] Value = { adm_id, Convert.ToDateTime(adm_date).ToString("yyyy-MM-dd", en), adm_title, adm_detail, adm_ref_emp_id, adm_admin_id, Convert.ToDateTime(adm_submit_date).ToString("yyyy-MM-dd HH:mm:ss") }; dbl.insert(table, Columns, Value); }
public void insertWorkLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_personal_work"; string[] Columns = { "work_id", "work_company", "work_address", "work_start", "work_end", "work_position", "work_ref_personal_id", "work_submit_date", "work_ref_admin_id" }; string[] Value = { work_id, work_company, work_address, work_start, work_end, work_position, work_ref_personal_id, Convert.ToDateTime(work_submit_date).ToString("yyyy-MM-dd HH:mm:ss"), work_ref_admin_id }; dbl.insert(table, Columns, Value); }
public void insert_imgLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_emp_profile_img"; string[] Columns = { "img_id", "img_name", "img_ref_emp_id", "img_ref_person_id", "img_ref_admin_id", "img_submit_date" }; string[] Value = { img_id, img_name, img_ref_emp_id, img_ref_person_id, img_ref_admin_id, Convert.ToDateTime(img_submit_date).ToString("yyyy-MM-dd HH:mm:ss", en) }; dbl.insert(table, Columns, Value); }
public void insertFundLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_info_fund"; string[] Columns = { "fund_id", "fund_name", "fund_submit_date", "fund_admin_id", "event_status", "fund_code" }; string[] Value = { fund_id, fund_name, Convert.ToDateTime(fund_date).ToString("yyyy-MM-dd HH:mm:ss", en), fund_admin, event_status, fund_code }; dbl.insert(table, Columns, Value); }
public void insertPrefixLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_info_prefix"; string[] Columns = { "prefix_id", "prefix_name_th", "prefix_name_en", "prefix_submit_date", "prefix_admin_id", "event_status" }; string[] Value = { prefix_id, name_th, name_en, Convert.ToDateTime(submit_date).ToString("yyyy/MM/dd HH:mm:ss", en), admin_id, event_status }; dbl.insert(table, Columns, Value); }
public void insertIncomeLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_info_income"; string[] Columns = { "income_id", "income_name", "income_submit_date", "income_admin_id", "event_status" }; string[] Value = { income_id, income_name, Convert.ToDateTime(income_submit_date).ToString("yyyy-MM-dd HH:mm:ss", en), income_admin, event_status }; dbl.insert(table, Columns, Value); }
public void insertKidLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_personal_kid"; string[] Columns = { "kid_id", "kid_name", "kid_lastname", "kid_age", "kid_study_status", "kid_study_level", "kid_study_school", "kid_ref_personal_id", "kid_submit_date", "kid_ref_admin_id" }; string[] Value = { kid_id, kid_name, kid_lastname, kid_age, kid_study_status, kid_study_level, kid_study_school, kid_ref_personal_id, Convert.ToDateTime(kid_submit_date).ToString("yyyy-MM-dd HH:mm:ss"), kid_ref_admin_id }; dbl.insert(table, Columns, Value); }
public void insertStudyLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_personal_study"; string[] Columns = { "study_id", "study_year", "study_academy", "study_gpa", "study_degree", "study_branch", "study_ref_personal_id", "study_submit_date", "study_ref_admin_id" }; string[] Value = { study_id, study_year, study_academy, study_gpa, study_degree, study_branch, study_ref_personal_id, Convert.ToDateTime(study_submit_date).ToString("yyyy-MM-dd HH:mm:ss"), study_ref_admin_id }; dbl.insert(table, Columns, Value); }
public void insertTrainLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_personal_train"; string[] Columns = { "train_id", "train_title", "train_location", "train_start", "train_end", "train_ref_personal_id", "train_submit_date", "train_ref_admin_id" }; string[] Value = { train_id, train_title, train_location, train_start, train_end, train_ref_personal_id, Convert.ToDateTime(train_submit_date).ToString("yyyy-MM-dd HH:mm:ss"), train_ref_admin_id }; dbl.insert(table, Columns, Value); }
public void insertMinusLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_info_minus"; string[] Columns = { "minus_id", "minus_name", "minus_submit_date", "minus_admin_id", "event_status" }; string[] Value = { minus_id, minus_name, Convert.ToDateTime(minus_date).ToString("yyyy-MM-dd HH:mm:ss", en), minus_admin, event_status }; dbl.insert(table, Columns, Value); }
public void insertTypeLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_emp_type"; string[] Columns = { "type_id", "type_name", "type_submit_date", "type_admin_id", "type_salary", "type_chk_salary2", "type_chk_incentive", "event_status" }; string[] Value = { type_id, type_name, Convert.ToDateTime(type_submit_date).ToString("yyyy-MM-dd HH:mm:ss", en), type_admin_id, type_salary, type_chk_salary2, type_chk_incentive, event_status }; dbl.insert(table, Columns, Value); }
public void insertPersonalLOG() { databaseClassLOG db = new databaseClassLOG(); string table = "tab_personal"; string[] Columns = { "ps_id", "ps_prefix_th", "ps_prefix_en", "ps_name_th", "ps_lastname_th", "ps_name_en", "ps_lastname_en", "ps_gender", "ps_blood", "ps_national_id", "ps_national_date_start", "ps_national_date_end", "ps_birthday", "ps_nationality", "ps_race", "ps_status_marital", "ps_admin_id", "ps_create_date", "ps_religion", "event_status" }; string[] Value = { personal_id, prefix_th, prefix_en, name_th, lastname_th, name_en, lastname_en, gender, blood, national_id, national_start, national_end, Convert.ToDateTime(birthday).ToString("yyyy-MM-dd", en), nationality, race, marital, "1", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), religion, event_status }; db.insert(table, Columns, Value); }
public void insertMinusSqlaryLOG() { CultureInfo en = new CultureInfo("EN"); databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_emp_minusSalary"; string[] Columns = { "ms_id", "ms_ref_minus_id", "ms_amount", "ms_ref_emp_id", "ms_admin_id", "ms_submit_date", "ms_start_date", "ms_end_date", "ms_status", "event_status" }; string[] Value = { ms_id, ms_ref_minus_id, ms_amount, ms_ref_emp_id, ms_admin_id, Convert.ToDateTime(ms_submit_date).ToString("yyyy-MM-dd HH:mm:ss", en), Convert.ToDateTime(ms_start_date).ToString("yyyy-MM-dd HH:mm:ss", en), Convert.ToDateTime(ms_end_date).ToString("yyyy-MM-dd HH:mm:ss", en), ms_status, event_status }; dbl.insert(table, Columns, Value); }
public void insertCommendLOG() { databaseClassLOG dbl = new databaseClassLOG(); CultureInfo en = new CultureInfo("EN"); string table = "tab_emp_commend"; string[] Columns = { "comm_id", "comm_date", "comm_title", "comm_detail", "comm_ref_emp_id", "comm_admin_id", "comm_submit_date" }; string[] Value = { comm_id, Convert.ToDateTime(comm_date).ToString("yyyy-MM-dd", en), comm_title, comm_detail, comm_ref_emp_id, comm_admin_id, Convert.ToDateTime(comm_submit_date).ToString("yyyy-MM-dd HH:mm:ss") }; dbl.insert(table, Columns, Value); }
public void insertEmpLOG() { CultureInfo en = new CultureInfo("EN"); databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_emp"; string[] Columns = { "ep_id", "ep_code", "ep_ref_personal_id", "ep_ref_type_id", "ep_start", "ep_end", "ep_status", "ep_submit_date", "ep_ref_admin_id", "event_status" }; string[] Value = { ep_id, ep_code, ep_ref_personal_id, ep_ref_type_id, Convert.ToDateTime(ep_start).ToString("yyyy-MM-dd", en), Convert.ToDateTime(ep_end).ToString("yyyy-MM-dd", en), ep_status, Convert.ToDateTime(ep_submit_date).ToString("yyyy-MM-dd HH:mm:ss",en), ep_ref_admin_id, event_status }; dbl.insert(table, Columns, Value); }
public void insertFamilyLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_personal_family"; string[] Columns = { "fam_id", "fam_name_dad", "fam_lastname_dad", "fam_age_dad", "fam_num_dad", "fam_moo_dad", "fam_province_dad", "fam_amphur_dad", "fam_district_dad", "fam_postcode_dad", "fam_tel_dad", "fam_mobile_dad", "fam_name_mom", "fam_lastname_mom", "fam_age_mom", "fam_num_mom", "fam_moo_mom", "fam_province_mom", "fam_amphur_mom", "fam_district_mom", "fam_postcode_mom", "fam_tel_mom", "fam_mobile_mom", "fam_name_marry", "fam_lastname_marry", "fam_age_marry", "fam_num_marry", "fam_moo_marry", "fam_province_marry", "fam_amphur_marry", "fam_district_marry", "fam_postcode_marry", "fam_tel_marry", "fam_mobile_marry", "fam_ref_person_id", "fam_submit_date", "fam_ref_admin_id" }; string[] Value = { fam_id, fam_name_dad, fam_lastname_dad, fam_age_dad, fam_num_dad, fam_moo_dad, fam_province_dad, fam_amphur_dad, fam_district_dad, fam_postcode_dad, fam_tel_dad, fam_mobile_dad, fam_name_mom, fam_lastname_mom, fam_age_mom, fam_num_mom, fam_moo_mom, fam_province_mom, fam_amphur_mom, fam_district_mom, fam_postcode_mom, fam_tel_mom, fam_mobile_mom, fam_name_marry, fam_lastname_marry, fam_age_marry, fam_num_marry, fam_moo_marry, fam_province_marry, fam_amphur_marry, fam_district_marry, fam_postcode_marry, fam_tel_marry, fam_mobile_marry, person_id, Convert.ToDateTime(fam_submit_date).ToString("yyyy-MM-dd HH:mm:ss"), fam_ref_admin_id }; dbl.insert(table, Columns, Value); }
public void insertAddressLOG() { databaseClassLOG dbl = new databaseClassLOG(); string table = "tab_emp_address"; string[] Columns = { "address_id", "address_num", "address_moo", "address_type", "address_name", "address_alley", "address_road", "address_district_id", "address_amphur_id", "address_province_id", "address_postcode", "address_num_call", "address_moo_call", "address_type_call", "address_name_call", "address_alley_call", "address_road_call", "address_district_id_call", "address_amphur_id_call", "address_province_id_call", "address_postcode_call", "address_ref_emp_id", "address_ref_admin_id", "address_submit_date" }; string[] Value = { address_id, address_num, address_moo, address_type, address_name, address_alley, address_road, address_district_id, address_amphur_id, address_province_id, address_postcode, address_num_call, address_moo_call, address_type_call, address_name_call, address_alley_call, address_road_call, address_district_id_call, address_amphur_id_call, address_province_id_call, address_postcode_call, address_ref_emp_id, "1", DateTime.Now.ToString("yyyy-MM-dd") }; dbl.insert(table, Columns, Value); }