May I know For Elective C-Sect and Emergency C- Sect, what kind of anesthesia they give ?

Usually for Csect, they give epidural (mostly this) or a spinal anaesthesia which keeps you awake during the process. Hospitals will hardly give or suggest GA unless the condition requires or you specifically strongly requested to be under it (which may be rejected).