"Yes" is what you would say normally, any time you're wanting to affirm something. "Aye" is an outdated word from Middle English that would have been used by maybe a pirate ("Aye aye, Captain!") but never in normal life these days. Alternatively, sometimes when taking a vote, those who are voting "yes" or in favor of something might say "Aye." If they win, sometimes we say, "The Ayes have it!" meaning that those voting "yes" have beaten those who voted "no."