The phrase down the drain means wasted or lost completely. Time, money, or effort disappears and cannot be recovered. This idiom draws a parallel to water going down the drain of a sink and vanishing.
All that planning went down the drain when it rained.