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