Click here to Skip to main content
Click here to Skip to main content
Articles » Languages » XML » Web Services » Downloads
 
Add your own
alternative version

Implementing WS-SecureConversation in Microsoft IssueVision

, 27 Sep 2005
Adding secure communications to the Microsoft IssueVision sample application using WSE 2.0.
issuevisionwsesmartclient.zip
Database
IssueVision
Controls
Outlook
Images
statusbar
toolbar
types
Libraries
ThreadHelper Documentation
Panes
Patterns
Web References
localhost
IssueVisionWebWseCS
Libraries
App.ico
IssueVision.csproj.user
IssueVision.snk
IssueVisionServices.disco
IssueVisionServices.wsdl
Reference.map
AppUpdater.dll
ThreadHelper.dll
About BackgroundWorker.doc
Async Windows Forms Programming with BackgroundWorker.doc
IssueVision-about-banner.png
mosaic-light.png
Signin.png
all_staffers.png
all_types.png
computer.png
environmental.png
help_desk.png
network.png
none.png
printer.png
staff.png
technicians.png
technicians_group.png
telecom.png
new_task.png
synchronize.png
work_offline.png
StatusConnected.ico
StatusDisconnected.ico
StatusSynchronizing.ico
IssueVisionWebWseCS.csproj.webinfo
IVDataSet.xsx
Use IssueVision
GO

-- IssueTypes

SET NOCOUNT ON

DELETE FROM [dbo].[IssueTypes]

GO

SET IDENTITY_INSERT [dbo].[IssueTypes] ON

GO

INSERT INTO [dbo].[IssueTypes]
([IssueTypeID], [IssueType])
SELECT 1, 'Telecommunications'
UNION ALL
SELECT 3, 'Computer'
UNION ALL
SELECT 5, 'Printer'
UNION ALL
SELECT 10, 'Network'

GO

SET IDENTITY_INSERT [dbo].[IssueTypes] OFF

SET NOCOUNT OFF

GO

-- Staffers

SET NOCOUNT ON

DELETE FROM [dbo].[Staffers]

GO

SET IDENTITY_INSERT [dbo].[Staffers] ON

GO

-- The unhashed password for all Staffers is 'password', except demo whose password is 'demo'
-- The PasswordHash has been created by taking the salt, appending the unhashed password and hashing it with SHA1

INSERT INTO [dbo].[Staffers]
([StafferID], [UserName], [PasswordHash], [PasswordSalt], [DisplayName], [StafferType])
SELECT 1, 'abarr', 'pWCsj910YW0E/VPjG7NNGkcvOr8=', 'TbWuXSzaVRw=', 'Adam Barr', 'H'
UNION ALL
SELECT 2, 'kabercrombie', 'A0rdUmWr+vx8ZiWuVkLXi+exwHI=', 'Ege0bGeWURU=', 'Kim Abercrombie', 'H'
UNION ALL
SELECT 3, 'ryoung', 'OIX1axF30WrzzwfcTC2+OYsSyhA=', 'VZogD+4seh8=', 'Rob Young', 'T'
UNION ALL
SELECT 4, 'tyoutsey', 'iaUDXfNJQxmnTLhxPdz1bRnYt/g=', 'mzTP0UOEFi0=', 'Tom Youtsey', 'H'
UNION ALL
SELECT 5, 'gyukish', 'XP+47Xfymksyweki/SHFI0T9cvM=', 'SR4FF/JjDMU=', 'Gary W. Yukish', 'T'
UNION ALL
SELECT 6, 'rcaron', 'tsEQw5ZqGTlWeNZtVc7rfJK2Eww=', '4SuuM3aDT2c=', 'Rob Caron', 'T'
UNION ALL
SELECT 7, 'kzimprich', '6mh4Gd4MxQ0BMc/fb5Q9buBpQjw=', 'AiXA1uF2IRo=', 'Karin Zimprich', 'H'
UNION ALL
SELECT 8, 'rboseman', 'BhwJdIw2pfVc9+C9qP2oOB1pSbg=', 'x/KklEUhGTw=', 'Randall Boseman', 'T'
UNION ALL
SELECT 9, 'kkennedy', 'xzSDFNKk9O4VXE+I96R5cSpe9Yc=', '1FLjk5r9gAs=', 'Kevin Kennedy', 'H'
UNION ALL
SELECT 10, 'dtibbott', 'w+XzHeIvQi92iQeo2PV3QI2ZTFE=', 'fex/UMYGwns=', 'Diane Tibbott', 'H'
UNION ALL
SELECT 11, 'gyoung', 'zGbvIP9USKTYM9UrR61R9AkkfEY=', 'KTxCXJMniCM=', 'Garrett Young', 'T'
UNION ALL
SELECT 12, 'demo', 'L0/YuWiMT78xMewOsQlxIUx+E8w=', 'qR9EK6wNB/k=', 'Demo', 'T'

GO

SET IDENTITY_INSERT [dbo].[Staffers] OFF

SET NOCOUNT OFF

GO


-- Issues

SET NOCOUNT ON

DELETE FROM [dbo].[Issues]

GO

SET IDENTITY_INSERT [dbo].[Issues] ON

GO

