public List<Veichles> readVeichles() { List<Veichles> displayVeichles = new List<Veichles>(); using (NpgsqlTransaction transaction = conn.BeginTransaction()) { using (NpgsqlCommand com = new NpgsqlCommand("SELECT * FROM printVeichles()", conn)) { NpgsqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); string type = reader.GetString(1); int year = reader.GetInt32(2); string model = reader.GetString(3); string make = reader.GetString(4); string place = reader.GetString(5); Veichles reading = new Veichles(id, type, year, make, model, place); displayVeichles.Add(reading); } } return displayVeichles; } }
public void updateMake(Veichles update) { using (NpgsqlTransaction transaction = conn.BeginTransaction()) { NpgsqlCommand com = new NpgsqlCommand("SELECT updateMake(" + update.makeID + ", '" + update.model + "');", conn); com.ExecuteNonQuery(); transaction.Commit(); } }
public void deleteMake(Veichles remove) { using (NpgsqlTransaction transaction = conn.BeginTransaction()) { NpgsqlCommand com = new NpgsqlCommand("SELECT deleteMake(" + remove.id + ")", conn); com.ExecuteNonQuery(); transaction.Commit(); } }
public void addMake(Veichles add) { using (NpgsqlTransaction transaction = conn.BeginTransaction()) { NpgsqlCommand com = new NpgsqlCommand("SELECT addMakeModel('" + add.make + "', '" + add.model + "', " + add.makeID + ");", conn); com.ExecuteNonQuery(); transaction.Commit(); } }
public void updateVeichle(Veichles update) { using (NpgsqlTransaction transaction = conn.BeginTransaction()) { NpgsqlCommand com = new NpgsqlCommand("SELECT updateVeichle(" + update.id + ", '" + update.type + "', " + update.yearOfMake + ", " + update.modelID + ", " + update.placeID + ");", conn); com.ExecuteNonQuery(); transaction.Commit(); } }
public void addVeichle(Veichles add) { using (NpgsqlTransaction transaction = conn.BeginTransaction()) { NpgsqlCommand com = new NpgsqlCommand("SELECT addVeichles('" + add.type + "', " + add.yearOfMake + ", " + add.modelID + ", " + add.placeID + ");", conn); com.ExecuteNonQuery(); transaction.Commit(); } }
public List<Veichles> readMakes() { List<Veichles> displayMakes = new List<Veichles>(); using (NpgsqlTransaction transaction = conn.BeginTransaction()) { using (NpgsqlCommand com = new NpgsqlCommand("SELECT * FROM printMakes()", conn)) { // com.CommandText = "SELECT printPlaces()"; NpgsqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); string make = reader.GetString(1); Veichles reading = new Veichles(id, make); displayMakes.Add(reading); } } return displayMakes; } }