public void position(string emp) { emp_positionModel pos = new emp_positionModel(); ViewData["check_position"] = pos.checkCount(emp); pos.selectPositionByemp(emp); ViewData["position_name"] = pos.pos_position_name; ViewData["position_comp"] = pos.pos_comp_name; ViewData["position_sect"] = pos.pos_sect_name; ViewData["position_dept"] = pos.pos_dept_name; ViewData["position_type"] = pos.pos_type_name; info_positionModel post = new info_positionModel(); ViewData["drop_position"] = post.dropDownPosition(); emp_typeModel type = new emp_typeModel(); ViewData["drop_type"] = type.dropdown_type(); companyModel comp = new companyModel(); ViewData["company"] = comp.drop_company(); sectionModel sect = new sectionModel(); ViewData["section"] = sect.drop_section(); departmentModel dept = new departmentModel(); ViewData["department"] = dept.drop_dep(); }
public IActionResult editPosition(string emp_id, string position_id, string position_edit, string section_edit, string type_edit, string start_edit, string company_edit, string end_edit, string deptEdit) { emp_positionModel pos = new emp_positionModel(); pos.pos_emp_id = emp_id; pos.pos_id = position_id; pos.selectPositionById(position_id); pos.insert_positionLOG(); pos.pos_position_id = position_edit; pos.pos_type = type_edit; pos.pos_comp_id = company_edit; pos.pos_sect_id = section_edit; pos.pos_dept_id = deptEdit; pos.pos_resign_date = end_edit; pos.pos_start_date = start_edit; pos.event_status = "U"; pos.update_position(); return(RedirectToAction("emp", "Employee", new { code = emp_id })); }
public string change_main(string emp, string position) { emp_positionModel ps = new emp_positionModel(); //old id ps.pos_emp_id = emp; ps.check_position_main(); ps.selectPositionById(ps.pos_id); ps.insert_positionLOG(); //update old to N ps.pos_active = "N"; ps.update_position(); //new id ps.pos_id = position; ps.selectPositionById(position); ps.insert_positionLOG(); //update new to Y ps.pos_active = "Y"; ps.update_position(); return(ps.pos_id); }
public IActionResult insert_position_resign(string emp_id, string prs_type, string prs_detail, string prs_date_resign, string prs_ref_emp_position_id) { emp_positionModel ps = new emp_positionModel(); ps.selectPositionById(prs_ref_emp_position_id); ps.insert_positionLOG(); EmpPositionResignModel prs = new EmpPositionResignModel(); prs.prs_ref_emp_posit_id = prs_ref_emp_position_id; prs.prs_ref_emp_id = emp_id; prs.prs_position_id = ps.pos_position_id; prs.prs_comp_id = ps.pos_comp_id; prs.prs_section_id = ps.pos_sect_id; prs.prs_dept_id = ps.pos_dept_id; prs.prs_type = ps.pos_type; prs.prs_start_date = ps.pos_start_date; prs.prs_resign_date = prs_date_resign; prs.prs_resign_type = prs_type; prs.prs_resign_detail = prs_detail; prs.insert_resign_position(); ps.pos_id = prs_ref_emp_position_id; ps.pos_resign_date = prs_date_resign; ps.event_status = "U"; ps.pos_status = "N"; ps.update_position(); return(RedirectToAction("emp", "Employee", new { code = emp_id })); }
public string getdataForEdit(string id) { emp_positionModel post = new emp_positionModel(); post.selectPositionById(id); return(post.pos_position_id + "^" + post.pos_comp_id + "^" + post.pos_sect_id + "^" + post.pos_dept_id + "^" + post.pos_type + "^" + post.pos_start_date + "^" + post.pos_resign_date + "^" + post.pos_id); }
public IActionResult addEmp(string ps_id, string type, string start, string position, string company, string txtsection, string txtdepartment) { CultureInfo en = new CultureInfo("EN"); CultureInfo th = new CultureInfo("TH"); DateTime dt = new DateTime(3000, 01, 01); empModel em = new empModel(); em.ep_ref_personal_id = ps_id; em.ep_ref_type_id = type; em.ep_start = Convert.ToDateTime(start).ToString("yyyy-MM-dd", th); em.insertEmp(); /// emp_positionModel pos = new emp_positionModel(); pos.pos_emp_id = em.ep_id; pos.pos_position_id = position; pos.pos_type = type; pos.pos_comp_id = company; pos.pos_sect_id = txtsection; pos.pos_dept_id = txtdepartment; pos.pos_start_date = Convert.ToDateTime(start).ToString("yyyy-MM-dd", en); pos.pos_resign_date = Convert.ToDateTime(dt).ToString("yyyy-MM-dd", en); pos.insert_position(); // string txt = pos.pos_emp_id + "^" + pos.pos_position_id + "^" + pos.pos_type + "^" + pos.pos_comp_id + "^" + pos.pos_sect_id + "^" + pos.pos_dept_id +"^" + pos.pos_start_date + "^" + pos.pos_resign_date; view_employeeModel v_emp = new view_employeeModel(); v_emp.selectData(em.ep_id); DateTime date = new DateTime(3000, 01, 01); emp_actionModel emp_action = new emp_actionModel(); emp_action.emp_code = v_emp.ep_code; emp_action.emp_prefix_th = v_emp.prefix_name_th; emp_action.emp_name_th = v_emp.ps_name_th; emp_action.emp_lastname_th = v_emp.ps_lastname_th; emp_action.emp_national_id = v_emp.ps_national_id; emp_action.emp_full_name = v_emp.ps_name_full; emp_action.emp_type_name = v_emp.type_name; emp_action.emp_start_date = Convert.ToDateTime(v_emp.ep_start).ToString("yyyy-MM-dd", en); emp_action.emp_end_date = date.ToString(); emp_action.emp_salary = ""; emp_action.emp_stipend = ""; emp_action.emp_action_start = DateTime.Now.ToString("yyyy-MM-dd", en); emp_action.emp_action_end = date.ToString(); // emp_action.insert_emp_action(); return(RedirectToAction("emp", new { code = em.ep_id, startaction = emp_action.emp_action_start, empcode = emp_action.emp_code, prefix = emp_action.emp_prefix_th, name = emp_action.emp_name_th, last = emp_action.emp_lastname_th, national = emp_action.emp_national_id, full = emp_action.emp_full_name, type = emp_action.emp_type_name, start = emp_action.emp_start_date, end = emp_action.emp_end_date, action = emp_action.emp_action_start, endaction = emp_action.emp_action_end })); }
public IActionResult insertPosition(string emp_id, string position_id, string position_type, string position_comp, string position_sect, string position_dept) { emp_positionModel pos = new emp_positionModel(); pos.pos_emp_id = emp_id; pos.pos_position_id = position_id; pos.pos_type = position_type; pos.pos_comp_id = position_comp; pos.pos_sect_id = position_sect; pos.pos_dept_id = position_dept; pos.insert_position(); return(RedirectToAction("emp", "Employee", new { code = emp_id })); }
public void del_position(string id, string emp_id) { emp_positionModel pos = new emp_positionModel(); pos.pos_emp_id = emp_id; pos.pos_id = id; pos.selectPositionById(id); pos.insert_positionLOG(); pos.event_status = "D"; pos.update_position(); }
public IActionResult addPosition(string type, string start, string position, string company, string txtsection, string txtdepartment, string emp_id) { CultureInfo en = new CultureInfo("EN"); emp_positionModel pos = new emp_positionModel(); pos.pos_emp_id = emp_id; pos.pos_position_id = position; pos.pos_type = type; pos.pos_comp_id = company; pos.pos_sect_id = txtsection; pos.pos_dept_id = txtdepartment; pos.pos_start_date = Convert.ToDateTime(start).ToString("yyyy-MM-dd", en); pos.pos_resign_date = Convert.ToDateTime("3000-01-01").ToString("yyyy-MM-dd", en); pos.insert_position(); return(RedirectToAction("emp", new { code = emp_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 IActionResult insert_position_change(string position_ch, string company_ch, string section_ch, string dept_ch, string type_ch, string start_ch, string position_id_ch, string emp_id) { DateTime dt = new DateTime(3000, 01, 01); emp_positionModel pos = new emp_positionModel(); pos.pos_emp_id = emp_id; pos.pos_id = position_id_ch; pos.selectPositionById(position_id_ch); pos.insert_positionLOG(); pos.event_status = "U"; pos.pos_resign_date = Convert.ToDateTime(start_ch).ToString("yyyy-MM-dd"); pos.pos_start_date = start_ch; pos.update_position(); /// pos.pos_emp_id = emp_id; pos.pos_position_id = position_ch; pos.pos_type = type_ch; pos.pos_comp_id = company_ch; pos.pos_sect_id = section_ch; pos.pos_dept_id = dept_ch; pos.pos_start_date = start_ch; pos.pos_resign_date = Convert.ToDateTime(dt).ToString("yyyy-MM-dd"); pos.insert_position(); empPositionChangeModel pc = new empPositionChangeModel(); pc.pc_emp_id = emp_id; pc.pc_comp_id = company_ch; pc.pc_sect_id = section_ch; pc.pc_dept_id = dept_ch; pc.pc_position_id = position_ch; pc.pc_type = type_ch; pc.pc_start_date = start_ch; pc.pc_admin_id = "1"; pc.pc_status = "Y"; pc.pc_active = "Y"; pc.event_status = "S"; pc.pc_position_id_old = pos.pos_position_id; pc.pc_company_old = pos.pos_comp_id; pc.pc_section_old = pos.pos_sect_id; pc.pc_dept_old = pos.pos_dept_id; pc.pc_type_old = pos.pos_type; pc.pc_start_old = pos.pos_start_date; pc.pc_end_old = pos.pos_resign_date; pc.pc_ref_emp_position_id = position_id_ch; pc.insert_position_chane(); return(RedirectToAction("emp", "Employee", new { code = emp_id })); }