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); }