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