Grouping Strings and Adding into a List<t>

I have now updated to a Complex Situation now and i am terribly stuck. Kindly Let me know if you can share some light to it.

I No more have this as List. It is now a List Which will have the Following properties

public class Categories

{

public string DisplayName { get; set; }

public string ValueCode { get; set; }

public string Count { get; set; }

}

This will have Values like

Category1/SubCategory1

cat1/sc1

Category1/SubCategory2

cat1/sc2

Category 2/Subcategory1

cat2/sc1

Category 2/Subcategory2

cat2/sc2

So, i updated my Existing JobCateogry Clas and so on.

public class JobCateogry

{

public string DisplayName { get; set; }

public string ValueCode { get; set; }

public string Count { get; set; }

public List SubCategories { get; set; }

}

I tried to Split the string and assign it to the new class in two step first by splitting and then by assiging. But i am sure i am doing it the wrong way, because the moment i split, i loose the count .

var lstCategory = Categories

.Where(i => i.count > 0)

.Select(item => item.valueCode.Split('/')

.Select(k =>(k)).ToList();

List jobcategories = lstCategory

.Select(item => item.Split(QueryStringConstants.CAT_SEPERATOR.ToCharArray()[0]))

.GroupBy(tokens => tokens[0].Trim(), tokens => tokens[1])

.Select(g => new JobCategories(g.Key, g.DisplayName,g.ToList(),)).ToList();

Can you please help?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Biswa Pujarini Mohapatra12y ago
Splitting each list item and then grouping by category name should give the desired result: list.Select(item => item.Split('/')) .GroupBy(tokens => tokens[0], tokens => tokens[1]) .Select(g => new TheClass { Category = g.Key, SubCategory = g.ToList() });
Biswa Pujarini Mohapatra12y ago
Find your answer here http://stackoverflow.com/questions/20671419/grouping-strings-and-adding-into-a-list