static void Main(string[] args)
{
// 03_Class Student
Student pesho =
new Student("Petar", "Peshev", 23, 10110000, "02/943-48-06",
"*****@*****.**", new List<int>() { 2, 5, 5, 6, 6, 6, 6 }, 2, "Excellent");
Student gosho =
new Student("Georgi", "Goshev", 19, 13118795, "+359887894568",
"*****@*****.**", new List<int>() { 2, 2, 2, 2, 2, 3, 4 }, 1, "Weak");
Student stoqn =
new Student("Stoqn", "Stoqnev", 56, 10111234, "+359279542357",
"*****@*****.**", new List<int>() { 6, 6, 6, 6, 6, 6, 6 }, 3, "Excellent");
Student angel =
new Student("Acho", "Stoqnov", 20, 12119874, "+359987456987",
"*****@*****.**", new List<int>() { 6, 6, 4, 6, 4, 2, 3 }, 2, "Medium");
Student angelA =
new Student("Acho", "Angelov", 18, 14124568, "+359789654123",
"*****@*****.**", new List<int>() { 5, 2, 4, 6, 4, 2, 3 }, 1, "Medium");
List<Student> students = new List<Student>();
students.Add(pesho);
students.Add(stoqn);
students.Add(gosho);
students.Add(angel);
students.Add(angelA);
// 04_Student-by-Group
var studentsFrom2Group =
from student in students
where student.GroupNumber == 2
orderby student.FirstName
select student;
Console.WriteLine("_04_Student by Group: ----------------------------> \n");
foreach (var item in studentsFrom2Group)
{
Console.WriteLine(item);
}
// 05_Students-by-First-and-Last-Name
var studentsByNameAndLastName =
from student in students
orderby student.FirstName, student.Lastname
select student;
Console.WriteLine("_05_Students by First and Last Name: -------------------> \n");
foreach (var item in studentsByNameAndLastName)
{
Console.WriteLine(item);
}
// 06_Students-by-Age
var studentsByAge =
from student in students
where student.Age <= 24 && student.Age >= 18
select new { FirstName = student.FirstName, LastName = student.Lastname };
Console.WriteLine("_06_Student by Age: ----------------------------> \n ");
foreach (var item in studentsByAge)
{
Console.WriteLine("Student: ({0} {1})", item.FirstName, item.LastName);
}
// 07_Sort-Students
Console.WriteLine("\n_07_Sort Students with LAMBDA: -------------------------------> \n");
students.OrderByDescending(s => s.FirstName).ThenByDescending(s => s.Lastname).ToList().ForEach(s => Console.WriteLine(s.ToString()));
var studentsInDescendingOrder =
from student in students
orderby student.FirstName descending, student.Lastname descending
select student;
Console.WriteLine("_07_Sort Students with LINQ: -----------------------------------> \n");
foreach (var item in studentsInDescendingOrder)
{
Console.WriteLine(item);
}
// 08_Filter Students by Email Domain
Console.WriteLine("_08_Students by Email Domain: ----------------------------> \n");
var studentsByEmail =
from student in students
where student.Email.Contains("@abv.bg")
select student;
foreach (var item in studentsByEmail)
{
Console.WriteLine(item);
}
// 09_Filter Students by Phone
Console.WriteLine("_09_Students by Phone: -------------------------------------> \n");
var studentsByPhone =
from student in students
where student.Phone.StartsWith("02") || student.Phone.StartsWith("+3592") || student.Phone.StartsWith("+359 2")
select student;
foreach (var item in studentsByPhone)
{
Console.WriteLine(item);
}
// 10_Excellent Students
Console.WriteLine("_10_Excellent Students: --------------------------------> \n");
var studentExcellent =
from student in students
where student.Marks.Contains(6)
select new { FirstName = student.FirstName, Marks = student.Marks };
foreach (var item in studentExcellent)
{
string marks = string.Join(", ", item.Marks);
Console.WriteLine("{0}: ({1})", item.FirstName, marks);
}
// 11_Weak Students
Console.WriteLine("_11_Weak Stuents: --------------------------------------> \n");
var weakStudents =
from student in students
where student.Marks.Where(s => s == 2).Count() == 2
select student;
foreach (var item in weakStudents)
{
Console.WriteLine(item);
}
// 12_Students Endrolled in 2014
Console.WriteLine("_12_Students Endrolled in 2014: ------------------------------------------> \n");
students.Where(s => s.FacultyNumber.ToString().Trim().StartsWith("14"))
.ToList().ForEach(s => Console.WriteLine(s.ToString()));
// 13_Students by Groups
Console.WriteLine("_13_Students by Groups: ----------------------------------------> \n");
var groups =
from student in students
group student by student.GroupName into g
orderby g.Key
select g;
int studentByGroupCounter = 0;
foreach (var item in groups)
{
var tempStudents = students.Where(s => s.GroupName == item.Key);
Console.WriteLine("{0}: \n",item.Key);
foreach (var student in tempStudents)
{
studentByGroupCounter++;
Console.WriteLine(studentByGroupCounter + ". \n" + student);
}
studentByGroupCounter = 0;
}
// 14_Students Joined To Specialties
Console.WriteLine("_14_Students Joined To Specialties: ---------------------------------> \n");
StudentSpecialty goshko = new StudentSpecialty("Software Enginering", 10111234);
StudentSpecialty achkata = new StudentSpecialty("Ecology", 12119874);
List<StudentSpecialty> specialties = new List<StudentSpecialty>();
specialties.Add(goshko);
specialties.Add(achkata);
var studentsWithSpecialties =
from speciality in specialties
join student in students on speciality.FacultyNumber equals student.FacultyNumber
select new { student, FacultyName = speciality.SpecialityName };
foreach (var item in studentsWithSpecialties)
{
Console.WriteLine(item);
Console.WriteLine();
}
}
static void Main(string[] args)
{
// 03_Class Student
Student pesho =
new Student("Petar", "Peshev", 23, 10110000, "02/943-48-06",
"*****@*****.**", new List <int>()
{
2, 5, 5, 6, 6, 6, 6
}, 2, "Excellent");
Student gosho =
new Student("Georgi", "Goshev", 19, 13118795, "+359887894568",
"*****@*****.**", new List <int>()
{
2, 2, 2, 2, 2, 3, 4
}, 1, "Weak");
Student stoqn =
new Student("Stoqn", "Stoqnev", 56, 10111234, "+359279542357",
"*****@*****.**", new List <int>()
{
6, 6, 6, 6, 6, 6, 6
}, 3, "Excellent");
Student angel =
new Student("Acho", "Stoqnov", 20, 12119874, "+359987456987",
"*****@*****.**", new List <int>()
{
6, 6, 4, 6, 4, 2, 3
}, 2, "Medium");
Student angelA =
new Student("Acho", "Angelov", 18, 14124568, "+359789654123",
"*****@*****.**", new List <int>()
{
5, 2, 4, 6, 4, 2, 3
}, 1, "Medium");
List <Student> students = new List <Student>();
students.Add(pesho);
students.Add(stoqn);
students.Add(gosho);
students.Add(angel);
students.Add(angelA);
// 04_Student-by-Group
var studentsFrom2Group =
from student in students
where student.GroupNumber == 2
orderby student.FirstName
select student;
Console.WriteLine("_04_Student by Group: ----------------------------> \n");
foreach (var item in studentsFrom2Group)
{
Console.WriteLine(item);
}
// 05_Students-by-First-and-Last-Name
var studentsByNameAndLastName =
from student in students
orderby student.FirstName, student.Lastname
select student;
Console.WriteLine("_05_Students by First and Last Name: -------------------> \n");
foreach (var item in studentsByNameAndLastName)
{
Console.WriteLine(item);
}
// 06_Students-by-Age
var studentsByAge =
from student in students
where student.Age <= 24 && student.Age >= 18
select new { FirstName = student.FirstName, LastName = student.Lastname };
Console.WriteLine("_06_Student by Age: ----------------------------> \n ");
foreach (var item in studentsByAge)
{
Console.WriteLine("Student: ({0} {1})", item.FirstName, item.LastName);
}
// 07_Sort-Students
Console.WriteLine("\n_07_Sort Students with LAMBDA: -------------------------------> \n");
students.OrderByDescending(s => s.FirstName).ThenByDescending(s => s.Lastname).ToList().ForEach(s => Console.WriteLine(s.ToString()));
var studentsInDescendingOrder =
from student in students
orderby student.FirstName descending, student.Lastname descending
select student;
Console.WriteLine("_07_Sort Students with LINQ: -----------------------------------> \n");
foreach (var item in studentsInDescendingOrder)
{
Console.WriteLine(item);
}
// 08_Filter Students by Email Domain
Console.WriteLine("_08_Students by Email Domain: ----------------------------> \n");
var studentsByEmail =
from student in students
where student.Email.Contains("@abv.bg")
select student;
foreach (var item in studentsByEmail)
{
Console.WriteLine(item);
}
// 09_Filter Students by Phone
Console.WriteLine("_09_Students by Phone: -------------------------------------> \n");
var studentsByPhone =
from student in students
where student.Phone.StartsWith("02") || student.Phone.StartsWith("+3592") || student.Phone.StartsWith("+359 2")
select student;
foreach (var item in studentsByPhone)
{
Console.WriteLine(item);
}
// 10_Excellent Students
Console.WriteLine("_10_Excellent Students: --------------------------------> \n");
var studentExcellent =
from student in students
where student.Marks.Contains(6)
select new { FirstName = student.FirstName, Marks = student.Marks };
foreach (var item in studentExcellent)
{
string marks = string.Join(", ", item.Marks);
Console.WriteLine("{0}: ({1})", item.FirstName, marks);
}
// 11_Weak Students
Console.WriteLine("_11_Weak Stuents: --------------------------------------> \n");
var weakStudents =
from student in students
where student.Marks.Where(s => s == 2).Count() == 2
select student;
foreach (var item in weakStudents)
{
Console.WriteLine(item);
}
// 12_Students Endrolled in 2014
Console.WriteLine("_12_Students Endrolled in 2014: ------------------------------------------> \n");
students.Where(s => s.FacultyNumber.ToString().Trim().StartsWith("14"))
.ToList().ForEach(s => Console.WriteLine(s.ToString()));
// 13_Students by Groups
Console.WriteLine("_13_Students by Groups: ----------------------------------------> \n");
var groups =
from student in students
group student by student.GroupName into g
orderby g.Key
select g;
int studentByGroupCounter = 0;
foreach (var item in groups)
{
var tempStudents = students.Where(s => s.GroupName == item.Key);
Console.WriteLine("{0}: \n", item.Key);
foreach (var student in tempStudents)
{
studentByGroupCounter++;
Console.WriteLine(studentByGroupCounter + ". \n" + student);
}
studentByGroupCounter = 0;
}
// 14_Students Joined To Specialties
Console.WriteLine("_14_Students Joined To Specialties: ---------------------------------> \n");
StudentSpecialty goshko = new StudentSpecialty("Software Enginering", 10111234);
StudentSpecialty achkata = new StudentSpecialty("Ecology", 12119874);
List <StudentSpecialty> specialties = new List <StudentSpecialty>();
specialties.Add(goshko);
specialties.Add(achkata);
var studentsWithSpecialties =
from speciality in specialties
join student in students on speciality.FacultyNumber equals student.FacultyNumber
select new { student, FacultyName = speciality.SpecialityName };
foreach (var item in studentsWithSpecialties)
{
Console.WriteLine(item);
Console.WriteLine();
}
}
