public User getContactDetails(int u)
{
User user = new User();
cmd = new SqlCommand("select name,eContact,address,medicalId from Users WHERE userId=@userId", con);
cmd.Parameters.AddWithValue("@userId", u);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
user.eContact= dr["eContact"].ToString();
user.address = dr["address"].ToString();
user.name =dr["name"].ToString();
user.medicalId= dr["medicalId"].ToString();
}
dr.Close();
con.Close();
return user;
}
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();
}
}
