public Resposta <FotoLista> ListarImagens(int orc, string connectionString) { dapperContext.connection.ConnectionString = connectionString; Expression <Func <Foto, object> > predicate = c => c.Orc; this.response = this.Get(predicate, orc); var lista = new List <FotoLista>(); foreach (var foto in response.Data) { lista.Add(new FotoLista { Codigo = foto.Orc, DataInclusao = foto.Dt_Foto, NumeroFoto = foto.Numfot, Versao = foto.Versao }); } if (lista.Count > 0) { return(responseLista.SetData(lista, (int)eRespostaStatus.OK)); } else { return(responseLista.SetMessage("Esse orçamento não possui imagens", (int)eRespostaStatus.OK)); } }
public Resposta <HistoricoParecer> GetUserById(Guid userId, string conn) { try { dapperContext.connection.ConnectionString = conn; DynamicParameters parameters = new DynamicParameters(); parameters.Add("@idHistoricoParecer", userId); var dados = SqlMapper.Query <HistoricoParecer>(dapperContext.connection, "spr_listarParecer", parameters, commandType: CommandType.StoredProcedure).ToList(); response.SetData(dados, 0); } catch (Exception ex) { response.SetMessage("Erro ao Executar Proc", 1, ex); } return(response); }
public Resposta <CamposOrcamento> StoreProcedure(DynamicParameters parameters, string Proc) { try { var dados = SqlMapper.Query <CamposOrcamento>(dapperContext.connection, Proc, parameters, commandType: CommandType.StoredProcedure).ToList(); response.SetData(dados, 0); } catch (Exception ex) { response.SetMessage($"Erro ao Executar Procedure: {Proc}", 1, ex); } return(response); }
public virtual Resposta <T> Get(Expression <Func <T, object> > predicate, object valor) { try { var pgMain = new PredicateGroup { Operator = GroupOperator.And, Predicates = new List <IPredicate>() }; pgMain.Predicates.Add(Predicates.Field <T>(predicate, Operator.Eq, valor)); response.SetData(dapperContext.connection.GetList <T>(pgMain).ToList(), (int)eRespostaStatus.OK); } catch (Exception ex) { response.SetMessage("Erro ao Consultar", (int)eRespostaStatus.Erro, ex); } return(response); }