Foundation suggestion?

I know a simple post won’t lead me to the best foundation for me, but I’d love some recommendations for me to go out and try.

I go to school from 8-3, my day is full of classes, active theater, and after school, I do cheerleading. But I’ve found my foundation, does not like to stay! It’s so embarrassing being close up to people where they can literally see the foundation all clumpy in some spaces and blotchy. I’ve been doing makeup for 6 years, I know I’m applying it correctly.

I use Too Faced Hangover primer. I’ve tried It foundation, Estée Lauder, Mary Kay, Clinique, NARS, and every one of them leave me feeling satisfying in the first week but then all of a sudden, it stops looking amazing after a few hours?

I need something full coverage or at least close to it, sweat/water proof, and good for dry skin. Can anyone suggest a foundation or even a primer that might help me? A powder suggestion would be great too. I just need a few ideas before I go in to a makeup store and talk to a consultant. Thank you and please leave any negative comments at the door! I’m just looking for a little help.