public string BuscarArquivosIndividual(string caminho)
{
OnStart();
Proxy = new FtpProxy();
try
{
return(Proxy.PercorrerDiretorio(caminho));
}
catch (Exception e)
{
Logger = new Logger(e.ToString(), EnumStatusLog.Nok, DateTime.Now);
Logger.WriteLog();
return("NOK");
}
}
public string BuscarArquivos()
{
OnStart();
Proxy = new FtpProxy();
try
{
return(Proxy.PercorrerDiretorio(null));
}
catch (Exception e)
{
Logger = new Logger(e.ToString(), EnumStatusLog.Nok, DateTime.Now);
Logger.WriteLog();
// return "NOK";
return(string.Format(" [ NOK ] " + e.ToString()));
}
}
private DataTable GetFromFtp()
{
DataTable dt = null;
logger.DebugFormat("IP: [{0}], Port: [{1}], User: [{2}]", etlSetting.IP, etlSetting.Port, etlSetting.UserName);
FtpProxy ftPxy = new FtpProxy(etlSetting.IP, etlSetting.Port, etlSetting.UserName, etlSetting.Pwd);
logger.InfoFormat("Download file : {0}", etlSetting.FileLocal);
byte[] datas = ftPxy.Download(etlSetting.FileLocal);
logger.DebugFormat("Downloaded file size : {0}", datas.Length);
string str = System.Text.Encoding.Default.GetString(datas);
string fiFor = etlSetting.FileFormat.ToUpper();
logger.InfoFormat("Source file format : {0}", fiFor);
try
{
if (fiFor == "JSON")
{
dt = JsonFormater.ConvertToDataTable(str, etlSetting.DbTimeColumn);
}
else if (fiFor == "CSV")
{
dt = CsvFormater.ConvertToDataTable(str, etlSetting.DbTimeColumn);
}
if (dt == null)
{
throw new Exception("Convert the DataTable is null.");
}
}
catch (Exception ex)
{
throw new Exception("Source file convert to DataTable fail.", ex);
}
logger.DebugFormat("Convert to DataTable row count : {0}", dt.Rows.Count);
return(dt);
}
public void Input(DataTable srcTb)
{
logger.Info("----- FileTarget.Input Start -----");
string data = "";
logger.DebugFormat("Target file format : [{0}]", etlSetting.FileFormat);
if (etlSetting.FileFormat.ToUpper() == "JSON")
{
data = JsonFormater.ConvertToString(srcTb);
}
logger.DebugFormat("Target IP: [{0}], Port: [{1}], User: [{2}]", etlSetting.IP, etlSetting.Port, etlSetting.UserName);
if (etlSetting.IP.StartsWith("ftp:"))
{
FtpProxy ftpPxy = new FtpProxy(etlSetting.IP, etlSetting.Port, etlSetting.UserName, etlSetting.Pwd);
byte[] databytes = System.Text.Encoding.Default.GetBytes(data);
logger.InfoFormat("Upload data length : {0}", databytes.Length);
ftpPxy.Upload(etlSetting.FileLocal, databytes);
}
logger.Info("----- FileTarget.Input End -----");
}
public void ApplyLoginSettings(SettingInfoBase settings)
{
ComponentPro.Net.Ftp ftp = (ComponentPro.Net.Ftp)_client;
ftp.Passive = _loginSettings.Get <bool>(FtpLoginInfo.PasvMode);
string proxyServer = _loginSettings.Get <string>(LoginInfo.ProxyServer);
int proxyPort = _loginSettings.Get <int>(LoginInfo.ProxyPort);
if (!string.IsNullOrEmpty(proxyServer) && proxyPort > 0)
{
FtpProxy proxy = new FtpProxy();
ftp.Proxy = proxy;
proxy.Server = proxyServer;
proxy.Port = proxyPort;
proxy.UserName = _loginSettings.Get <string>(LoginInfo.ProxyUser);
proxy.Password = _loginSettings.Get <string>(LoginInfo.ProxyPassword);
proxy.Domain = _loginSettings.Get <string>(LoginInfo.ProxyDomain);
proxy.ProxyType = _loginSettings.Get <FtpProxyType>(LoginInfo.ProxyType);
proxy.AuthenticationMethod = _loginSettings.Get <FtpProxyHttpConnectAuthMethod>(LoginInfo.ProxyHttpAuthnMethod);
}
}
public void Init()
{
ftpPxy = new FtpProxy("t1test.wneweb.com.tw", 21, "edsaadmin", "wncedsa3.0");
//ftpPxy.Connect("t1test.wneweb.com.tw", 21, "edsaadmin", "wncedsa3.0");
}
