static void Main()
{
List <Student> students = ListOfStudents.GetListOfSudents();
Console.WriteLine("Students grouped by GROUP NUMBER using LINQ!");
var groupedByGroupNumber =
from student in students
orderby student.GroupNumber
select student;
foreach (var st in groupedByGroupNumber)
{
Console.WriteLine("Name: {0} {1}, Group number: {2}",
st.FirstName,
st.LastName,
st.GroupNumber);
}
Console.WriteLine("\nStudents grouped by GROUP NUMBER using LINQ with extension method!");
var groupedByGroupNumberWithExtension = students.OrderBy(x => x.GroupNumber);
foreach (var st in groupedByGroupNumberWithExtension)
{
Console.WriteLine("Name: {0} {1}, Group number: {2}",
st.FirstName,
st.LastName,
st.GroupNumber);
}
}
static void Main()
{
List <Student> students = ListOfStudents.GetListOfSudents();
Console.WriteLine("Students from GROUP 2!");
var studentsFromSecondGroup = students.Where(st => st.GroupNumber == 2);
foreach (var st in studentsFromSecondGroup)
{
Console.WriteLine("Name: {0} {1}, Group Nr.: {2}",
st.FirstName,
st.LastName,
st.GroupNumber);
}
Console.WriteLine("\nStudents from GROUP 2 ordered by first name!");
var studentsFromSecondGroupOrderedByFirstName = studentsFromSecondGroup.OrderBy(st => st.FirstName);
foreach (var st in studentsFromSecondGroupOrderedByFirstName)
{
Console.WriteLine("Name: {0} {1}, Group Nr.: {2}",
st.FirstName,
st.LastName,
st.GroupNumber);
}
}
static void Main()
{
List <Student> students = ListOfStudents.GetListOfSudents();
Console.WriteLine("Students from GROUP 2!");
var studentsFromSecondGroup =
from student in students
where student.GroupNumber == 2
select student;
foreach (var st in studentsFromSecondGroup)
{
Console.WriteLine("Name: {0} {1}, Group Nr.: {2}",
st.FirstName,
st.LastName,
st.GroupNumber);
}
Console.WriteLine("\nStudents from GROUP 2 ordered by first name!");
var studentsFromSecondGroupOrderedByFirstName =
from student in studentsFromSecondGroup
orderby student.FirstName
select student;
foreach (var st in studentsFromSecondGroupOrderedByFirstName)
{
Console.WriteLine("Name: {0} {1}, Group Nr.: {2}",
st.FirstName,
st.LastName,
st.GroupNumber);
}
}
static void Main()
{
Student[] students = ListOfStudents.GetListOfSudents().ToArray();
var studentInAgeRange = FindStudentsInAgeRange(students, 18, 24);
foreach (var st in studentInAgeRange)
{
Console.WriteLine("Name: {0} {1}, Age: {2}", st.FirstName, st.LastName, st.Age);
}
}
static void Main()
{
List <Student> students = ListOfStudents.GetListOfSudents();
Console.WriteLine("Students with exact two marks 2!");
var studentsWithTwoMarks = students.Where(st => st.Marks.FindAll(x => x == 2).Count == 2);
foreach (var st in studentsWithTwoMarks)
{
Console.WriteLine("Name: {0} {1}", st.FirstName, st.LastName);
}
}
static void Main()
{
List <Group> groups = new List <Group>()
{
new Group {
GroupNumber = 1,
DepartmentName = "Mathematics"
},
new Group {
GroupNumber = 2,
DepartmentName = "Phisics"
},
new Group {
GroupNumber = 3,
DepartmentName = "Computer Science"
}
};
List <Student> students = ListOfStudents.GetListOfSudents();
Console.WriteLine("Students from the Mathematics department:");
var studentsFromMathDepartment =
from gr in groups
where gr.DepartmentName == "Mathematics"
join student in students
on gr.GroupNumber
equals student.GroupNumber
select new
{
FullName = string.Format("{0} {1}", student.FirstName, student.LastName),
DepartmentName = gr.DepartmentName
};
foreach (var st in studentsFromMathDepartment)
{
Console.WriteLine("Name: {0}\n--->Department: {1}\n", st.FullName, st.DepartmentName);
}
//var studentsFromMathDepartment =
// from student in students
// where student.GroupNumber == 1
// join gr in groups
// //where gr.DepartmentName == "Mathematics"
// on student.GroupNumber
// equals gr.GroupNumber
// select student;
}
static void Main()
{
List <Student> students = ListOfStudents.GetListOfSudents();
Console.WriteLine("Students that have email in ABV!");
var emailInAbv =
from student in students
where student.Email.Contains("abv.bg")
select student;
foreach (var st in emailInAbv)
{
Console.WriteLine("Name: {0} {1}, Email: {2}",
st.FirstName,
st.LastName,
st.Email);
}
}
static void Main()
{
List <Student> students = ListOfStudents.GetListOfSudents();
Console.WriteLine("Using Lambda Method");
var studentsOrderedLambda = OrderStudentsDescendingLambda(students);
foreach (var student in studentsOrderedLambda)
{
Console.WriteLine("Name: {0} {1}", student.FirstName, student.LastName);
}
Console.WriteLine("\nUsing LINQ Method");
var studentsOrderedLinq = OrderStudentsDescendingLinq(students);
foreach (var student in studentsOrderedLinq)
{
Console.WriteLine("Name: {0} {1}", student.FirstName, student.LastName);
}
}
static void Main()
{
//List<Student> students = ListOfStudents.GetListOfSudents();
Student[] students = ListOfStudents.GetListOfSudents().ToArray();
Console.WriteLine("Lambda method:");
var studentsListLambda = FirstBeforeLastLambda(students);
foreach (var st in studentsListLambda)
{
Console.WriteLine("Name: {0} {1}", st.FirstName, st.LastName);
}
Console.WriteLine("Linq method:");
var studentsListLinq = FirstBeforeLastLinq(students);
foreach (var st in studentsListLinq)
{
Console.WriteLine("Name: {0} {1}", st.FirstName, st.LastName);
}
}
static void Main()
{
List <Student> students = ListOfStudents.GetListOfSudents();
Console.WriteLine("Students with phone in Sofia!");
var phoneInSofia =
from student in students
where student.PhoneNumber.StartsWith("02") ||
student.PhoneNumber.StartsWith("+359 2") ||
student.PhoneNumber.StartsWith("00359 2")
select student;
foreach (var st in phoneInSofia)
{
Console.WriteLine("Name: {0} {1}, Phone number: {2}",
st.FirstName,
st.LastName,
st.PhoneNumber);
}
}
static void Main()
{
List <Student> students = ListOfStudents.GetListOfSudents();
var studentsIn2006 =
from student in students
where student.FN.ToString().EndsWith("06")
select new
{
Fullname = string.Format("{0} {1}", student.FirstName, student.LastName),
Marks = student.Marks
};
foreach (var st in studentsIn2006)
{
Console.Write("\nName: {0}\n Marks: ",
st.Fullname);
foreach (var mark in st.Marks)
{
Console.Write(" ({0}) ", mark);
}
}
}
static void Main()
{
List <Student> students = ListOfStudents.GetListOfSudents();
Console.WriteLine("Students that have at least one mark Excellent (6)!");
var studentsWithExcellentMark =
from student in students
where student.Marks.Contains(6)
select new
{
FullName = string.Format("{0} {1}", student.FirstName, student.LastName),
Marks = student.Marks
};
foreach (var st in studentsWithExcellentMark)
{
Console.WriteLine("\nName: {0}", st.FullName);
foreach (var mark in st.Marks)
{
Console.Write(" ({0}) ", mark);
}
}
}
