public void UpdatePrediction(PredictionDto oldPrediction, PredictionDto newPrediction) { for (int i = 0; i < predictions.Count; i++) { if (predictions[i].PredictionText == oldPrediction.PredictionText) { predictions[i].PredictionText = newPrediction.PredictionText; } } }
public void DeletePrediction(PredictionDto prediction) { for (int i = 0; i < predictions.Count; i++) { if (predictions[i].PredictionText == prediction.PredictionText) { predictions.RemoveAt(i); i--; } } }
public void DeletePrediction(PredictionDto prediction) { using IDbConnection db = new MySqlConnection("Server=127.0.0.1;Database=simplewebapp;Uid=root;Pwd=my-secret-pw;"); db.Execute("DELETE from predictions where predictionText = @PredictionText", new { PredictionText = prediction.PredictionText }); }
public void UpdatePrediction(PredictionDto oldPrediction, PredictionDto newPrediction) { using IDbConnection db = new MySqlConnection("Server=127.0.0.1;Database=simplewebapp;Uid=root;Pwd=my-secret-pw;"); //db.Execute("update predictions set predictionText = '" + newPrediction.PredictionText + "' where predictionText = @predictionText", oldPrediction); db.Execute("update predictions set predictionText = @newPred where predictionText = @oldPred", new { oldPred = oldPrediction.PredictionText, newPred = newPrediction.PredictionText }); }