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