public void DeleteStudentsPerCourses(STUDENT_PER_COURSE studentPerCourse, DataClasses1DataContext db)
{
STUDENT sTudent = new STUDENT();
Student student = new Student();
Course course = new Course();
Check_ID check_ID = new Check_ID();
var listTotalNumbersOfCourses = new List <int>();
Console.WriteLine("\n\n\t" + "DELETE STUDENTS PER COURSES" +
"\n\t----------------------------");
Console.WriteLine("\t" + "For Dalete one only course press --> {1}");
Console.WriteLine("\t" + "For Delete all courses prees --> {2}");
Console.Write("\t" + "Give a choise between v --> {1 - 2}: ");
string selection = Console.ReadLine();
int choice;
while (!int.TryParse(selection, out choice) || string.IsNullOrEmpty(selection) || choice < 1 || choice > 2)
{
Console.Write("\n\t" + "Give choice again Only Integer between {1 - 2}!!!: ");
selection = Console.ReadLine();
}
int studentID = check_ID.GetTrueStudentIDWhoHaveCourses(student, db);
if (choice == 1)
{
int courseID = course.GetTrueCourseIDForCreate(check_ID, db);
studentPerCourse = db.STUDENT_PER_COURSEs.Single(i => i.STUDENT_ID == studentID && i.COURSE_ID == courseID);
studentPerCourse.STUDENT_ID = studentID;
studentPerCourse.COURSE_ID = courseID;
db.STUDENT_PER_COURSEs.DeleteOnSubmit(studentPerCourse);
db.SubmitChanges();
}
else
{
listTotalNumbersOfCourses = GetListTotalNumbersOfCourses(db, studentID);
int count = 1;
while (count <= listTotalNumbersOfCourses.Count())
{
foreach (int i in listTotalNumbersOfCourses)
{
studentPerCourse = db.STUDENT_PER_COURSEs.Single(j => j.STUDENT_ID == studentID && j.COURSE_ID == i);
studentPerCourse.STUDENT_ID = studentID;
studentPerCourse.COURSE_ID = i;
db.STUDENT_PER_COURSEs.DeleteOnSubmit(studentPerCourse);
db.SubmitChanges();
count += 1;
}
}
}
Console.WriteLine("\n\tDeleted Succesfully!!!");
}
public void MenuStudentPerCourse(DataClasses1DataContext db)
{
STUDENT_PER_COURSE studentPerCourse = new STUDENT_PER_COURSE();
Student student = new Student();
Check_ID check_ID = new Check_ID();
string stringChoice;
Console.WriteLine("\n\tSTUDENT PER COURSE MENU\n\t" + "-----------------------");
Console.WriteLine("\tCreate STUDENT PER COURSE press ---> {1}");
Console.WriteLine("\tRead STUDENT PER COURSE press ---> {2}");
Console.WriteLine("\tUpdate STUDENT PER COURSE press ---> {3}");
Console.WriteLine("\tDelete STUDENT PER COURSE press ---> {4}");
Console.Write("\tEnter a choice between ---> {1 - 4}: ");
stringChoice = Console.ReadLine();
Console.WriteLine();
int outChoice;
while (!int.TryParse(stringChoice, out outChoice) || outChoice < 1 || outChoice > 4)
{
Console.WriteLine("\n\tThe choice should be Only integer between {1- 4}!!!");
Console.Write("\tEnter a new choice: ");
stringChoice = Console.ReadLine();
}
int choice = outChoice;
switch (choice)
{
case (int)SelectionStudentPerCourse.create:
CreateStudentsPerCourses(studentPerCourse, db);
break;
case (int)SelectionStudentPerCourse.read:
int studentID = check_ID.GetTrueStudentIDWhoHaveCourses(student, db);
ReadStudentsPerCourses(db, studentID);
break;
case (int)SelectionStudentPerCourse.update:
UpdateStudentsPerCourses(studentPerCourse, db);
break;
case (int)SelectionStudentPerCourse.delete:
DeleteStudentsPerCourses(studentPerCourse, db);
break;
}
}
public void UpdateStudentsPerCourses(STUDENT_PER_COURSE studentPerCourse, DataClasses1DataContext db)
{
STUDENT sTudent = new STUDENT();
Student student = new Student();
Check_ID check_ID = new Check_ID();
int studentID = check_ID.GetTrueStudentIDWhoHaveCourses(student, db);
Console.WriteLine("\n\n\t" + "UPATE STUDENTS PER COURSES" +
"\n\t---------------------------");
sTudent = student.UpdateStudent(db, sTudent, studentID);
int courseID = GetCourseIdFromStudent(db, sTudent.STUDENT_ID);
studentPerCourse.STUDENT_ID = sTudent.STUDENT_ID;
studentPerCourse.COURSE_ID = courseID;
db.SubmitChanges();
Console.WriteLine("\n\tStudents Per Courses was successfully enrolled!!!");
}