public async Task <ObterCidResult> ObterCID(IObterCidSignature signature) { using (SqlConnection conn = new SqlConnection(ConnectionStringManager.Value)) { conn.Open(); try { var parameters = new DynamicParameters(); parameters.Add("@Codigo", signature.Codigo); parameters.Add("@Descricao", signature.Descricao); var result = await conn.QueryFirstOrDefaultAsync <ObterCidResult>("GetCid", parameters, null, null, CommandType.StoredProcedure); if (result != null) { result.SubCategorias = await ObterSubCategorias(result.Codigo); } conn.Close(); return(result); } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } } }
public async Task <IActionResult> ObterCid(IObterCidSignature signature) { try { var result = await _cidApp.ObterCID(signature); if (result == null) { result = new ObterCidResult(); } return(Ok(result)); } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
public async Task <ObterCidResult> ObterCID(IObterCidSignature signature) { return(await _cidRepositorio.ObterCID(signature)); }
public async Task <ObterCidResult> ObterCID(IObterCidSignature signature) { return(await _cidService.ObterCID(signature)); }