protected void Page_Load(object sender, EventArgs e) { var aId = Request.QueryString["aId"]; var pm = Request.QueryString["pm"]; EncounterService service = new EncounterService(); babyPCP = service.GetBabyPCP(Convert.ToInt64(aId)); states = service.GeStatesMaster(); momobid.Value = babyPCP.Id.ToString(); asId.Value = aId; phy_name.Text = babyPCP.Name; ph_no.Text = babyPCP.Phone; address1.Text = babyPCP.Address1; address2.Text = babyPCP.Address2; city.Text = babyPCP.City; zip.Text = babyPCP.ZipCode; }
public BabyPCPhy GetBabyPCP(long assessmentId) { SqlParameter[] sqlParms = new SqlParameter[]{ new SqlParameter("AssessmentId",assessmentId) }; var robj = new BabyPCPhy(); using (SqlDataReader sqlobj = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "Encounters_GetBabyPCP", sqlParms)) { while (sqlobj.Read()) { robj.Id = DBHelper.getInt64(sqlobj, "Id"); robj.AssessmentId = DBHelper.getInt64(sqlobj, "AssessmentId"); robj.Address1 = DBHelper.getString(sqlobj, "Address1"); robj.Address2 = DBHelper.getString(sqlobj, "Address2"); robj.Name = DBHelper.getString(sqlobj, "Name"); robj.Phone = DBHelper.getString(sqlobj, "Phone"); robj.City = DBHelper.getString(sqlobj, "City"); robj.State = DBHelper.getString(sqlobj, "State"); robj.ZipCode = DBHelper.getString(sqlobj, "ZipCode"); } } return robj; }