public IActionResult Index()
{
Employee model = new Employee();
// DoctorsSchedule model = new DoctorsSchedule();
List <DoctorsScheduleViewhome> doctorseduleList = (from p in _accountRepository.GetAllPerson()
join e in _employeeRepository.GetAllEmployees() on p.Id equals e.PersonId
join ds in _doctorsScheduleRepository.GetAllDoctorsSchedule() on e.Id equals ds.EmployeeId
select new DoctorsScheduleViewhome
{
PersonId = p.Id,
Id = ds.Id,
EmployeeId = ds.EmployeeId,
Name = p.Name,
Day = ds.Day,
Time = ds.Time
}).OrderBy(x => x.Day).ThenBy(x => x.Time).ThenBy(x => x.Name).ToList();
model.DoctorsScheduleList = doctorseduleList;
List <EmployeeView> empList = (from e in _employeeRepository.GetAllEmployees()
join p in _accountRepository.GetAllPerson() on e.PersonId equals p.Id
select new EmployeeView
{
Name = p.Name,
PhotoPath = e.PhotoPath
}).ToList();
// var model = _employeeRepository.GetAllEmployees();
model.EmployeeList = empList;
return(View(model));
}
public ViewResult ListDoctorShedule()
{
DoctorsSchedule model = new DoctorsSchedule();
List <DoctorsScheduleView> doctorseduleList = (from p in _accountRepository.GetAllPerson()
join e in _employeeRepository.GetAllEmployees() on p.Id equals e.PersonId
join ds in _doctorsScheduleRepository.GetAllDoctorsSchedule() on e.Id equals ds.EmployeeId
select new DoctorsScheduleView
{
PersonId = p.Id,
Id = ds.Id,
EmployeeId = ds.EmployeeId,
Name = p.Name,
Day = ds.Day,
Time = ds.Time
}).OrderBy(x => x.Day).ThenBy(x => x.Time).ThenBy(x => x.Name).ToList();
model.DoctorsScheduleList = doctorseduleList;
return(View(model));
}
