Ejemplo n.º 1
0
 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;
 }