private static void ShowStudents() { //Instantiate the Student Data Mapper class StudentDataMapper student_mapper = new StudentDataMapper(); var students = student_mapper.Select(); //List<Student> students = student_mapper.Select(); var output = new StringBuilder(); output.AppendLine("Student ID\tFirst Name\tLast Name\tEnroll Date\tMajor"); output.AppendLine("-----------\t----------\t----------\t-----------\t---------"); //Loop throuth students list and display values foreach (var stu in students) { output.Append(stu.ID.ToString().PadRight(10)); output.Append("\t"); output.Append(stu.FirstName.PadRight(10)); output.Append("\t"); output.Append(stu.LastName.PadRight(10)); output.Append("\t"); output.Append(string.Format("{0:d}", stu.EnrollDate).PadRight(10)); output.Append("\t"); output.Append(stu.Major.PadRight(10)); output.AppendLine(); } Console.WriteLine(output.ToString()); }
private static void ShowStudents() { //instantiate the student data mapper class StudentDataMapper student_mapper = new StudentDataMapper(); // var students = student_mapper.Select(); List <Student> students = student_mapper.Select(); var output = new StringBuilder(); output.AppendLine("Student ID\tFirst Name\tLast Name\tEnroll Date\tMajor"); output.AppendLine("---------\t---------\t---------\t---------\t---------"); foreach (var stu in students) { output.AppendLine(stu.ID.ToString().PadRight(10)); output.Append("\t"); output.Append } }
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); } }