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