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 string insert_contact_log()
{
databaseClassLOG dbClass = new databaseClassLOG();
dbFile db = new dbFile();
string txt = "";
using (SqlConnection conn = new SqlConnection(db.sqlConnection_log)) {
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO tab_emp_contact(contact_id, contact_email, contact_table, contact_phone, contact_mobile1, contact_mobile2, contact_emp_id, contact_admin_id, contact_submit_date, contact_status) VALUES(@contact_id, @contact_email, @contact_table, @contact_phone, @contact_mobile1, @contact_mobile2, @contact_emp_id, @contact_admin_id, @contact_submit_date, @contact_status)", conn);
cmd.Parameters.AddWithValue("@contact_id", contact_id);
cmd.Parameters.AddWithValue("@contact_email", contact_email);
cmd.Parameters.AddWithValue("@contact_table", contact_table);
cmd.Parameters.AddWithValue("@contact_phone", contact_phone);
cmd.Parameters.AddWithValue("@contact_mobile1", contact_mobile1);
cmd.Parameters.AddWithValue("@contact_mobile2", contact_mobile2);
cmd.Parameters.AddWithValue("@contact_emp_id", contact_emp_id);
cmd.Parameters.AddWithValue("@contact_admin_id", contact_admin_id);
cmd.Parameters.AddWithValue("@contact_submit_date", Convert.ToDateTime(contact_submit_date).ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@contact_status", contact_status);
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
return(txt);
}
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_positionLOG()
{
databaseClassLOG dbl = new databaseClassLOG();
string table = "tab_emp_position";
string[] Columns = { "position_id", "position_emp_id", "position_comp_id", "position_sect_id", "position_dept_id", "position_posit_id", "position_type", "position_start_date", "position_resign_date", "position_admin_id", "position_submit_date", "position_status", "position_active", "event_status" };
string[] Value = { pos_id, pos_emp_id, pos_comp_id, pos_sect_id, pos_dept_id, pos_position_id, pos_type, Convert.ToDateTime(pos_start_date).ToString("yyyy-MM-dd", en), Convert.ToDateTime(pos_resign_date).ToString("yyyy-MM-dd", en), pos_emp_id, Convert.ToDateTime(pos_submit_date).ToString("yyyy-MM-dd HH:mm:ss", en), pos_status, pos_active, event_status };
dbl.insert_db(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 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 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 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);
}
