Esempio n. 1
0
 public void Update(Contestant contestant)
 {
     using (var con = new SqlConnection(connectionString))
     {
         con.Open();
         using (var com = new SqlCommand())
         {
             com.Connection  = con;
             com.CommandText = "UPDATE Contestants SET [name] = @Name, ind_score = @IndScore, team_name = @TeamName, team_score = @TeamScore, fav_obstacle = @FavObstacle WHERE Id = @id";
             com.Parameters.AddWithValue("@Id", contestant.Id);
             com.Parameters.AddWithValue("@Name", contestant.Name);
             com.Parameters.AddWithValue("@IndScore", contestant.IndScore);
             com.Parameters.AddWithValue("@TeamName", contestant.TeamName);
             com.Parameters.AddWithValue("@TeamScore", contestant.TeamScore);
             com.Parameters.AddWithValue("@FavObstacle", contestant.FavObstacle);
             com.ExecuteNonQuery();
         }
     }
 }
 static void UpdateContestant(IDatabase database, Contestant contestant)
 {
     database.Update(contestant);
 }
 static void AddContestant(IDatabase database, Contestant contestant)
 {
     database.Create(contestant);
 }
Esempio n. 4
0
 public void Update(Contestant contestant)
 {
     throw new NotImplementedException();
 }