Transmission Problem and other problems

Mercedes » E-Class » 1996-2003
Question

Smog check said I needed transmission speed sensor. Do I have to replace whole transmission.  And windows only work at night time. Rain hit in car now they dint work at all.  The shift on console won't work. I have to turn off car restart it to shift and