public bool updateDoctorUserID(Entities.Doctor doctor) { int count; using (Entities.Entities ctx = new Entities.Entities()) { var doc = ctx.Doctors.FirstOrDefault(d => d.DoctorID == doctor.DoctorID); doc.UserID = doctor.UserID; count = ctx.SaveChanges(); } return(count > 0 ? true : false); }
public Entities.EpisodeOfCare FindEpisodeOfCareById(Guid episodeOfCareId) { Entities.EpisodeOfCare episodeOfCare = QueryOne <Entities.EpisodeOfCare>("[EPONS].[FindEpisodeOfCareById]", new { episodeOfCareId = episodeOfCareId }); //string reasonForAdmissionName = null; //if (episodeOfCare.AdmissionTypeId != Guid.Empty) //{ // ListRepository _listRepository = new ListRepository(GetConnection()); ; // IList<ValueObjects.ListItem> icd10Codes = _listRepository.GetICD10CodesByCodes(episodeOfCare.AdmissionTypeId.ToString()); // reasonForAdmissionName = icd10Codes.FirstOrDefault().Name; //} //episodeOfCare.ReasonForAdmissionName = reasonForAdmissionName; var refDrID = episodeOfCare.ReferringDoctorId; if (refDrID != null) { Entities.Doctor refDr = QueryOne <Entities.Doctor>("[EPONS].[FindDoctorById]", new { doctorid = episodeOfCare.ReferringDoctorId }); episodeOfCare.ReferringDoctor = refDr; episodeOfCare.ReferringDoctorName = refDr.Name; episodeOfCare.ReferringDoctorNumber = refDr.ContactNumber; episodeOfCare.ReferringDoctorEmail = refDr.Email; episodeOfCare.ReferringDoctorPracticeName = refDr.PracticeName; episodeOfCare.ReferringDoctorHPCSANumber = refDr.HPCSANumber; } var attDrId = episodeOfCare.AttendingDoctorId; if (attDrId != null) { Entities.Doctor attDr = QueryOne <Entities.Doctor>("[EPONS].[FindDoctorById]", new { doctorid = episodeOfCare.AttendingDoctorId }); episodeOfCare.AttendingDoctor = attDr; episodeOfCare.AttendingDoctorName = attDr.Name; episodeOfCare.AttendingDoctorNumber = attDr.ContactNumber; episodeOfCare.AttendingDoctorEmail = attDr.Email; episodeOfCare.AttendingDoctorPracticeName = attDr.PracticeName; episodeOfCare.AttendingDoctorHPCSANumber = attDr.HPCSANumber; } return(episodeOfCare); }