/// <summary>
/// Retrieve searcher results
/// </summary>
public async Task <SqlDataReader> GetSearchRecordsAsync(SqlIOAsync sqlIO,
SearchManager searcher)
{
SqlDataReader dataReader = null;
if (searcher.SearchResult.URIDataManager.AppType == GeneralHelpers.APPLICATION_TYPES.networks ||
searcher.SearchResult.URIDataManager.AppType == GeneralHelpers.APPLICATION_TYPES.locals ||
searcher.SearchResult.URIDataManager.AppType == GeneralHelpers.APPLICATION_TYPES.addins)
{
dataReader = await GetAdminPageSearch(sqlIO, searcher);
}
else
{
if (searcher.SearchResult.URIDataManager.ServerSubActionType
== GeneralHelpers.SERVER_SUBACTION_TYPES.searchbyservice)
{
dataReader = await GetPageSearchByService(sqlIO, searcher);
}
else
{
dataReader = await GetPageSearch(sqlIO, searcher);
}
}
return(dataReader);
}
private async Task <SqlDataReader> GetPageSearchByService(SqlIOAsync sqlIO, SearchManager searcher)
{
SqlDataReader dataReader = null;
//initialize parameters for general query
string sQry = GetSearchByServiceQry(searcher.SearchResult);
if (sQry != string.Empty && sQry != null)
{
SqlParameter[] oPrams = GetPageSearchByServiceParams(searcher, sqlIO);
dataReader = await sqlIO.RunProcAsync(sQry, oPrams);
if (dataReader != null)
{
searcher.RowCount = dataReader.RecordsAffected;
}
}
return(dataReader);
}
private static SqlParameter[] GetPageSearchByServiceParams(SearchManager searcher,
SqlIOAsync data)
{
int iIsForward = GeneralHelpers.ConvertStringToInt(searcher.IsForward);
if (iIsForward != 1 || iIsForward != 0)
{
iIsForward = 1;
}
bool bNeedsTypeId = NeedsTypeIdSearchParam(searcher.SearchResult.URIDataManager.AppType);
if (bNeedsTypeId)
{
SqlParameter[] oPrams2 =
{
data.MakeInParam("@AccountId", SqlDbType.Int, 4, searcher.SearchResult.URIMember.ClubInUse.PKId),
data.MakeInParam("@NetworkId", SqlDbType.Int, 4, searcher.NetworkSelected.PKId),
data.MakeInParam("@NetworkType", SqlDbType.NVarChar, 25, searcher.NetworkType.ToString()),
data.MakeInParam("@Keywords", SqlDbType.NVarChar, 255, searcher.Keywords),
data.MakeInParam("@IsForward", SqlDbType.Bit, 1, iIsForward),
data.MakeInParam("@StartRow", SqlDbType.Int, 4, searcher.StartRow),
data.MakeInParam("@PageSize", SqlDbType.Int, 4, searcher.PageSize),
//filter for types
data.MakeInParam("@TypeId", SqlDbType.Int, 4, searcher.TypeId),
data.MakeInParam("@ServiceId", SqlDbType.Int, 4, searcher.ServiceSelected.ServiceId)
};
return(oPrams2);
}
else
{
SqlParameter[] oPrams3 =
{
data.MakeInParam("@AccountId", SqlDbType.Int, 4, searcher.SearchResult.URIMember.ClubInUse.PKId),
data.MakeInParam("@NetworkId", SqlDbType.Int, 4, searcher.NetworkSelected.PKId),
data.MakeInParam("@NetworkType", SqlDbType.NVarChar, 25, searcher.NetworkType.ToString()),
data.MakeInParam("@Keywords", SqlDbType.NVarChar, 255, searcher.Keywords),
data.MakeInParam("@IsForward", SqlDbType.Bit, 1, iIsForward),
data.MakeInParam("@StartRow", SqlDbType.Int, 4, searcher.StartRow),
data.MakeInParam("@PageSize", SqlDbType.Int, 4, searcher.PageSize),
data.MakeInParam("@ServiceId", SqlDbType.Int, 4, searcher.ServiceSelected.ServiceId)
};
return(oPrams3);
}
}
private async Task <SqlDataReader> GetPageSearch(SqlIOAsync sqlIO, SearchManager searcher)
{
SqlDataReader dataReader = null;
//initialize parameters for general query
//returns Web.ViewDataHelper records at a time
bool bIsPageSearch = true;
string sQry = GetQry(searcher.SearchResult, bIsPageSearch);
if (sQry != string.Empty && sQry != null)
{
SqlParameter[] oPrams = GetPageSearchParams(searcher, sqlIO);
dataReader = await sqlIO.RunProcAsync(sQry, oPrams);
if (dataReader != null)
{
searcher.RowCount = dataReader.RecordsAffected;
}
}
return(dataReader);
}
private async Task <SqlDataReader> GetAdminPageSearch(SqlIOAsync sqlIO, SearchManager searcher)
{
SqlDataReader dataReader = null;
//initialize parameters for general query
//uint iIsForward = 1;
//if (searcher.IsForward == "0") iIsForward = 0;
//returns pkid, name record list (children of the parent displayed at top of list)
string sQry = string.Empty;
bool bIsPageSearch = true;
sQry = GetQry(searcher.SearchResult, bIsPageSearch);
if (sQry != string.Empty && sQry != null)
{
SqlParameter[] oPrams = GetPageSearchParams(searcher, sqlIO);
dataReader = await sqlIO.RunProcAsync(sQry, oPrams);
if (dataReader != null)
{
searcher.RowCount = dataReader.RecordsAffected;
}
}
return(dataReader);
}