/// <summary>
/// Deletepages the specified page.
/// </summary>
/// <param name="page">The page.</param>
/// <returns></returns>
public int Deletepage(EBlogPage page)
{
return ExecuteNonQuery(
@"Delete TBlogPage
WHERE
pageID = @pageID;",
CreateParameter("@pageID", page.PageID));
}
/// <summary>
/// Insertpages the specified page.
/// </summary>
/// <param name="page">The page.</param>
/// <returns></returns>
public int Insertpage(EBlogPage page)
{
return ExecuteInsertQueryReturnID(
"TBlogPage",
new Dictionary<string, object>() {
{"BlogID", page.BlogID},
{"Title", page.Title},
{"Content", page.Content},
{"Summary", page.Summary},
{"PublishDate", page.PublishDate},
{"LastModifiedDate", page.LastModifiedDate},
{"Author", page.Author},
{"IsPublished", page.IsPublished},
{"Visible", page.Visible},
{"ReadCount", page.ReadCount},
{"OrderNo", page.OrderNo},
{"ParentPageID", page.ParentPageID},
});
}
/// <summary>
/// Updatepages the specified page.
/// </summary>
/// <param name="page">The page.</param>
/// <returns></returns>
public int Updatepage(EBlogPage page)
{
return ExecuteNonQuery(
@"UPDATE TBlogPage
SET
BlogID = @BlogID,
Title = @Title,
[Content] = @Content,
Summary = @Summary,
PublishDate = @PublishDate,
LastModifiedDate = @LastModifiedDate,
Author = @Author,
IsPublished = @IsPublished,
Visible = @Visible,
ReadCount = @ReadCount,
OrderNo = @OrderNo,
ParentPageID = @ParentPageID
WHERE
pageID = @pageID;",
CreateParameter("@BlogID", page.BlogID),
CreateParameter("@Title", page.Title),
CreateParameter("@Content", page.Content),
CreateParameter("@Summary", page.Summary),
CreateParameter("@PublishDate", page.PublishDate),
CreateParameter("@LastModifiedDate", page.LastModifiedDate),
CreateParameter("@Author", page.Author),
CreateParameter("@IsPublished", page.IsPublished),
CreateParameter("@Visible", page.Visible),
CreateParameter("@ReadCount", page.ReadCount),
CreateParameter("@OrderNo", page.OrderNo),
CreateParameter("@ParentPageID", page.ParentPageID),
CreateParameter("@pageID", page.PageID));
}
/// <summary>
/// Changes the specified page.
/// </summary>
/// <param name="page">The page.</param>
/// <returns></returns>
protected BBlogPage Change(EBlogPage page)
{
return new BBlogPage()
{
PageID = page.PageID,
ParentPageID = page.ParentPageID,
Author = page.Author,
BlogID = page.BlogID,
Content = page.Content,
IsPublished = page.IsPublished,
LastModifiedDate = page.LastModifiedDate,
PublishDate = page.PublishDate,
ReadCount = page.ReadCount,
Summary = page.Summary,
Title = page.Title,
Visible = page.Visible,
OrderNo = page.OrderNo
};
}
