Home Depot review: Outdoor dept./umbrella

Good Morning

On Saturday July 10th I was at Home Depot Rexdale, I enquired about an umbrella that was on display as the price/sku was not on the umbrella instead a picture/price chart for all umbrellas was displayed. The associate checked and advise the price was $188.00 she checked stock and none was in stock; I then asked if I could purchase the display she said let her ask the Manager.
After 3 calls and waited for over 45 minutes the Manager finally showed up; I explained that I would like to purchase the display and he said ok no problem.
He searched for the price for another half an hour then came back to let me know that he would give it to me for $188.00 less 25% since it is the display and if I could pay for it and pick it up on Sunday instead. I said ok no problem.
He asked me to follow him over to an associate that he signed the paper with price and discount and ask her to cash me out.

As I waited to pay for the umbrella THE CASHIER decided that this umbrella is not $188.00 even though she had paper that the Manager signed with price and discount. She in turn called the Manager back went over to the umbrella to check it out while I waited at the register to pay; after half an hour they both came back to say the umbrella is in fact $649.00 and not $188.00 and I cannot get it for that price even though he had promised and sign paper to give me that price. The associate went on to say we don't have any of the $188.00 umbrella in stock and I could go home and order online for the $188.00.

At this time I was furious and said I will be complaining to Jason who is the store Manager. I waited over 2 hours only to leave store without the umbrella because the cashier made an Executive decision that I couldn't get it for that price.
What kind of service is this and if I was told price by 2 separate people including the Manager of the outdoor dept. why was I denied getting the umbrella on display for the $188.00 less 25% regardless of value?

I would appreciate someone to get back to me with an answer and I would like that same umbrella for the price I was Promised.