I have a horrible armpit problem.

More information: 
So I have to horrible smell and I would start to use deorant and it does not help it makes it worse than it was. And now that I work in a place the I have to be well groomed and cleaned and having the smell on has made me horrified to go to work. I tried lemon juice for a few days. Everything was going fine until I got a rash under both armpits and it's painful. I have to put on aloe Vera on but I only started last night and I don't if that helps. I don't know what to do. I'm scared that one day one of my managers are gonna tell me to leave for the day cause I stink. I serously don't know what to do. Help me please.