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