public void AddHOPE(HOPE hope)
        {
            int id = AddMission(hope as Mission);
            if (id > 0)
            {
                List<string> rowListHope = new List<string>();
                rowListHope.Add("missieID");
                rowListHope.Add("terugkomstDatum");

                List<OracleParameter> parametersHope = new List<OracleParameter>();
                parametersHope.Add(new OracleParameter(":missieID", id));
                parametersHope.Add(new OracleParameter(":terugkomstDatum", hope.ReturnDate));
            }
        }
        public List<Mission> GetMissions()
        {
            List<Mission> missions = new List<Mission>();

            string missionQuery =
                "SELECT * FROM MISSIE";

            OracleDataReader getAllMissions = this.Read(missionQuery, new List<OracleParameter>());
            if (getAllMissions != null)
            {
                if (getAllMissions.HasRows)
                {
                    while (getAllMissions.Read())
                    {
                        Mission mission = null;

                        int missionID = Convert.ToInt32(getAllMissions["ID"]);
                        int boatID = Convert.ToInt32(getAllMissions["bootID"]);
                        DateTime leaveDate = Convert.ToDateTime(getAllMissions["vertrekDatum"]);
                        string description = Convert.ToString(getAllMissions["beschrijving"]);
                        double locationX = Convert.ToDouble(getAllMissions["locatieX"]);
                        double locationY = Convert.ToDouble(getAllMissions["locatieY"]);
                        GeoCoordinate location = new GeoCoordinate(locationX, locationY);
                        string report = Convert.ToString(getAllMissions["verslag"]);
                        char type = Convert.ToChar(getAllMissions["soort"]);

                        switch (type)
                        {
                            case 'H':
                                string hopeQuery = "SELECT * FROM M_HOPE WHERE MissieID = :missionID";
                                List<OracleParameter> hopeParameters = new List<OracleParameter>();
                                hopeParameters.Add(new OracleParameter(":missionID", missionID));
                                OracleDataReader getHope = this.Read(hopeQuery, hopeParameters);
                                if (getHope != null)
                                {
                                    if (getHope.HasRows)
                                    {
                                        while (getHope.Read())
                                        {
                                            int hopeID = Convert.ToInt32(getHope["ID"]);
                                            DateTime returnDate = Convert.ToDateTime(getHope["terugkomstDatum"]);
                                            bool approved = Convert.ToChar(getHope["goed"]) == 'Y';
                                            mission = new HOPE(missionID,null,leaveDate,description,location,new BoatType(boatID), null, null, report, hopeID, returnDate, approved, null);

                                            break;
                                        }

                                    }
                                    getHope.Close();
                                }
                                break;
                            case 'S':
                                string sinQuery = "SELECT * FROM M_SIN WHERE MissieID = :missionID";
                                List<OracleParameter> sinParameters = new List<OracleParameter>();
                                sinParameters.Add(new OracleParameter(":missionID", missionID));
                                OracleDataReader getSin = this.Read(sinQuery, sinParameters);
                                if (getSin != null)
                                {
                                    if (getSin.HasRows)
                                    {
                                        while (getSin.Read())
                                        {
                                            int sinID = Convert.ToInt32(getSin["ID"]);
                                            mission = new SIN(missionID, null, leaveDate, description, location, new BoatType(boatID), null, null, report,sinID, null);
                                            break;
                                        }

                                    }
                                    getSin.Close();
                                }
                                break;
                        }
                        missions.Add(mission);
                    }

                }
                getAllMissions.Close();
            }

            this.CloseConnection();

            return missions;
        }