// GET: /<controller>/ public IActionResult Index() { info_prefixModels prefix = new info_prefixModels(); info_statusModel status = new info_statusModel(); emp_typeModel type = new emp_typeModel(); personalModel ps = new personalModel(); info_positionModel posi = new info_positionModel(); companyModel comp = new companyModel(); sectionModel sect = new sectionModel(); departmentModel dep = new departmentModel(); view_employeeModel emp = new view_employeeModel(); ViewData["prefix_th"] = prefix.select_prefixTH(); ViewData["prefix_en"] = prefix.select_prefixEN(); ViewData["type"] = type.dropdown_type(); ViewData["status"] = status.dropdown_status(); ViewData["national_id"] = ps.national(); ViewData["personal_name"] = ps.personal(); ViewData["position"] = posi.dropDownPosition(); ViewData["company"] = comp.drop_company(); ViewData["section"] = sect.drop_section(); ViewData["department"] = dep.drop_dep(); ViewData["emp_data"] = emp.emp_data(); ViewData["option_position"] = posi.positionList(); ViewData["option_department"] = dep.deptList(); ViewData["option_section"] = sect.sectList(); ViewData["option_company"] = comp.compList(); ViewData["option_status"] = status.statusList(); ViewData["option_type"] = type.typeList(); HttpContext.Session.SetString("empTab", ""); return(View()); }
public IActionResult updatePerson(string person_id, string prefix_th, string name_th, string lastname_th, string prefix_en, string name_en, string lastname_en, string gender, string blood, string national_id, string national_start, string national_end, string birthday, string age, string nationality, string race, string religion, string marital) { personalModel ps = new personalModel(); ps.select_personal(person_id); ps.insertPersonalLOG(); ps.personal_id = person_id; ps.prefix_th = prefix_th; ps.name_th = name_th; ps.lastname_th = lastname_th; ps.prefix_en = prefix_en; ps.name_en = name_en; ps.lastname_en = lastname_en; ps.gender = gender; ps.blood = blood; ps.national_id = national_id; ps.national_start = national_start; ps.national_end = national_end; ps.birthday = birthday; ps.nationality = nationality; ps.race = race; ps.religion = religion; ps.marital = marital; ps.event_status = "U"; ps.updatePerson(); return(RedirectToAction("editPersonal", "Personal", new { person = person_id })); }
public string checkName(string name, string lastname) { personalModel ps = new personalModel(); return(ps.checkName(name, lastname)); }
// GET: /<controller>/ public IActionResult Index() { personalModel ps = new personalModel(); ViewData["data"] = ps.infoPersonal(); HttpContext.Session.SetString("tabClick", ""); return(View()); }
public IActionResult editPersonal(string person) { personalModel ps = new personalModel(); info_prefixModels px = new info_prefixModels(); ps.select_personal(person); ViewData["ps_id"] = ps.personal_id; ViewData["prefix_th"] = px.select_prefixTH_for_edit(ps.prefix_th); ViewData["prefix_en"] = px.select_prefixEN_for_edit(ps.prefix_en); ViewData["name_th"] = ps.name_th; ViewData["name_en"] = ps.name_en; ViewData["lastname_th"] = ps.lastname_th; ViewData["lastname_en"] = ps.lastname_en; ViewData["gender"] = ps.gender; ViewData["blood"] = ps.blood; ViewData["national_id"] = ps.national_id; ViewData["national_start"] = ps.national_start; ViewData["national_end"] = ps.national_end; ViewData["birthday"] = ps.birthday; ViewData["age"] = ps.age; ViewData["nationality"] = ps.nationality; ViewData["race"] = ps.race; ViewData["marital"] = ps.marital; ViewData["religion"] = ps.religion; selectAddressPerson(person); selectContact(person); selectFamily(person); select_kid(person); select_study(person); select_work(person); select_train(person); try { ViewData["test_step"] = HttpContext.Session.GetString("step").ToString(); } catch { ViewData["test_step"] = "false"; } personalChangeModel pc = new personalChangeModel(); pc.ch_ref_person_id = person; ViewData["person_change"] = pc.list_chane_name(); return(View()); }
//[HttpPost] public string insertPersonal(string prefix_th, string name_th, string lastname_th, string prefix_en, string name_en, string lastname_en, string gender, string blood, string national_id, string national_start, string national_end, string birthday, string age, string nationality, string race, string marital, string gion) { personalModel ps = new personalModel(); ps.prefix_th = prefix_th; ps.prefix_en = prefix_en; ps.name_th = name_th; ps.name_en = name_en; ps.lastname_th = lastname_th; ps.lastname_en = lastname_en; ps.gender = gender; ps.blood = blood; ps.national_id = national_id; ps.national_start = national_start; ps.national_end = national_end; ps.birthday = birthday; ps.nationality = nationality; ps.race = race; ps.religion = gion; ps.marital = marital; ps.insertPersonal(); DateTime dt = new DateTime(3000, 01, 01); personalChangeModel pc = new personalChangeModel(); pc.ch_ref_prefix_id = prefix_th; pc.ch_ref_prefix_id_old = prefix_th; pc.ch_ref_person_id = ps.personal_id; pc.ch_name_th = name_th; pc.ch_name_th_old = name_th; pc.ch_name_en = name_en; pc.ch_name_en_old = name_en; pc.ch_lastname_th = lastname_th; pc.ch_lastname_th_old = lastname_th; pc.ch_lastname_en = lastname_en; pc.ch_lastname_en_old = lastname_en; pc.ch_start_date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); pc.ch_end_date = Convert.ToDateTime(dt).ToString("yyyy-MM-dd HH:mm:ss"); pc.insert_person_change(); return(ps.personal_id); }
public IActionResult viewPersonal(string person) { personalModel ps = new personalModel(); info_prefixModels px = new info_prefixModels(); ps.select_personal(person); ViewData["ps_id"] = ps.personal_id; ViewData["prefix_th"] = px.select_prefixTH_for_edit(ps.prefix_th); ViewData["prefix_en"] = px.select_prefixEN_for_edit(ps.prefix_en); ViewData["prefix_th_name"] = ps.prefix_th_name; ViewData["prefix_en_name"] = ps.prefix_en_name; ViewData["name_th"] = ps.name_th; ViewData["name_en"] = ps.name_en; ViewData["lastname_th"] = ps.lastname_th; ViewData["lastname_en"] = ps.lastname_en; ViewData["gender"] = ps.gender; ViewData["blood"] = ps.blood; ViewData["national_id"] = ps.national_id; ViewData["national_start"] = ps.national_start; ViewData["national_end"] = ps.national_end; ViewData["birthday"] = ps.birthday; ViewData["age"] = ps.age; ViewData["nationality"] = ps.nationality; ViewData["race"] = ps.race; ViewData["marital"] = ps.marital; ViewData["religion"] = ps.religion; selectAddressPerson(person); selectContact(person); selectFamily(person); select_kid(person); select_study(person); select_work(person); select_train(person); return(View()); }
public IActionResult update_person_profile(string emp_id, string gender_edit, string blood_edit, string national_id_edit, string national_start_edit, string national_end_edit, string birthday_edit, string age_edit, string nationality_edit, string race_edit, string religion_edit, string marital_edit) { personalModel ps = new personalModel(); ps.select_person_byEmp(emp_id); ps.insertPersonalLOG(); ps.gender = gender_edit; ps.blood = blood_edit; ps.national_id = national_id_edit; ps.national_start = national_start_edit; ps.national_end = national_end_edit; ps.birthday = birthday_edit; ps.age = age_edit; ps.nationality = nationality_edit; ps.race = race_edit; ps.religion = religion_edit; ps.marital = marital_edit; ps.updatePersonal(); return(RedirectToAction("emp", "Employee", new { code = emp_id })); }
public string getPerson(string id) { personalModel ps = new personalModel(); return(ps.getdata_personal(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 async Task <IActionResult> insert_change_name(IList <IFormFile> file, string prefix_th, string name_th, string lastname_th, string prefix_en, string name_en, string lastname_en, string person_id) { DateTime dt = new DateTime(3000, 01, 01); personalModel ps = new personalModel(); ps.select_personal(person_id); //person // personalChangeModel pc = new personalChangeModel(); pc.ch_ref_person_id = person_id; pc.select_max_id(); // if (pc.max_id != "N") { pc.ch_name_id = pc.max_id; pc.select_data_id(); pc.ch_end_date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); pc.event_status = "U"; pc.update_person_change(); } // pc.ch_ref_prefix_id_old = ps.prefix_th; pc.ch_name_th_old = ps.name_th; pc.ch_lastname_th_old = ps.lastname_th; pc.ch_name_en_old = ps.name_en; pc.ch_lastname_en_old = ps.lastname_en; pc.ch_ref_prefix_id = prefix_th; pc.ch_name_th = name_th; pc.ch_lastname_th = lastname_th; pc.ch_name_en = name_en; pc.ch_lastname_en = lastname_en; pc.ch_ref_person_id = person_id; pc.ch_start_date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); pc.ch_end_date = Convert.ToDateTime(dt).ToString("yyyy-MM-dd HH:mm:ss"); //change pc.insert_person_change(); // ps.event_status = "U"; ps.insertPersonalLOG(); //person ps.personal_id = person_id; ps.prefix_th = prefix_th; ps.name_th = name_th; ps.lastname_th = lastname_th; ps.prefix_en = prefix_en; ps.name_en = name_en; ps.lastname_en = lastname_en; //person ps.updatePerson(); // personFileModel pf = new personFileModel(); var uploads = Path.Combine(_hostingEnvironment.WebRootPath, "profile"); foreach (var fl in file) { if (fl.Length > 0) { pf.ch_file_ref_person_id = person_id; pf.ch_file_name = fl.FileName; pf.ch_ref_change_name_id = pc.turn_id; pf.insert_file(); var filePath = Path.Combine(uploads, fl.FileName); using (var fileStream = new FileStream(filePath, FileMode.Create)) { await fl.CopyToAsync(fileStream); } } } return(RedirectToAction("editPersonal", "Personal", new { person = person_id })); }
private bool CheckUser(string username, string password) { using (var client = new HttpClient()) { LoginModel anvandareAttKolla = new LoginModel { AnvandarNamn = username, Losenord = password }; client.BaseAddress = new Uri("http://193.10.202.74/inlogg/personals"); var response = client.PostAsJsonAsync("Login", anvandareAttKolla).Result; if (response.IsSuccessStatusCode) { string svarFrånInloggning = response.Content.ReadAsStringAsync().Result; if (svarFrånInloggning != "" && svarFrånInloggning != "0" && svarFrånInloggning != null) { return(true); } else { return(false); } Logger.Info("Misslyckad inloggning"); personalModel objektFrånWS = JsonConvert.DeserializeObject <personalModel>(svarFrånInloggning); if (objektFrånWS != null) { if (objektFrånWS.Behorighetniva == 2 || objektFrånWS.Behorighetniva == 3) { return(true); } else { return(false); } } else { return(false); } } else { return(false); } //Om svaret inte är IsSuccessStatusCode så kan vi inte godkänna inloggningen } //public personalModel hamtaUser(string AnvNamn, string Losenord) //{ // personalModel svarAnv = new personalModel(); // svarAnv.AnvandarNamn = AnvNamn; // svarAnv.Losenord = Losenord; // using (var client = new HttpClient()) { // client.BaseAddress = new Uri("http://193.10.202.74/inlogg/personals"); // var svar = client.PostAsJsonAsync("Login", svarAnv).Result; // if (svar.IsSuccessStatusCode) // { // var personalSvar = svar.Content.ReadAsStringAsync().Result; // svarAnv.Behorighetsniva = JsonConvert.DeserializeObject<personalModel>(personalSvar).Behorighetsniva; // } // return (svarAnv); // } }