USP_DATAFORMTEMPLATE_LUMINATEONLINEDATACONNECTORSETTINGS_EDIT

create procedure dbo.USP_DATAFORMTEMPLATE_LUMINATEONLINEDATACONNECTORSETTINGS_EDIT
(
  @USERNAME nvarchar(255),
  @PASSWORD nvarchar(255),
  @URL nvarchar(255),
  @SYNCPARTITIONID nvarchar(255),
  @BDEOPERATIONID nvarchar(10),
  @CHANGEAGENTID uniqueidentifier = null
)
as
begin
    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
    exec dbo.USP_GET_KEY_ACCESS;
        if exists (select top 1 ID from dbo.LUMINATEONLINEDATACONNECTORSETTINGS)
            update dbo.LUMINATEONLINEDATACONNECTORSETTINGS set
            USERNAME = @USERNAME,
      PASSWORD = EncryptByKey(Key_GUID('sym_BBInfinity'), @PASSWORD),
      URL = @URL,
      SYNCPARTITIONID = @SYNCPARTITIONID,
      BDEOPERATIONID = @BDEOPERATIONID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
    else
    begin
      insert into dbo.LUMINATEONLINEDATACONNECTORSETTINGS
      (
        USERNAME,
        PASSWORD,
        URL,
        SYNCPARTITIONID,
        BDEOPERATIONID,
        ADDEDBYID, 
                CHANGEDBYID, 
                DATEADDED, 
                DATECHANGED
      )
      values
      (
        @USERNAME,
        EncryptByKey(Key_GUID('sym_BBInfinity'), @PASSWORD),
        @URL,
        @SYNCPARTITIONID,
        @BDEOPERATIONID,
        @CHANGEAGENTID,
                @CHANGEAGENTID,
                @CURRENTDATE,
                @CURRENTDATE
      )
      close symmetric key sym_BBInfinity;    

      -- Create default parameter set

      insert into dbo.LUMINATEONLINEDATACONNECTORPARAMETERSET (ID, NAME, ADDEDBYID, CHANGEDBYID) values(newid(), 'Default', @CHANGEAGENTID, @CHANGEAGENTID);

      -- Create Luminate Online Data Connectors

      delete from dbo.LUMINATEONLINEDATACONNECTOR;
      insert into dbo.LUMINATEONLINEDATACONNECTOR (
      ID, NAME, DESCRIPTION, SEQUENCE, ASSEMBLYNAME, CLASSNAME, ADDEDBYID, CHANGEDBYID
      ) values (
      NEWID(), 'Email Campaign Data', 'Download email campaign data from CWS', 1, 'BBDW.ReportDB.Catalog.dll','BBDW.ReportDB.Catalog.LuminateOnlineDataConnector.Email.EmailCampaignHandler', @CHANGEAGENTID, @CHANGEAGENTID);

      insert into dbo.LUMINATEONLINEDATACONNECTOR(
      ID, NAME, DESCRIPTION, SEQUENCE, ASSEMBLYNAME, CLASSNAME, ADDEDBYID, CHANGEDBYID
      ) values (
      NEWID(), 'Email Message Data', 'Download email message data from CWS', 2, 'BBDW.ReportDB.Catalog.dll','BBDW.ReportDB.Catalog.LuminateOnlineDataConnector.Email.EmailMessageHandler', @CHANGEAGENTID, @CHANGEAGENTID);

      insert into dbo.LUMINATEONLINEDATACONNECTOR (
      ID, NAME, DESCRIPTION, SEQUENCE, ASSEMBLYNAME, CLASSNAME, ADDEDBYID, CHANGEDBYID
      ) values (
      NEWID(), 'Email Recipient Data', 'Download email recipient data from CWS', 3, 'BBDW.ReportDB.Catalog.dll','BBDW.ReportDB.Catalog.LuminateOnlineDataConnector.Email.EmailRecipientHandler', @CHANGEAGENTID, @CHANGEAGENTID);

      insert into dbo.LUMINATEONLINEDATACONNECTOR (
      ID, NAME, DESCRIPTION, SEQUENCE, ASSEMBLYNAME, CLASSNAME, ADDEDBYID, CHANGEDBYID
      ) values (
      NEWID(), 'Constituent Data', 'Download constituent data from CWS', 4, 'BBDW.ReportDB.Catalog.dll','BBDW.ReportDB.Catalog.LuminateOnlineDataConnector.LuminateConstituent.LuminateConstituentHandler', @CHANGEAGENTID, @CHANGEAGENTID);

    end
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch
end