public IActionResult ConsultarPorId([FromBody] ConsultaZonaPorIdRequestDTO request)
{
Guid guid = Guid.NewGuid();
_log.RegistrarEvento($"{guid.ToString()}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(request)}");
ConsultaZonaPorIdResponseDTO response = new ConsultaZonaPorIdResponseDTO();
try
{
ConsultaZonaPorIdBE consultaZonaPorIdBE = _ZonaService.ConsultarZonaPorId(request);
response.Result.Data = consultaZonaPorIdBE;
string distrito = consultaZonaPorIdBE.DistritoId;
string departamento = distrito.Remove(distrito.Length - 3) + "000";
string provincia = distrito.Remove(distrito.Length - 2) + "00";
consultaZonaPorIdBE.DepartamentoId = departamento;
consultaZonaPorIdBE.ProvinciaId = provincia;
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 ConsultaZonaPorIdBE ConsultarZonaPorId(int ZonaId)
{
ConsultaZonaPorIdBE itemBE = null;
var parameters = new DynamicParameters();
parameters.Add("@ZonaId", ZonaId);
using (IDbConnection db = new SqlConnection(_connectionString.Value.CoffeeConnectDB))
{
var list = db.Query <ConsultaZonaPorIdBE>("uspZonaConsultaPorIdZona", parameters, commandType: CommandType.StoredProcedure);
if (list.Any())
{
itemBE = list.First();
}
}
return(itemBE);
}
