/// <summary> /// Llist new product which is splitted in maingroup and subgroup by lamda expression / linq /// </summary> public void GetProducts() { List <Product> listProducts = ProductMethods.ListProducts(); MainGroup = listProducts.Select(x => x.ProductGroup.Substring(0, 2)).OrderBy(x => x).ToList(); SubGroup = listProducts.Select(x => x.ProductGroup.Substring(3, 3)).OrderBy(x => x).ToList(); MainGroup = MainGroup.Distinct().ToList(); SubGroup = SubGroup.Distinct().ToList(); }