public List <PhongBanDTO> GetPhongBans() { return(db.SP_PhongBan_GetAll().Select(q => new PhongBanDTO { PhongBan_Id = q.PhongBan_Id, TenPhongBan = q.TenPhongBan, ChuyenKhoa = new ChuyenKhoaDTO { Status = q.ChuyenKhoa_Status, Name = q.Name, IDChuyenKhoa = q.IDChuyenKhoa, }, IDChuyenKhoa = q.IDChuyenKhoa, IDPhongBan = q.IDPhongBan, Status = q.PhongBan_Status, }).OrderBy(q => q.TenPhongBan).ToList()); }