public async Task <IEnumerable <dynamic> > GetCountryHistoryAsync(string country)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
return(await connection.QueryAsync <dynamic>(OrderingQueriesText.CountryHistory(country), new { country }));
}
}
public async Task <IEnumerable <dynamic> > GetProductHistoryAsync(string productId)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
return(await connection.QueryAsync <dynamic>(OrderingQueriesText.ProductHistory(productId), new { productId }));
}
}
public async Task <IEnumerable <ProductData> > GetProductDataAsync(string productId)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
var productHistory = await connection.QueryAsync <ProductData>(OrderingQueriesText.ProductHistory(productId), new { productId });
return(productHistory.Where(p => p.next != 0 && p.prev != 0));
}
}
