public async Task <List <SearchManager.SearchType> > GetSearchTypesByNetworkIdAndServiceGroupIdAsync(
SearchManager searcher, DataHelpers.SUBAPPLICATION_TYPES subAppType,
int typeId, int networkId, int serviceGroupId)
{
SearchManager.SearchType searchTypeSelected = new SearchManager.SearchType();
List <SearchManager.SearchType> colSearchTypes = await _repository
.GetSearchTypesByNetworkIdAndServiceGroupIdAsync(
searcher.SearchResult, subAppType, networkId, serviceGroupId);
searchTypeSelected = colSearchTypes.FirstOrDefault(
st => st.Id == typeId);
if (searchTypeSelected != null)
{
searchTypeSelected.IsSelected = true;
}
else
{
if (colSearchTypes.Count > 0)
{
searchTypeSelected = colSearchTypes[0];
}
if (searchTypeSelected != null)
{
searchTypeSelected.IsSelected = true;
}
}
if (searchTypeSelected == null)
{
searchTypeSelected = new SearchManager.SearchType();
}
searcher.SearchTypeSelected = searchTypeSelected;
return(colSearchTypes);
}
public async Task <List <SearchManager.SearchType> > GetTypesAsync(
ContentURI uri, int networkId, int serviceGroupId)
{
Helpers.SqlIOAsync sqlIO = new Helpers.SqlIOAsync(uri);
SqlParameter[] colPrams =
{
sqlIO.MakeInParam("@NetworkId", SqlDbType.Int, 4, networkId),
sqlIO.MakeInParam("@ServiceGroupId", SqlDbType.Int, 4, serviceGroupId)
};
SqlDataReader categories = await sqlIO.RunProcAsync(
"0GetCategories", colPrams);
List <SearchManager.SearchType> colSearchTypes
= new List <SearchManager.SearchType>();
if (categories != null)
{
using (categories)
{
//categories return id, label, name, servicegroupid and networkid sorted by label
//contenturi not strictly needed
while (categories.Read())
{
SearchManager.SearchType searchType = new SearchManager.SearchType();
searchType.Id = categories.GetInt32(0);
searchType.Label = categories.GetString(1);
searchType.Name = categories.GetString(2);
searchType.NetworkId = categories.GetInt32(3);
searchType.ServiceClassId = categories.GetInt32(4);
colSearchTypes.Add(searchType);
}
}
}
sqlIO.Dispose();
return(colSearchTypes);
}
