I have a e200 kompressor .The lights and horn works but when I try to start it it makes a noise of starting but does not start.It was working perfectly until I stopped the car and switched off the engine. The battery was changed but its still refuses to start.

Have you had the battery itself tested? Features like the lights and power windows do not use a lot of battery power. A starter motor will use at least 9 volts on a 12 volt battery. Batteries usually only last about 5 to 8 years before they start to fail, less if you have 'start-stop' fitted to your vehicle.

Several possibilities Darrell. Make sure shift is in park (if an automatic) - wiggle the shift lever while trying to crank engine. If manual transmission, make sure clutch pedal is depressed.
You said lights work but have someone see if they dim when trying to crank engine. A low batt will blow horn or turn light s on but if batt is low the lights will dim a lot when trying to crank.

The clicking noise is the starter solenoid trying to operate but not enough power to work. The battery must be weak.
Try charging the battery first then retry to start.
Autozone, Sears, and others will check and charge your battery free.
Autozone also has videos to show what to do.
Hope this helps.

posible the contamiantion of water in to the transmision damage the transmision

If the engine will not crank in park, will it crank in neutral ?
Have you checked for voltage at the starter when the key is in the crank position ?

SO, would it crank before you changed the cables and battery? When you arc the solenoid does the starter actually crank?

If you need further help, I’m available over the phone at https://www.6ya.com/expert/justin_3ae27a9d61d6acd4

Have you tried replacing earthing cable

1. Loose battery or earth connections on bodywork/engine.

2. Starter stuck in mesh. (rock car backwards and forwards in gear to free)

3. Solenoid stuck. Tap lightly with a hammer.

4. Starter relay in or near fuse box faulty. Replace relay.

take it to a shop