// GET: QuoteHdrs public async Task <ActionResult> Index() { QuoteFilterViewModel model = new QuoteFilterViewModel(); model.Companies = await db.Companies.ToDictionaryAsync(c => c.CompanyID, c => c.CompanyName); model.Users = await db.Users.ToDictionaryAsync(u => u.UserId, u => u.UserName); model.Quotes = await db.QuoteHdrs.ToListAsync(); return(View(model)); }
public async Task <ActionResult> Index(QuoteFilterViewModel model) { model.Companies = await db.Companies.ToDictionaryAsync(c => c.CompanyID, c => c.CompanyName); model.Users = await db.Users.ToDictionaryAsync(c => c.UserId, c => c.UserName); IQueryable <QuoteHdr> set = db.QuoteHdrs.AsQueryable(); if (true) { set = set.Where(q => q.CompanyID == model.CompanyId); } if (true) { set = set.Where(q => q.UserID == model.UserId); } model.Quotes = await set.ToListAsync(); return(View(model)); }