protected void Page_Load(object sender, EventArgs e)
        {
            Page.DataBind();
            if (!IsPostBack)
            {
                userId = (int)Session["userId"];
                user = dc.getContactDetails(userId);
                eContactC = user.eContact;
                nameC = user.name;
                addressC = user.address;
                medicalIdC = user.medicalId;

                medical = dc.getMedicalDetails(userId);
                allergiesC = medical.allergies;
                bloodGroupC = medical.bloodGroup;
                specialConditionC = medical.specialCondition;

                hs = dc.getHospitalDetails();

            }
        }
        public Medical getMedicalDetails(int u)
        {
            Medical medical = new Medical();
            cmd = new SqlCommand("select allergies,bloodGroup,specialCondition from medicalData WHERE userId=@userId", con);
            cmd.Parameters.AddWithValue("@userId", u);
            con.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                medical.allergies = dr["allergies"].ToString();
                medical.bloodGroup = dr["bloodGroup"].ToString();
                medical.specialCondition = dr["specialCondition"].ToString();

            }
            dr.Close();
            con.Close();
            return medical;
        }