private List <Event> GetEvents(int registrationId) { var reader = Reader.GetTableReader(CoordinatorRequest.Events(registrationId)); var events = new List <Event>(); while (reader.Read()) { var localEvent = new Event( reader["EventId"].ToString(), reader["EventName"].ToString() ); events.Add(localEvent); } return(events); }
public List <RegistrationStatus> GetRegistrationStatuses() { var reader = Reader.GetTableReader(CoordinatorRequest.Statuses()); var statuses = new List <RegistrationStatus>(); while (reader.Read()) { var status = new RegistrationStatus( reader["RegistrationStatusId"].ToString(), reader["RegistrationStatus"].ToString() ); statuses.Add(status); } return(statuses); }
public List <Country> GetCountries() { var reader = Reader.GetTableReader(CoordinatorRequest.Countries()); var countries = new List <Country>(); while (reader.Read()) { var country = new Country( reader["CountryCode"].ToString(), reader["CountryName"].ToString() ); countries.Add(country); } return(countries); }
public List <Charity> GetCharities() { var reader = Reader.GetTableReader(CoordinatorRequest.Charities()); var charities = new List <Charity>(); while (reader.Read()) { var totalAmount = Convert.ToDouble(reader["Total"].ToString()); var charity = new Charity( reader["CharityId"].ToString(), reader["CharityName"].ToString(), totalAmount, reader["CharityLogo"].ToString() ); charities.Add(charity); } return(charities); }
public List <User> GetAllRunners() { var reader = Reader.GetTableReader(CoordinatorRequest.Runners()); var users = new List <User>(); while (reader.Read()) { var role = new Role(reader["RoleId"].ToString()); var user = new User( reader["Email"].ToString(), reader["Password"].ToString(), reader["FirstName"].ToString(), reader["LastName"].ToString(), role ); user.registrationStatus = new RegistrationStatus( reader["RegistrationStatusId"].ToString(), reader["RegistrationStatus"].ToString(), reader["RegistrationId"].ToString() ); var country = new Country( reader["CountryCode"].ToString(), reader["CountryName"].ToString() ); user.runnerData = new RunnerData( reader["RunnerId"].ToString(), reader["Gender"].ToString(), reader["Date"].ToString(), country ); user.runnerData.charity = new Charity( reader["CharityId"].ToString(), reader["CharityName"].ToString() ); user.runnerData.kitOption = new KitOption( reader["RaceKitOptionId"].ToString(), reader["RaceKitOption"].ToString() ); user.runnerData.target = Convert.ToDouble(reader["Cost"].ToString()); users.Add(user); } //SetRunnersEvent(users); return(users); }
public void EditUser(User user) { using (SqlConnection con = new SqlConnection(Configuration.someeServer)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = CoordinatorRequest.UpdateUser(user); cmd.ExecuteNonQuery(); SqlCommand cmdRunner = con.CreateCommand(); cmdRunner.CommandType = CommandType.Text; var runner = user.runnerData; cmdRunner.CommandText = CoordinatorRequest.UpdateRunner(runner, user.email); cmdRunner.Parameters.AddWithValue("@DateOfBirth", Convert.ToDateTime(runner.dateOfBirth)); cmdRunner.ExecuteNonQuery(); SqlCommand cmdStatus = con.CreateCommand(); cmdStatus.CommandType = CommandType.Text; cmdStatus.CommandText = CoordinatorRequest.UpdateRegistrationStatus(user.registrationStatus); cmdStatus.ExecuteNonQuery(); } }