//Methodes
private void join_btn_Click(object sender, EventArgs e)
{
var bw = new BackgroundWorker();
server_tb.Enabled = servers_list.Enabled = join_btn.Enabled = false;
//vider la liste
ServerDatabases.Clear();
//Affecter le helper pour contenir les information de connection
Helper.Server = server_tb.Text;
Helper.Username = login_tb.Text;
Helper.Password = password_tb.Text;
Connector = DatasUtility.GetConenctorByProvider(servers_list.SelectedItem.ToString());
Connector.cnxHelper = Helper;
bw.DoWork += (send, ev) =>
{
ev.Result = Connector.GetServerDatabases();
};
bw.RunWorkerCompleted += (send, ev) =>
{
ServerDatabases = (List <string>)ev.Result;
getDbProgress.Visible = false;
server_tb.Enabled = servers_list.Enabled = join_btn.Enabled = true;
//Affecter l'evenement du fin de traitement
if (FinTraitements != null)
{
FinTraitements(this, new EventArgs());
}
};
getDbProgress.Visible = true;
bw.RunWorkerAsync();
}
public override string CreateStoredProcedureQuery(ConnexionSysteme sysAmont, params object[] args)
{
try
{
var output = (List <Parametre>)args[0]; var input = (List <Parametre>)args[1];
string nomSp = args[2].ToString(); string tmp = args[3].ToString();
string evenement = args[4].ToString(); string viewName = args[5].ToString();
//Connecteur vers le systéme amont
DbConnector connectToSystem = DatasUtility.GetConenctorByProvider(sysAmont.ServerType);
connectToSystem.cnxHelper = sysAmont.CnxHelper;
StringBuilder sb = new StringBuilder();
//l'entete de la procedure
sb.Append(connectToSystem.CreateSPHeader(input, nomSp));
sb.Append("\nBEGIN");
sb.Append("\n" + connectToSystem.MakeCreateTableQuery(output, tmp));//Creation de la table temporaire
sb.Append("\n");
//Check L'existance du trigger
sb.Append("\nDeclare @checkTrSQL nvarchar(max) = '");
sb.Append(DatasUtility.GetFileCheckTrValue(tmp, evenement));
sb.Append("';");
sb.Append("\nExecute(@checkTrSQL);");
sb.Append("\n");
//Creation du Trigger de trasmission: [Tmp] Vers La table[Mvt_tbLSortie] dans BD(INTERMEDIAIRE)
sb.Append("\nDeclare @TrSQL nvarchar(max) = '");
sb.Append(connectToSystem.CreateTriggerQuery(tmp, evenement));
sb.Append("';");
sb.Append("\nExecute(@TrSQL);");
sb.Append("\n");
//remplir la table temporaire avec le SELECT
sb.Append("\n" + connectToSystem.CreateInsertIntoTmpQuery(output, tmp));
sb.Append("\n" + connectToSystem.CreateSelectQuery(output, input, viewName));
sb.Append("\nEND");//les SP de tous providers termine par END
return(sb.ToString());
}
catch (Exception ex)
{
return("Error In Create Procedure:\n" + ex.Message);
}
}
private void valider_btn_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(sqlStoredProcedure))
{
var systemAmont = (ConnexionSysteme)systemes_liste.SelectedItem;
var amontConnector = DatasUtility.GetConenctorByProvider(systemAmont.ServerType);
amontConnector.cnxHelper = systemAmont.CnxHelper;
MessageBox.Show("AmontConnector: " + amontConnector.GetChaineConnection());
if (amontConnector.ExecuteNonQuery(sqlStoredProcedure) == 0)
{
MessageBox.Show("La Procedure à été bien créer sur le systeme");
}
else
{
MessageBox.Show("Il y avait une erreur dans la creation de la procedure stockée");
}
}
else
{
MessageBox.Show("Veuillez generer d'abord la procedure stockée");
}
}
