static void Main(string[] args)
{
var log = new LoggerConfiguration()
.WriteTo.RollingFile("AppLog.txt")
.WriteTo.ColoredConsole()
.CreateLogger();
Log.Logger = log;
//ReadFoxproTable();
//return;
_dbHelper = new FoxproHelper();
_list = new List<FileDetail>();
//_list.Add(new FileDetail
//{
// FileName = "Test.rtf",
// Records = 100,
// DownloadTime = DateTime.Now,
// FileDate = DateTime.Now,
// Folder = "Hands"
//});
//InsertRecord();
//return;
var siteurl = ConfigurationManager.AppSettings["ftpUrl"];
var ftpUserName = ConfigurationManager.AppSettings["ftpUserName"];
var ftpPassword = ConfigurationManager.AppSettings["ftpPassword"];
Ftp ftp = new Ftp();
// Ftper ftper = new Ftper();
// var files = ftper.Connect(siteurl, ftpUserName, ftpPassword);
var files = ftp.Connect(siteurl, ftpUserName, ftpPassword);
foreach (var ftpinfo in files)
{
// Console.WriteLine($"File Name: {ftpinfo.Filename}, File Type: {ftpinfo.FileType}");
GetFtpFiles(ftpinfo, ftp, siteurl);
}
if (!_list.Any())
{
Console.WriteLine("No new files found!");
return;
}
foreach (var detail in _list)
{
var fileName = detail.FileName;
Console.WriteLine($"Inserting {fileName} into master ftp dbf");
try
{
if (_dbHelper.InsertFtpRecord(detail))
{
Console.WriteLine($"Inserted {fileName} into master ftp dbf successfully");
}
}
catch (Exception ex)
{
Log.Error(ex.Message);
}
Console.WriteLine($"Inserting {fileName} into master ftp sql");
try
{
if (_dbHelper.InsertSqlFtpRecord(detail))
{
Console.WriteLine($"Inserted {fileName} into master ftp sql successfully");
}
}
catch (Exception ex)
{
Log.Error(ex.Message);
}
}
try
{
SendEmail();
}
catch (Exception ex)
{
Log.Error(ex.Message);
}
}
private static void GetFtpFiles(Ftpinfo ftpinfo, Ftp ftp, string siteurl)
{
if (ftpinfo.FileType == DirectoryEntryTypes.Directory)
{
var subFiles = ftp.Browse(siteurl + ftpinfo.Filename);
if (subFiles == null)
{
return;
}
foreach (var subFile in subFiles)
{
// Console.WriteLine($"File Name: {subFile.Filename}, File Type: {subFile.FileType}");
if (subFile.FileType == DirectoryEntryTypes.Directory)
{
var path = subFile.Path;
if (!path.EndsWith("/"))
{
path = path + "/";
}
GetFtpFiles(subFile, ftp, path );
}
else
{
var fileTime = subFile.FileDateTime;
var kftpfolder = ConfigurationManager.AppSettings["ftpSaveDestination"];
var fileName = subFile.Filename;
var fileDate = fileTime.Date;
var arr = subFile.Path.Split('/');
var folder = arr[arr.Length-1];
var folderFullPath = Path.Combine(kftpfolder, folder, fileDate.ToString("MMddyyyy"));
if (!Directory.Exists(folderFullPath))
{
Directory.CreateDirectory(folderFullPath);
}
var ftpFileName = Path.Combine(folderFullPath, fileName);
// Console.WriteLine($"Name: {subFile.Filename}\tSize: {subFile.Size}");
if (fileTime < new DateTime(2016,1,16) || File.Exists(ftpFileName))
{
// Console.WriteLine($"{ftpFileName} already exists");
}
else
{
Console.WriteLine($"New file found: {fileName}");
var path = subFile.Path;
if (!path.EndsWith("/"))
{
path = path + "/";
}
FtpDownload.Fileinfo fileInfo = new FtpDownload.Fileinfo(path + fileName,ftpFileName,DirectionEnum.Down,true);
// ftp.AddFileToDownloadQueue(path + fileName, ftpFileName);
// ftp.StartProcessing();
ftp.Download(fileInfo);
var lineCount = File.ReadLines(ftpFileName).Count();
// minus 2 for Header line and blank line after header line
FileDetail fileDetail = new FileDetail
{
FileName = fileName,
DownloadTime = DateTime.Now,
FileDate = fileTime,
Folder = folder,
Records = lineCount - 2
};
_list.Add(fileDetail);
//_dbHelper.InsertFtpRecord(fileDetail);
}
}
}
}
}