1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
| private void insertdemande(string requete_demande_complement, string recherche, string requete_demande, string bdd, string server, string utilisateur, string pwd, string nom_serveur, string categorie, string probleme, string objet_demande, string os )
{
try
{
// Chaine de connexion
string connectString = "database='" + bdd + "'; server= '" + server + "';User ID='" + utilisateur + "'; pwd='" + pwd + "'";
// Objet connection
SqlConnection connection = new SqlConnection(connectString);
connection.Open();// Ouverture
recherche = "select A.nom_serveur_alerte, P.categorie_probleme, P.probleme_probleme, A.OS_ALERTE from probleme P inner join obs_link_slx O on P.ID_PROBLEME = O.ID_POBLEME inner join alerte A on A.description_alerte = O.description_alerte";
SqlCommand insert_recherche = new SqlCommand(recherche, connection);
Console.WriteLine(recherche);
insert_recherche.ExecuteNonQuery();
insert_recherche.Dispose();
while (insert_recherche.Equals(""))
{
nom_serveur = insert_recherche["nom_serveur_alerte"].ToString();
categorie = insert_recherche["categorie_probleme"].ToString();
probleme = insert_recherche["probleme_probleme"].ToString();
os = insert_recherche["os_alerte"].ToString();
objet_demande = "Surveillance Serveur : "+ nom_serveur +" Probleme "+ categorie +" | " + probleme + " | " + os;
//Insertion dans la table demande
requete_demande = "insert into demande(domaine_demande, categorie_demande, probleme_demande, id_client, refexterne, libelle_demande)select P.domaine_probleme, P.categorie_probleme, P.probleme_probleme, A.id_client, A.uid_alerte, A.information_alerte from alerte A inner join obs_link_slx O on A.description_alerte = O.description_alerte inner join probleme P on P.ID_PROBLEME = O.ID_POBLEME where A.alerte_247 = 2";
Console.WriteLine("requete : " + requete_demande);
SqlCommand insert_demande = new SqlCommand(requete_demande, connection);
insert_demande.ExecuteNonQuery();
insert_demande.Dispose();
//complement
requete_demande_complement = "insert into demande(source_demande, objet_demande)value(surveillance/supervision,"+ objet_demande +") where refexterne =(select uid_alerte from alerte)";
SqlCommand insert_demande_complement = new SqlCommand(requete_demande_complement, connection);
Console.WriteLine(requete_demande_complement);
insert_demande_complement.ExecuteNonQuery();
insert_demande_complement.Dispose();
connection.Close();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
text = text + "Il n'y a pas u d'insertion dans la table demande";
}
} |
Partager