private bool records_exists_in_table(infinite_loops infinite_loops) { PostgresConnection con = new PostgresConnection(); con.connection().Open(); NpgsqlCommand cmd = new NpgsqlCommand("SELECT CASE WHEN EXISTS (SELECT * FROM " + infinite_loops.getTable_name() + " LIMIT 1) THEN 1 ELSE 0 END", con.connection()); NpgsqlDataReader rdr = cmd.ExecuteReader(); int value = -1; while (rdr.Read()) { value = rdr.GetInt16(0); } rdr.Close(); con.connection().Close(); return(value == 1 ? true : false); }
private void testing_add_record_Click(object sender, EventArgs e) { string temporarty_bag_record = null; temporarty_bag_record = "test_record"; PostgresConnection con = new PostgresConnection(); con.connection().Open(); NpgsqlCommand cmd = new NpgsqlCommand("select var_table from existing_bags eb order by id ", con.connection()); NpgsqlDataReader rdr = cmd.ExecuteReader(); bool table_already_exists = false; while (rdr.Read()) { if (rdr.GetString(0).Equals(temporarty_bag_record)) { table_already_exists = true; } } rdr.Close(); if (table_already_exists == false) { // NpgsqlCommand cmd_2 = new NpgsqlCommand("insert into existing_bags(var_table, alive, gather_data_time) values('"+ temporarty_bag_record + "',true,2000 ", con.connection()); // NpgsqlDataReader rdr_2 = cmd_2.ExecuteReader(); using (var cmd_2 = new NpgsqlCommand("insert into existing_bags(var_table, alive, gather_data_time) values(@p1,@p2,@p3)", con.connection())) { cmd_2.Parameters.Add(new NpgsqlParameter("p1", NpgsqlTypes.NpgsqlDbType.Text)); cmd_2.Parameters.Add(new NpgsqlParameter("p2", NpgsqlTypes.NpgsqlDbType.Boolean)); cmd_2.Parameters.Add(new NpgsqlParameter("p3", NpgsqlTypes.NpgsqlDbType.Integer)); cmd_2.Parameters[0].Value = temporarty_bag_record; cmd_2.Parameters[1].Value = true; cmd_2.Parameters[2].Value = 2000; cmd_2.ExecuteNonQuery(); } infinite_loops inf_temp = new infinite_loops(2000, temporarty_bag_record); inifite_loop_list.Add(inf_temp); create_additional_table(temporarty_bag_record, con); MessageBox.Show("table created", "Database information", MessageBoxButtons.OK); insert_example_values_to_table(temporarty_bag_record, con); MessageBox.Show("values added", "Database information", MessageBoxButtons.OK); inf_temp.initizalizer(); MessageBox.Show("loop initialized", "Database information", MessageBoxButtons.OK); } else { MessageBox.Show("Rekord aleady exists", "Database information", MessageBoxButtons.OK); } con.connection().Close(); }