Exemplo n.º 1
0
        /// <summary> Updates a specific LDAP profile. </summary>
        public void UpdateLdapProfile(LdapProfileDTO dto)
        {
            if (dto == null) throw new ArgumentNullException("dto");

            const string sql = @"
UPDATE [dbo].[LdapProfiles]
SET [Name] = @name,
    [ServerType] = @serverType,
    [UseForLogin] = @useForLogin,
    [ServerPath] = @serverPath,
    [Username] = @username,
    [Password] = @password,
    [RootPath] = @rootPath,
    [SearchFilter] = @searchFilter,
    [UseSSL] = @useSSL
WHERE [Id] = @id
";

            using (var cmd = new SqlCommand(sql))
            {
                cmd.Parameters.AddWithValue("@name", dto.Name.AsNullableObj());
                cmd.Parameters.AddWithValue("@serverType", (int)dto.ServerType);
                cmd.Parameters.AddWithValue("@useForLogin", dto.UseForLogin);
                cmd.Parameters.AddWithValue("@serverPath", dto.ServerPath.AsNullableObj());
                cmd.Parameters.AddWithValue("@username", EncryptionService.EncryptString(dto.Username ?? string.Empty));
                cmd.Parameters.AddWithValue("@password", EncryptionService.EncryptString(dto.Password ?? string.Empty));
                cmd.Parameters.AddWithValue("@rootPath", dto.RootPath.AsNullableObj());
                cmd.Parameters.AddWithValue("@searchFilter", dto.SearchFilter.AsNullableObj());
                cmd.Parameters.AddWithValue("@useSSL", dto.UseSSL);
                cmd.Parameters.AddWithValue("@id", dto.Id);

                Database.Execute(cmd);
            }
        }
Exemplo n.º 2
0
        /// <summary> Creates new LDAP profile. </summary>
        public void InsertLdapProfile(LdapProfileDTO dto)
        {
            if (dto == null) throw new ArgumentNullException("dto");

            const string sql = @"
INSERT INTO [dbo].[LdapProfiles] 
( 
    [Name]
   ,[UseForLogin]
   ,[ServerPath]
   ,[Username]
   ,[Password]
   ,[RootPath]
   ,[UseSSL]
   ,[ServerType]
   ,[SearchFilter]
)
VALUES 
( 
    @name
   ,@useForLogin
   ,@serverPath
   ,@username
   ,@password
   ,@rootPath
   ,@useSSL
   ,@serverType
   ,@searchFilter
)

SELECT  [Id]
FROM    [dbo].[LdapProfiles]
WHERE   [Id] = SCOPE_IDENTITY()
";

            using (var ctx = ConnectionManager<SqlConnection>.GetManager(Database.VeyronMeta, false))
            {
                var cn = ctx.Connection;

                using (var cmd = new SqlCommand(sql, cn))
                {
                    cmd.Parameters.AddWithValue("@name", dto.Name.AsNullableObj());
                    cmd.Parameters.AddWithValue("@serverType", (int)dto.ServerType);
                    cmd.Parameters.AddWithValue("@useForLogin", dto.UseForLogin);
                    cmd.Parameters.AddWithValue("@serverPath", dto.ServerPath.AsNullableObj());
                    cmd.Parameters.AddWithValue("@username", EncryptionService.EncryptString(dto.Username ?? string.Empty));
                    cmd.Parameters.AddWithValue("@password", EncryptionService.EncryptString(dto.Password ?? string.Empty));
                    cmd.Parameters.AddWithValue("@rootPath", dto.RootPath.AsNullableObj());
                    cmd.Parameters.AddWithValue("@searchFilter", dto.SearchFilter.AsNullableObj());
                    cmd.Parameters.AddWithValue("@useSSL", dto.UseSSL);

                    dto.Id = (int) cmd.ExecuteScalar();
                }
            }
        }