/// <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();
}
