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