public FeedingObservations GetFeedingObservations(long assessmentId)
        {
            SqlParameter[] sqlParms = new SqlParameter[]{
                new SqlParameter("AssessmentId",assessmentId)
            };

            //var list = new List<FeedingMother>();
            var robj = new FeedingObservations();
            using (SqlDataReader sqlobj = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "Encounters_GetBreastFeedingObservations", sqlParms))
            {
                while (sqlobj.Read())
                {
                    robj.Id = DBHelper.getInt64(sqlobj, "Id");
                    robj.IsObserved = DBHelper.getBool(sqlobj, "IsObserved");

                }
                if (sqlobj.NextResult())
                {
                    while (sqlobj.Read())
                    {
                        var obcld = new FeedingOvbservationChild();
                        obcld.Id = DBHelper.getInt64(sqlobj, "Id");
                        obcld.FeedingId = DBHelper.getInt64(sqlobj, "FeedingId");
                        obcld.Status = DBHelper.getInt16(sqlobj, "StsVal");
                        obcld.StatusStr = DBHelper.getString(sqlobj, "Status");
                        obcld.Notes = DBHelper.getString(sqlobj, "Notes");
                        obcld.Description = DBHelper.getString(sqlobj, "Description");
                        obcld.ObservationParentId = DBHelper.getInt64(sqlobj, "ObservationParentId");
                        robj.ChildObservations.Add(obcld);
                    }
                }
            }
            return robj;
        }
        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;
        }