Moderation | ASP.NET 3.5 Social Networking

Solution

Now let's take a look at the solution.

Implementing the database

First let's take a look at what tables are needed:

Moderations

The moderation table shown in the following screenshot holds the SystemObjectID and SystemObjectRecordID as well as the Account that created the content in question. It also carries the Account that executed the resulting action as well as what that action is.

In addition to tables, we are going to need a way to quickly and easily determine if a bit of content has been flagged or not. I hate to say it boys and girls, but we are going to dip into the actual SQL for this one. We will create a function that will take a SystemObjectID and a SystemObjectRecordID and determine if that item is flagged or not.

create function [dbo].[IsFlagged]
(
	@SystemObjectID int,
	@SystemObjectRecordID bigint
)
returns bit 

as
begin
	declare @result bit
	if exists (
		select 1 
		from moderations 
		where systemobjectid = @SystemObjectID and 
			systemobjectrecordid = @SystemObjectRecordID...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

ASP.NET 3.5 Social Networking

By : Andrew Siemer

ASP.NET 3.5 Social Networking

By: Andrew Siemer

Overview of this book

Solution

Implementing the database

Moderations

ASP.NET 3.5 Social Networking

By : Andrew Siemer

ASP.NET 3.5 Social Networking

By: Andrew Siemer

Overview of this book

Solution

Implementing the database

Moderations

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access