public List <PostUpdate> GetUpdatePosts()
{
List <PostUpdate> updateposts = new List <PostUpdate>();
using (MySqlCommand query = new MySqlCommand("select * from updatepost", con))
{
con.Open();
var reader = query.ExecuteReader();
while (reader.Read())
{
PostUpdate post = new PostUpdate();
post.id = reader.GetInt32(0);
post.postID = reader.GetInt32(1);
post.title = reader.GetString(2);
post.description = reader.GetString(3);
if (!reader.IsDBNull(3))
{
post.image = reader.GetString(4);
}
updateposts.Add(post);
}
}
return(updateposts);
}
public string UpdatePost(PostUpdate post)
{
try
{
con.Open();
string sql = "INSERT INTO updatepost (postID, title, description, image) VALUES('" + post.postID + "', '" + post.title + "', '" + post.description + "', '" + post.image + "');";
MySqlCommand cmd = new MySqlCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
return("Data save Successfully");
}
catch (Exception ex)
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
return(ex.Message.ToString());
}
}
