private static Student GetStudentByID(int studentID)
{
using (var context = new StudentCourse())
{
var student = context.Students.FirstOrDefault(x => x.StudentID == studentID);
return(student);
}
}
private static void AddCourse(string courseName)
{
using (var context = new StudentCourse())
{
var course = new Course()
{
CoursedName = courseName
};
context.Courses.Add(course);
context.SaveChanges();
}
}
private static bool Delete(int studentID)
{
using (var context = new StudentCourse())
{
var student = context.Students.FirstOrDefault(x => x.StudentID == studentID);
if (student == null)
{
return(false);
}
context.Students.Remove(student);
context.SaveChanges();
return(true);
}
}
private static void Insert(string studentName, int studentAge, string studentGender, int studentCourseID)
{
using (var context = new StudentCourse())
{
var student = new Student()
{
StudentName = studentName,
StudentAge = studentAge,
StudentGender = studentGender,
CourseID = studentCourseID
};
context.Students.Add(student);
context.SaveChanges();
}
}
private static void Update(string studentName, int studentAge, string studentGender, int studentCourseID, int studentID)
{
using (var context = new StudentCourse())
{
var student = context.Students.FirstOrDefault(x => x.StudentID == studentID);
if (student != null)
{
student.StudentName = studentName;
student.StudentAge = studentAge;
student.StudentGender = studentGender;
student.CourseID = studentCourseID;
}
context.SaveChanges();
}
}
private static void Main(string[] args)
{
do
{
Console.WriteLine("1: Insert Student\n2: View Student Details\n3: Update Student\n4: Delete Student\n5: Add Course\n6: Exit");
var option = Console.ReadLine();
if (option == "1")
{
Console.WriteLine("Enter Student Name");
var name = Console.ReadLine();
Console.WriteLine("Enter Student Age");
var age = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Enter Student Gender");
var gender = Console.ReadLine();
var studentCourse = new StudentCourse();
foreach (var course in studentCourse.Courses)
{
Console.WriteLine(course.CourseID + ":" + "\t" + course.CoursedName);
}
Console.WriteLine("Enter Course ID");
var courseID = Convert.ToInt32(Console.ReadLine());
Insert(name, age, gender, courseID);
Console.WriteLine("Record Added Successfully");
Console.ReadLine();
}
else if (option == "2")
{
Console.WriteLine("Enter Student ID");
var id = Convert.ToInt32(Console.ReadLine());
var student = GetStudentByID((id));
if (student != null)
{
Console.WriteLine("Student Name: " + student.StudentName + "\t" + "Student Age: " + student.StudentAge + "\t" + "Student Gender: " + student.StudentGender);
Console.ReadLine();
}
else
{
Console.WriteLine("Student Not Found");
Console.ReadLine();
}
}
else if (option == "3")
{
Console.WriteLine("Enter Student ID");
var id = Convert.ToInt32(Console.ReadLine());
var student = GetStudentByID((id));
if (student != null)
{
Console.WriteLine("Enter Student Name");
var name = Console.ReadLine();
Console.WriteLine("Enter Student Age");
var age = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Enter Student Gender");
var gender = Console.ReadLine();
var studentCourse = new StudentCourse();
foreach (var course in studentCourse.Courses)
{
Console.WriteLine(course.CourseID + ":" + "\t" + course.CoursedName);
}
Console.WriteLine("Enter Course ID");
var courseID = Convert.ToInt32(Console.ReadLine());
Update(name, age, gender, courseID, student.StudentID);
Console.WriteLine("Record Updated Successfully");
Console.ReadLine();
}
else
{
Console.WriteLine("Student Not Found");
Console.ReadLine();
}
}
else if (option == "4")
{
Console.WriteLine("Enter Student ID");
var id = Convert.ToInt32(Console.ReadLine());
Console.WriteLine(Delete(id) ? "Record Deleted Successfully" : "Student Not Found");
Console.ReadLine();
}
else if (option == "5")
{
Console.WriteLine("Enter Course Name");
var courseName = Console.ReadLine();
AddCourse(courseName);
Console.WriteLine("Course Added Successfully");
Console.ReadLine();
}
else if (option == "6")
{
break;
}
} while (true);
}