private async Task <int> GetCatalogRecordCount(AggregatedConditionDto condition, string spName)
{
using (var connection = new SqlConnection(ConnectionString))
{
var xml = condition.Serialize();
var result = await connection.ExecuteScalarAsync <int>(spName,
new
{
SearchConditionXml = xml,
LanguageID = condition.Language
},
commandType : CommandType.StoredProcedure);
return(result);
}
}
private async Task <IEnumerable <T> > GetCatalogItems <T>(AggregatedConditionDto condition, string spName)
{
var xml = condition.Serialize();
using (var connection = new SqlConnection(ConnectionString))
{
var result = await connection.QueryAsync <T>(spName,
new
{
SearchConditionXml = xml,
LanguageID = condition.Language,
intStart = condition.PageNumber * condition.PageSize,
intCount = condition.PageSize
},
commandType : CommandType.StoredProcedure);
return(result);
}
}
