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 });
}