public static void InsertElectedCourse(SqlConnection conn, ElectedCourse electedcourse) { const string V = " VALUES (@CoursesID, @StudentsID)"; var _insert = "INSERT INTO ElectedCourses(CoursesID, StudentsID)" + V; var cmd = new SqlCommand(_insert, conn); cmd.Parameters.AddWithValue("CoursesID", electedcourse.CoursesId); cmd.Parameters.AddWithValue("StudentsID", electedcourse.StudentsId); cmd.ExecuteScalar(); }
//get courses //add to DB static void Main(string[] args) { Console.WriteLine("Enter (course) or (professor)"); var reply = Console.ReadLine(); const string CONNECTION_STRING = @"Server=localhost\SQLEXPRESS;Database=Universities;Trusted_Connection=True;"; if (reply == "professor") { Console.WriteLine("Enter professor name"); var pname = Console.ReadLine(); Console.WriteLine("Enter professor title: Mr., Mrs., Dr., etc"); var tname = Console.ReadLine(); var newProfessor = new Professor { Name = pname, Title = tname, }; using (var conn = new SqlConnection(CONNECTION_STRING)) { conn.Open(); ProfessorService.InsertProfessor(conn, newProfessor); ProfessorService.GetAllProfessors(conn); } } else { Console.WriteLine("Enter course number:"); var cnumber = Console.ReadLine(); Console.WriteLine("Enter course level:"); var clevel = Console.ReadLine(); Console.WriteLine("Enter course name:"); var cname = Console.ReadLine(); Console.WriteLine("Enter room number:"); var roomnumber = Console.ReadLine(); Console.WriteLine("Enter start time in :"); var starttime = Console.ReadLine(); Console.WriteLine("Enter professor ID"); var pid = Console.ReadLine(); var convertedpid = Convert.ToInt32(pid); var newcourse = new Course { CourseNumber = cnumber, CourseLevel = clevel, CourseName = cname, RoomNumber = roomnumber, StartTime = starttime, ProfessorID = convertedpid }; using (var conn = new SqlConnection(CONNECTION_STRING)) { conn.Open(); CourseService.InsertCourse(conn, newcourse); CourseService.GetAllCourses(conn); } } Console.WriteLine("Enter Student Name"); var sname = Console.ReadLine(); Console.WriteLine("Enter Student Email"); var email = Console.ReadLine(); Console.WriteLine("Enter Student Phone"); var phone = Console.ReadLine(); Console.WriteLine("Enter Student Major"); var major = Console.ReadLine(); var newStudent = new Student { StudentName = sname, Email = email, Phone = phone, Major = major, }; using (var conn = new SqlConnection(CONNECTION_STRING)) { conn.Open(); StudentService.InsertStudent(conn, newStudent); } Console.WriteLine("Enroll or View My Enrolled Class List? Type (enroll) or (view)"); reply = Console.ReadLine(); if (reply == "enroll") { using (var conn = new SqlConnection(CONNECTION_STRING)) { conn.Open(); CourseService.GetAllCourses(conn); Console.WriteLine("Enter course ID to enroll"); var answer = Console.ReadLine(); var courseid = Convert.ToInt32(answer); Console.WriteLine("Enter name"); var enrolleeName = Console.ReadLine(); var _select = "SELECT ID, StudentName, Email, Phone, Major" + " FROM Students" + " WHERE Students.StudentName = " + enrolleeName; var query = new SqlCommand(_select, conn); var reader = query.ExecuteReader(); var _rv = new List <Student>(); var studentid = 0; // parse the results while (reader.Read()) { var _student = new Student(reader); studentid = _student.Id; } reader.Close(); var electedCourse = new ElectedCourse { CoursesId = courseid, StudentsId = studentid, }; Console.WriteLine(electedCourse.StudentsId); CourseService.GetSelectedCourse(conn, courseid); CourseService.InsertElectedCourse(conn, electedCourse); } } }