public List<Huur> GetAllHuren()
{
List<Huur> ret = new List<Huur>();
try
{
Con.Open();
Cmd.CommandText = "SELECT * FROM HUUR";
OracleDataReader dr = Cmd.ExecuteReader();
while (dr.Read())
{
Cmd.Parameters.Clear();
int huurid = dr.GetInt32(0);
Cmd.CommandText = "SELECT Naam FROM boothuur WHERE Huurid = :hid";
Cmd.Parameters.Add("hid", huurid);
OracleDataReader dr2 = Cmd.ExecuteReader();
dr2.Read();
Boot bname = new Spierkrachtboot();
if (dr2.HasRows)
{
bname.Naam = dr2.GetString(0);
}
Cmd.CommandText = "SELECT NAAM FROM KLANT WHERE KLANTID = :kid";
Cmd.Parameters.Add("kid", dr.GetInt32(1));
OracleDataReader dr3 = Cmd.ExecuteReader();
dr3.Read();
string kname = null;
if (dr3.HasRows)
{
kname = dr3.GetString(0);
}
Huur add = new Huur
{
Huurdernaam = kname,
Boot = bname,
HuurBegin = dr.GetDateTime(2),
HuurEind = dr.GetDateTime(3)
};
ret.Add(add);
}
Con.Close();
return ret;
}
catch(OracleException e)
{
Console.WriteLine("Oh noes OracleException: " + e.Message);
Con.Close();
return null;
}
}
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;
}
}