public Variavel ListarRegraLogica(Variavel entidade) { var regraLogica = new Variavel(); SqlParameter parms = new SqlParameter { DbType = DbType.Int32, Direction = ParameterDirection.Input, ParameterName = "@IDVariavel", Value = entidade.IDVariavel }; using (IDataReader reader = SqlHelper.ExecuteReader(ConfigurationManager.ConnectionStrings["Default"].ConnectionString, CommandType.StoredProcedure, "VariavelRegraLogicaListar", parms)) { regraLogica.VariavelRegraLogicaLista = new List <VariavelRegraLogica>(); while (reader.Read()) { var variavelRegraLogica = new VariavelRegraLogica(); variavelRegraLogica.RegraLogica = new RegraLogica() { IdRegraLogica = Convert.ToInt32(reader["IdSegmento"]) }; variavelRegraLogica.Variavel = new Variavel() { IDVariavel = Convert.ToInt32(reader["IDVariavel"]) }; variavelRegraLogica.Criterio = new Criterio() { IDCriterio = Convert.ToInt32(reader["IdCriterio"]) }; variavelRegraLogica.Valor = reader["Valor"].ToString(); variavelRegraLogica.TipoComparacaoRegraLogica = new TipoComparacaoRegraLogica() { IDTipoComparacaoRegraLogica = Convert.ToInt32(reader["IDTipoComparacaoRegraLogica"]) }; regraLogica.VariavelRegraLogicaLista.Add(variavelRegraLogica); } } return(regraLogica); }
public RegraLogica ListarVariavel(RegraLogica entidade) { var regraLogica = new RegraLogica(); SqlParameter parm = new SqlParameter() { DbType = DbType.Int32, Direction = ParameterDirection.Input, ParameterName = "@IdRegraLogica", Value = entidade.IdRegraLogica }; using (IDataReader reader = SqlHelper.ExecuteReader(ConfigurationManager.ConnectionStrings["Default"].ConnectionString, CommandType.StoredProcedure, "RegraLogicaVariavelListar", parm)) { if (reader.Read()) { regraLogica.IdRegraLogica = Convert.ToInt32(reader["IdRegraLogica"]); regraLogica.VariavelRegraLogica = new List <VariavelRegraLogica>(); while (reader.Read()) { var variavelRegraLogicaLista = new VariavelRegraLogica(); variavelRegraLogicaLista.Criterio = new Criterio() { IDCriterio = Convert.ToInt32(reader["IdCriterio"]) }; variavelRegraLogicaLista.Variavel = new Variavel() { IDVariavel = Convert.ToInt32(reader["IdVariavel"]) }; regraLogica.VariavelRegraLogica.Add(variavelRegraLogicaLista); } } } return(regraLogica); }
public Variavel ListarRegraLogicaProcessoSegmento(Variavel entidade) { var RegraLogicaProcessoSegmento = new Variavel(); SqlParameter[] parms = new SqlParameter[] { new SqlParameter() { DbType = DbType.Int32, Direction = ParameterDirection.Input, ParameterName = "@IdClasseVariavel", Value = entidade.ClasseVariavel.IDClasseVariavel }, new SqlParameter() { DbType = DbType.Int32, Direction = ParameterDirection.Input, ParameterName = "@IdTipoSaida", Value = entidade.TipoSaida.IDTipoSaida }, new SqlParameter() { DbType = DbType.Int32, Direction = ParameterDirection.Input, ParameterName = "@IdModelo", Value = entidade.Modelo.IDModelo }, new SqlParameter() { DbType = DbType.Int32, Direction = ParameterDirection.Input, ParameterName = "@IdRegraLogica", Value = entidade.RegraLogica.IdRegraLogica } }; using (IDataReader reader = SqlHelper.ExecuteReader(ConfigurationManager.ConnectionStrings["Default"].ConnectionString, CommandType.StoredProcedure, "VariavelRegraLogicaProcessoSegmentoListar", parms)) { RegraLogicaProcessoSegmento.VariavelRegraLogicaLista = new List <VariavelRegraLogica>(); while (reader.Read()) { var variavelRegraLogica = new VariavelRegraLogica(); variavelRegraLogica.Variavel = new Variavel() { IDVariavel = Convert.ToInt32(reader["IDVariavel"]) }; variavelRegraLogica.RegraLogica = new RegraLogica() { IdRegraLogica = Convert.ToInt32(reader["IDVariavel"]) }; variavelRegraLogica.Criterio = new Criterio() { IDCriterio = Convert.ToInt32(reader["IDCriterio"]) }; variavelRegraLogica.Valor = reader["Valor"].ToString(); RegraLogicaProcessoSegmento.VariavelRegraLogicaLista.Add(variavelRegraLogica); } } return(RegraLogicaProcessoSegmento); }