public void insert_resign()
{
databaseClass db = new databaseClass();
string table = "tab_emp_resign";
string[] Columns =
{
"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_ref_emp_id,
re_emp_code,
re_type,
re_detail,
Convert.ToDateTime(re_resign_date).ToString("yyyy-MM-dd",en),
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", en),
"1",
"S"
};
db.insert(table, Columns, Value);
}
public void insertEmp()
{
countEmpforCode();
string table = "tab_employee";
string[] Columns = { "emp_code", "emp_prefix", "emp_name_th", "emp_lastname_th", "emp_prefix_en", "emp_name_en", "emp_lastname_en", "emp_status", "emp_type", "emp_start_date", "emp_admin_id", "emp_submit_date", "emp_end_date" };
string[] Value =
{
resultCode,
emp_prefix_th,
emp_name_th,
emp_lastname_th,
emp_prefix_en,
emp_name_en,
emp_lastname_en,
emp_status,
emp_type,
Convert.ToDateTime(emp_start_date).ToString("yyyy-MM-dd",EN),
"1",
DateTime.Now.ToString("yyyy-MM-ss HH:mm:ss", EN),
" "
};
emp_id = db.insert(table, Columns, Value);
}
public void insertEmp()
{
CultureInfo en = new CultureInfo("EN");
countEmpforCode();
DateTime dt = new DateTime(3000, 01, 01);
databaseClass db = new databaseClass();
string table = "tab_emp";
string[] Columns = { "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 =
{
resultCode,
ep_ref_personal_id,
ep_ref_type_id,
Convert.ToDateTime(ep_start).ToString("yyyy-MM-dd",en),
Convert.ToDateTime(dt).ToString("yyyy-MM-dd", en),
"Y",
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", en),
"1",
"S"
};
ep_id = db.insert(table, Columns, Value);
}
public void insert_type()
{
string table = "tab_emp_type";
string[] Columns = { "type_name", "type_submit_date", "type_admin_id", "event_status" };
string[] Value = { type_name, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", en), "1", "S" };
db.insert(table, Columns, Value);
}
public void insert_profile()
{
string table = "tab_emp_profile";
string[] Columns = { "profile_gender", "profile_birthday", "profile_age", "profile_nationality", "profile_race", "profile_religion", "profile_blood", "profile_identification", "profile_date_issue", "profile_expired_date", "profile_weigth", "profile_height", "profile_marital_status", "profile_child_num", "profile_emp_id", "profile_admin_id", "profile_submit_date", "profile_status" };
string[] Value = { profile_gender, profile_birthday, profile_age, profile_nationality, profile_race, profile_religion, profile_blood, profile_identification, profile_date_issue, profile_expired_date, profile_weight, profile_height, profile_marital_status, profile_child_num, profile_emp_id, "1", DateTime.Now.ToString("yyyy-MM-dd"), "OPEN" };
db.insert(table, Columns, Value);
}
public void insert_prefix()
{
string table = "tab_info_prefix";
string[] Columns = { "prefix_name_th", "prefix_name_en", "prefix_submit_date", "prefix_admin_id", "event_status" };
string [] Value = { name_th, name_en, DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss", en), "1", "S" };
db.insert(table, Columns, Value);
}
public void insertAddress()
{
string table = "tab_emp_address";
string[] Columns =
{
"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_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")
};
db.insert(table, Columns, Value);
}
public void insertStudy()
{
string table = "tab_emp_study";
string[] Columns = { "study_year", "study_education", "study_academy", "study_gpa", "study_emp_id", "study_admin_id", "study_submit_date" };
string[] Value = { study_year, study_education, study_academy, study_gpa, study_emp_id, "1", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", th) };
db.insert(table, Columns, Value);
}
public void insertKid()
{
databaseClass dbclass = new databaseClass();
string table = "tab_personal_kid";
string[] Columns = { "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_name, kid_lastname, kid_age, kid_study_status, kid_study_level, kid_study_school, kid_ref_personal_id, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "1" };
dbclass.insert(table, Columns, Value);
}
public void insertPersonal()
{
databaseClass db = new databaseClass();
string table = "tab_personal";
string[] Columns = { "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" };
string[] Value = { 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 };
personal_id = db.insert(table, Columns, Value);
}
public void insertTrain()
{
databaseClass dbclass = new databaseClass();
string table = "tab_personal_train";
string[] Columns = { "train_title", "train_location", "train_start", "train_end", "train_ref_personal_id", "train_submit_date", "train_ref_admin_id" };
string[] Value = { train_title, train_location, train_start, train_end, train_ref_personal_id, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "1" };
dbclass.insert(table, Columns, Value);
}
public void insert_img()
{
databaseClass dbc = new databaseClass();
string table = "tab_emp_profile_img";
string[] Columns = { "img_name", "img_ref_emp_id", "img_ref_person_id", "img_ref_admin_id", "img_submit_date" };
string[] Value = { img_name, img_ref_emp_id, img_ref_person_id, "1", Convert.ToDateTime(DateTime.Now).ToString("yyyy-MM-dd HH:mm:ss", en) };
dbc.insert(table, Columns, Value);
}
public void insert_emp_action()
{
databaseClass data = new databaseClass();
string table = "tab_emp_action";
string[] Columns = { "emp_code", "emp_prefix_th", "emp_name_th", "emp_lastname_th", "emp_national_id", "emp_full_name", "emp_type_name", "emp_start_date", "emp_end_date", "emp_salary", "emp_stipend", "emp_action_start", "emp_action_end", "event_status" };
string[] Value = { emp_code, emp_prefix_th, emp_name_th, emp_lastname_th, emp_national_id, emp_full_name, emp_type_name, DateTime.Now.ToString("yyyy-MM-dd", en), Convert.ToDateTime(emp_end_date).ToString("yyyy-MM-dd", en), emp_salary, emp_stipend, Convert.ToDateTime(emp_action_start).ToString("yyyy-MM-dd", en), Convert.ToDateTime(emp_action_end).ToString("yyyy-MM-dd", en), "S" };
data.insert(table, Columns, Value);
}
public void insert_file()
{
databaseClass dbc = new databaseClass();
string table = "tab_person_file";
string[] Columns = { "ch_file_name", "ch_file_ref_person_id", "ch_file_create_date", "ch_file_ref_admin_id", "event_status", "ch_ref_change_name_id" };
string[] Value = { ch_file_name, ch_file_ref_person_id, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "1", "S", ch_ref_change_name_id };
dbc.insert(table, Columns, Value);
}
public void insertWork()
{
databaseClass dbclass = new databaseClass();
string table = "tab_personal_work";
string[] Columns = { "work_company", "work_address", "work_start", "work_end", "work_position", "work_ref_personal_id", "work_submit_date", "work_ref_admin_id" };
string[] Value = { work_company, work_address, work_start, work_end, work_position, work_ref_personal_id, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "1" };
dbclass.insert(table, Columns, Value);
}
public string insert_contact()
{
string table = "tab_emp_contact";
string[] Columns = { "contact_email", "contact_table", "contact_phone", "contact_mobile1", "contact_mobile2", "contact_admin_id", "contact_submit_date", "contact_status", "contact_emp_id" };
string[] Value = { contact_email, contact_table, contact_phone, contact_mobile1, contact_mobile2, "1", DateTime.Now.ToString("yyyy-MM-dd"), "OPEN", contact_emp_id };
db.insert(table, Columns, Value);
return("");
}
public void insert_resign_LOG()
{
databaseClass db = new databaseClass();
string table = "tab_emp_position_resign";
string[] Columns = { "prs_id", "prs_ref_emp_posit_id", "prs_ref_emp_id", "prs_position_id", "prs_comp_id", "prs_section_id", "prs_dept_id", "prs_type", "prs_start_date", "prs_resign_date", "prs_submit_date", "prs_admin_id", "event_status", "prs_resign_type", "prs_resign_detail" };
string[] Value = { prs_id, prs_ref_emp_posit_id, prs_ref_emp_id, prs_position_id, prs_comp_id, prs_section_id, prs_dept_id, prs_type, Convert.ToDateTime(prs_start_date).ToString("yyyy-MM-dd", en), Convert.ToDateTime(prs_resign_date).ToString("yyyy-MM-dd", en), Convert.ToDateTime(prs_submit_date).ToString("yyyy-MM-dd HH:mm:ss", en), prs_admin_id, event_status, prs_resign_type, prs_resign_detail };
db.insert(table, Columns, Value);
}
public void insert_position_chane()
{
databaseClass db = new databaseClass();
string table = "tab_emp_position_change";
string[] Columns = { "pc_emp_id", "pc_comp_id", "pc_sect_id", "pc_dept_id", "pc_position_id", "pc_type", "pc_start_date", "pc_resign_date", "pc_admin_id", "pc_submit_date", "pc_status", "pc_active", "event_status", "pc_position_id_old", "pc_company_old", "pc_section_old", "pc_dept_old", "pc_type_old", "pc_start_old", "pc_end_old", "pc_ref_emp_position_id" };
string[] Value = { pc_emp_id, pc_comp_id, pc_sect_id, pc_dept_id, pc_position_id, pc_type, Convert.ToDateTime(pc_start_date).ToString("yyyy-MM-dd", en), Convert.ToDateTime(dt).ToString("yyyy-MM-dd", en), pc_admin_id, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", en), pc_status, pc_active, event_status, pc_position_id_old, pc_company_old, pc_section_old, pc_dept_old, pc_type_old, Convert.ToDateTime(pc_start_old).ToString("yyyy-MM-dd", en), Convert.ToDateTime(pc_end_old).ToString("yyyy-MM-dd", en), pc_ref_emp_position_id };
db.insert(table, Columns, Value);
}
public void insertStudy()
{
databaseClass dbclass = new databaseClass();
string table = "tab_personal_study";
string[] Columns = { "study_year", "study_academy", "study_gpa", "study_degree", "study_branch", "study_ref_personal_id", "study_submit_date", "study_ref_admin_id" };
string[] Value = { study_year, study_academy, study_gpa, study_degree, study_branch, study_ref_personal_id, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "1" };
dbclass.insert(table, Columns, Value);
}