public ObservableCollection <DataGridTreatmentsViewModel> FillGrid() { ObservableCollection <DataGridTreatmentsViewModel> dataSource = new ObservableCollection <DataGridTreatmentsViewModel>(); ObservableCollection <Treatment> treatments = new ObservableCollection <Treatment>(); DataGridTreatmentsViewModel data = new DataGridTreatmentsViewModel(); CustomPrincipal customPrincipal = Thread.CurrentPrincipal as CustomPrincipal; string currentEmail = customPrincipal.Identity.Email; var context = new MedicalDBEntities(); var query = context.Users .Where(s => s.email == currentEmail) .FirstOrDefault <User>(); User user = query; var queryTreat = from st in context.Treatments where st.idUser == user.idUser select st; if (queryTreat != null) { foreach (Treatment t in queryTreat) { treatments.Add(t); } dataSource = data.FillTreatmentsGrid(treatments); return(dataSource); } else { MessageBox.Show("Nu aveti introduse tratamente medicale momentan"); return(null); } }
private void SearchUser(object obj) { if (Cnp != null) { ObservableCollection <DataGridTreatmentsViewModel> dataSource = new ObservableCollection <DataGridTreatmentsViewModel>(); ObservableCollection <Treatment> treatments = new ObservableCollection <Treatment>(); DataGridTreatmentsViewModel data = new DataGridTreatmentsViewModel(); CustomPrincipal customPrincipal = Thread.CurrentPrincipal as CustomPrincipal; string currentEmail = customPrincipal.Identity.Email; var context = new MedicalDBEntities(); var query = context.Users .Where(s => s.email == currentEmail) .FirstOrDefault <User>(); User user = query; var queryDoc = context.Doctors .Where(s => s.idUser == user.idUser) .FirstOrDefault <Doctor>(); Doctor doc = queryDoc; var patient = context.Users .Where(s => s.CNP == Cnp) .FirstOrDefault <User>(); if (patient != null) { var queryTreat = from st in context.Treatments where st.idUser == patient.idUser select st; if (queryTreat.FirstOrDefault <Treatment>() != null) { foreach (Treatment t in queryTreat) { treatments.Add(t); } dataSource = data.FillTreatmentsGrid(treatments); _dataSource = dataSource; NotifyPropertyChanged("DataSource"); } else { MessageBox.Show("Acest pacient nu are tratament momentan"); } } else { MessageBox.Show("Nu s-a gasit pacient cu acest CNP"); } } else { MessageBox.Show("Introduceti mai intai CNP-ul!"); } }
public ObservableCollection <DataGridTreatmentsViewModel> FillTreatmentsGrid(ObservableCollection <Treatment> treatments) { ObservableCollection <DataGridTreatmentsViewModel> dataSource = new ObservableCollection <DataGridTreatmentsViewModel>(); foreach (Treatment t in treatments) { DataGridTreatmentsViewModel data = new DataGridTreatmentsViewModel(); data.NamePatient = GetPatientName(t.idUser); data.SurnamePatient = GetPatientSurname(t.idUser); data.Cnp = GetPatientCnp(t.idUser); data.Diagnosis = GetDiagnosis(t.idDiagnosis); data.NameDoctor = GetDoctorName(t.idDoctor); data.StartDate = t.dateStart; data.FinishDate = t.dateFinish; data.Medicines = GetMedicines(t.idTreatment); data.Observations = t.observation; dataSource.Add(data); } return(dataSource); }