C#

0
down vote
favorite
I need to write a code in script component in SSIS that will move files to corresponding folders. Files that I'm getting are usually named, for example "Dem323_04265.45.23.4", "Dem65_459.452.56", "Ec2345_456.156.7894" and I need to move them to a corresponding folders. The name of my folders are "Oklahoma City (323)", "New York(65)".. I need to move those files to matching folders, so for example "Dem323_04265.45.23.4" would go to folder "Oklahoma City (323)". I need to modify my code so the number that is located between first two or three letter and underline matches number located in parenthesis. I've been working on this for several days already and I'm new with ssis and c#, so any help would be appreciated. This is the code I have so far:

public void Main()
    {
        string filename;
       // string datepart;
        bool FolderExistFlg;
        filename = Dts.Variables["User::FileName"].Value.ToString();
        // datepart = (filename.Substring(filename.Length - 12)).Substring(0, 8);
        var folderNumber = Regex.Match(
            filename,

    //Dts.Variables["OutputMainFolder"].Value.ToString(),
                    @"\(([^)]*)\)").Groups[1].Value;
        FolderExistFlg = Directory.Exists(Dts.Variables["OutputMainFolder"].Value.ToString() + "\\" + folderNumber);

        if (!FolderExistFlg)
        {
            Directory.CreateDirectory(Dts.Variables["OutputMainFolder"].Value.ToString() + "\\" + folderNumber);
        }

        File.Move(Dts.Variables["SourceFolder"].Value.ToString() + "\\" + filename + "\\" + folderNumber,
        Dts.Variables["OutputMainFolder"].Value.ToString()  + "\\" + filename);
        Dts.TaskResult = (int)ScriptResults.Success;
    }

    #region ScriptResults declaration

    enum ScriptResults
    {
        Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
        Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
    };
    #endregion

}
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections.Specialized;
using HtmlAgilityPack;
using System.Net;
using System.IO;

namespace DocumentosSubsidios.Infrastructure.RobotBase
{
    public abstract class BaseRoboAddress
    {
        public enum EncodingEnum
        {
            Default,
            UTF8,
            ASCII,
            ISO_8859_1, 
            ANSICodePage

        }

        public BaseRoboAddress() { }

        public BaseRoboBaseRoboAddress(WebClientSession webClientSession)
        {
            this._webClientSession = webClientSession;
        }

        public delegate void MyMethodInvoker<T>(T t);
        public event MyMethodInvoker<string> ResultRequest;

        #region [Membros Privados]

        private CredentialCache _credentialCache;
        private WebClientSession _webClientSession;

        private CookieCollection _cookies = null;
        private HtmlNodeCollection _inputs = null;

        #endregion

        #region [Propriedades]

        public WebClientSession WebClientSession
        {
            get
            {
                if (_webClientSession == null) _webClientSession = new WebClientSession();
                return _webClientSession;
            }
            set
            {
                _webClientSession = value;
            }
        }
        private CredentialCache mCredentialCache
        {
            get
            {
                if (_credentialCache == null) _credentialCache = new CredentialCache();
                return _credentialCache;
            }
            set
            {
                _credentialCache = value;
            }
        }

        public CookieCollection Cookies
        {
            get
            {
                if (_cookies == null)
                    _cookies = new CookieCollection();

                return _cookies;
            }
            set { _cookies = value; }
        }
        public HtmlNodeCollection Inputs
        {
            get
            {
                if (_inputs == null)
                    _inputs = new HtmlNodeCollection(null);

                return _inputs;
            }
            set { _inputs = value; }
        }

        #endregion

        #region [Métodos Publicos]

        public virtual HtmlDocument Get(string url)
        {
            return this.Get(url, false, EncodingEnum.UTF8);
        }

        public HtmlDocument Get(string url, EncodingEnum encoding)
        {
            return this.Get(url, false, encoding);
        }

