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