public static StudentPerCourse AddStudentPerCourse() { StudentPerCourse spc = new StudentPerCourse(); FrontEnd.PrintStudents(); spc.StudentId = InputsMethods.SelectStudentId(); FrontEnd.PrintCourses(); spc.CourseId = InputsMethods.SelectCourseId(); return(spc); }
public static void InsertStudentPerCourse(StudentPerCourse spc) { var connectionString = Properties.Settings.Default.connectionString; using (SqlConnection con = new SqlConnection(connectionString)) { string query = @"INSERT INTO Student_Per_Course VALUES(@StudentId, @CourseId)"; SqlCommand cmd = new SqlCommand(query, con); //Pass values to Parameters cmd.Parameters.AddWithValue("@StudentId", spc.StudentId); cmd.Parameters.AddWithValue("@CourseId", spc.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.InsertStudentPerCourse(Inserts.AddStudentPerCourse()); } 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(); } } }