Ejemplo n.º 1
0
        public string getData(string pos)
        {
            info_positionModel post = new info_positionModel();

            post.selectBYpost_id(pos);
            return(post.post_id + "^" + post.post_name + "^" + post.post_submit_date);
        }
Ejemplo n.º 2
0
        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();
        }
Ejemplo n.º 3
0
        // 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());
        }
Ejemplo n.º 4
0
        public IActionResult position()
        {
            info_positionModel post = new info_positionModel();

            ViewData["tab_position"] = post.tablePosition();

            return(View());
        }
Ejemplo n.º 5
0
        public IActionResult insertPosition(string position)
        {
            info_positionModel post = new info_positionModel();

            post.post_name = position;
            post.insertPosition();

            return(RedirectToAction("position"));
        }
Ejemplo n.º 6
0
        public void del_position(string id)
        {
            info_positionModel ps = new info_positionModel();

            ps.selectBYpost_id(id);

            ps.insertPositionLOG();
            ps.event_status = "D";

            ps.updatePosition();
        }
Ejemplo n.º 7
0
        public IActionResult editPosition(string position_id, string position_edit)
        {
            info_positionModel ps = new info_positionModel();

            ps.selectBYpost_id(position_id);

            ps.insertPositionLOG();
            ps.post_name    = position_edit;
            ps.event_status = "U";
            ps.updatePosition();

            return(RedirectToAction("position", "Information"));
        }
Ejemplo n.º 8
0
        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());
        }