public async Task <IActionResult> UserDonations(UserForDonationDto userForDonationDto)
{
using (SqlConnection connection = new SqlConnection(configuration.GetConnectionString("DefaultConnection")))
{
var values = await connection.QueryAsync <Donations>(String.Format("SELECT * FROM TableDonations WHERE Username like '{0}'", userForDonationDto.Username));
return(Ok(values));
}
}
public async Task <IActionResult> UserDonations(UserForDonationDto userForDonationDto)
{
myList.Clear();
var values = await _context.TableDonations.ToListAsync();
foreach (var item in values)
{
if (item.Username == userForDonationDto.Username)
{
myList.Add(item);
}
}
return(Ok(myList));
}