Ejemplo n.º 1
0
        public void del_personChange(string id)
        {
            personalChangeModel ps = new personalChangeModel();

            ps.ch_name_id = id;
            ps.select_data_id();

            ps.insert_person_change_LOG();
            ps.event_status = "D";
            ps.update_person_change();
        }
Ejemplo n.º 2
0
        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 }));
        }