public Tram(int id, Tramtype tramtype, int nummer, int lengte, string status, Remise remise, bool vervuild, bool defect, bool conducteurGeschikt, bool beschikbaar) { this.Id = id; this.tramtype = tramtype; this.nummer = nummer; this.lengte = lengte; this.status = status; this.remise = remise; this.vervuild = vervuild; this.defect = defect; this.conducteurGeschikt = conducteurGeschikt; this.beschikbaar = beschikbaar; }
public static List <Tram> LaadTrams() { List <Tram> trams = new List <Tram>(); try { connection.Open(); OracleCommand command = new OracleCommand("SELECT * FROM TRAM"); command.CommandType = CommandType.Text; command.Connection = connection; OracleDataReader reader = command.ExecuteReader(); if (!reader.HasRows) { return(trams); } else { while (reader.Read()) { int id = Convert.ToInt32(reader["ID"]); Tramtype tramtype = (Tramtype)Convert.ToInt32(reader["Tramtype_ID"]) - 1; int nummer = Convert.ToInt32(reader["Nummer"]); int lengte = Convert.ToInt32(reader["Lengte"]); string status = Convert.ToString(reader["Status"]); Remise remise = RemiseManager.remiseViaId(Convert.ToInt32(reader["Remise_ID_Standplaats"])); bool vervuild = convertBool(Convert.ToString(reader["Vervuild"])); bool defect = convertBool(Convert.ToString(reader["Defect"])); bool conducteurGeschikt = convertBool(Convert.ToString(reader["ConducteurGeschikt"])); bool beschikbaar = convertBool(Convert.ToString(reader["Beschikbaar"])); trams.Add(new Tram(id, tramtype, nummer, lengte, status, remise, vervuild, defect, conducteurGeschikt, beschikbaar)); } } } catch (Exception) { throw; } finally { connection.Close(); } return(trams); }