/// <summary> /// /// </summary> /// <param name="sourceConnexion"></param> /// <param name="destConnexion"></param> /// <param name="mode">Exclude, Include or Aucun</param> /// <param name="liste">Liste des tables lié à l'option Mode</param> public static void DataBaseCopy (string sourceConnexion, string destConnexion, ListeMode mode, List <string> liste) { MSDBIntegration sql = new MSDBIntegration(sourceConnexion, destConnexion); sql.bulkcopyData(mode, liste.ToDatabaseTableList()); }
public static void ACTION_PROCESS_BulkCopy_FACTSET_MODELE_CLASSIFICATION_2(string date, string filepath) { DataSet ds = new DataSet("DATA_FACTSET"); MSDBIntegration s = new MSDBIntegration(destinationConnection: ENV); OpenXMLDataAdapter adapter = new OpenXMLDataAdapter(filepath, "Modele Classification", "B1", "V926", true); adapter.AddColumnMapping("DATA_FACTSET", "MXEU", "MXEU", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "MXUSLC", "MXUSLC", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "MXEM", "MXEM", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "MXEUM", "MXEUM", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "MXFR", "MXFR", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "6100001", "6100001", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "6100004", "6100004", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "6100030", "6100030", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "6100033", "6100033", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "6100063", "6100063", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "AVEURO", "AVEURO", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "AVEUROPE", "AVEUROPE", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "6100026", "6100026", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "6100062", "6100062", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "6100002", "6100002", System.Type.GetType("System.Double")); adapter.AddColumnMapping("DATA_FACTSET", "6100024", "6100024", System.Type.GetType("System.Double")); adapter.FillColumnWithValue("DATE", date); adapter.Fill(ds); DataTable dt = ds.Tables["DATA_FACTSET"]; s.bulkcopyData(dt); }
public static void ACTION_PROCESS_BulkCopy_Import_ACT_PTF_BaseTitreDirects_4(string filePath, string date = null) { MSDBIntegration s = new MSDBIntegration("OMEGA", ENV); string request; if (date != null) { request = parameterRequest(filePath, new string[] { "@dateDemandee" }, new string[] { "'" + date + "'" }); } else { request = parameterRequest(filePath, new string[] { }, new string[] { }); } s.bulkcopySourceRequest(request, new DatabaseTable("ACT_PTF")); }
/// <summary> /// /// </summary> /// <param name="sourceConnexion"></param> /// <param name="destConnexion"></param> /// <param name="mode">Exclude, Include or Aucun</param> /// <param name="liste">Liste des tables lié à l'option Mode</param> /// <param name="ds">Contenu de la requete ou des requetes à mettre en plus dans les tables destination</param> /// <param name="nomTableDestination"></param> public static void DataBaseCopy (string sourceConnexion, string destConnexion, DataSet DataTables, List <string> nomTableDestination) { MSDBIntegration sql = new MSDBIntegration(sourceConnexion, destConnexion); if (DataTables.Tables.Count != nomTableDestination.Count) { IntegratorBatch.ExceptionLogger.Error("Il manque des noms de table de destination, opération de copie du SELECT annulée"); } else { for (int i = 0; i < DataTables.Tables.Count; i++) { sql.bulkcopyData(DataTables.Tables[i], new DatabaseTable(nomTableDestination[i])); } } }
public static void ACTION_PROCESS_BulkCopy_IMPORT_ISR_3(string filepath) { DataSet ds = new DataSet("ISR_NOTE"); MSDBIntegration s = new MSDBIntegration(destinationConnection: ENV); OpenXMLDataAdapter adapter = new OpenXMLDataAdapter(filepath, "ISR", "A2", "F3000", true); adapter.AddColumnMapping("ISR_NOTE", "Note Actions", "Note Actions", System.Type.GetType("System.Double")); adapter.AddColumnMapping("ISR_NOTE", "Note Credit", "Note Credit", System.Type.GetType("System.Double")); adapter.AddColumnMapping("ISR_NOTE", "date ", "DATE", System.Type.GetType("System.DateTime")); adapter.AddColumnMapping("ISR_NOTE", "Name", "NAME"); adapter.Fill(ds); DataTable dt = ds.Tables["ISR_NOTE"]; s.bulkcopyData(dt); }
// TODO: A TESTER public static void ACTION_PROCESS_BulkCopy_FACTSET_TICKER_CONV() { string date = "17/01/2014"; string filepath1 = @"G:\,FGA Front Office\02_Gestion_Actions\00_BASE\Base 2.0\TickerConversion.xlsx"; string filepath2 = @"C:\TickerConversion.xlsx"; DataSet ds = new DataSet("ACT_TICKER_CONVERSION"); MSDBIntegration s = new MSDBIntegration(destinationConnection: "FGA_PREPROD_RW"); OpenXMLDataAdapter adapter = new OpenXMLDataAdapter(filepath2, "Feuil1", "B3", "F51", true); adapter.AddColumnMapping("ACT_TICKER_CONVERSION", "ISIN", "ISIN"); adapter.AddColumnMapping("ACT_TICKER_CONVERSION", "TICKER", "TICKER"); adapter.AddColumnMapping("ACT_TICKER_CONVERSION", "BBG", "BBG"); adapter.AddColumnMapping("ACT_TICKER_CONVERSION", "EXCH_F", "EXCH_B"); adapter.Fill(ds); DataTable dt = ds.Tables["ACT_TICKER_CONVERSION"]; s.bulkcopyData(dt); }