public Joke UpdateJoke(Joke j)
{
using (conn = GetConnection())
{
SqlCommand cmd = new SqlCommand()
{
Connection = conn, CommandType = CommandType.StoredProcedure, CommandText = "UpdateJoke"
};
cmd.Parameters.AddWithValue("@JokeID", j.JokeId);
cmd.Parameters.AddWithValue("@Title", j.Title);
cmd.Parameters.AddWithValue("@JokeText", j.JokeText);
conn.Open();
cmd.ExecuteNonQuery();
return(j);
}
}
public Joke GetJoke(int jokeId)
{
using (conn = GetConnection())
{
List <Joke> jokes = new List <Joke>();
SqlCommand cmd = new SqlCommand("SELECT * FROM Jokes", conn);
SqlDataAdapter da = new SqlDataAdapter($"SELECT * FROM Jokes WHERE JokeID = { jokeId }", conn);
DataTable dt = new DataTable();
da.Fill(dt);
Joke j = new Joke()
{
JokeId = (int)dt.Rows[0]["JokeID"], Title = (string)dt.Rows[0]["Title"], JokeText = (string)dt.Rows[0]["Joke"]
};
return(j);
}
}
