public static void Update(int idVersao, string valorJson)
{
var conn = ConexaoDao.conexao();
SqlCommand query;
query = new SqlCommand($"UPDATE GRID_DLL SET resultado = '{valorJson}' WHERE id_versao = {idVersao}", conn);
query.ExecuteNonQuery();
conn.Close();
}
public static void AdicionarLinhaGrid(int idversao, string valorJson)
{
var lista = ListarGridDao.GridLista(idversao);
if (ListarGridDao.GridLista(idversao) == null)
{
var conn = ConexaoDao.conexao();
SqlCommand query;
query = new SqlCommand($"INSERT INTO GRID_DLL (id_versao, resultado) VALUES ({idversao},'{valorJson}')", conn);
query.ExecuteNonQuery();
conn.Close();
}
else
{
UpdateDao.Update(idversao, valorJson);
}
}
public static Grid GridLista(int idversao)
{
var conn = ConexaoDao.conexao();
var query = new SqlCommand("select * from GRID_DLL where id_versao = @ID_VERSAO", conn);
query.Parameters.AddWithValue("@ID_VERSAO", idversao);
SqlDataReader dr = query.ExecuteReader();
Grid retorno = null;
while (dr.Read())
{
retorno = new Grid(Convert.ToInt32(dr[0]), Convert.ToInt32(dr[1]), dr[2].ToString());
}
dr.Close();
conn.Close();
return(retorno);
}
