private static ImportFileContext CreateFromConfiguration(ImportConfigurationModel model)
{
return(new ImportFileContext
{
ClientConnectionString = model.ClientConnectionString,
MarketConnectionString = model.MarketConnectionString,
DirectoryIn = model.DirectoryDecrypted,
DirectoryInArchive = model.DirectoryArchive,
DirectoryInException = model.DirectoryException,
});
}
public static ImportFileContext[] CreateXmlContext(ImportConfigurationModel configuration)
{
return(new[]
{
ImportFileContext.CreateXml("810*.xml", "810", configuration),
ImportFileContext.CreateXml("814*.xml", "814", configuration),
ImportFileContext.CreateXml("867*.xml", "867", configuration),
ImportFileContext.CreateXml("LSE*.xml", "867", configuration),
ImportFileContext.CreateXml("650*.xml", "650", configuration),
ImportFileContext.CreateXml("820*.xml", "820", configuration),
ImportFileContext.CreateXml("824*.xml", "824", configuration),
ImportFileContext.CreateXml("997*.xml", "997", configuration),
ImportFileContext.CreateXml("248*.xml", "248", configuration)
});
}
public static ImportFileContext[] CreatePrismContext(ImportConfigurationModel configuration)
{
return(new[]
{
ImportFileContext.CreatePrism("*_810.*", "810", configuration),
ImportFileContext.CreatePrism("*_814.*", "814", configuration),
ImportFileContext.CreatePrism("*_867.*", "867", configuration),
ImportFileContext.CreatePrism("*_LSE.*", "867", configuration),
ImportFileContext.CreatePrism("*_650.*", "650", configuration),
ImportFileContext.CreatePrism("*_820.*", "820", configuration),
ImportFileContext.CreatePrism("*_824.*", "824", configuration),
ImportFileContext.CreatePrism("*_MTCRCustomerInformation.*", "CBF", configuration),
ImportFileContext.CreatePrism("*_MTERCOT2CR.*", "CBF", configuration)
});
}
public ImportConfigurationModel LoadImportConfiguration(int clientId)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("csp_GlobalApplicationConfigurationLoad"))
{
command.AddWithValue("@ClientID", clientId)
.AddWithValue("@MachineName", Environment.MachineName);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
using (var reader = command.ExecuteReader())
{
if (!reader.Read())
{
return(null);
}
var model = new ImportConfigurationModel
{
ClientId = clientId,
Client = reader.GetString("ClientAbbreviation"),
ClientConnectionString = reader.GetString("ConnectionCsr"),
MarketConnectionString = reader.GetString("ConnectionMarket"),
DirectoryEncrypted = reader.GetString("ImportDirectoryEncrypted"),
DirectoryDecrypted = reader.GetString("ImportDirectoryDecrypted"),
DirectoryException = reader.GetString("ImportDirectoryException"),
DirectoryArchive = reader.GetString("ImportDirectoryArchive"),
};
reader.TryGetString("ImportDirectoryFtpIn", x => model.FtpDirectory = x);
reader.TryGetString("ImportFtpRemoteDirectory", x => model.FtpRemoteDirectory = x);
reader.TryGetString("FtpRemoteServer", x => model.FtpRemoteServer = x);
reader.TryGetString("FtpUserName", x => model.FtpUsername = x);
reader.TryGetString("FtpUserPassword", x => model.FtpPassword = x);
reader.TryGetString("PgpPassPhrase", x => model.PgpPassPhrase = x);
reader.TryGetString("PgpEncryptionKey", x => model.PgpEncryptionKey = x);
reader.TryGetString("PgpSignatureKey", x => model.PgpSignatureKey = x);
return(model);
}
}
}
public static ImportFileContext CreateXml(string filePattern, string fileType, ImportConfigurationModel model)
{
var item = CreateFromConfiguration(model);
item.ProviderId = 2;
item.FileType = fileType;
item.FilePattern = filePattern;
return(item);
}
public static ImportFileContext[] CreateContextList(ProviderModel[] provider, ImportConfigurationModel configuration)
{
var collection = new List <ImportFileContext>();
if (provider.Any(x => x.ProviderId == 1))
{
collection.AddRange(CreatePrismContext(configuration));
}
if (provider.Any(x => x.ProviderId == 2))
{
collection.AddRange(CreateXmlContext(configuration));
}
return(collection.ToArray());
}
