public static List <VaccinationForPatientsTab> GetRepresentation(int treatmentHistoryId) { using (var context = new DataBaseContext()) { var TreatmentHistory = context.TreatmentHistories .Include(x => x.PastVaccinations) .Include(x => x.RequiredVaccinations) .SingleOrDefault(x => x.Id == treatmentHistoryId); return(TreatmentHistory.PastVaccinations .Select(x => new VaccinationForPatientsTab() { Id = x.Id, Status = x.VaccineStatus, StatusText = CustomEnumToString.GetVaccineStatusText(x.VaccineStatus), Name = x.VaccinesName, VaccinationDoneDate = x.VaccinationDate.HasValue ? x.VaccinationDate.Value.ToShortDateString() : "-", VaccinationObligatoryByDate = x.ObligatoryBy.HasValue ? x.ObligatoryBy.Value.ToShortDateString() : "Nie wymagane" }) .ToList() .Concat(TreatmentHistory.RequiredVaccinations .Select(x => new VaccinationForPatientsTab() { Id = x.Id, Status = x.VaccineStatus, StatusText = CustomEnumToString.GetVaccineStatusText(x.VaccineStatus), Name = x.VaccinesName, VaccinationDoneDate = x.VaccinationDate.HasValue ? x.VaccinationDate.Value.ToShortDateString() : "-", VaccinationObligatoryByDate = x.ObligatoryBy.HasValue ? x.ObligatoryBy.Value.ToShortDateString() : "Nie wymagane" }) .ToList()) .ToList()); } }
public static List <ShortPatientForPatientsTab> GetRepresentation() { using (var context = new DataBaseContext()) { return(context.Patients .AsEnumerable() .OrderBy(x => x.LastName) .Select(x => new ShortPatientForPatientsTab() { PatientId = x.Id, PatientsGender = x.PatientsPronounce.ToString(), EmailContact = CustomEnumToString.GetEmailContactText(x.EmailContact), FullName = x.FirstName + " " + x.LastName, EmailAdress = x.EmailAdress, DateOfBirth = x.DateOfBirth.ToLongDateString() }) .ToList()); } }