public static Admission SearchAdmission(string patientID)
{
Admission admission = null;
using (DAL dal = new DAL())
{
SqlParameter[] spParams =
{
new SqlParameter("@patientID", patientID),
};
var data = dal.ExecuteQuery("spSearchAdmittedPatient", spParams).Tables[0];
foreach (DataRow dr in data.AsEnumerable())
{
admission = new Admission()
{
id = dr.Field <int>(0),
patient = new Patient()
{
id = dr.Field <string>(1),
firstname = dr.Field <string>(2),
middlename = dr.Field <string>(3),
lastname = dr.Field <string>(4),
}
};
}
return(admission);
}
}
public static int SaveAdmission(Admission admission)
{
using (DAL dal = new DAL())
{
SqlParameter[] spParams =
{
new SqlParameter("@id", admission.id),
new SqlParameter("@patientID", admission.patient.id),
new SqlParameter("@admittedDate", admission.admittedDate),
new SqlParameter("@admittedTime", admission.admittedTime),
new SqlParameter("@dischargeDate", admission.dischargedDate),
new SqlParameter("@dischargeTime", admission.dischargedTime),
new SqlParameter("@timesAdmitted", admission.timesAdmitted),
new SqlParameter("@ward", admission.ward),
new SqlParameter("@roomNo", admission.roomNo),
new SqlParameter("@bedNo", admission.bedNo),
new SqlParameter("@fatherName", admission.fatherName),
new SqlParameter("@fAddress", admission.fAddress),
new SqlParameter("@fOccupation", admission.fOccupation),
new SqlParameter("@fEmployer", admission.fEmployer),
new SqlParameter("@motherName", admission.motherName),
new SqlParameter("@mAddress", admission.mAddress),
new SqlParameter("@mOccupation", admission.mOccupation),
new SqlParameter("@mEmployer", admission.mEmployer),
new SqlParameter("@spouseName", admission.spouseName),
new SqlParameter("@sAddress", admission.sAddress),
new SqlParameter("@sOccupation", admission.sOccupation),
new SqlParameter("@sEmployer", admission.sEmployer),
new SqlParameter("@captainName", admission.captainName),
new SqlParameter("@companionName", admission.companionName),
new SqlParameter("@cRelationship", admission.cRelationship),
new SqlParameter("@cAddress", admission.cAddress),
new SqlParameter("@eName", admission.eName),
new SqlParameter("@eRelationship", admission.eRelationship),
new SqlParameter("@eAddress", admission.eAddress),
new SqlParameter("@contact", admission.contact),
new SqlParameter("@isAdmitted", admission.isAdmitted),
new SqlParameter("@isDischarged", admission.isDischarged),
new SqlParameter("@isTransferred ", admission.isTransferred),
new SqlParameter("@employeeID ", admission.doctorID),
new SqlParameter("@bp", admission.blood_pressure),
new SqlParameter("@temperature", admission.temperature),
new SqlParameter("@pr", admission.pulse_rate),
new SqlParameter("@cc", admission.cc),
new SqlParameter("@rr", admission.respiratory_rate),
new SqlParameter("@gcs", admission.gcs),
new SqlParameter("@o2sat", admission.o2sat),
new SqlParameter("@nurseID", admission.nurseID),
};
try
{
dal.ExecuteQuery("spSaveAdmission", spParams);
return(1);
}
catch (Exception)
{
return(0);
}
}
}