INSERT INTO [dbo].[Issues]
([IssueID], [StafferID], [IssueTypeID], [Title], [Description], [DateOpened], [DateClosed], [IsOpen], [DateModified])
SELECT 12, 1, 3, 'Computer won''t shut down', 'Computer just hangs after clicking Shut Down. User must manually turn computer off.', '20031229 4:03:42 PM', NULL, 1, '20040110 9:50:37 AM'
UNION ALL
SELECT 13, 2, 1, 'Voice mail password doesn''t work', 'The user went away on vacation and came back to find that his voice mail password didn''t work.', '20031229 4:07:13 PM', NULL, 1, '20040110 10:09:11 AM'
UNION ALL
SELECT 14, 3, 10, 'User can''t log into network', 'The user gets a message that her account has been locked.', '20031229 4:09:54 PM', NULL, 1, '20040110 9:50:37 AM'
UNION ALL
SELECT 15, 2, 5, 'HERCULES printer driver not installed', 'The user gets a message that the driver for printer HERCULES is not installed.', '20031229 4:12:33 PM', NULL, 1, '20040110 9:50:37 AM'
UNION ALL
SELECT 16, 1, 10, 'User''s VPN access not working', 'The user''s home computer can''t connect to the VPN server remotely.', '20031229 4:14:08 PM', NULL, 1, '20040110 9:50:37 AM'
UNION ALL
SELECT 17, 3, 1, '9 key not working', 'The 9 key on the user''s telephone does not work.', '20031229 4:15:19 PM', NULL, 1, '20040110 9:50:37 AM'
UNION ALL
SELECT 18, 2, 3, 'Needs an upgrade to Office 2003', 'Authorized and requested by department head.', '20031229 4:17:25 PM', NULL, 1, '20040110 9:50:37 AM'
UNION ALL
SELECT 19, 1, 1, 'Voice mail light does not work', '', '20040111 12:41:55 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 20, 2, 10, 'Laptop in cubicle 119 can''t access the WiFi network', 'The laptop is 802.11a enabled.', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 21, 3, 3, 'Docking station in cubicle 37 doesn''t work', '', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 22, 4, 1, 'Phone at cubicle 217 has an echo when dialing out', '', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 23, 5, 5, 'Printer Zeus has run out of legal size paper', '', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 24, 6, 10, 'Network load balancer is not seeing server #9', 'Server #9 was re-imaged last week.', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 25, 7, 1, 'People on the other end of the line can''t hear when the speaker phone is turned on', 'It works fine using the handset or a headset.', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 26, 8, 3, 'Graphics station in cubicle 79 needs an upgrade to a 20 inch monitor', 'This has already been approved.', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 27, 9, 10, 'Firewall is blocking instant messenger', 'Neither Yahoo nor AOL work. MSN does however.', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 28, 10, 5, 'Printer Apollo is low on toner', '', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 29, 11, 3, 'Cubicle 597 needs a developer workstation', '', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 30, 12, 5, 'The printer in cubicle 18 needs to be moved to cubicle 67A', '', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'

GO

SET IDENTITY_INSERT [dbo].[Issues] OFF

SET NOCOUNT OFF

GO


-- IssueHistory

SET NOCOUNT ON

DELETE FROM [dbo].[IssueHistory]

GO

SET IDENTITY_INSERT [dbo].[IssueHistory] ON

GO

INSERT INTO [dbo].[IssueHistory]
([IssueHistoryID], [StafferID], [IssueID], [Comment], [DateCreated])
SELECT 11, 1, 12, 'Issue created.', '20031229 4:03:42 PM'
UNION ALL
SELECT 12, 2, 13, 'Issue created.', '20031229 4:07:13 PM'
UNION ALL
SELECT 13, 3, 14, 'Issue created.', '20031229 4:09:54 PM'
UNION ALL
SELECT 14, 2, 15, 'Issue created.', '20031229 4:12:33 PM'
UNION ALL
SELECT 15, 1, 16, 'Issue created.', '20031229 4:14:08 PM'
UNION ALL
SELECT 16, 3, 17, 'Issue created.', '20031229 4:15:19 PM'
UNION ALL
SELECT 17, 2, 18, 'Issue created.', '20031229 4:17:25 PM'
UNION ALL
SELECT 18, 12, 13, 'test', '20040110 10:09:11 AM'
UNION ALL
SELECT 19, 1, 19, 'Issue created.', '20040111 12:41:55 PM'
UNION ALL
SELECT 20, 2, 20, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 21, 3, 21, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 22, 4, 22, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 23, 5, 23, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 24, 6, 24, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 25, 7, 25, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 26, 8, 26, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 27, 9, 27, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 28, 10, 28, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 29, 11, 29, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 30, 12, 30, 'Issue created.', '20040111 12:41:56 PM'

GO

SET IDENTITY_INSERT [dbo].[IssueHistory] OFF

SET NOCOUNT OFF

GO

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Weidong Shen
Software Developer (Senior)
United States United States
Weidong has been an information system professional since 1990. He has a Master's degree in Computer Science, and is currently a MCSD .NET

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.150123.1 | Last Updated 27 Sep 2005
Article Copyright 2005 by Weidong Shen
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid