public async Task <List <Donation> > SearchDonations(DonationQuery query)
{
using (var connection = GetConnection())
{
return((await connection.QueryAsync <Donation>(
@"SELECT * FROM donation
WHERE donee like @TextSearch OR party like @TextSearch or donee_address like @TextSearch",
query
)).ToList());
}
}
public async Task <List <PartyDonations> > GetDonationsByParty(DonationQuery query)
{
using (var connection = GetConnection())
{
return((await connection.QueryAsync <PartyDonations>(
@"SELECT party, SUM(amount) as total, SUM(number_of_donations) as numberOfDonations,
SUM(amount) / SUM(number_of_donations) as average
FROM donation
WHERE number_of_donations > 0
AND (@Year IS NULL OR year = @Year)
GROUP BY party", query
)).ToList());
}
}
