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