public List <Runner> GetRunners()
{
var reader = Reader.GetTableReader(SponsorRequest.Runners());
var runners = new List <Runner>();
while (reader.Read())
{
var charity = new Charity(
reader["CharityId"].ToString(),
reader["CharityName"].ToString(),
reader["CharityDescription"].ToString(),
reader["CharityLogo"].ToString()
);
var runner = new Runner(
reader["RunnerId"].ToString(),
reader["RegistrationId"].ToString(),
reader["FirstName"].ToString(),
reader["LastName"].ToString(),
reader["CountryName"].ToString(),
reader["SponsorshipTarget"].ToString(),
charity
);
runners.Add(runner);
}
return(runners);
}
public void SponsorRunner(string name, Runner runner, double amount)
{
using (SqlConnection con = new SqlConnection(Configuration.someeServer))
{
con.Open();
var cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = SponsorRequest.Sponsor(name, runner, amount);
cmd.ExecuteNonQuery();
runner.sponsorshipTarget += amount;
var cmdUpdate = con.CreateCommand();
cmdUpdate.CommandType = CommandType.Text;
cmdUpdate.CommandText = SponsorRequest.UpdateSponsorshipTarget(runner);
cmdUpdate.ExecuteNonQuery();
}
}
