public static TrainerPerCourse AddTrainertPerCourse() { TrainerPerCourse tpc = new TrainerPerCourse(); FrontEnd.PrintTrainers(); tpc.TrainerId = InputsMethods.SelectTrainerId(); FrontEnd.PrintCourses(); tpc.CourseId = InputsMethods.SelectCourseId(); return(tpc); }
public static void InsertTrainerPerCourse(TrainerPerCourse tpc) { var connectionString = Properties.Settings.Default.connectionString; using (SqlConnection con = new SqlConnection(connectionString)) { string query = @"INSERT INTO Trainer_Per_Course VALUES(@TrainerId, @CourseId)"; SqlCommand cmd = new SqlCommand(query, con); //Pass values to Parameters cmd.Parameters.AddWithValue("@TrainerId", tpc.TrainerId); cmd.Parameters.AddWithValue("@CourseId", tpc.CourseId); try { con.Open(); cmd.ExecuteNonQuery(); Console.WriteLine("Records Inserted Successfully"); Menu.RunMenu(); } catch (SqlException e) when(e.Number == 2627) //Exception this relationship already exists { Console.WriteLine("\n Wrong\n The Id already exists try again"); Inserts.InsertTrainerPerCourse(Inserts.AddTrainertPerCourse()); } catch (SqlException e) when(e.Number == 547) //Exception the id doesn't exist { Console.WriteLine("\n Wrong\n The Id does not exist try again"); Inserts.InsertStudentPerCourse(Inserts.AddStudentPerCourse()); } catch (SqlException e) { Console.WriteLine("Error Generated. Details: " + e.ToString()); } finally { con.Close(); Console.ReadKey(); } } }