protected void Page_Load(object sender, EventArgs e) { var aId = Request.QueryString["aId"]; var pm = Request.QueryString["pm"]; EncounterService service = new EncounterService(); momOB = service.GetMomOB(Convert.ToInt64(aId)); states = service.GeStatesMaster(); momobid.Value = momOB.Id.ToString(); asId.Value = aId; phy_name.Text = momOB.Name; ph_no.Text = momOB.Phone; address1.Text = momOB.Address1; address2.Text = momOB.Address2; city.Text = momOB.City; zip.Text = momOB.ZipCode; }
public MomOB GetMomOB(long assessmentId) { SqlParameter[] sqlParms = new SqlParameter[]{ new SqlParameter("AssessmentId",assessmentId) }; var robj = new MomOB(); var list = new List<MomOB>(); using (SqlDataReader sqlobj = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "Encounters_GetMomOB", 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; }