public bool DeletePatientAdmission(PatientAdmission c)
{
try
{
string delete = "Delete from PatientAdmission where PatientRegistrationNumber=" + c.PatientRegistration.PatientRegistrationNumber + "";
con = new OleDbConnection();
this.readconfile = new ReadConfigFile();
con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
tran = con.BeginTransaction();
cmd = new OleDbCommand(delete, con);
cmd.Transaction = tran;
cmd.ExecuteNonQuery();
tran.Commit();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
public bool SavePatientAdmission(PatientAdmission pa)
{
try
{
string insert;
insert = "INSERT INTO PatientAdmission(PatientRegistrationNumber, DiffDiag, ProvDiag, AdmissionDateTime, Status, Pluse, Temp, BPsys, BPdia, RR) " +
" VALUES ('" + pa.PatientRegistration.PatientRegistrationNumber + "','" + pa.DiffDiag + "','" + pa.provDiag + "','" + DateTime.Now + "','" + 0 + "','" + pa.Pluse + "','" + pa.Temp + "','" + pa.BPsys + "','" + pa.BPdia + "','" + pa.RR + "')";
con = new OleDbConnection();
this.readconfile = new ReadConfigFile();
con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
tran = con.BeginTransaction();
cmd = new OleDbCommand(insert, con);
cmd.Transaction = tran;
cmd.ExecuteNonQuery();
tran.Commit();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
private bool UpdateBed(PatientAdmission patient)
{
if (patient.Bed.BedNumber != m_bedRepo.ReadPatientsBed(patient.PatientId).BedNumber)
{
return(m_bedRepo.Update(patient.Bed));
}
return(true);
}
public bool Update(PatientAdmission patient)
{
if (Exists(patient.PatientId))
{
return(UpdatePatientAdmission(patient));
}
return(false);
}
public ActionResult DeleteConfirmed(int id)
{
PatientAdmission patientAdmission = db.PatientAdmissions.Find(id);
db.PatientAdmissions.Remove(patientAdmission);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private bool UpdateDetails(PatientAdmission patient)
{
if (Admit(patient))
{
return(UpdateHospitalBed(patient));
}
return(false);
}
public JsonResult GetPatientAdmissionForApproval()
{
PatientAdmission onlyAdmission = null;
List <PatientAdmission> onlyAdmissionList = new List <PatientAdmission> ();
List <PatientAdmission> outPutAdmissionList = new List <PatientAdmission>();
using (Repository <PatientAdmission> Repository = new Repository <PatientAdmission>())
{
Expression <Func <PatientAdmission, bool> > lambda;
lambda = (x => x.DischargeApprovalStatusId == 101 && x.IsReleased == false && x.Active == true);
onlyAdmissionList = Repository.GetByQuery(lambda).ToList();
if (onlyAdmissionList != null)
{
foreach (PatientAdmission item in onlyAdmissionList)
{
onlyAdmission = new PatientAdmission();
onlyAdmission.Id = item.Id;
onlyAdmission.PatientId = item.PatientId;
onlyAdmission.AdmissionDate = item.AdmissionDate;
onlyAdmission.ServiceProviderId = item.ServiceProviderId;
onlyAdmission.RefererId = item.RefererId;
onlyAdmission.DepartmentId = item.DepartmentId;
onlyAdmission.BedId = item.BedId;
onlyAdmission.IsReleased = item.IsReleased;
onlyAdmission.DischargeApprovalStatusId = item.DischargeApprovalStatusId;
onlyAdmission.DischargeNote = item.DischargeNote;
onlyAdmission.ApprovedUserId = item.ApprovedUserId;
onlyAdmission.Notes = item.Notes;
onlyAdmission.UserId = item.UserId;
onlyAdmission.Active = item.Active;
onlyAdmission.Patient = new Patient();
onlyAdmission.Patient.FirstName = item.Patient.FirstName;
onlyAdmission.Patient.LastName = item.Patient.LastName;
onlyAdmission.Department = new Department();
onlyAdmission.Department.Name = item.Department.Name;
if (item.Item != null)
{
onlyAdmission.Item = new Item();
onlyAdmission.Item.Name = item.Item.Name;
}
outPutAdmissionList.Add(onlyAdmission);
}
}
}
return(Json(outPutAdmissionList, JsonRequestBehavior.AllowGet));
}
private bool AdmitPatientAdmission(PatientAdmission patient)
{
var query = $"Insert into PatientAdmission values('{patient.PatientId}','{patient.DoctorId}','{patient.Illness}','{patient.Diagnosis}','{patient.AdmissionTime}','0')";
if (SqlCommands.ExecuteCommand(query, conString) && WriteDevices(patient))
{
return(UpdateBed(patient));
}
return(false);
}
public bool Admit(PatientAdmission patient)
{
var query = $"Select * From PatientAdmission where PatientId='{patient.PatientId}'";
if (!SqlCommands.Exists(conString, query))
{
return(AdmitPatientAdmission(patient));
}
return(false);
}
public bool UpdatePatientAdmission(PatientAdmission patient)
{
string query = $"DELETE FROM PatientAdmission WHERE PatientId='{patient.PatientId}'";
if (SqlCommands.ExecuteCommand(query, conString) && DeletePatientDevices(patient.PatientId))
{
return(UpdateDetails(patient));
}
return(false);
}
private void TryValidate(PatientAdmission patient, Vitals vital, ref PatientAlert patientAlert)
{
foreach (var patientDevice in patient.Devices)
{
if (patientDevice.DeviceId == vital.DeviceId)
{
ValidateDeviceRange(vital, patientDevice, ref patientAlert);
}
}
}
public List <PatientAdmission> GetAll()
{
PatientAdmissionDAC _patientAdmissionComponent = new PatientAdmissionDAC();
IDataReader reader = _patientAdmissionComponent.GetAllPatientAdmission().CreateDataReader();
List <PatientAdmission> _patientAdmissionList = new List <PatientAdmission>();
while (reader.Read())
{
if (_patientAdmissionList == null)
{
_patientAdmissionList = new List <PatientAdmission>();
}
PatientAdmission _patientAdmission = new PatientAdmission();
if (reader["PatientAdmissionId"] != DBNull.Value)
{
_patientAdmission.PatientAdmissionId = Convert.ToInt32(reader["PatientAdmissionId"]);
}
if (reader["AdmissionStartDate"] != DBNull.Value)
{
_patientAdmission.AdmissionStartDate = Convert.ToDateTime(reader["AdmissionStartDate"]);
}
if (reader["DischargeDate"] != DBNull.Value)
{
_patientAdmission.DischargeDate = Convert.ToDateTime(reader["DischargeDate"]);
}
if (reader["AdmissionStayTypeId"] != DBNull.Value)
{
_patientAdmission.AdmissionStayTypeId = Convert.ToInt32(reader["AdmissionStayTypeId"]);
}
if (reader["DischargeTypeId"] != DBNull.Value)
{
_patientAdmission.DischargeTypeId = Convert.ToInt32(reader["DischargeTypeId"]);
}
if (reader["PatientCode"] != DBNull.Value)
{
_patientAdmission.PatientCode = Convert.ToString(reader["PatientCode"]);
}
if (reader["ConsultantId"] != DBNull.Value)
{
_patientAdmission.ConsultantId = Convert.ToInt32(reader["ConsultantId"]);
}
if (reader["SpecialityId"] != DBNull.Value)
{
_patientAdmission.SpecialityId = Convert.ToInt32(reader["SpecialityId"]);
}
if (reader["WardBedId"] != DBNull.Value)
{
_patientAdmission.WardBedId = Convert.ToInt32(reader["WardBedId"]);
}
_patientAdmission.NewRecord = false;
_patientAdmissionList.Add(_patientAdmission);
}
reader.Close();
return(_patientAdmissionList);
}
public JsonResult GetAdmission(long PatientId)
{
PatientAdmission onlyAdmission = null;
List <PatientAdmission> onlyAdmissionList;
using (Repository <PatientAdmission> Repository = new Repository <PatientAdmission>())
{
Expression <Func <PatientAdmission, bool> > lambda;
lambda = (x => x.PatientId == PatientId && x.IsReleased == false && x.Active == true);
onlyAdmissionList = Repository.GetByQuery(lambda).ToList();
if (onlyAdmissionList != null)
{
foreach (PatientAdmission item in onlyAdmissionList)
{
onlyAdmission = new PatientAdmission();
onlyAdmission.Id = item.Id;
onlyAdmission.PatientId = item.PatientId;
onlyAdmission.AdmissionDate = item.AdmissionDate;
onlyAdmission.ServiceProviderId = item.ServiceProviderId;
onlyAdmission.RefererId = item.RefererId;
onlyAdmission.DepartmentId = item.DepartmentId;
onlyAdmission.BedId = item.BedId;
onlyAdmission.IsReleased = item.IsReleased;
onlyAdmission.DischargeApprovalStatusId = item.DischargeApprovalStatusId;
onlyAdmission.DischargeNote = item.DischargeNote;
onlyAdmission.ApprovedUserId = item.ApprovedUserId;
onlyAdmission.Notes = item.Notes;
onlyAdmission.UserId = item.UserId;
onlyAdmission.Active = item.Active;
/* onlyAdmission.Patient = new Patient();
* onlyAdmission.Patient.FirstName = item.Patient.FirstName;
* onlyAdmission.Patient.LastName = item.Patient.LastName;
*
* onlyAdmission.Department = new Department();
*
* onlyAdmission.Department.Name = item.Department.Name;
*
* onlyAdmission.Item = new Item();
*
* onlyAdmission.Item.Name = item.Item.Name;*/
}
}
}
if (onlyAdmission == null)
{
return(Json(HttpNotFound(), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(onlyAdmission, JsonRequestBehavior.AllowGet));
}
}
private void ClearControls()
{
this.txtDiffDiag.Text = "";
this.txtProvDiag.Text = "";
this.txtPluse.Text = "";
this.txtTemp.Text = "";
this.txtRR.Text = "";
this.txtBPsys.Text = "";
this.txtBPdia.Text = "";
CurrentAdmission = new PatientAdmission();
}
public bool Insert(PatientAdmission patientadmission)
{
int autonumber = 0;
PatientAdmissionDAC patientadmissionComponent = new PatientAdmissionDAC();
bool endedSuccessfuly = patientadmissionComponent.InsertNewPatientAdmission(ref autonumber, patientadmission.AdmissionStartDate, patientadmission.DischargeDate, patientadmission.AdmissionStayTypeId, patientadmission.DischargeTypeId, patientadmission.PatientCode, patientadmission.ConsultantId, patientadmission.SpecialityId, patientadmission.WardBedId);
if (endedSuccessfuly)
{
patientadmission.PatientAdmissionId = autonumber;
}
return(endedSuccessfuly);
}
private bool WriteDevices(PatientAdmission patient)
{
foreach (var device in patient.Devices)
{
if (!WritePatientDevice(patient.PatientId, device))
{
Discharge(patient.PatientId);
return(false);
}
}
return(true);
}
public ActionResult Edit([Bind(Include = "PatientAdmissionId,PatientId,RoomNo,DateOfAdmission,DateOfDischarge,Remarks,RemarkOfDischarge,DoctorId")] PatientAdmission patientAdmission)
{
if (ModelState.IsValid)
{
db.Entry(patientAdmission).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DoctorId = new SelectList(db.Doctors, "DoctorId", "DoctorName", patientAdmission.DoctorId);
ViewBag.PatientId = new SelectList(db.Patients, "PatientId", "PatientName", patientAdmission.PatientId);
return(View(patientAdmission));
}
//[ValidateAntiForgeryToken]
public JsonResult SaveAdmission(PatientAdmission Admission, long InititalSetupId)
{
PatientAdmission onlyAdmission;
using (Repository <PatientAdmission> Repository = new Repository <PatientAdmission> ())
{
Admission.UserId = GetLoggedinUserInfo().UserId;
onlyAdmission = Repository.Insert(Admission);
Repository.Commit();
}
using (Repository <InitialSetupItem> Repository = new Repository <InitialSetupItem>())
{
Expression <Func <InitialSetupItem, bool> > lambda;
lambda = (x => x.InitialSetupId == InititalSetupId && x.Active == true);
List <InitialSetupItem> onlyAdmissionItemList = Repository.GetByQuery(lambda).ToList();
foreach (InitialSetupItem initalsetupitem in onlyAdmissionItemList)
{
PatientService sItem = new PatientService();
sItem.PatientID = Admission.PatientId;
sItem.PatientAdmissionId = onlyAdmission.Id;
sItem.ItemId = initalsetupitem.ItemId;
sItem.ServiceActualPrice = initalsetupitem.Item.SalePrice;
sItem.ServiceListPrice = initalsetupitem.Item.SalePrice;
sItem.ServiceQuantity = 1;
sItem.ServiceDate = DateTime.Now;
sItem.Discount = 0;
using (Repository <PatientService> psRepository = new Repository <PatientService>())
{
psRepository.Insert(sItem);
psRepository.Commit();
}
}
}
if (onlyAdmission == null)
{
return(Json(HttpNotFound(), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(onlyAdmission, JsonRequestBehavior.AllowGet));
}
}
// GET: PatientAdmissions/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PatientAdmission patientAdmission = db.PatientAdmissions.Find(id);
if (patientAdmission == null)
{
return(HttpNotFound());
}
return(View(patientAdmission));
}
public PatientAdmission GetByID(int _patientAdmissionId)
{
PatientAdmissionDAC _patientAdmissionComponent = new PatientAdmissionDAC();
IDataReader reader = _patientAdmissionComponent.GetByIDPatientAdmission(_patientAdmissionId);
PatientAdmission _patientAdmission = null;
while (reader.Read())
{
_patientAdmission = new PatientAdmission();
if (reader["PatientAdmissionId"] != DBNull.Value)
{
_patientAdmission.PatientAdmissionId = Convert.ToInt32(reader["PatientAdmissionId"]);
}
if (reader["AdmissionStartDate"] != DBNull.Value)
{
_patientAdmission.AdmissionStartDate = Convert.ToDateTime(reader["AdmissionStartDate"]);
}
if (reader["DischargeDate"] != DBNull.Value)
{
_patientAdmission.DischargeDate = Convert.ToDateTime(reader["DischargeDate"]);
}
if (reader["AdmissionStayTypeId"] != DBNull.Value)
{
_patientAdmission.AdmissionStayTypeId = Convert.ToInt32(reader["AdmissionStayTypeId"]);
}
if (reader["DischargeTypeId"] != DBNull.Value)
{
_patientAdmission.DischargeTypeId = Convert.ToInt32(reader["DischargeTypeId"]);
}
if (reader["PatientCode"] != DBNull.Value)
{
_patientAdmission.PatientCode = Convert.ToString(reader["PatientCode"]);
}
if (reader["ConsultantId"] != DBNull.Value)
{
_patientAdmission.ConsultantId = Convert.ToInt32(reader["ConsultantId"]);
}
if (reader["SpecialityId"] != DBNull.Value)
{
_patientAdmission.SpecialityId = Convert.ToInt32(reader["SpecialityId"]);
}
if (reader["WardBedId"] != DBNull.Value)
{
_patientAdmission.WardBedId = Convert.ToInt32(reader["WardBedId"]);
}
_patientAdmission.NewRecord = false;
}
reader.Close();
return(_patientAdmission);
}
//[ValidateAntiForgeryToken]
public JsonResult DischagePatient(PatientAdmission patientAdmission, bool isAdmin)
{
patientAdmission.Patient = null;
patientAdmission.Department = null;
patientAdmission.Item = null;
using (Repository <PatientAdmission> Repository = new Repository <PatientAdmission>())
{
if (!isAdmin)
{
patientAdmission.UserId = GetLoggedinUserInfo().UserId;
}
if (isAdmin)
{
patientAdmission.ApprovedUserId = GetLoggedinUserInfo().UserId;
}
if (patientAdmission.IsReleased)
{
patientAdmission.Active = false;
}
Repository.Update(patientAdmission);
Repository.Commit();
}
if (patientAdmission.IsReleased)
{
using (Repository <BedOccupancy> repository = new Repository <BedOccupancy>())
{
Expression <Func <BedOccupancy, bool> > lambda;
lambda = (x => x.Occupied == true && x.Active == true && x.AdmissioinId == patientAdmission.Id);
List <BedOccupancy> bedlist = new List <BedOccupancy>();
bedlist = repository.GetByQuery(lambda).ToList();
if (bedlist.Count > 0)
{
BedOccupancy bed = new BedOccupancy();
bed = bedlist[0];
bed.UserId = GetLoggedinUserInfo().UserId;
bed.Occupied = false;
bed.Active = false;
repository.Update(bed);
repository.Commit();
}
}
}
return(Json("Discharge successfull", JsonRequestBehavior.AllowGet));
}
public PatientAdmission Read(string patientId)
{
PatientAdmission patient = new PatientAdmission
{
PatientId = patientId,
AdmissionTime = DateTime.Now.ToString(),
Bed = new HospitalBed {
BedNumber = 10, Campus = "PIC", Floor = "2", Occupancy = patientId, Wing = "2A", RoomNumber = "12"
},
Devices = new List <Device>(),
Diagnosis = "Diagnosis",
DoctorId = "100",
Illness = "Fever",
MuteAlert = false
};
patient.Devices.Add(new Device
{
DeviceId = "Dev111",
Limits = new List <Limits>
{
new Limits
{
MaxValue = 50,
Message = "Normal",
MinValue = 0,
Type = LimitType.Normal
},
new Limits
{
MaxValue = 75,
Message = "Normal",
MinValue = 50,
Type = LimitType.Critical
},
new Limits
{
MaxValue = 100,
Message = "Normal",
MinValue = 75,
Type = LimitType.Warning
}
},
MaxInputValue = 100,
MinInputValue = 0
});
return(patient);
}
// GET: PatientAdmissions/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PatientAdmission patientAdmission = db.PatientAdmissions.Find(id);
if (patientAdmission == null)
{
return(HttpNotFound());
}
ViewBag.DoctorId = new SelectList(db.Doctors, "DoctorId", "DoctorName", patientAdmission.DoctorId);
ViewBag.PatientId = new SelectList(db.Patients, "PatientId", "PatientName", patientAdmission.PatientId);
return(View(patientAdmission));
}
private bool UpdateHospitalBed(PatientAdmission patient)
{
var oldBed = m_bedRepo.ReadPatientsBed(patient.PatientId);
if (patient.Bed.ToString() != oldBed.ToString())
{
oldBed.Occupancy = "";
if (m_bedRepo.Update(oldBed))
{
return(m_bedRepo.Update(patient.Bed));
}
return(false);
}
return(true);
}
public List <PatientAdmission> GetPatientAdmissionAdmit()
{
PatientAdmissions = new List <PatientAdmission>();
try
{
string Get = " Select * from PatientAdmission where status=0 ";
con = new OleDbConnection();
this.readconfile = new ReadConfigFile();
con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
tran = con.BeginTransaction();
cmd = new OleDbCommand(Get, con);
cmd.Transaction = tran;
dr = cmd.ExecuteReader();
while (dr.Read())
{
PatientAdmission c = new PatientAdmission();
// c. = Convert.ToInt32(dr["CityID"]);
c.PatientRegistration.Patient.RegistrationNumber = dr["PatientRegistrationNumber"].ToString();
c.PatientRegistration.Patient = new PatientDAL().GetPatientByNo(c.PatientRegistration.Patient.RegistrationNumber);
c.DiffDiag = dr["DiffDiag"].ToString();
c.provDiag = dr["ProvDiag"].ToString();
c.AdmissoinDate = dr["AdmissionDateTime"] == DBNull.Value ? DateTime.Now.Date : Convert.ToDateTime(dr["AdmissionDateTime"]);
c.Pluse = Convert.ToInt32(dr["Pluse"]);
c.Temp = Convert.ToInt32(dr["Temp"]);
c.BPsys = Convert.ToInt32(dr["BPsys"]);
c.BPdia = Convert.ToInt32(dr["BPdia"]);
c.RR = dr["RR"].ToString();
// c.CityName = dr["CityName"].ToString();
PatientAdmissions.Add(c);
}
dr.Close();
tran.Commit();
return(PatientAdmissions);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
private List <PatientAdmission> ParseAdmissions(SqlDataReader reader)
{
List <PatientAdmission> admissions = new List <PatientAdmission>();
while (reader.Read())
{
PatientAdmission admission = new PatientAdmission();
admission.AdmissionTime = (reader["AdmissionDate"]).ToString();
admission.Diagnosis = reader["Diagnosis"].ToString();
admission.DoctorId = reader["DoctorId"].ToString();
admission.Illness = reader["Illness"].ToString();
admission.PatientId = reader["PatientId"].ToString();
admission.MuteAlert = Convert.ToBoolean(reader["MuteAlert"]);
admissions.Add(admission);
}
return(admissions);
}
public void AlertUsers(PatientAlert alert)
{
AlertMonitorList subscribers = AlertMonitorList.Instance;
PatientAdmission patient = m_admissionRepository.Read(alert.PatientId);
if (patient.PatientId != alert.PatientId)
{
return;
}
string bedNo = patient.Bed.ToString();
string roomNo = bedNo.Substring(0, bedNo.LastIndexOf('-'));
TryInvoke(alert, subscribers.TryGetValue(roomNo));
AlertNurseStations(alert, roomNo, subscribers);
var func = subscribers.TryGetValue("Doctor" + patient.DoctorId);
alert.WarningAlerts = new List <DeviceAlert>();
TryInvoke(alert, func);
}
private List <Device> ReadDevices(PatientAdmission patientAdmission)
{
List <Device> deviceMap = new List <Device>();
foreach (var device in patientAdmission.Devices)
{
Device dev;
if (device.Limits != null)
{
dev = m_customDeviceRepo.ReadCustom(device.DeviceId, patientAdmission.PatientId);
}
else
{
dev = m_defaultDeviceRepo.Read(device.DeviceId);
}
deviceMap.Add(dev);
}
return(deviceMap);
}
private void PrintPreview(bool preview, PatientAdmission pa)
{
string BranchName = ConfigurationManager.AppSettings["Name"].ToString();
string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString();
DsPatientRegistration.PatientRegistrationDataTable prt = new DsPatientRegistration.PatientRegistrationDataTable();
PatientRegistration pr = new PatientRegistration();
pr = pa.PatientRegistration;
pr.TokenBy = IsLoginUser;
object[] values = { 0, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Address, pr.TokenType, pr.CashReceived, pr.Room.Name, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate, 0, pr.TokenBy.UserName };
prt.LoadDataRow(values, true);
DSPatientAdmission.PatientAdmissionDataTable pat = new DSPatientAdmission.PatientAdmissionDataTable();
object[] PAvalues = { pa.Pluse, pa.BP, pa.RR, pa.AdmissoinDate, pa.DiffDiag, pa.provDiag };
pat.LoadDataRow(PAvalues, true);
rptPatientClinicalRoport crp = new rptPatientClinicalRoport();
// crp.SetDataSource((DataTable)prt);
crp.Database.Tables[0].SetDataSource((DataTable)pat);
crp.Database.Tables[1].SetDataSource((DataTable)prt);
crp.SetDataSource((DataTable)pat);
crp.SetParameterValue("Name", BranchName);
crp.SetParameterValue("Address", BranchAddress);
FrmReportViewer frmViewer = new FrmReportViewer();
frmViewer.crystalReportViewer1.ReportSource = crp;
if (true)
{
frmViewer.ShowDialog();
}
else
{
frmViewer.crystalReportViewer1.RefreshReport();
frmViewer.crystalReportViewer1.PrintReport();
}
}
public PatientAdmission Read(string patientId)
{
string query = $"Select * FROM PatientAdmission WHERE PatientId='{patientId}'";
var patientAdmissions = patientAdmissionReader.FetchPatientAdmissions(conString, query);
patientAdmissionReader.FetchPatientsDevices(conString, ref patientAdmissions);
foreach (var patientAdmission in patientAdmissions)
{
patientAdmission.Devices = ReadDevices(patientAdmission);
}
if (patientAdmissions.Any())
{
patientAdmissions.First().Bed = m_bedRepo.ReadPatientsBed(patientAdmissions.First().PatientId);
return(patientAdmissions.First());
}
PatientAdmission admission = new PatientAdmission
{
Devices = new List <Device>(), Bed = new HospitalBed()
};
return(admission);
}
