private void AddStudent() { using (StudentDBContext studentDBContext = new StudentDBContext()) { Console.Write("Enter Student FirstName : "); string studentFirstName = Console.ReadLine(); Console.Write("Enter Student Lastname : "); string studentLastName = Console.ReadLine(); Console.Write("Enter the Address : "); string studentAddress = Console.ReadLine(); Console.WriteLine("Enter Your Choice : "); foreach (var item in studentDBContext.Course) { Console.WriteLine(item.CourseID + "=>" + item.CourseName); } int courseID = Convert.ToInt32(Console.ReadLine()); Students student = new Students() { FirstName = studentFirstName, LastName = studentLastName, Address = studentAddress, CourseID = courseID, }; studentDBContext.Student.Add(student); studentDBContext.SaveChanges(); } }
private void UpdateStudentDetails() { using (StudentDBContext studentDBContext = new StudentDBContext()) { Console.Write("Enter StudentID : "); int studentID = Convert.ToInt32(Console.ReadLine()); Students student = studentDBContext.Student.Where(x => x.StudentID == studentID).FirstOrDefault(); if (student != null) { Console.Write("Enter Student FirstName : "); string studentFirstName = Console.ReadLine(); Console.Write("Enter Student Lastname : "); string studentLastName = Console.ReadLine(); Console.Write("Enter the Address : "); string studentAddress = Console.ReadLine(); Console.WriteLine("Enter Your Choice : "); foreach (var item in studentDBContext.Course) { Console.WriteLine(item.CourseID + "=>" + item.CourseName); } int courseID = Convert.ToInt32(Console.ReadLine()); student.FirstName = studentFirstName; student.LastName = studentLastName; student.Address = studentAddress; student.CourseID = courseID; } else { Console.WriteLine("StudentID is not Found "); } studentDBContext.SaveChanges(); } }
private void DeleteStudentDetails() { using (StudentDBContext studentDBContext = new StudentDBContext()) { Console.Write("Enter StudentID : "); int studentID = Convert.ToInt32(Console.ReadLine()); Students student = studentDBContext.Student.Where(x => x.StudentID == studentID).FirstOrDefault(); if (student != null) { studentDBContext.Student.Remove(student); } else { Console.WriteLine("StudentID is not Found "); } studentDBContext.SaveChanges(); } }
private void AddCourse() { using (StudentDBContext studentDBContext = new StudentDBContext()) { Console.Write("Enter Course Name: "); string courseName = Console.ReadLine(); Console.Write("Enter Course AcademicYear: "); int academicYear = Convert.ToInt32(Console.ReadLine()); Courses courses = new Courses() { CourseName = courseName, AcademicYear = academicYear, }; studentDBContext.Course.Add(courses); studentDBContext.SaveChanges(); Console.ReadKey(); } }