Пример #1
0
 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;
        }