protected void Page_Load(object sender, EventArgs e) { var aId = Request.QueryString["aId"]; // TODO var userid =Convert.ToString(Session["userid"]); var peerid = Session["peerId"]; EncounterService service = new EncounterService(); summary = service.GetCompleteAssessmentSummary(Convert.ToInt64(aId), Convert.ToInt64(peerid)); asId.Value = aId; }
public EncounterAssessmentSummary GetCompleteAssessmentSummary(long AssessmentId, long UserId) { SqlParameter[] sqlParms = new SqlParameter[]{ new SqlParameter("AssessmentId",AssessmentId), new SqlParameter("UserId",UserId) }; var ea = new EncounterAssessmentSummary(); using (SqlDataReader sqlobj = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "Encounters_GetCompleteSummary", sqlParms)) { while (sqlobj.Read()) { ea.PatientName = DBHelper.getString(sqlobj, "PeerName"); ea.DOB = Convert.ToDateTime(ecd.DecryptData(DBHelper.getString(sqlobj, "DOB"), ecd.GetEncryptType())); ea.Age = DBHelper.getInt(sqlobj, "Age"); ea.AssessmentDate = DBHelper.getDateTime(sqlobj, "AssessmentDate"); ea.AssessmentBy = DBHelper.getString(sqlobj, "AssessmentBy"); } if (sqlobj.NextResult()) { while (sqlobj.Read()) { ea.AssessmentDate = DBHelper.getDateTime(sqlobj, "AssessmentDate"); ea.AssessmentBy = DBHelper.getString(sqlobj, "AssessmentBy"); ea.AssessmentNotes = DBHelper.getString(sqlobj, "aNotes"); ea.HPINotes = DBHelper.getString(sqlobj, "piNotes"); ea.COCNotes = DBHelper.getString(sqlobj, "corNotes"); } } if (sqlobj.NextResult()) { //public List<FeedingMother> BreastFeedingBabies { get; set; } while (sqlobj.Read()) { var fb = new FeedingMother(); fb.Description = DBHelper.getString(sqlobj, "Description"); fb.StatusStr = DBHelper.getString(sqlobj, "Status"); ea.BreastFeedingBabies.Add(fb); } } if (sqlobj.NextResult()) { //public List<FeedingMother> BreastFeedingMothers { get; set; } while (sqlobj.Read()) { var fm = new FeedingMother(); fm.Description = DBHelper.getString(sqlobj, "Description"); fm.StatusStr = DBHelper.getString(sqlobj, "Status"); ea.BreastFeedingMothers.Add(fm); } } if (sqlobj.NextResult()) { //public List<FeedingOvbservationChild> Observations { get; set; } while (sqlobj.Read()) { var oc = new FeedingOvbservationChild(); oc.Description = DBHelper.getString(sqlobj, "Description"); oc.StatusStr = DBHelper.getString(sqlobj, "Status"); oc.Notes = DBHelper.getString(sqlobj, "Notes"); ea.Observations.Add(oc); } } if (sqlobj.NextResult()) { //public List<ChiefComplaints> ChiefComplaintList { get; set; } while (sqlobj.Read()) { var cc = new EncounterAssessmentSummary.ChiefComplaints(); cc.Notes = DBHelper.getString(sqlobj, "Description"); ea.ChiefComplaintList.Add(cc); var ccid = DBHelper.getInt64(sqlobj, "Id"); sqlParms = new SqlParameter[]{ new SqlParameter("ComplaintId", ccid) }; using (SqlDataReader pObj = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "Encounters_GetChiefComplaintPlans", sqlParms)) { while (pObj.Read()) { var cp = new EncounterAssessmentSummary.ChiefComplaints.ComplaintsPlan(); cp.Plan = DBHelper.getString(pObj, "Description"); cc.ComplaintsPlans.Add(cp); } } } } } return ea; }