public static async Task <int> GetNumberOfPricingUnitsForItemAsync(string itemId, string connectionString)
{
var query = @"SELECT COUNT(*)
FROM dbo.CataloguePrice
WHERE CatalogueItemId = @itemId;";
var result = await SqlExecutor.ExecuteScalarAsync(connectionString, query, new { itemId });
return(result);
}
public async Task <int> RetrieveCountAsync(string connectionString)
{
var query = @"SELECT COUNT(*) FROM [dbo].[MarketingContact] WHERE SolutionId=@solutionId";
return(await SqlExecutor.ExecuteScalarAsync(connectionString, query, new { SolutionId }));
}
