static void Main()
{
StudentsDirectory database1 = new StudentsDirectory();
SpecialtiesDirectory database2 = new SpecialtiesDirectory();
// LINQ query
var joinedData =
from student in database1.Students
orderby student.FirstName ascending, student.LastName ascending
join speciality in database2.StudentSpecialties on student.FacultyNumber equals speciality.FacultyNumber
select new { student.FirstName, student.LastName, student.FacultyNumber, speciality.Speciality };
// lambda expression
var joinedDataLinqExtMtd =
database1.Students.OrderBy(st => st.FirstName)
.ThenBy(st => st.LastName)
.Join(database2.StudentSpecialties, st => st.FacultyNumber, sp => sp.FacultyNumber,
(student, speciality) =>
new { student.FirstName, student.LastName, student.FacultyNumber, speciality.Speciality });
// printing
Console.WriteLine("{0, -18} {1, -8} {2, -12}", "Name", "FacNum", "Specialty");
foreach (var item in joinedData)
{
Console.WriteLine("{0, -18} {1, -8} {2, -12}", item.FirstName + " " + item.LastName, item.FacultyNumber, item.Speciality );
}
}
public static List<StudentWithGroup> CreateGroupsDirectory()
{
var studentsWithGroups = new List<StudentWithGroup>();
// using the intitial students databae, to create new studets with groups database
StudentsDirectory database = new StudentsDirectory();
foreach (var student in database.Students)
{
if (student.GroupNumber == 1)
{
studentsWithGroups.Add(new StudentWithGroup(student, "C#"));
}
else if (student.GroupNumber == 2)
{
studentsWithGroups.Add(new StudentWithGroup(student, "PHP"));
}
else if (student.GroupNumber == 3)
{
studentsWithGroups.Add(new StudentWithGroup(student, "JS"));
}
else if (student.GroupNumber == 4)
{
studentsWithGroups.Add(new StudentWithGroup(student, "Java"));
}
else
{
studentsWithGroups.Add(new StudentWithGroup(student, "No group chosen"));
}
}
return studentsWithGroups;
}
public static void Main()
{
// Problem 1. Class Student - creating an instance of the StudentsDirectory class, so that we can use its List<Student> with sample students
StudentsDirectory database = new StudentsDirectory();
// printing
database.Students.PrintStudentsInfo();
}
public static void Main()
{
// Problem 1. Class Student - creating an instance of the StudentsDirectory class, so that we can use its List<Student> with sample students
StudentsDirectory database = new StudentsDirectory();
// printing
database.Students.PrintStudentsInfo();
}
static void Main(string[] args)
{
StudentsDirectory database = new StudentsDirectory();
var studentsByPhone =
from student in database.Students
where student.Phone.StartsWith("02") || student.Phone.StartsWith("+3592")|| student.Phone.StartsWith("+359 2")
select student;
foreach (var student in studentsByPhone) Console.WriteLine("{0} {1}, {2}",student.FirstName, student.LastName, student.Phone);
}
static void Main(string[] args)
{
StudentsDirectory database = new StudentsDirectory();
var excellentStudent =
from student in database.Students
where student.Marks.Contains(6)
select student;
foreach(var student in excellentStudent)
Console.WriteLine("{0} {1}, {2}", student.FirstName,student.LastName,string.Join(",",student.Marks));
}
static void Main()
{
// creating an instance of the StudentsDirectory class, so that we can use its IList<Student>
StudentsDirectory database = new StudentsDirectory();
// running LINQ query
var studentsByPhoneQuery = database.Students.StudentsByPhoneQuery();
// printing - by invoking the PrintStudentsInfo() method from the StudentsByFirstAndLastName project
StudentsByFirstAndLastName.PrintStudentsInfo(studentsByPhoneQuery);
}
static void Main()
{
// creating an instance of the StudentsDirectory class, so that we can use its IList<Student>
StudentsDirectory database = new StudentsDirectory();
// running LINQ query
var studentsByNames = database.Students.StudentsByNames();
// printing
PrintStudentsInfo(studentsByNames);
}
static void Main(string[] args)
{
StudentsDirectory database = new StudentsDirectory();
var studentsByEmail =
from student in database.Students
where student.Email.Substring(student.Email.Length - 6) == "abv.bg"
select student;
foreach (var student in studentsByEmail)
Console.WriteLine("{0} {1}, {2}", student.FirstName, student.LastName, student.Email);
}
static void Main(string[] args)
{
StudentsDirectory database = new StudentsDirectory();
var weakStudents =
from student in database.Students
where (student.Marks.Count(x => x == 2) == 2)
select student;
foreach(var student in weakStudents)
Console.WriteLine("{0} {1}, {2}", student.FirstName, student.LastName, string.Join(",", student.Marks));
}
static void Main()
{
// creating an instance of the StudentsDirectory class, so that we can use its IList<Student>
StudentsDirectory database = new StudentsDirectory();
// running LINQ query
var excellentStudents =
from student in database.Students
where student.Marks.Contains(6)
select new { Fullname = string.Join(" ", student.FirstName, student.LastName), Marks = string.Join(", ", student.Marks) };
// printing
foreach (var student in excellentStudents)
{
Console.WriteLine("Name: {0}, Grades: {{{1}}}", student.Fullname, student.Marks);
}
}
static void Main()
{
// creating an instance of the StudentsDirectory class, so that we can use its IList<Student>
StudentsDirectory database = new StudentsDirectory();
// using lambda expressions
var sortedStudents =
database.Students.OrderByDescending(student => student.FirstName).ThenBy(student => student.LastName);
// running LINQ query
var studentsSortQuery = database.Students.StudentsSortQuery();
// printing - by invoking the PrintStudentsInfo() method from the StudentsByFirstAndLastName project
StudentsByFirstAndLastName.PrintStudentsInfo(sortedStudents);
Console.WriteLine();
StudentsByFirstAndLastName.PrintStudentsInfo(studentsSortQuery);
}
static void Main()
{
// creating an instance of the StudentsDirectory class, so that we can use its IList<Student>
StudentsDirectory database = new StudentsDirectory();
// running LINQ query
var studentsByAgeQuery =
from student in database.Students
where student.Age >= 18 && student.Age <= 24
select new {student.FirstName, student.LastName, student.Age}; // limiting the query to names and age
// printing
foreach (var student in studentsByAgeQuery)
{
Console.WriteLine("Name: {0} {1}, Age: {2}",
student.FirstName, student.LastName, student.Age);
}
}
static void Main(string[] args)
{
StudentsDirectory database = new StudentsDirectory();
var sortedStudents =
from student in database.Students
orderby student.FirstName descending,
student.LastName descending
select student;
var sortedStudent = database.Students.OrderByDescending(student => student.FirstName).ThenByDescending(student => student.LastName);
Console.WriteLine("LINQ");
foreach (var student in sortedStudent) Console.Write("{0} {1}\n",student.FirstName, student.LastName);
Console.WriteLine();
Console.WriteLine("Lambda");
foreach(var student in sortedStudents) Console.Write("{0} {1}\n", student.FirstName, student.LastName);
}
static void Main()
{
// creating an instance of the StudentsDirectory class, so that we can use its IList<Student>
StudentsDirectory database = new StudentsDirectory();
// running LINQ query
var studentsByAge =
from student in database.Students
orderby student.Age
select student;
// printing
foreach (var student in studentsByAge)
{
Console.WriteLine("Name: {0} {1}, Age: {2}",
student.FirstName, student.LastName, student.Age);
}
}
static void Main(string[] args)
{
StudentsDirectory database = new StudentsDirectory();
}
