コード例 #1
0
        public IActionResult editTrain(string person_id, string tr_id, string tr_title, string tr_location, string tr_start, string tr_end)
        {
            personal_trainModel t = new personal_trainModel();

            t.select_form_train(tr_id);
            t.insertTrainLOG();

            t.train_id       = tr_id;
            t.train_title    = tr_title;
            t.train_location = tr_location;
            t.train_start    = tr_start;
            t.train_end      = tr_end;

            t.updateTrain();

            return(RedirectToAction("editPersonal", "Personal", new { person = person_id }));
        }
コード例 #2
0
        public IActionResult addTrain(string person_id, IEnumerable <string> t_title, IEnumerable <string> t_location, IEnumerable <string> t_start, IEnumerable <string> t_end)
        {
            personal_trainModel tr = new personal_trainModel();

            int           len      = t_title.Count();
            List <string> title    = new List <string>();
            List <string> location = new List <string>();
            List <string> start    = new List <string>();
            List <string> end      = new List <string>();

            foreach (var txt in t_title)
            {
                title.Add(txt);
            }

            foreach (var txt in t_location)
            {
                location.Add(txt);
            }

            foreach (var txt in t_start)
            {
                start.Add(txt);
            }

            foreach (var txt in t_end)
            {
                end.Add(txt);
            }

            for (int i = 0; i < len; i++)
            {
                tr.train_ref_personal_id = person_id;
                tr.train_title           = title[i];
                tr.train_location        = location[i];
                tr.train_start           = start[i];
                tr.train_end             = end[i];

                tr.insertTrain();
            }



            return(RedirectToAction("editPersonal", "Personal", new { person = person_id }));
        }
コード例 #3
0
        public string Train(string title, string location, string start, string end, int num, string person)
        {
            string[] txt_title    = title.Split('^');
            string[] txt_location = location.Split('^');
            string[] txt_start    = start.Split('^');
            string[] txt_end      = end.Split('^');
            int      i            = 0;

            personal_trainModel tr = new personal_trainModel();

            for (i = 0; i < num; i++)
            {
                tr.train_title           = txt_title[i];
                tr.train_location        = txt_location[i];
                tr.train_start           = txt_start[i];
                tr.train_end             = txt_end[i];
                tr.train_ref_personal_id = person;

                tr.insertTrain();
            }

            return("ok");
        }
コード例 #4
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());
        }
コード例 #5
0
        public void select_train(string person)
        {
            personal_trainModel tr = new personal_trainModel();

            ViewData["data_train"] = tr.tb_train_person(person);
        }