public static ExportFileContext[] CreateSsxContext(ExportConfigurationModel configuration)
{
return(new[]
{
ExportFileContext.CreateXml("814", configuration)
});
}
private static ExportFileContext CreateFromConfiguration(ExportConfigurationModel model)
{
return(new ExportFileContext
{
ClientConnectionString = model.ClientConnectionString,
MarketConnectionString = model.MarketConnectionString,
DirectoryOut = model.DirectoryDecrypted,
});
}
public static ExportFileContext CreateSsx(string fileType, ExportConfigurationModel model)
{
var item = CreateFromConfiguration(model);
item.ProviderId = 3;
item.Extension = "csv";
item.FileType = fileType;
return(item);
}
public static ExportFileContext[] CreatePrismContext(ExportConfigurationModel configuration)
{
return(new[]
{
ExportFileContext.CreatePrism("650", configuration),
ExportFileContext.CreatePrism("810", configuration),
ExportFileContext.CreatePrism("814", configuration),
ExportFileContext.CreatePrism("820", configuration),
ExportFileContext.CreatePrism("824", configuration),
ExportFileContext.CreatePrism("CBF", configuration)
});
}
public ExportConfigurationModel LoadExportConfiguration(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 ExportConfigurationModel
{
ClientId = clientId,
Client = reader.GetString("ClientAbbreviation"),
ClientConnectionString = reader.GetString("ConnectionCsr"),
MarketConnectionString = reader.GetString("ConnectionMarket"),
DirectoryEncrypted = reader.GetString("ExportDirectoryEncrypted"),
DirectoryDecrypted = reader.GetString("ExportDirectoryDecrypted"),
DirectoryException = reader.GetString("ExportDirectoryException"),
DirectoryArchive = reader.GetString("ExportDirectoryArchive"),
};
reader.TryGetString("ExportDirectoryFtpOut", x => model.FtpDirectory = x);
reader.TryGetString("ExportFtpRemoteDirectory", 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 ExportFileContext[] CreateContextList(ProviderModel[] provider, ExportConfigurationModel configuration)
{
var collection = new List <ExportFileContext>();
if (provider.Any(x => x.ProviderId == 1))
{
collection.AddRange(CreatePrismContext(configuration));
}
if (provider.Any(x => x.ProviderId == 2))
{
collection.AddRange(CreateXmlContext(configuration));
}
if (provider.Any(x => x.ProviderId == 3))
{
collection.AddRange(CreateSsxContext(configuration));
}
return(collection.ToArray());
}
