public void selectFamily(string person) { personal_familyModel fm = new personal_familyModel(); districtModel dis = new districtModel(); amphurModel amp = new amphurModel(); provinceModel prov = new provinceModel(); fm.selectFamilyPerson(person); ViewData["d_name"] = fm.fam_name_dad; ViewData["d_last"] = fm.fam_lastname_dad; ViewData["d_age"] = fm.fam_age_dad; ViewData["d_num"] = fm.fam_num_dad; ViewData["d_moo"] = fm.fam_moo_dad; ViewData["d_province"] = prov.selectProvince_forEdit(fm.fam_province_dad); ViewData["d_amphur"] = amp.select_amphur_forEdit(fm.fam_amphur_dad); ViewData["d_district"] = dis.select_district_forEdit(fm.fam_district_dad); ViewData["d_postcode"] = fm.fam_postcode_dad; ViewData["d_tel"] = fm.fam_tel_dad; ViewData["d_mobile"] = fm.fam_mobile_dad; ViewData["d_province_name"] = fm.province_name_dad; ViewData["d_amphur_name"] = fm.amphur_name_dad; ViewData["d_district_name"] = fm.district_name_dad; ViewData["m_name"] = fm.fam_name_mom; ViewData["m_last"] = fm.fam_lastname_mom; ViewData["m_age"] = fm.fam_age_mom; ViewData["m_num"] = fm.fam_num_mom; ViewData["m_moo"] = fm.fam_moo_mom; ViewData["m_province"] = prov.selectProvince_forEdit(fm.fam_province_mom); ViewData["m_amphur"] = amp.select_amphur_forEdit(fm.fam_amphur_mom); ViewData["m_district"] = dis.select_district_forEdit(fm.fam_district_mom); ViewData["m_postcode"] = fm.fam_postcode_mom; ViewData["m_tel"] = fm.fam_tel_mom; ViewData["m_mobile"] = fm.fam_mobile_mom; ViewData["m_province_name"] = fm.province_name_mom; ViewData["m_amphur_name"] = fm.amphur_name_mom; ViewData["m_district_name"] = fm.district_name_mom; ViewData["h_name"] = fm.fam_name_marry; ViewData["h_last"] = fm.fam_lastname_marry; ViewData["h_age"] = fm.fam_age_marry; ViewData["h_num"] = fm.fam_num_marry; ViewData["h_moo"] = fm.fam_moo_marry; ViewData["h_province"] = prov.selectProvince_forEdit(fm.fam_province_marry); ViewData["h_amphur"] = amp.select_amphur_forEdit(fm.fam_amphur_marry); ViewData["h_district"] = dis.select_district_forEdit(fm.fam_district_marry); ViewData["h_postcode"] = fm.fam_postcode_marry; ViewData["h_tel"] = fm.fam_tel_marry; ViewData["h_mobile"] = fm.fam_mobile_marry; ViewData["h_province_name"] = fm.province_name_marry; ViewData["h_amphur_name"] = fm.amphur_name_marry; ViewData["h_district_name"] = fm.district_name_marry; }
public IActionResult editFamily(string person_id, string dad_name, string dad_lastname, string dad_age, string dad_num, string dad_moo, string dad_province, string dad_amphur, string dad_district, string dad_postcode, string dad_tel, string dad_mobile, string mom_name, string mom_lastname, string mom_age, string mom_num, string mom_moo, string mom_province, string mom_amphur, string mom_district, string mom_postcode, string mom_tel, string mom_mobile, string mar_name, string mar_lastname, string mar_age, string mar_num, string mar_moo, string mar_province, string mar_amphur, string mar_district, string mar_postcode, string mar_tel, string mar_mobile) { personal_familyModel fm = new personal_familyModel(); fm.selectFamilyPerson(person_id); fm.insertFamilyLOG(); fm.fam_name_dad = dad_name; fm.fam_lastname_dad = dad_lastname; fm.fam_age_dad = dad_age; fm.fam_num_dad = dad_num; fm.fam_moo_dad = dad_moo; fm.fam_province_dad = dad_province; fm.fam_amphur_dad = dad_amphur; fm.fam_district_dad = dad_district; fm.fam_postcode_dad = dad_postcode; fm.fam_tel_dad = dad_tel; fm.fam_mobile_dad = dad_mobile; fm.fam_name_mom = mom_name; fm.fam_lastname_mom = mom_lastname; fm.fam_age_mom = mom_age; fm.fam_num_mom = mom_num; fm.fam_moo_mom = mom_moo; fm.fam_province_mom = mom_province; fm.fam_amphur_mom = mom_amphur; fm.fam_district_mom = mom_district; fm.fam_postcode_mom = mom_postcode; fm.fam_tel_mom = mom_tel; fm.fam_mobile_mom = mom_mobile; fm.fam_name_marry = mar_name; fm.fam_lastname_marry = mar_lastname; fm.fam_age_marry = mar_age; fm.fam_num_marry = mar_num; fm.fam_moo_marry = mar_moo; fm.fam_province_marry = mar_province; fm.fam_amphur_marry = mar_amphur; fm.fam_district_marry = mar_district; fm.fam_postcode_marry = mar_postcode; fm.fam_tel_marry = mar_tel; fm.fam_mobile_marry = mar_mobile; fm.updateFamily(); 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()); }
//[HttpPost] //public IActionResult Family(string d_name, string d_last, string d_age, string d_num, string d_moo, string d_pro, string d_amp, string d_dis, string d_post, string d_tel, string d_mo, string m_name, string m_last, string m_age, string m_num, string m_moo, string m_pro, string m_amp, string m_dis, string m_post, string m_tel, string m_mo, string ma_name, string ma_last, string ma_age, string ma_num, string ma_moo, string ma_pro, string ma_amp, string ma_dis, string ma_post, string ma_tel, string ma_mo, string person) { public string Family(string dad_name, string dad_lastname, string dad_age, string dad_num, string dad_moo, string dadProvince, string dad_amphur, string dad_district, string dad_postcode, string dad_tel, string dad_mobile, string mom_name, string mom_lastname, string mom_age, string mom_num, string mom_moo, string mom_province, string mom_amphur, string mom_district, string mom_postcode, string mom_tel, string mom_mobile, string mar_name, string mar_lastname, string mar_age, string mar_num, string mar_moo, string mar_province, string mar_amphur, string mar_district, string mar_postcode, string mar_tel, string mar_mobile, string person) { personal_familyModel fm = new personal_familyModel(); fm.fam_name_dad = dad_name; fm.fam_lastname_dad = dad_lastname; fm.fam_age_dad = dad_age; fm.fam_num_dad = dad_num; fm.fam_moo_dad = "0"; //dad_moo; fm.fam_province_dad = dadProvince; fm.fam_amphur_dad = "1"; //dad_amphur; fm.fam_district_dad = "1"; //dad_district; fm.fam_postcode_dad = dad_postcode; fm.fam_tel_dad = dad_tel; fm.fam_mobile_dad = dad_mobile; // fm.fam_name_mom = mom_name; fm.fam_lastname_mom = mom_lastname; fm.fam_age_mom = mom_age; fm.fam_num_mom = mom_num; fm.fam_moo_mom = mom_moo; fm.fam_province_mom = mom_province; fm.fam_amphur_mom = "1"; // mom_amphur; fm.fam_district_mom = "1"; //mom_district; fm.fam_postcode_mom = mom_postcode; fm.fam_tel_mom = mom_tel; fm.fam_mobile_mom = mom_mobile; // fm.fam_name_marry = mar_name; fm.fam_lastname_marry = mar_lastname; fm.fam_age_marry = mar_age; fm.fam_num_marry = mar_num; fm.fam_moo_marry = mar_moo; fm.fam_province_marry = mar_province; fm.fam_amphur_marry = "1"; //mar_amphur; fm.fam_district_marry = "1"; // mar_district; fm.fam_postcode_marry = mar_postcode; fm.fam_tel_marry = mar_tel; fm.fam_mobile_marry = mar_mobile; fm.person_id = person; fm.insertFamily(); string aa = "-" + fm.fam_name_dad + "-" + fm.fam_lastname_dad + "-" + fm.fam_age_dad + "-" + fm.fam_num_dad + "-" + fm.fam_moo_dad + "-" + fm.fam_province_dad + "-" + fm.fam_amphur_dad + "-" + fm.fam_district_dad + "-" + fm.fam_postcode_dad + "-" + fm.fam_tel_dad + "-" + fm.fam_mobile_dad + "-" + fm.fam_name_mom + "-" + fm.fam_lastname_mom + "-" + fm.fam_age_mom + "-" + fm.fam_num_mom + "-" + fm.fam_moo_mom + "-" + fm.fam_province_mom + "-" + fm.fam_amphur_mom + "-" + fm.fam_district_mom + "-" + fm.fam_postcode_mom + "-" + fm.fam_tel_mom + "-" + fm.fam_mobile_mom + "-" + fm.fam_name_marry + "-" + fm.fam_lastname_marry + "-" + fm.fam_age_marry + "-" + fm.fam_num_marry + "-" + fm.fam_moo_marry + "-" + fm.fam_province_marry + "-" + fm.fam_amphur_marry + "-" + fm.fam_district_marry + "-" + fm.fam_postcode_marry + "-" + fm.fam_tel_marry + "-" + fm.fam_mobile_marry + "-" + fm.person_id; return(aa); }