public static List <Post> PostSearch(string searchWord)
{
List <Post> allPosts = new List <Post> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT id, blog_id, title, content, date, file FROM posts WHERE content LIKE '%" + searchWord + "%' OR title LIKE '%" + searchWord + "%';";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int postId = rdr.GetInt32(0);
int postBlogId = rdr.GetInt32(1);
string postTitle = rdr.GetString(2);
string postContent = rdr.GetString(3);
DateTime postDate = rdr.GetDateTime(4);
string postFile = rdr.IsDBNull(5) ? null : rdr.GetString(5);
Post searchPost = new Post(postTitle, postContent, postFile, postBlogId, postId);
searchPost.SetDate(postDate);
allPosts.Add(searchPost);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allPosts);
}
public List <Post> GetPosts()
{
List <Post> allPosts = new List <Post> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM posts WHERE blog_id = @thisId;";
MySqlParameter thisId = new MySqlParameter("@thisId", _id);
cmd.Parameters.Add(thisId);
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int postId = rdr.GetInt32(0);
int blogId = rdr.GetInt32(1);
string postTitle = rdr.GetString(2);
string postContent = rdr.GetString(3);
DateTime postDate = rdr.GetDateTime(4);
string postFile = rdr.IsDBNull(5) ? null : rdr.GetString(5);
Post thisPost = new Post(postTitle, postContent, postFile, blogId, postId);
thisPost.SetDate(postDate);
allPosts.Add(thisPost);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allPosts);
}
public static Post Find(int id)
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM posts WHERE id = (@searchId);";
MySqlParameter searchId = new MySqlParameter();
searchId.ParameterName = "@searchId";
searchId.Value = id;
cmd.Parameters.Add(searchId);
var rdr = cmd.ExecuteReader() as MySqlDataReader;
int postId = 0;
int postBlogId = 0;
string postTitle = "";
string postContent = "";
DateTime postDate = new DateTime();
string postFile = null;
while (rdr.Read())
{
postId = rdr.GetInt32(0);
postBlogId = rdr.GetInt32(1);
postTitle = rdr.GetString(2);
postContent = rdr.GetString(3);
postDate = rdr.GetDateTime(4);
postFile = rdr.IsDBNull(5) ? null : rdr.GetString(5);
}
Post foundPost = new Post(postTitle, postContent, postFile, postBlogId, postId);
foundPost.SetDate(postDate);
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(foundPost);
}
