/// <summary> /// Deletes the category. /// </summary> /// <param name="category">The category.</param> /// <returns></returns> public int DeleteCategory(EBlogCategory category) { return ExecuteNonQuery( "DELETE TBlogCategory WHERE CategoryID = @CategoryID;", CreateParameter("@CategoryID", category.CategoryID) ); }
/// <summary> /// Changes the specified cat. /// </summary> /// <param name="cat">The cat.</param> /// <returns></returns> protected BBlogCategory Change(EBlogCategory cat) { return new BBlogCategory() { CategoryID = cat.CategoryID, CategoryName = cat.CategoryName, ParentCategoryID = cat.ParentCategoryID, OrderNo = cat.OrderNo }; }
/// <summary> /// Updates the category. /// </summary> /// <param name="category">The category.</param> /// <returns></returns> public int UpdateCategory(EBlogCategory category) { return ExecuteNonQuery( @"UPDATE TBlogCategory SET ParentCategoryID = @ParentCategoryID, CategoryName = @CategoryName, OrderNo = @OrderNo WHERE CategoryID = @CategoryID;", CreateParameter("@ParentCategoryID", category.ParentCategoryID), CreateParameter("@CategoryName", category.CategoryName), CreateParameter("@OrderNo", category.OrderNo), CreateParameter("@CategoryID", category.CategoryID) ); }
/// <summary> /// Inserts the category. /// </summary> /// <param name="category">The category.</param> /// <returns></returns> public int InsertCategory(EBlogCategory category) { return ExecuteInsertQueryReturnID( "TBlogCategory", new Dictionary<string, object>() { {"ParentCategoryID",category.ParentCategoryID}, {"CategoryName",category.CategoryName}, {"OrderNo",category.OrderNo} }); }