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();
}
}
}
