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