public void UpdateRoom(int id,int ileOsob, int ilePoje, int ilePodw, bool czyTaras, int koszt)
        {
            //cala reszta chyba wiadomo o co chodzi

            int result = database.ExecuteNonQuery($"UPDATE rental SET idroom = {id}, guests = {ileOsob}, singlebeds = {ilePoje} doublebeds = {ilePodw}, balcony = {czyTaras}, occupied = {true}, cost = {koszt} WHERE idrental = {id}")

                }