public string Kid(int num, string name, string lastname, string age, string status, string level, string school, string person)
{
string[] res_name = name.Split('^');
string[] res_lastname = lastname.Split('^');
string[] res_age = age.Split('^');
string[] res_status = status.Split('^');
string[] res_level = level.Split('^');
string[] res_school = level.Split('^');
int lentg = res_name.Length;
personal_kidModel k = new personal_kidModel();
for (int i = 0; i < num; i++)
{
k.kid_name = res_name[i];
k.kid_lastname = res_lastname[i];
k.kid_age = res_age[i];
k.kid_study_status = res_status[i];
k.kid_study_level = res_level[i];
k.kid_study_school = res_school[i];
k.kid_ref_personal_id = person;
k.insertKid();
}
//
return("ok");
}
public IActionResult addKid(string kid_num, string person_id, IEnumerable <string> kid_name, IEnumerable <string> kid_lastname, IEnumerable <string> kid_age, IEnumerable <string> kid_status, IEnumerable <string> kid_level, IEnumerable <string> kid_school)
{
personal_kidModel kid = new personal_kidModel();
List <string> name = new List <string>();
List <string> lastname = new List <string>();
List <string> age = new List <string>();
List <string> status = new List <string>();
List <string> level = new List <string>();
List <string> school = new List <string>();
string txt_s = "";
foreach (var txt in kid_name)
{
name.Add(txt);
}
foreach (var txt in kid_lastname)
{
lastname.Add(txt);
}
foreach (var txt in kid_age)
{
age.Add(txt);
}
for (int i = 0; i < Convert.ToInt32(kid_num); i++)
{
status.Add(Request.Form["kid_status" + i]);
}
foreach (var txt in kid_level)
{
level.Add(txt);
}
foreach (var txt in kid_school)
{
school.Add(txt);
}
for (int i = 0; i < Convert.ToInt32(kid_num); i++)
{
kid.kid_name = name[i];
kid.kid_lastname = lastname[i];
kid.kid_age = age[i];
kid.kid_study_status = status[i];
kid.kid_study_level = level[i];
kid.kid_study_school = school[i];
kid.kid_ref_personal_id = person_id;
kid.insertKid();
}
return(RedirectToAction("editPersonal", "Personal", new { person = person_id }));
}
public IActionResult editKid(string person_id, string k_id, string k_name, string k_lastname, string k_age, string num_i, string k_level, string k_school)
{
string status = Request.Form["study_" + num_i];
personal_kidModel kid = new personal_kidModel();
kid.kid_ref_personal_id = person_id;
kid.select_from_kidId(k_id);
kid.insertKidLOG();
kid.kid_name = k_name;
kid.kid_lastname = k_lastname;
kid.kid_age = k_age;
kid.kid_study_status = status;
kid.kid_study_level = k_level;
kid.kid_study_school = k_school;
kid.updateKid();
return(RedirectToAction("editPersonal", "Personal", new { person = person_id }));
}
public IActionResult emp(string code, string txt)
{
code_test = code;
personalModel ps = new personalModel();
ViewData["person_edit"] = ps.personal_for_edit();
info_positionModel posi = new info_positionModel();
companyModel comp = new companyModel();
sectionModel sect = new sectionModel();
departmentModel dep = new departmentModel();
emp_typeModel type = new emp_typeModel();
ViewData["position_dropdown"] = posi.dropDownPosition();
ViewData["company"] = comp.drop_company();
ViewData["section"] = sect.drop_section();
ViewData["department"] = dep.drop_dep();
ViewData["type"] = type.dropdown_type();
info_prefixModels prefix = new info_prefixModels();
info_statusModel status = new info_statusModel();
personal_studyModel study = new personal_studyModel();
ViewData["prefix_th"] = prefix.select_prefixTH();
ViewData["prefix_en"] = prefix.select_prefixEN();
ViewData["type_emp"] = type.dropdown_type();
ViewData["status"] = status.dropdown_status();
//view employee//
view_employeeModel emp = new view_employeeModel();
emp.selectData(code);
ViewData["emp_id"] = code;
ViewData["emp_code"] = emp.ep_code;
ViewData["emp_name_th"] = emp.prefix_name_en + " " + emp.ps_name_th + " " + emp.ps_lastname_th;
ViewData["emp_name_en"] = emp.prefix_name_en + " " + emp.ps_name_en + " " + emp.ps_lastname_en;
ViewData["emp_type"] = emp.type_name;
ViewData["emp_status"] = emp.ep_status;
ViewData["emp_start_date"] = emp.ep_start;
ViewData["emp_end_date"] = emp.ep_end;
ViewData["emp_email"] = emp.contact_email;
ViewData["emp_table"] = emp.contact_table;
ViewData["emp_phone"] = emp.contact_phone;
ViewData["emp_mobile1"] = emp.contact_mobile1;
ViewData["emp_mobile2"] = emp.contact_mobile2;
ViewData["position_name"] = emp.post_name;
ViewData["position_type"] = emp.type_name;
ViewData["position_dept"] = emp.dept_name;
ViewData["position_sect"] = emp.Section_name;
ViewData["position_comp"] = emp.T_Company;
ViewData["gender"] = emp.ps_gender;
ViewData["age"] = Convert.ToInt32((DateTime.Now.Year)) - Convert.ToInt32((Convert.ToDateTime(emp.ps_birthday).Year));
ViewData["nationality"] = emp.ps_nationality;
ViewData["race"] = emp.ps_race;
ViewData["religion"] = emp.ps_religion;
ViewData["blood"] = emp.ps_blood;
ViewData["birthday"] = Convert.ToDateTime(emp.ps_birthday).ToString("dd MMMM yyyy");
ViewData["birthday_format"] = Convert.ToDateTime(emp.ps_birthday).ToString("dd/MM/yyyy");
ViewData["identification"] = emp.ps_national_id;
ViewData["date_issue"] = emp.ps_national_date_start;
ViewData["expired_date"] = emp.ps_national_date_end;
ViewData["marital"] = emp.ps_status_marital;
ViewData["emp_person_id"] = emp.ep_ref_personal_id;
ViewData["type_"] = type.dropdown_type_id(emp.ep_ref_type_id);
emp_positionModel posit = new emp_positionModel();
ViewData["position"] = posit.emp_position_list(code);
//
/// address
dataAddress(code);
///
// study
ViewData["data_study"] = study.tb_study(code);
//
// work
personal_workModel work = new personal_workModel();
ViewData["data_work"] = work.tb_work(code);
//
// train
personal_trainModel train = new personal_trainModel();
ViewData["data_train"] = train.tb_train(code);
//
// family
personal_familyModel fam = new personal_familyModel();
fam.get_family(code);
ViewData["dad_name"] = fam.fam_name_dad + " " + fam.fam_lastname_dad;
ViewData["dad_age"] = fam.fam_age_dad;
ViewData["dad_tel"] = fam.fam_tel_dad;
ViewData["dad_mobile"] = fam.fam_mobile_dad;
ViewData["dad_address"] = fam.fam_num_dad + " หมู่ " + fam.fam_moo_dad + " " + fam.fam_district_dad + ", " + fam.fam_amphur_dad + ", " + fam.fam_province_dad + " " + fam.fam_postcode_dad;
ViewData["mom_name"] = fam.fam_name_mom + " " + fam.fam_lastname_mom;
ViewData["mom_age"] = fam.fam_age_mom;
ViewData["mom_tel"] = fam.fam_tel_mom;
ViewData["mom_mobile"] = fam.fam_mobile_mom;
ViewData["mom_address"] = fam.fam_num_mom + " หมู่ " + fam.fam_moo_mom + " " + fam.fam_district_mom + ", " + fam.fam_amphur_mom + ", " + fam.fam_province_mom + " " + fam.fam_postcode_mom;
ViewData["marry_name"] = fam.fam_name_marry + " " + fam.fam_lastname_marry;
ViewData["marry_age"] = fam.fam_age_marry;
ViewData["marry_tel"] = fam.fam_tel_marry;
ViewData["marry_mobile"] = fam.fam_mobile_marry;
ViewData["marry_address"] = fam.fam_num_marry + " หมู่ " + fam.fam_moo_marry + " " + fam.fam_district_marry + ", " + fam.fam_amphur_marry + ", " + fam.fam_province_marry + " " + fam.fam_postcode_marry;
//
// child
personal_kidModel child = new personal_kidModel();
ViewData["data_child"] = child.tb_kid(code);
//
/// income
checkPay(code);
select_income();
///
/// minus
minus();
minusSalary(code);
///
/// fund
fund(code);
empFundResign fn = new empFundResign();
empFundChange fc = new empFundChange();
ViewData["fundResign"] = fn.list_fundResignEmp(code);
ViewData["fundChange"] = fc.list_fundChange_emp(code);
///
/// commend
commend(code);
///
/// admonish
admonish(code);
///
////
provinceModel province = new provinceModel();
ViewData["province"] = province.selectProvince();
amphurModel amphur = new amphurModel();
ViewData["amphur"] = amphur.select_amphur();
districtModel district = new districtModel();
ViewData["district"] = district.select_district();
//profile img
empModel em = new empModel();
em.check_img(code);
if (string.IsNullOrEmpty(em.img_name) == true)
{
ViewData["profile_img"] = "../../profile/face-2.jpg";
}
else
{
ViewData["profile_img"] = "../../profile/" + em.img_name;
}
empPositionChangeModel pc = new empPositionChangeModel();
pc.pc_emp_id = code;
ViewData["data_change_position"] = pc.list_posiotnChane_emp_id();
EmpPositionResignModel rs = new EmpPositionResignModel();
ViewData["data_resign_position"] = rs.list_position_resign_emp(code);
return(View());
}
public void select_kid(string person)
{
personal_kidModel kid = new personal_kidModel();
ViewData["data_kid"] = kid.tb_kid_person(person);
}