public ActionResult ApprovedQuotes(int page = 1) { var pageSize = 15; var quotes = _quoteService.GetQuotes().Select( q => new QuoteIndexViewModel { Id = q.Id, CustomerName = q.Customer.Name, QuoteNo = q.QuoteNumber, CreatedBy = q.CreatedBy.Name, DateCreated = q.DateCreated.ToLongDateString(), OrderNo = q.OrderNumber, AdviceNo = q.AdviceNumber, CurrencyName = q.Currency.Name }).OrderBy(q => q.QuoteNo).Skip((page - 1) * pageSize).Take(pageSize); var viewModel = new QuoteListViewModel { Items = quotes, Page = page, PageSize = pageSize, Total = _quoteService.GetQuotesCount() }; return(View(viewModel)); }
// GET: /<controller>/ public IActionResult Index() { var orgId = getOrg(); var allquotes = _context.QuoteRecords.Where(x => x.OrganisationId == orgId).Where(x => x.DateCreated.Month == DateTime.Now.Month).OrderByDescending(x => x.DateCreated).ToList(); var customer = _context.Customers.Where(x => x.OrganisationId == orgId).ToList(); ViewData["StatusMessage"] = StatusMessage; List <QuoteListViewModel> listQVM = new List <QuoteListViewModel>(); QuoteListViewModel qVM; foreach (var item in allquotes) { qVM = new QuoteListViewModel(); qVM.QuoteRecord = item; qVM.Customer = customer.Where(x => x.Id == item.CustomerId).FirstOrDefault(); listQVM.Add(qVM); } return(View(listQVM.OrderByDescending(x => x.QuoteRecord.DateCreated))); }