Sorting an array by name alphabetically

Question

I currently have an array of "Brand Products" that I am trying to sort into alphabetical order based on their name after they are obtained from the database, the list is currently populated using this:

    protected override object[] GetCollection()
    {
        Brand brand = ItemLocator.LocateItem(this.Parent, typeof(Brand)) as Brand;

        ICriteria criteria = CoreHttpModule.Session.CreateCriteria(typeof(Product));
        criteria.Add(NHibernate.Expression.Expression.Eq("Brand", brand));
        criteria.Add(NHibernate.Expression.Expression.Eq("IsVisibleOnWebsite", true));

        IList<Product> productList = criteria.List<Product>();

        IList<Product> filteredLroductList = new List<Product>();

        for (int i = 0; i < productList.Count; i++)
        {
            if (productList[i].Parent != null)
            {
                filteredLroductList.Add(productList[i]);
            }
        }

        object[] filteredProductListArray = new object[filteredLroductList.Count];

        for (int i = 0; i < filteredLroductList.Count; i++)
        {
            filteredProductListArray.SetValue(filteredLroductList[i], i);
        }

             return filteredProductListArray;
    }

Asif Mushtaq · Accepted Answer · 2012-10-19 11:08:24Z

2

You can achieve it in a single linq expression.

products[] productList = criteria.List<Product>()
                                  .Where(p => p.Parent != null)
                                  .OrderBy((p => p.Name)
                                  .ToArray();

Comple code.

protected override object[] GetCollection()
{
    Brand brand = ItemLocator.LocateItem(this.Parent, typeof(Brand)) as Brand;

    ICriteria criteria = CoreHttpModule.Session.CreateCriteria(typeof(Product));
    criteria.Add(NHibernate.Expression.Expression.Eq("Brand", brand));
    criteria.Add(NHibernate.Expression.Expression.Eq("IsVisibleOnWebsite", true));

    products[] productList = criteria.List<Product>()
                                         .Where(p => p.Parent != null)
                                         .OrderBy((p => p.Name)
                                         .ToArray();
    return productList;
}

answered Oct 19, 2012 at 11:08

Asif Mushtaq

13.1k3 gold badges36 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hello World Over a year ago

I actually used an alternative method by doing most of it in NHibernate :) but thank for you the answer and I am sure this will help other people with similar issues!

ChrisF · Accepted Answer · 2012-10-19 11:04:23Z

0

I'd simply replace the 2^nd half of your method by:

return filteredProductList.OrderBy(f => f.BrandName).ToArray();

assuming that BrandName is what you want to order by

answered Oct 19, 2012 at 11:04

ChrisF

138k31 gold badges265 silver badges335 bronze badges

Comments

Artyom Skrobov · Accepted Answer · 2012-10-19 11:06:03Z

0

Something roughly like this, depending on your types:

var products = from p in GetCollection() orderby p.ProductName select p;

answered Oct 19, 2012 at 11:06

Artyom Skrobov

3101 silver badge11 bronze badges

Comments

Christian Phillips · Accepted Answer · 2012-10-19 11:21:53Z

0

If you keep it as a List, then you can use linq against the collection...

mylist = myList.OrderBy(x => x.Name).ToList();

edited Oct 19, 2012 at 11:21

answered Oct 19, 2012 at 11:07

Christian Phillips

18.8k8 gold badges55 silver badges85 bronze badges

Comments

Enigmativity · Accepted Answer · 2012-10-19 11:52:49Z

0

Try this:

protected override object[] GetCollection()
{
    Brand brand = ItemLocator.LocateItem(this.Parent, typeof(Brand)) as Brand;

    ICriteria criteria = CoreHttpModule.Session.CreateCriteria(typeof(Product));
    criteria.Add(NHibernate.Expression.Expression.Eq("Brand", brand));
    criteria.Add(NHibernate.Expression.Expression.Eq("IsVisibleOnWebsite", true));

    return criteria.List<Product>()
        .Where(x => x.Parent != null)
        .OrderBy(x => x.Name)
        .Cast<object>()
        .ToArray();
}

edited Oct 19, 2012 at 11:52

answered Oct 19, 2012 at 11:05

Enigmativity

117k12 gold badges101 silver badges184 bronze badges

1 Comment

Artyom Skrobov Over a year ago

How about filtering by Parent != null, as in the original?

Collectives™ on Stack Overflow

Sorting an array by name alphabetically

5 Answers 5

1 Comment

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related