public List <DoctorDTO> GetDoctorByPhongKham(int id) { return(db.SP_BacSi_GetByPhongBan_Id(id).Select(q => new DoctorDTO { FullName = q.TenNhanVien, IDDoctor = q.NhanVien_Id, LichLamViecs = null, PhongBan = new PhongBanDTO { ChuyenKhoa = new ChuyenKhoaDTO { Name = q.Name, IDChuyenKhoa = q.IDChuyenKhoa, Status = q.ChuyenKhoa_Status, }, IDChuyenKhoa = q.IDChuyenKhoa, PhongBan_Id = q.PhongBan_Id, Status = q.PhongBan_Status, IDPhongBan = q.IDPhongBan, TenPhongBan = q.TenPhongBan, } }).OrderBy(q => q.FullName).ToList()); }