public ICUStatu GetSpecificPatient(string id)
{
using (ICUDBEntities1 entities = new ICUDBEntities1())
{
var entity = entities.ICUStatus.Where(e => e.PatientId.ToLower() == id.ToLower());
return(entity.FirstOrDefault());
}
}
public ICUStatu GetPatientBasedOnBed(int id)
{
using (ICUDBEntities1 entities = new ICUDBEntities1())
{
var entity = entities.ICUStatus.Where(e => e.bedNo == id);
return(entity.FirstOrDefault());
}
}
public void AlertStatus(string id)
{
using (ICUDBEntities1 entities = new ICUDBEntities1())
{
var entity = entities.ICUStatus.FirstOrDefault(e => e.PatientId.ToLower() == id.ToLower());
entity.PatientStatus = "Alert";
entities.SaveChanges();
}
}
public ICUStatu AddPatient(ICUStatu record)
{
using (ICUDBEntities1 entities = new ICUDBEntities1())
{
var entity = entities.ICUStatus.Add(record);
entities.SaveChanges();
return(entity);
}
}
public ICUStatu UpdateTemp(string id, int temp)
{
using (ICUDBEntities1 entities = new ICUDBEntities1())
{
var entity = entities.ICUStatus.FirstOrDefault(e => e.PatientId == id);
entity.Temperature = temp;
entities.SaveChanges();
return(entity);
}
}
public ICUStatu UpdatePulse(string id, int pulse)
{
using (ICUDBEntities1 entities = new ICUDBEntities1())
{
var entity = entities.ICUStatus.FirstOrDefault(e => e.PatientId == id);
entity.PulseRate = pulse;
entities.SaveChanges();
return(entity);
}
}
public ICUStatu UpdateSpo2(string id, int spo2)
{
using (ICUDBEntities1 entities = new ICUDBEntities1())
{
var entity = entities.ICUStatus.FirstOrDefault(e => e.PatientId == id);
entity.SPO2 = spo2;
entities.SaveChanges();
return(entity);
}
}
public List <int> GetVitals(string id)
{
List <int> vitalsList = new List <int>();
using (ICUDBEntities1 entities = new ICUDBEntities1())
{
var entity = entities.ICUStatus.FirstOrDefault(e => e.PatientId == id);
vitalsList.Add((int)entity.SPO2);
vitalsList.Add((int)entity.PulseRate);
vitalsList.Add((int)entity.Temperature);
}
return(vitalsList);
}
public ICUStatu UpdatePatientStatus(string id, ICUStatu updatestatus)
{
using (ICUDBEntities1 entities = new ICUDBEntities1())
{
var entity = entities.ICUStatus.FirstOrDefault(e => e.PatientId == id);
entity.FirstName = updatestatus.FirstName;
entity.LastName = updatestatus.LastName;
entity.AdmissionDate = updatestatus.AdmissionDate;
entity.DoctorAssigned = updatestatus.DoctorAssigned;
entity.PatientAge = updatestatus.PatientAge;
entity.PatientGender = updatestatus.PatientGender;
entity.PatientHeight = updatestatus.PatientHeight;
entity.PatientWeight = updatestatus.PatientWeight;
entity.PatientStatus = updatestatus.PatientStatus;
entity.SPO2 = updatestatus.SPO2;
entity.Temperature = updatestatus.Temperature;
entity.PulseRate = updatestatus.PulseRate;
entity.bedNo = updatestatus.bedNo;
entity.OtherMedications = updatestatus.OtherMedications;
entity.PatientDob = updatestatus.PatientDob;
entities.SaveChanges();
return(entity);
}
}
public List <ICUStatu> GetPatient()
{
using (ICUDBEntities1 entities = new ICUDBEntities1())
{ return(entities.ICUStatus.Where(e => e.PatientStatus.ToLower() != "discharged").ToList()); }
}
