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