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()); }