public List<Boot> GetBoats(string type) { List<Boot> ret = new List<Boot>(); try { Con.Open(); Cmd.CommandText = "SELECT * FROM BOOT WHERE Type = :tp"; Cmd.Parameters.Add("tp", type); OracleDataReader dr = Cmd.ExecuteReader(); while (dr.Read()) { if (type == "Motorboot") { Motorboot add = new Motorboot(dr.GetInt32(2), dr.GetString(0), dr.GetString(3)); ret.Add(add); } else { Spierkrachtboot adds = new Spierkrachtboot(dr.GetString(0), dr.GetString(3)); ret.Add(adds); } } Cmd.Parameters.Clear(); Con.Close(); return ret; } catch (OracleException e) { Console.WriteLine("Oh noes OracleException: " + e.Message); Con.Close(); return null; } }
public void MotorbootRadiusTest() { Motorboot mb = new Motorboot(10,"Testmb","Testklasse"); Assert.AreEqual(mb.Actieradius,150,"Actieradius berekening gaat fout!"); }
public void MotorbootPrijsTest() { Motorboot mb = new Motorboot(10,"Testboot","Testklasse"); Assert.AreEqual(mb.Prijs,15,"Verkeerde prijs voor een motorboot!"); }
/// <summary> /// Krijg alle huur objecten de gekoppeld staan aan een huurcontract /// </summary> /// <param name="id">Huurcontract ID</param> /// <returns></returns> public static List<Huur> KrijgHuurLijst(int id) { try { Openconnecion(); List<Huur> list = new List<Huur>(); string str = "select b.* from Boot b join Boot_huurcontract bh on bh.boot_ID = b.naam where b.motor = 0 and bh.huurcontract_ID = "+ id; OracleCommand cmd = new OracleCommand(str); cmd.Connection = Conn; OracleDataReader Read = cmd.ExecuteReader(); while (Read.Read()) { Spierboot boot = new Spierboot(Read.GetString(0), Read.GetDecimal(2), Read.GetString(3)); list.Add(boot); } str = "select b.* from Boot b join Boot_huurcontract bh on bh.boot_ID = b.naam where b.motor = 1 and bh.huurcontract_ID = " + id; cmd = new OracleCommand(str); cmd.Connection = Conn; Read = cmd.ExecuteReader(); while (Read.Read()) { Motorboot boot = new Motorboot(Read.GetString(0), Read.GetDecimal(2), Read.GetString(3), Read.GetInt16(1)); list.Add(boot); } str = "select A.* from Artikelen A join Artikelen_huurcontract AH on AH.Artikelen_ID = A.id where AH.Huurcontract_ID = " + id; cmd = new OracleCommand(str); cmd.Connection = Conn; Read = cmd.ExecuteReader(); while (Read.Read()) { Artikel boot = new Artikel(Read.GetInt16(0), Read.GetString(1), Read.GetDecimal(2)); list.Add(boot); } return list; } catch (Exception) { return null; } }
/// <summary> /// Krijg een lijst van alle objecten die gehuurd kunnen worden /// </summary> /// <returns></returns> public static List<Huur> KrijgHuurLijst() { try { Openconnecion(); List<Huur> list = new List<Huur>(); string str = "select * from Boot where motor = 0"; OracleCommand cmd = new OracleCommand(str); cmd.Connection = Conn; OracleDataReader Read = cmd.ExecuteReader(); while (Read.Read()) { Spierboot boot = new Spierboot(Read.GetString(0), Read.GetDecimal(2), Read.GetString(3)); list.Add(boot); } str = "select * from Boot where motor = 1"; cmd = new OracleCommand(str); cmd.Connection = Conn; Read = cmd.ExecuteReader(); while (Read.Read()) { Motorboot boot = new Motorboot(Read.GetString(0), Read.GetDecimal(2), Read.GetString(3), Read.GetInt16(1)); list.Add(boot); } str = "select * from Artikelen"; cmd = new OracleCommand(str); cmd.Connection = Conn; Read = cmd.ExecuteReader(); while (Read.Read()) { Artikel boot = new Artikel(Read.GetInt16(0), Read.GetString(1), Read.GetDecimal(2)); list.Add(boot); } return list; } catch (Exception) { return null; } }