public void LoadData() { _Customers = new ObservableCollection<CustomerModel>(); var customerList = customerRepository.Retrieve(); CustomerTypeRepository customerTypeRepository = new CustomerTypeRepository(); var customerTypeList = customerTypeRepository.Retrieve(); //var sortedList = customerRepository.SortByName(customerList); // var itemList = customerRepository.GetNamesAndId(customerList); //var itemList = customerRepository.GetNamesAndType(customerList, // customerTypeList); var query = customerList.Join(customerTypeList, c => c.CustomerTypeId, ct => ct.CustomerTypeId, (c, ct) => new CustomerModel { Name = c.LastName + ", " + c.FirstName, CustomerTypeName = ct.TypeName }); foreach (var customerInstance in query.OrderBy(c=>c.Name)) { _Customers.Add(customerInstance); } }
private void GetCustomersButton_Click(object sender, EventArgs e) { //CustomerGridView.DataSource = customerRepository.Retrieve(); var customerList = customerRepository.Retrieve(); //CustomerGridView.DataSource = customerRepository.SortByName(customerList).ToList(); //CustomerGridView.DataSource = customerRepository.GetOverdueCustomers(customerList).ToList(); //var unpaidCustomerList = customerRepository.GetOverdueCustomers(customerList); //CustomerGridView.DataSource = customerRepository.SortByName(unpaidCustomerList).ToList(); CustomerTypeRepository customerTypeRepository = new CustomerTypeRepository(); var customerTypeList = customerTypeRepository.Retrieve(); CustomerGridView.DataSource = customerRepository.GetNamesAndType(customerList, customerTypeList); }