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;
}