private ObservableCollection <DataGridAppoimentsViewModel> FillDataGrid()
{
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 currentUser = query;
var appoimentsQuery = from st in context.Appoiments
where st.idUser == currentUser.idUser
select st;
var app = appoimentsQuery.FirstOrDefault <Appoiment>();
ObservableCollection <Appoiment> appoiments = new ObservableCollection <Appoiment>();
foreach (var ap in appoimentsQuery)
{
appoiments.Add(ap);
}
DataGridAppoimentsViewModel data = new DataGridAppoimentsViewModel();
ObservableCollection <DataGridAppoimentsViewModel> source = new ObservableCollection <DataGridAppoimentsViewModel>();
source = data.FillAppoimentsGrid(appoiments);
return(source);
}
public ObservableCollection <DataGridAppoimentsViewModel> FillAppoimentsGrid(ObservableCollection <Appoiment> Appoiments)
{
ObservableCollection <DataGridAppoimentsViewModel> data = new ObservableCollection <DataGridAppoimentsViewModel>();
foreach (Appoiment ap in Appoiments)
{
DataGridAppoimentsViewModel apData = new DataGridAppoimentsViewModel();
apData.Date = ap.date.ToString("dd/MM/yyyy");
apData.Doctor = GetDoctor(ap.idDoctor);
apData.Specialization = GetSpecialization(ap.idService);
apData.Service = GetService(ap.idService);
apData.StartHour = ap.startTime;
apData.FinishHour = ap.startTime + 1;
apData.AppoimentId = ap.idAppoiment;
data.Add(apData);
}
return(data);
}