public List <DtoEmployee> ListEmployee(DtoEmployee emp)
        {
            Entities_Visit ctx;

            using (ctx = new Entities_Visit()) {
                List <DtoEmployee> list = new List <DtoEmployee>();
                DtoEmployee        objEmployee;
                try
                {
                    var query = ctx.PR_SEARCH_EMPLOYEE(emp.bemp_state, emp.iBra_buis_id);
                    foreach (var employee in query)
                    {
                        objEmployee                  = new DtoEmployee();
                        objEmployee.iEmp_id          = (int)employee.EMP_ID;
                        objEmployee.iRol_id          = (int)employee.ROL_ID;
                        objEmployee.sRol_name        = employee.ROL_NAME;
                        objEmployee.sEmp_document    = employee.EMP_DOCUMENT;
                        objEmployee.sEmp_name        = employee.EMP_NAME;
                        objEmployee.sEmp_surname     = employee.EMP_SURNAME;
                        objEmployee.sEmp_phone       = employee.EMP_PHONE;
                        objEmployee.sEmp_phone2      = employee.EMP_PHONE;
                        objEmployee.sEmp_cell_phone  = employee.EMP_CELL_PHONE;
                        objEmployee.sEmp_cell_phone2 = employee.EMP_CELL_PHONE2;
                        objEmployee.sEmp_addres      = employee.EMP_ADDRES;
                        objEmployee.sEmp_mail        = employee.EMP_MAIL;
                        objEmployee.sEmp_mail2       = employee.EMP_MAIL2;
                        objEmployee.sEmp_password    = employee.EMP_PASSWORD;
                        list.Add(objEmployee);
                    }
                    list.ToList();
                }
                catch (Exception e) {
                }
                return(list);
            }
        }