public void updateVacationWeek(int vacationHouseId, VacationWeek vacationWeek)
        {
            string sql = "";

            sql += "UPDATE vacationweek";
            sql += " SET price=" + vacationWeek.Price;
            sql += " WHERE vacationhouseid=" + vacationHouseId + " and weeknumber=" + vacationWeek.WeekNumber;
            SqlCommand cmd = new SqlCommand(sql, con);

            executeQuery(cmd);
        }
        // VacationHouseWeeks
        public void createVacationWeek(int vacationHouseId, VacationWeek vacationWeek)
        {
            string sql = "";

            sql += "INSERT INTO";
            sql += " vacationweek(weeknumber,price,isBooked,vacationhouseid)";
            sql += " VALUES (" + vacationWeek.WeekNumber + "," + vacationWeek.Price + ",'" + vacationWeek.IsBooked + "'," + vacationHouseId + ")";
            SqlCommand cmd = new SqlCommand(sql, con);

            executeQuery(cmd);
        }
        public List <VacationWeek> getVacationHousesWeeks(int i)
        {
            List <VacationWeek> vacationWeeks = new List <VacationWeek>();
            string     sql = "SELECT weeknumber,price,isBooked FROM vacationweek WHERE vacationhouseid=" + i + "";
            SqlCommand cmd = new SqlCommand(sql, con);

            try
            {
                con.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    int          week         = (int)reader["weeknumber"];
                    int          price        = (int)reader["price"];
                    Boolean      isBooked     = (Boolean)reader["isBooked"];
                    VacationWeek vacationWeek = new VacationWeek(week, price);
                    vacationWeek.IsBooked = isBooked;
                    if (!vacationWeeks.Contains(vacationWeek))
                    {
                        vacationWeeks.Add(vacationWeek);
                    }
                }
            }
            catch (Exception ex)
            {
                System.Windows.Forms.MessageBox.Show(ex.Message.ToString());
            }
            finally
            {
                if (con.State == ConnectionState.Open)
                {
                    con.Close();
                }
            }
            return(vacationWeeks);
        }