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 ViewStudentDetails()
{
using (StudentDBContext studentDBContext = new StudentDBContext())
{
foreach (var item in studentDBContext.Student)
{
Console.WriteLine(item.StudentID + " " + item.FirstName + " " + item.LastName + " " + item.Address + " " + item.CourseID);
}
}
Console.ReadKey();
}
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();
}
}
