public static void SearchingCustomers(ApplicationDbContext _context, CustomersHistoryViewModel viewModel, string searchString) { foreach (var customer in viewModel.CustomersList) { if (customer.CompanyName == null) { customer.CompanyName = ""; } } if (!String.IsNullOrWhiteSpace(searchString)) { viewModel.CustomersList = viewModel.CustomersList.Where(c => c.FullName.ToUpper().Contains(searchString.ToUpper())).ToList(); } }
public static void SortingCustomers(ApplicationDbContext _context, CustomersHistoryViewModel viewModel, string sortOrder) { switch (sortOrder) { case "lastName_desc": viewModel.CustomersList = viewModel.CustomersList.OrderByDescending(c => c.LastName).ToList(); break; case "firstName_asc": viewModel.CustomersList = viewModel.CustomersList.OrderBy(c => c.FirstName).ToList(); break; case "firstName_desc": viewModel.CustomersList = viewModel.CustomersList.OrderByDescending(c => c.FirstName).ToList(); break; case "companyName_asc": viewModel.CustomersList = viewModel.CustomersList.OrderBy(c => c.CompanyName).ToList(); break; case "companyName_desc": viewModel.CustomersList = viewModel.CustomersList.OrderByDescending(c => c.CompanyName).ToList(); break; case "country_asc": viewModel.CustomersList = viewModel.CustomersList.OrderBy(c => c.Country).ToList(); break; case "country_desc": viewModel.CustomersList = viewModel.CustomersList.OrderByDescending(c => c.Country).ToList(); break; case "member_asc": viewModel.CustomersList = viewModel.CustomersList.OrderBy(c => c.MemberCard.Type).ToList(); break; case "member_desc": viewModel.CustomersList = viewModel.CustomersList.OrderByDescending(c => c.MemberCard.Type).ToList(); break; default: viewModel.CustomersList = viewModel.CustomersList.OrderBy(c => c.LastName).ToList(); break; } }
public static void GetCustomers(ApplicationDbContext _context, CustomersHistoryViewModel viewModel) { var customers = _context.Customers .Where(c => c.ActivityStatus == ActivityStatus.Active) .ToList(); foreach (var customer in customers) { viewModel.CustomersList.Add(new CustomerBasicDetailsViewModel() { CustomerID = customer.CustomerID, FirstName = customer.FirstName, LastName = customer.LastName, CompanyName = customer.CompanyName, Country = customer.Country, City = customer.City, MemberCard = customer.MemberCard }); } }