Vendor Page generation

DB Changes
alter table tblContactDetails alter column UserType char(10)
alter table tbl_UserSocialNetwork add UserType char(10)
alter table tbl_UserSocialNetwork add  Website varchar(1024)

update tblContactDetails set UserType='Vendor' where UserType='1'

dbo.pGetEventPageData
dbo.uspInsertVendorDetails