public IActionResult ConsultarPais()
        {
            Guid guid = Guid.NewGuid();
            // _log.RegistrarEvento($"{guid.ToString()}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(Str)}");

            ConsultaTablaDeTablasResponseDTO response = new ConsultaTablaDeTablasResponseDTO();

            try
            {
                List <ConsultaPaisBE> lista = _maestroService.ConsultarPais();

                response.Result.Data = lista.OrderBy(x => x.Descripcion).ToList();;

                response.Result.Success = true;
            }
            catch (ResultException ex)
            {
                response.Result = new Result()
                {
                    Success = true, ErrCode = ex.Result.ErrCode, Message = ex.Result.Message
                };
            }
            catch (Exception ex)
            {
                response.Result = new Result()
                {
                    Success = false, Message = "Ocurrio un problema en el servicio, intentelo nuevamente."
                };
                _log.RegistrarEvento(ex, guid.ToString());
            }

            //_log.RegistrarEvento($"{guid.ToString()}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(response)}");

            return(Ok(response));
        }
        public IActionResult ConsultarTablaDeTablas([FromBody] ConsultaTablaDeTablasRequestDTO request)
        {
            Guid guid = Guid.NewGuid();

            _log.RegistrarEvento($"{guid.ToString()}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(request)}");

            ConsultaTablaDeTablasResponseDTO response = new ConsultaTablaDeTablasResponseDTO();

            try
            {
                List <ConsultaDetalleTablaBE> lista = _maestroService.ConsultarDetalleTablaDeTablas(request.EmpresaId, request.Idioma);

                lista = lista.Where(a => a.CodigoTabla.Trim().Equals(request.CodigoTabla.Trim())).ToList();

                if (request.CodigoTabla.Equals("SensorialAtributos"))
                {
                    response.Result.Data = lista;
                }
                else if (request.CodigoTabla.Equals("IndicadorTostado"))
                {
                    response.Result.Data = lista;
                }
                else if (request.CodigoTabla.Equals("TiposCafeProcesado"))
                {
                    response.Result.Data = lista.OrderBy(x => x.Codigo).ToList();
                }
                else
                {
                    response.Result.Data = lista.OrderBy(x => x.Label).ToList();
                }
                response.Result.Success = true;
            }
            catch (ResultException ex)
            {
                response.Result = new Result()
                {
                    Success = true, ErrCode = ex.Result.ErrCode, Message = ex.Result.Message
                };
            }
            catch (Exception ex)
            {
                response.Result = new Result()
                {
                    Success = false, Message = "Ocurrio un problema en el servicio, intentelo nuevamente."
                };
                _log.RegistrarEvento(ex, guid.ToString());
            }

            _log.RegistrarEvento($"{guid.ToString()}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(response)}");

            return(Ok(response));
        }
        public IActionResult ConsultarProvincia([FromBody] ConsultaProvinciaRequestDTO request)
        {
            Guid guid = Guid.NewGuid();

            _log.RegistrarEvento($"{guid.ToString()}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(request)}");

            ConsultaTablaDeTablasResponseDTO response = new ConsultaTablaDeTablasResponseDTO();

            try
            {
                List <ConsultaUbigeoBE> lista = new List <ConsultaUbigeoBE>();

                if (!string.IsNullOrEmpty(request.CodigoDepartamento))
                {
                    lista = _maestroService.ConsultaUbibeo();
                    string prefijoDepartamento = !String.IsNullOrEmpty(request.CodigoDepartamento.ToString()) &&
                                                 request.CodigoDepartamento.Length >= 2 ? request.CodigoDepartamento.Substring(0, 2) : "-";

                    lista = lista.Where(a => a.CodigoPais == request.CodigoPais && a.Codigo.EndsWith("00") &&
                                        a.Codigo.StartsWith(prefijoDepartamento) &&
                                        !a.Codigo.EndsWith("0000"))
                            .ToList();

                    lista = lista.OrderBy(x => x.DescripcionPais).ToList();
                }

                response.Result.Data = lista;

                response.Result.Success = true;
            }
            catch (ResultException ex)
            {
                response.Result = new Result()
                {
                    Success = true, ErrCode = ex.Result.ErrCode, Message = ex.Result.Message
                };
            }
            catch (Exception ex)
            {
                response.Result = new Result()
                {
                    Success = false, Message = "Ocurrio un problema en el servicio, intentelo nuevamente."
                };
                _log.RegistrarEvento(ex, guid.ToString());
            }

            //_log.RegistrarEvento($"{guid.ToString()}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(response)}");

            return(Ok(response));
        }