public IEnumerable <ParametroValor> GetAll()
{
List <ParametroValor> parametrosValores = new List <ParametroValor>();
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "SELECT pv.Id, pv.IdTestData, pv.Valor, p.ColunaTecnicaTosca, p.Id IdParametro FROM[TDM.Db].[dbo].[ParametroValor] pv INNER JOIN[TDM.Db].[dbo].[ParametroScript] ps on pv.IdParametroScript = ps.Id INNER JOIN[TDM.Db].[dbo].[Parametro] p on ps.IdParametro = p.Id";
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ParametroValor pv = new ParametroValor
{
Id = reader["Id"] == DBNull.Value ? 0 : Convert.ToInt32(reader["id"]),
IdTestData = Convert.ToInt32(reader["IdTestData"]),
IdParametro = Convert.ToInt32(reader["IdParametro"]),
DescricaoParametro = reader["ColunaTecnicaTosca"].ToString(),
Valor = reader["Valor"].ToString()
};
parametrosValores.Add(pv);
}
}
connection.Close();
}
return(parametrosValores);
}
public ParametroValor Get(int IdTestData)
{
ParametroValor pv = new ParametroValor();
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "SELECT pv.Id, pv.IdTestData, pv.Valor, p.ColunaTecnicaTosca, p.Id IdParametro FROM[TDM.Db].[dbo].[ParametroValor] pv INNER JOIN[TDM.Db].[dbo].[ParametroScript] ps on pv.IdParametroScript = ps.Id INNER JOIN[TDM.Db].[dbo].[Parametro] p on ps.IdParametro = p.Id WHERE pv.IdTestData = " + IdTestData + " AND ps.IdTipoParametro = 1";
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
pv = new ParametroValor
{
Id = reader["Id"] == DBNull.Value ? 0 : Convert.ToInt32(reader["id"]),
IdTestData = Convert.ToInt32(reader["IdTestData"]),
IdParametro = Convert.ToInt32(reader["IdParametro"]),
DescricaoParametro = reader["ColunaTecnicaTosca"].ToString(),
Valor = reader["Valor"].ToString()
};
//pv.Add(ob);
}
}
connection.Close();
}
return(pv);
}
