예제 #1
0
 public Student(string firstName, string lastName, string fn, string tel, string email, List<double> marks, Group groupN)
 {
     this.FirstName = firstName;
     this.LastName = lastName;
     this.FN = fn;
     this.Tel = tel;
     this.Email = email;
     this.Marks = marks;
     this.GroupN = groupN;
 }
        static void Main(string[] args)
        {
            List<Student> students = new List<Student>()
            {
                new Student("Pesho", "Peshov", "123406", "0854373434", "*****@*****.**", new List<double> {4, 5, 4.50}, new Group(2, "Mathematics")),
                new Student("Georgi", "Ivanov", "123409", "02543533", "*****@*****.**", new List<double> {6, 5.50, 4.50}, new Group(3, "Physics")),
                new Student("Nikola", "Dimitrov", "123411", "0894532313", "*****@*****.**", new List<double> {3.50, 4, 2, 2}, new Group(2, "Informatics")),
                new Student("Kiril", "Petrov", "123406", "0854343212", "*****@*****.**", new List<double> {5, 6, 5.50}, new Group(2, "Mathematics")),
                new Student("Maria", "Hristova", "123406", "02865782", "*****@*****.**", new List<double> {4.50, 5.25, 5}, new Group(1, "Mathematics")),
            };

            // only the students that are from group number 2, order the students by first name, with linq
            Console.WriteLine("Only the students that are from group number 2 with linq");
            var studentsFromGroupTwoWithLinq =
                from student in students
                where student.GroupN.GroupNumber == 2
                orderby student.FirstName
                select student;

            foreach (Student student in studentsFromGroupTwoWithLinq)
            {
                Console.WriteLine(student);
            }
            Console.WriteLine();

            // only the students that are from group number 2, order the students by first name, with lambda
            Console.WriteLine("Only the students that are from group number 2 with lambda");
            var studentsFromGroupTwoWithLambda = students.Where(student => student.GroupN.GroupNumber == 2)
                .OrderBy(student => student.FirstName);

            foreach (Student student in studentsFromGroupTwoWithLambda)
            {
                Console.WriteLine(student);
            }
            Console.WriteLine();

            // all students that have email in abv.bg with linq
            Console.WriteLine("All students that have email in abv.bg");
            var extractStudentsByEmail =
                from student in students
                where student.Email.Contains("@abv.bg")
                select student;

            foreach (Student student in extractStudentsByEmail)
            {
                Console.WriteLine(student);
            }
            Console.WriteLine();

            //all students with phones in Sofia with linq
            Console.WriteLine("All students with phones in Sofia");
            var extractStudentsByPhone =
                from student in students
                where student.Tel.StartsWith("02")
                select student;

            foreach (Student student in extractStudentsByPhone)
            {
                Console.WriteLine(student);
            }
            Console.WriteLine();

            // all students that have at least one mark Excellent (6) into a new anonymous class that has properties – FullName and Marks, with linq
            Console.WriteLine("All students that have at least one mark Excellent (6)");
            var extractStudentsByMark =
                from student in students
                where student.Marks.Contains(6)
                select new { FullName = student.FirstName + " " + student.LastName, Marks = student.Marks};

            foreach (var student in extractStudentsByMark)
            {
                Console.WriteLine("Full name: {0} \nMarks: {1}\n", student.FullName, string.Join(", ", student.Marks));
            }
            Console.WriteLine();

            //the students with exactly two marks "2" with lambda
            Console.WriteLine("The students with exactly two marks 2");
            var extractStudentsWithTwoMarks = students.Where(student => student.Marks.FindAll(mark => mark == 2).Count == 2)
                .Select(student => new {
                    FullName = student.FirstName + " " + student.LastName,
                    Marks = student.Marks });

            foreach (var student in extractStudentsWithTwoMarks)
            {
                Console.WriteLine("Full name: {0} \nMarks: {1}\n", student.FullName, string.Join(", ", student.Marks));
            }
            Console.WriteLine();

            //all Marks of the students that enrolled in 2006
            Console.WriteLine("All Marks of the students that enrolled in 2006");
            var extractMarks = students.Where(student => student.FN.Substring(4, 2) == "06")
                .Select(student => student.Marks);

            foreach (var mark in extractMarks)
            {
                Console.WriteLine("{0}", string.Join(", ", mark));
            }
            Console.WriteLine();

            //All students from "Mathematics" department
            Group group1 = new Group(1, "Informatics");
            Group group2 = new Group(2, "Mathematics");
            Group group3 = new Group(3, "Physics");

            List<Group> listOfGroups = new List<Group> {group1, group2, group3};

             Console.WriteLine("All students from Mathematics department");
            var extractStudentsByDepartment =
                from someGroup in listOfGroups
                where someGroup.DepartmentNumber == "Mathematics"
                join student in students on someGroup.DepartmentNumber equals student.GroupN.DepartmentNumber
                select student;

            foreach (Student student in extractStudentsByDepartment)
            {
                Console.WriteLine(student);
            }
            Console.WriteLine();

            //students grouped by GroupNumber with linq
            Console.WriteLine("Students grouped by GroupNumber with linq");

            var groupsWithLinq =
                from student in students
                group student by student.GroupN.GroupNumber;

            List<string> resultWithLinq = new List<string>();

            foreach (var someGroup in groupsWithLinq)
            {
                resultWithLinq.Add(string.Format("group {0}", someGroup.ElementAt(0).GroupN.GroupNumber));
            }

            foreach (var element in resultWithLinq)
            {
                Console.WriteLine(element);
            }
            Console.WriteLine();

            //students grouped by GroupNumber with lambda
            Console.WriteLine("Students grouped by GroupNumber with lambda");

            var groupsWithLambda = students.GroupBy(student => student.GroupN.GroupNumber);

            List<string> resultWithLambda = new List<string>();

            foreach (var someGroup in groupsWithLambda)
            {
                resultWithLambda.Add(string.Format("group {0}", someGroup.ElementAt(0).GroupN.GroupNumber));
            }

            foreach (var element in resultWithLambda)
            {
                Console.WriteLine(element);
            }
            Console.WriteLine();
        }