public static int GetSubjectID(string subject, Verification verification) { SqlConnection connection = new SqlConnection(DataAccess.SQLCONNECTIONSTRING); connection.Open(); int subjectId = 0; SqlCommand takeSubjectId = connection.CreateCommand(); takeSubjectId.CommandText = "SELECT IDSubject FROM Subject WHERE NameSubject = @sujet"; takeSubjectId.Parameters.AddWithValue("@sujet", subject); try { if (takeSubjectId.ExecuteScalar() == null) { Console.WriteLine("Ce sujet n'existe pas"); Console.WriteLine(); Console.WriteLine("Vous voulez ajouter un nouveau sujet ?"); bool a = false; while (!a) { Console.WriteLine("O/N"); ConsoleKeyInfo resultat = Console.ReadKey(); Console.Clear(); switch (resultat.Key) { case ConsoleKey.O: Console.Write("Sujet : "); string sujet = Console.ReadLine(); sujet = TestException.CheckTextInfo(sujet); SqlCommand firstInsert = connection.CreateCommand(); firstInsert.CommandText = "INSERT INTO Subject (NameSubject) VALUES (@sujet)"; firstInsert.Parameters.AddWithValue("@sujet", sujet); try { firstInsert.ExecuteNonQuery(); Console.WriteLine("Le sujet {0} a été ajouté! \n", sujet); } catch (Exception ex) { Console.WriteLine("Une erreur s'est produite: " + ex.Message); Console.WriteLine("Type d'erreur: " + ex.GetType()); Console.WriteLine("Veuillez recommencer.."); MainMenu.ShowMainMenu(verification); connection.Close(); } break; case ConsoleKey.N: MainMenu.ShowMainMenu(verification); break; } a = true; } } else { subjectId = (int)takeSubjectId.ExecuteScalar(); } } catch (Exception ex) { Console.WriteLine("Erreur : " + ex.Message); Console.WriteLine("Type d'erreur: " + ex.GetType()); Console.WriteLine("Pile : " + ex.StackTrace); MainMenu.ShowMainMenu(verification); } connection.Close(); return(subjectId); }