public void DeleteAll(AthleteRecord athlete) { this.command.CommandText = @" DELETE FROM EventParticipation WHERE AtheteId=@AthleteId"; this.command.Parameters.Add(new SqlParameter("@AthleteId", athlete.Id)); using (this.command) this.command.ExecuteNonQuery(); }
public void Insert(AthleteRecord athlete) { this._command.CommandText = @" INSERT INTO Athletes (Id, Nickname, FirstName, LastName, Gender, TrainerSizeM, TrainerSizeW, SpikeSizeM, SpikeSizeW, Notes, Status) VALUES (@Id, @Nickname, @FirstName, @LastName, @Gender, @TrainerSizeM, @TrainerSizeW, @SpikeSizeM, @SpikeSizeW, @Notes, @Status)"; SetupParameters(athlete); using (this._command) this._command.ExecuteNonQuery(); }
public void Update(AthleteRecord athlete) { this._command.CommandText = @" UPDATE Athletes SET Id=@Id, FirstName=@FirstName, LastName=@LastName, Gender=@Gender, TrainerSizeM=@TrainerSizeM, TrainerSizeW=@TrainerSizeW, SpikeSizeM=@SpikeSizeM, SpikeSizeW=@SpikeSizeW, Notes=@Notes, Status=@Status WHERE Id=@Id"; SetupParameters(athlete); using (this._command) this._command.ExecuteNonQuery(); }
private AthleteRecord Map(IDataReader reader) { var athleteRecord = new AthleteRecord(); athleteRecord.Id = Convert.ToInt32(reader["Id"]); athleteRecord.Nickname = Convert.ToString(reader["Nickname"]); athleteRecord.FirstName = Convert.ToString(reader["FirstName"]); athleteRecord.LastName = Convert.ToString(reader["LastName"]); athleteRecord.Gender = Convert.ToChar(reader["Gender"]); athleteRecord.TrainerSizeM = Convert.ToDouble(reader["TrainerSizeM"]); athleteRecord.TrainerSizeW = Convert.ToDouble(reader["TrainerSizeW"]); athleteRecord.SpikeSizeM = Convert.ToDouble(reader["SpikeSizeM"]); athleteRecord.SpikeSizeW = Convert.ToDouble(reader["SpikeSizeW"]); athleteRecord.Notes = Convert.ToString(reader["Notes"]); athleteRecord.Status = Convert.ToString(reader["Status"]); return athleteRecord; }
private void SetupParameters(AthleteRecord athlete) { this._command.Parameters.Add(new SqlParameter("@Id", athlete.Id)); this._command.Parameters.Add(new SqlParameter("@Nickname", athlete.Nickname)); this._command.Parameters.Add(new SqlParameter("@FirstName", athlete.FirstName)); this._command.Parameters.Add(new SqlParameter("@LastName", athlete.LastName)); this._command.Parameters.Add(new SqlParameter("@Gender", athlete.Gender)); this._command.Parameters.Add(new SqlParameter("@TrainerSizeM", athlete.TrainerSizeM)); this._command.Parameters.Add(new SqlParameter("@TrainerSizeW", athlete.TrainerSizeW)); this._command.Parameters.Add(new SqlParameter("@SpikeSizeM", athlete.SpikeSizeM)); this._command.Parameters.Add(new SqlParameter("@SpikeSizeW", athlete.SpikeSizeW)); this._command.Parameters.Add(new SqlParameter("@Notes", athlete.Notes)); this._command.Parameters.Add(new SqlParameter("@Status", athlete.Status)); }