        public HtmlDocument Get(string url, bool fire, EncodingEnum encoding)
        {
            HtmlDocument htmlDocument = new HtmlAgilityPack.HtmlDocument();
            byte[] pagina = this.WebClientSession.DownloadData(url);

            switch (encoding)
            {
                case EncodingEnum.UTF8:
                    htmlDocument.LoadHtml(Encoding.UTF8.GetString(pagina, 0, pagina.Count()));
                    break;

                case EncodingEnum.ASCII:
                    htmlDocument.LoadHtml(Encoding.ASCII.GetString(pagina, 0, pagina.Count()));
                    break;

                case EncodingEnum.Default:
                    htmlDocument.LoadHtml(Encoding.Default.GetString(pagina, 0, pagina.Count()));
                    break;

                case EncodingEnum.ISO_8859_1:
                    htmlDocument.LoadHtml(Encoding.GetEncoding("ISO-8859-1").GetString(pagina, 0, pagina.Count()));
                    break;
            }

            return htmlDocument;
        }

        public HtmlDocument Post(string url, NameValueCollection parametros, bool fire)
        {
            return this.Post(url, parametros, fire, EncodingEnum.UTF8);
        }

        public HtmlDocument Post(string url, NameValueCollection parametros, EncodingEnum encoding)
        {
            return this.Post(url, parametros, true, encoding);
        }

        public HtmlDocument Post(string url, NameValueCollection parametros)
        {
            return this.Post(url, parametros, true);
        }

        public HtmlDocument Post(string url, NameValueCollection parametros, bool fire, EncodingEnum encoding)
        {
            HtmlDocument htmlDocument = new HtmlAgilityPack.HtmlDocument();
            byte[] pagina = this.WebClientSession.UploadValues(url, parametros);

            switch (encoding)
            {
                case EncodingEnum.Default:
                    htmlDocument.LoadHtml(Encoding.Default.GetString(pagina, 0, pagina.Count()));
                    break;
                case EncodingEnum.UTF8:
                    htmlDocument.LoadHtml(Encoding.UTF8.GetString(pagina, 0, pagina.Count()));
                    break;
                case EncodingEnum.ASCII:
                    htmlDocument.LoadHtml(Encoding.ASCII.GetString(pagina, 0, pagina.Count()));
                    break;

                case EncodingEnum.ISO_8859_1:
                    htmlDocument.LoadHtml(Encoding.GetEncoding("ISO-8859-1").GetString(pagina, 0, pagina.Count()));
                    break;
            }

            return htmlDocument;
        }

        public byte[] PostBinario(string url, NameValueCollection parametros)
        {
            HtmlDocument htmlDocument = new HtmlAgilityPack.HtmlDocument();
            return this.WebClientSession.UploadValues(url, parametros);
        }

        public HtmlDocument PostData(string url, IEnumerable<byte> IBody, bool fire)
        {
            lock (this)
            {

                HtmlDocument htmlDocument = new HtmlAgilityPack.HtmlDocument();
                byte[] pagina = this.WebClientSession.UploadData(url, "POST", IBody.ToArray());
                htmlDocument.LoadHtml(Encoding.UTF8.GetString(pagina, 0, pagina.Count()));
                return htmlDocument;
            }
        }

        public HtmlDocument PostData(string url, IEnumerable<byte> IBody)
        {
            return this.PostData(url, IBody, true);
        }

        public HtmlDocument PostData(string url, IEnumerable<byte> IBody, EncodingEnum encoding)
        {
            lock (this)
            {
                byte[] pagina = this.WebClientSession.UploadData(url, "POST", IBody.ToArray());
                HtmlDocument htmlDocument = LoadHtmlDocument(encoding, pagina);
                return htmlDocument;
            }
        }

        private HtmlDocument LoadHtmlDocument(EncodingEnum encoding, byte[] pagina)
        {
            HtmlDocument htmlDocument = new HtmlAgilityPack.HtmlDocument();
            switch (encoding)
            {
                case EncodingEnum.Default:
                    htmlDocument.LoadHtml(Encoding.Default.GetString(pagina, 0, pagina.Count()));
                    break;
                case EncodingEnum.UTF8:
                    htmlDocument.LoadHtml(Encoding.UTF8.GetString(pagina, 0, pagina.Count()));
                    break;
                case EncodingEnum.ASCII:
                    htmlDocument.LoadHtml(Encoding.ASCII.GetString(pagina, 0, pagina.Count()));
                    break;

                case EncodingEnum.ISO_8859_1:
                    htmlDocument.LoadHtml(Encoding.GetEncoding("ISO-8859-1").GetString(pagina, 0, pagina.Count()));
                    break;
            }
            return htmlDocument;
        }