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(); }