Set up:
3 things you need to do in order to get this running:

1. Create your data tables using the following queries:

CREATE TABLE dbo.FurtivueAnonyMsg(
MsgID bigint IDENTITY(1,1) NOT NULL,
SenderName varchar(32) NULL,
SenderEmail varchar(255) NULL,
ReceiverName varchar(32) NULL,
ReceiverEmail varchar(255) NULL,
TimeToShow int NULL,
Message varchar(max) NULL,
HasBeenRead bit NULL,
TimeStamp timestamp NULL,
LinkKey uniqueidentifier NULL,
IPAddress varchar(16) NULL,
DateSent datetime NOT NULL,
DateRead datetime NULL,
CONSTRAINT PK_FurtivueAnonyMsg PRIMARY KEY CLUSTERED
(
MsgID ASC
)WITH (PADINDEX = OFF, STATISTICSNORECOMPUTE = OFF, IGNOREDUPKEY = OFF, ALLOWROWLOCKS = ON, ALLOWPAGELOCKS = ON) ON PRIMARY
) ON PRIMARY

GO

CREATE TABLE dbo.FurtivueMsg(
MsgID bigint IDENTITY(1,1) NOT NULL,
SenderID int NOT NULL,
ReceiverID int NULL,
ReceiverWithin bit NULL,
ReceiverName varchar(32) NULL,
ReceiverEmail varchar(255) NULL,
TimeToShow int NULL,
Message varchar(max) NULL,
HasBeenRead bit NULL,
ReadOnce bit NULL,
ReadTill smalldatetime NULL,
TimeStamp timestamp NULL,
LinkKey uniqueidentifier NULL,
DateSent datetime NULL,
DateRead datetime NULL,
CONSTRAINT PK_FurtivueMsg PRIMARY KEY CLUSTERED
(
MsgID ASC
)WITH (PADINDEX = OFF, STATISTICSNORECOMPUTE = OFF, IGNOREDUPKEY = OFF, ALLOWROWLOCKS = ON, ALLOWPAGELOCKS = ON) ON PRIMARY
) ON PRIMARY


GO

CREATE TABLE dbo.FurtivUser(
UserID int NOT NULL,
Email varchar(150) NULL,
Username varchar(16) NULL,
LatestUse smalldatetime NULL,
CONSTRAINT PK_FurtivUser PRIMARY KEY CLUSTERED
(
UserID ASC
)WITH (PADINDEX = OFF, STATISTICSNORECOMPUTE = OFF, IGNOREDUPKEY = OFF, ALLOWROWLOCKS = ON, ALLOWPAGELOCKS = ON) ON PRIMARY
) ON PRIMARY


(dont forget to set your connection string in the config file and \Access\DBConnection.cs)

2. Set up your email parameters in the web.config file

3. Configure your web service reference address (for initial testing, I don't mind if you use my own: http://www.furtivue.com/vueservice/V.svc)

Last edited Jun 23, 2012 at 6:51 PM by Necemon, version 2

Comments

No comments yet.