private static void ShowStudents()
{
StudentDataMapper student_mapper = new StudentDataMapper();
var students = student_mapper.Select();
//List<Student> student = student_mapper.Select();
var output = new StringBuilder();
output.AppendLine("Student ID\tFirst Name\tEnroll Date\tMajor");
output.AppendLine("----------\t----------\t-----------\t-----");
foreach (var stu in students)
{
output.Append(stu.ID.ToString().PadRight(10));
output.Append("\t");
output.Append(stu.FirstName.ToString().PadRight(10));
output.Append("\t");
output.Append(stu.LastName.ToString().PadRight(10));
output.Append("\t");
output.Append(string.Format("{0:d}", stu.EnrollDate).PadRight(10));
output.Append("\t");
output.Append(stu.Major.ToString().PadRight(10));
output.AppendLine();
}
Console.WriteLine(output.ToString());
}
private static void FindStudent()
{
Console.WriteLine("Enter the student name: ");
string name = Console.ReadLine();
StudentDataMapper student_mapper = new StudentDataMapper();
var searchStudents = student_mapper.Find(name);
Console.WriteLine("---------Search Results -------");
if (searchStudents.Count() > 0)
{
foreach (var s in searchStudents)
{
Console.WriteLine(s.StudentName);
}
}
else
{
Console.WriteLine($"No Records found for {name}");
}
Console.WriteLine();
}
