//This will get some post data by using post ID.
public NewPost GetPost(int id)
{
string conString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=OnlineWebSite;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
SqlConnection con = new SqlConnection(conString);
con.Open();
string query = $"select * from Posts " +
$"where Id = @u";
SqlParameter p1 = new SqlParameter("u", id);
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add(p1);
SqlDataReader dr = cmd.ExecuteReader();
NewPost p = new NewPost();
if (dr.HasRows)
{
if (dr.Read())
{
p.title = dr["title"].ToString();
p.content = dr["content"].ToString();
}
}
con.Close();
return(p);
}
//This will Update the Post into the DBMS.
public void UpdatePost(int id, NewPost p)
{
string conString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=OnlineWebSite;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
SqlConnection con = new SqlConnection(conString);
con.Open();
string query = $"update Posts set title = @t, content = @c " +
$"where Id = @i";
SqlParameter p1 = new SqlParameter("i", id);
SqlParameter p2 = new SqlParameter("t", p.title);
SqlParameter p3 = new SqlParameter("c", p.content);
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
int status = cmd.ExecuteNonQuery();
con.Close();
}
