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