public void ShowPersonalMessage(int id)
{
ICollection <Student> students = DBStudent.ReadStudents();
Student s = students.Where(st => st.Id == id).First();
ConsoleUI.ShowLine($"Hello {s.FirstName} {s.LastName}");
}
public static bool IsEmptyDB()
{
int UserSize = DBUser.ReadUsers().Count();
int AssignmentSize = DBAssignment.ReadAssignments().Count();
int StudentSize = DBStudent.ReadStudents().Count();
int CourseSize = DBCourse.ReadCourses().Count();
int TrainerSize = DBTrainer.ReadTrainers().Count();
bool basicEntities = UserSize == 0 &&
AssignmentSize == 0 &&
StudentSize == 0 &&
CourseSize == 0 &&
TrainerSize == 0;
return(basicEntities);
}
public void Read()
{
ICollection <Student> students = DBStudent.ReadStudents();
if (students.Count() == 0)
{
ConsoleUI.ShowLine("No students yet");
}
else
{
foreach (Student s in students)
{
ConsoleUI.ShowLine(s);
}
}
ConsoleUI.ReadKey();
ConsoleUI.Clear();
}
public void Delete()
{
bool exit;
ICollection <Student> students = DBStudent.ReadStudents();
if (students.Count() == 0)
{
ConsoleUI.ShowLine("No students yet");
ConsoleUI.ReadKey();
ConsoleUI.Clear();
return;
}
else
{
ConsoleUI.ShowLine("select student to delete, type 0 to exit");
foreach (Student s in students)
{
ConsoleUI.ShowLine(s);
}
}
exit = ConsoleUI.GetInt(out int StudentID, "give student id: ");
if (exit)
{
return;
}
Student student;
try
{
student = students.Where(s => s.Id == StudentID).First();
}
catch (Exception)
{
ConsoleUI.ShowLine($"NO STUDENT FOUND WITH ID: {StudentID}");
ConsoleUI.ReadKey();
return;
}
bool confirmed = ConsoleUI.GetConfirmation($"are you sure you want to delete student {student.FirstName} {student.LastName}? [y/n]: ");
int result = 0;
if (confirmed)
{
try
{
result = DBStudent.DeleteStudent(StudentID);
if (result == 0)
{
throw new Exception("could NOT delete student");
}
}
catch (Exception e)
{
ConsoleUI.ShowLine(e.Message);
ConsoleUI.ReadKey();
return;
}
try
{
result = DBUser.DeleteUser(StudentID);
if (result == 0)
{
throw new Exception("could NOT delete user");
}
}
catch (Exception e)
{
ConsoleUI.ShowLine(e.Message);
ConsoleUI.ReadKey();
return;
}
ConsoleUI.ShowLine("student deleted successfully");
ConsoleUI.ReadKey();
}
}
public void Update()
{
bool exit;
ICollection <Student> students = DBStudent.ReadStudents();
if (students.Count() == 0)
{
ConsoleUI.ShowLine("No students yet");
ConsoleUI.ReadKey();
ConsoleUI.Clear();
return;
}
else
{
ConsoleUI.ShowLine("select student to update, type 0 to exit");
foreach (Student s in students)
{
ConsoleUI.ShowLine(s);
}
}
exit = ConsoleUI.GetInt(out int StudentID, "give student id: ");
if (exit)
{
return;
}
ConsoleUI.Clear();
Student student;
try
{
student = students.Where(s => s.Id == StudentID).First();
}
catch (Exception)
{
ConsoleUI.ShowLine($"NO STUDENT FOUND WITH ID: {StudentID}");
ConsoleUI.ReadKey();
return;
}
ConsoleUI.ShowLine($"you selected to edit student: {student.FirstName} {student.LastName}");
ConsoleUI.ShowLine($"select attribute to edit, type 0 anytime to exit");
ConsoleUI.ShowLine("1. Username");
ConsoleUI.ShowLine("2. Password");
ConsoleUI.ShowLine("3. First name");
ConsoleUI.ShowLine("4. Last name");
ConsoleUI.ShowLine("5. Date of birth");
ConsoleUI.ShowLine("6. Fees");
exit = ConsoleUI.GetInt(out int choice);
if (exit)
{
return;
}
ConsoleUI.Clear();
Object attribute;
if (choice == 1 || choice == 2)
{
attribute = (UserAttributes)choice;
}
else
{
attribute = (StudentAttributes)choice;
}
string newInput = "";
DateTime?newDate;
decimal newFees;
int result = 0;
try
{
switch (attribute)
{
case StudentAttributes.Fname:
exit = ConsoleUI.GetString(out newInput, "enter new first name: ");
if (exit)
{
return;
}
result = DBStudent.UpdateStudent(StudentID, attribute, newInput);
if (result == 0)
{
throw new Exception("student NOT updated");
}
break;
case StudentAttributes.Lname:
exit = ConsoleUI.GetString(out newInput, "enter new last name: ");
if (exit)
{
return;
}
result = DBStudent.UpdateStudent(StudentID, attribute, newInput);
if (result == 0)
{
throw new Exception("student NOT updated");
}
break;
case StudentAttributes.DOB:
exit = ConsoleUI.GetDate(out newDate, "enter new date of birth: ");
if (exit)
{
return;
}
result = DBStudent.UpdateStudent(StudentID, attribute, newDate);
if (result == 0)
{
throw new Exception("student NOT updated");
}
break;
case StudentAttributes.Fees:
exit = ConsoleUI.GetDecimal(out newFees, "enter new fees: ");
if (exit)
{
return;
}
result = DBStudent.UpdateStudent(StudentID, attribute, newFees);
if (result == 0)
{
throw new Exception("student NOT updated");
}
break;
case UserAttributes.Username:
exit = ConsoleUI.GetString(out newInput, "enter new username: "******"user NOT updated");
}
break;
case UserAttributes.Password:
exit = ConsoleUI.GetString(out newInput, "enter new password: "******"user NOT updated");
}
break;
default:
break;
}
}
catch (Exception e)
{
ConsoleUI.ShowLine(e.Message);
}
ConsoleUI.ShowLine("student updated successfully");
ConsoleUI.ReadKey();
}