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