public SearchResultModel(DataSet resultDs) { Categories = new List <SearchResultCategory>(); foreach (DataTable dt in resultDs.Tables) { List <string> columns = new List <string>(); //data columns start at index 4 for (int i = 4; i < dt.Columns.Count; i++) { columns.Add(Resources.Localizer.GetString("Resources.Shared.Search", dt.Columns[i].ColumnName, dt.Columns[i].ColumnName)); } DataView dv = dt.DefaultView; dv.Sort = "group"; foreach (DataRowView drv in dv) { SearchResultCategory srCat = FindCategory(drv["table"].ToString()); if (srCat == null) { srCat = new SearchResultCategory(drv); srCat.Columns = columns; Categories.Add(srCat); } if (string.IsNullOrEmpty(FirstCategory)) { FirstCategory = srCat.Id; } SearchResultItem srItem = new SearchResultItem(drv, dt.Columns.Count); srCat.Items.Add(srItem); } } }
public SearchResultModel(DataSet resultDs) { Categories = new List<SearchResultCategory>(); foreach (DataTable dt in resultDs.Tables) { List<string> columns = new List<string>(); //data columns start at index 4 for(int i = 4; i < dt.Columns.Count; i++) { columns.Add(Resources.Localizer.GetString("Resources.Shared.Search", dt.Columns[i].ColumnName, dt.Columns[i].ColumnName)); } DataView dv = dt.DefaultView; dv.Sort = "group"; foreach (DataRowView drv in dv) { SearchResultCategory srCat = FindCategory(drv["table"].ToString()); if (srCat == null) { srCat = new SearchResultCategory(drv); srCat.Columns = columns; Categories.Add(srCat); } if (string.IsNullOrEmpty(FirstCategory)) { FirstCategory = srCat.Id; } SearchResultItem srItem = new SearchResultItem(drv, dt.Columns.Count); srCat.Items.Add(srItem); } } }