Transmission Problem and other problems

  mercedes/e-class/1996-2003

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 

10