public void deletePlace(Places remove) { using (NpgsqlTransaction transaction = conn.BeginTransaction()) { NpgsqlCommand com = new NpgsqlCommand("SELECT deletePlaces(" + remove.id + ")", conn); com.ExecuteNonQuery(); transaction.Commit(); } }
public void addPlace(Places add) { using (NpgsqlTransaction transaction = conn.BeginTransaction()) { NpgsqlCommand com = new NpgsqlCommand("SELECT addPlace('" + add.name + "', '" + add.postalNum + "');", conn); com.ExecuteNonQuery(); transaction.Commit(); } }
public void updatePlace(Places update) { using (NpgsqlTransaction transaction = conn.BeginTransaction()) { NpgsqlCommand com = new NpgsqlCommand("SELECT updatePlace(" + update.id + ", '" + update.name + "', '" + update.postalNum + "');", conn); com.ExecuteNonQuery(); transaction.Commit(); } }
public List<Places> readForChart() { List<Places> chartDisplay = new List<Places>(); using (NpgsqlTransaction transaction = conn.BeginTransaction()) { using (NpgsqlCommand com = new NpgsqlCommand("SELECT * FROM printPlacesChart()", conn)) { NpgsqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { string name = reader.GetString(0); int num = reader.GetInt32(1); Places reading = new Places(name, num); chartDisplay.Add(reading); } } return chartDisplay; } }
public List<Places> readPlaces() { List<Places> displayPlaces = new List<Places>(); using (NpgsqlTransaction transaction = conn.BeginTransaction()) { using(NpgsqlCommand com = new NpgsqlCommand("SELECT * FROM printPlaces()", conn)) { // com.CommandText = "SELECT printPlaces()"; NpgsqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); string name = reader.GetString(1); string postNum = reader.GetString(2); Places reading = new Places(id, name, postNum); displayPlaces.Add(reading); } } return displayPlaces; } }