public Exception CheckConnection(string providerType, string connectionString)
{
try
{
Spring.Data.Common.IDbProvider dbProvider = Spring.Data.Common.DbProviderFactory.GetDbProvider(providerType);
dbProvider.ConnectionString = connectionString;
using (System.Data.IDbConnection connection = dbProvider.CreateConnection())
{
connection.Open();
}
return(null);
}
catch (Exception e)
{
return(e);
}
}
public static bool ProcessNextInputFile()
{
StringBuilder message = new StringBuilder();
bool success = false, foundFile = false;
try
{
ProcessDBImportCSVFiles.OutputStatus(message, "Start CameoInputFileProcessor...");
CreateApplicationEventLog();
string importFolder = Settings.Default.ImportFolder;
string importCSVFileSearchPattern = Settings.Default.ImportCSVFileSearchPattern;
string importFileSearchToDBTableNamePattern = Settings.Default.ImportFileSearchToDBTableNamePattern;
string tempFolderPath = Settings.Default.TempFolderPath;
string dbProviderType = Settings.Default.DBProviderType;
string dbConnectionString = Settings.Default.DBConnectionString;
string archiveFolder = Settings.Default.ArchiveFolder;
string errorFolder = Settings.Default.ErrorFolder;
string cleanupTablesStoredProcName = Settings.Default.CleanupTablesStoredProcName;
string endProcessingStoredProcName = Settings.Default.EndProcessingStoredProcName;
ICompressionHelper compressionHelper = new CompressionHelper();
Spring.Data.Common.IDbProvider dbProvider = Spring.Data.Common.DbProviderFactory.GetDbProvider(dbProviderType);
dbProvider.ConnectionString = dbConnectionString;
SpringBaseDao springBaseDao = new SpringBaseDao(dbProvider);
ProcessDBImportCSVFiles.OutputStatus(message, "ImportFolder ({0}), ArchiveFolder ({1}), ErrorFolder ({2}), ImportCSVFileSearchPattern ({3}), ImportFileSearchToDBTableNamePattern ({4}), EndProcessingStoredProcName ({5}), TempFolderPath ({6}), DBProviderType ({7}), DBConnectionString ({8})",
importFolder, archiveFolder, errorFolder, importCSVFileSearchPattern,
importFileSearchToDBTableNamePattern, endProcessingStoredProcName, tempFolderPath,
dbProviderType, dbConnectionString);
message.Append(ProcessDBImportCSVFiles.ProcessImportFile(importFolder, archiveFolder, errorFolder,
importCSVFileSearchPattern, importFileSearchToDBTableNamePattern,
cleanupTablesStoredProcName, endProcessingStoredProcName,
springBaseDao, tempFolderPath,
compressionHelper, out success, out foundFile));
ProcessDBImportCSVFiles.OutputStatus(message, "Stop CameoInputFileProcessor...");
}
catch (Exception ex)
{
DebugUtils.CheckDebuggerBreak();
message.Append(string.Format("\n\n\nERROR *********************\n\n"
+ ex.Message
+ "\n\n***************************\n\n\n{0}",
ExceptionUtils.ToLongString(ex)));
}
finally
{
string messageOut = message.ToString();
if (success)
{
LogInfo(messageOut);
}
else
{
LogError(messageOut);
}
Console.WriteLine(messageOut);
}
return(foundFile);
}
