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