コード例 #1
0
        public async Task <IActionResult> ListarOperadora(IListarOperadoraSignature signature)
        {
            try
            {
                var result = await _operadoraApp.ListarOperadora(signature);

                if (result == null)
                {
                    return(null);
                }

                return(Ok(result));
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message.ToString());
            }
        }
コード例 #2
0
        public async Task <IList <ListarOperadoraResult> > ListarOperadora(IListarOperadoraSignature signature)
        {
            using (SqlConnection conn = new SqlConnection(ConnectionStringManager.Value))
            {
                try
                {
                    var parameters = new DynamicParameters();
                    parameters.Add("@Cnpj", signature.Cnpj);
                    parameters.Add("@RazaoSocial", signature.RazaoSocial);

                    var result = await conn.QueryAsync <ListarOperadoraResult>("GetOperadora", parameters, null, null, CommandType.StoredProcedure);

                    conn.Close();
                    return(result.ToList());
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message.ToString());
                }
            }
        }
コード例 #3
0
 public async Task <IList <ListarOperadoraResult> > ListarOperadora(IListarOperadoraSignature signature)
 {
     return(await _operadoraRepositorio.ListarOperadora(signature));
 }