// Paramaters of blog get by blogID
public static BlogPostE GetBlogPostByBlogID(int blogID)
{
BlogPostE blogPost = null;
SqlCommand com = new SqlCommand("GetBlogPostByBlogID", Connection.Con); // Prodecure
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add(new SqlParameter("@blogID", blogID));
if (com.Connection.State == ConnectionState.Closed)
{
com.Connection.Open();
}
SqlDataReader rd = com.ExecuteReader();
if (rd.HasRows)
{
if (rd.Read())
{
blogPost = new BlogPostE
{
BlogID = Convert.ToInt32(rd["blogID"]),
DietitanID = Convert.ToInt32(rd["dietitianID"]),
Title = rd["title"].ToString(),
BlogContent = rd["blogContent"].ToString(),
PostDate = DateTime.Parse(rd["PostDate"].ToString())
};
}
}
com.Dispose();
com.Connection.Close();
return(blogPost);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null && Session["diettian"] == null)
{
Response.Redirect("~/Logon.aspx");
}
// Get "id" from URL
string blogpostid = Page.RouteData.Values["id"] as string;
// ID of BlogPost get Database
currentPost = BusinessLayers.Business.getBlogPostByBlogID(Convert.ToInt32(blogpostid));
}
public static void updateBlogPost(BlogPostE obj)
{
BlogPostC.UpdateBlogPost(obj.BlogID, obj.DietitanID, obj.Title, obj.BlogContent);
}
public static int newBlogPost(BlogPostE obj)
{
return(BlogPostC.NewBlogPost(obj.DietitanID, obj.Title, obj.BlogContent));
}
