public ObservableCollection <DataGridAppoimentsDoctorViewModel> FillAppoimentsGrid(DateTime date)
{
var context = new MedicalDBEntities();
CustomPrincipal customPrincipal = Thread.CurrentPrincipal as CustomPrincipal;
string currentEmail = customPrincipal.Identity.Email;
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 app = context.Appoiments
.Where(s => s.idDoctor == doc.idDoctor && s.date == date);
ObservableCollection <Appoiment> appoiments = new ObservableCollection <Appoiment>();
foreach (Appoiment ap in app)
{
appoiments.Add(ap);
}
ObservableCollection <DataGridAppoimentsDoctorViewModel> dataSource = new ObservableCollection <DataGridAppoimentsDoctorViewModel>();
DataGridAppoimentsDoctorViewModel data = new DataGridAppoimentsDoctorViewModel();
dataSource = data.FillDataGrid(appoiments);
return(dataSource);
}
public ObservableCollection <DataGridAppoimentsDoctorViewModel> FillDataGrid(ObservableCollection <Appoiment> appoiments)
{
ObservableCollection <DataGridAppoimentsDoctorViewModel> dataSource = new ObservableCollection <DataGridAppoimentsDoctorViewModel>();
foreach (Appoiment a in appoiments)
{
DataGridAppoimentsDoctorViewModel data = new DataGridAppoimentsDoctorViewModel();
data.NameUser = GetNameUser(a.idUser);
data.SurnameUser = GetSurnameUser(a.idUser);
data.Cnp = GetCnpUser(a.idUser);
data.Date = a.date;
data.StartHour = a.startTime;
data.FinishHour = a.startTime + 1;
data.Service = GetService(a.idService);
dataSource.Add(data);
}
return(dataSource);
}
