public async Task <APIResult <QuanHamViewModel> > Details(int IDQH) { var qh = _context.QuanHams.FirstOrDefaultAsync(x => x.IDQH == IDQH); var qhvm = new QuanHamViewModel() { IDQH = qh.Result.IDQH, TenQH = qh.Result.TenQH }; return(new APISuccessedResult <QuanHamViewModel>(qhvm)); }
public async Task <APIResult <List <QuanHamViewModel> > > GetAllWithoutPaging() { var query = from qh in _context.QuanHams select qh; var list = new List <QuanHamViewModel>(); foreach (var data in query) { var qh = new QuanHamViewModel() { IDQH = data.IDQH, TenQH = data.TenQH }; list.Add(qh); } return(new APISuccessedResult <List <QuanHamViewModel> >(list)); }
public async Task <APIResult <List <QuanHamViewModel> > > GetListQuanHamNotInHeSoLuong() { var query = (from qh in _context.QuanHams where !_context.HeSoLuongTheoQuanHams.Any(x => x.IDQH == qh.IDQH) select qh); var list = new List <QuanHamViewModel>(); foreach (var data in query) { var qhvm = new QuanHamViewModel() { IDQH = data.IDQH, TenQH = data.TenQH }; list.Add(qhvm); } return(new APISuccessedResult <List <QuanHamViewModel> >(list)); }