public MySqlContext(DbContextOptions options) : base(options) { //Database.EnsureDeleted(); Database.EnsureCreated(); if (Articles.Count() == 0) { PutData data = new PutData(); Articles.AddRange(data.articles); Comments.AddRange(data.comments); SuperUsers.Add(data.super); TeacherUsers.AddRange(data.teacher); StudentUsers.AddRange(data.studentUser); TestStudents.AddRange(data.testStudents); QuestionAnswers.AddRange(data.questionAnswers); Tests.AddRange(data.tests); Themes.AddRange(data.themes); TestThemes.AddRange(data.TestThemas); Questions.AddRange(data.questions1); Questions.AddRange(data.questions2); Questions.AddRange(data.questions3); Marks.AddRange(data.Marks1); Marks.AddRange(data.Marks2); EventProfileUsers.AddRange(data.EventProfileUsers); Meetups.AddRange(data.Meetups); Speakers.AddRange(data.Speakers); SaveChanges(); } }
public static void Main() { // Test Task 1 Console.WriteLine("Substring of Stringbuilder: "); var strBuild = new StringBuilder(); strBuild.Append("Lorem ipsum dolor sit amet, consectetur adipiscing elit."); var newStrBuild = strBuild.Substring(0, 7); Console.WriteLine(newStrBuild.ToString()); Separator(); // Test Task 2 var list = new List <int>(); for (int i = 1; i <= 35; i++) { list.Add(i); } Console.WriteLine(string.Join(", ", list)); Console.WriteLine("The sum of elements in collection is: {0}", list.Sum()); Console.WriteLine("The product of elements in collection is: {0}", list.Product()); Console.WriteLine("Minimal value of all elements is: {0}", list.Min()); Console.WriteLine("Maximal value of all elements is: {0}", list.Max()); Console.WriteLine("Average value of elements is: {0}", list.Average()); Separator(); // Creating list of students var studentsList = TestStudents.GenerateListStudents(); // Adding some marks studentsList[0].AddMark(Course.CSharpFundamentals, MarkValue.Excellent); studentsList[0].AddMark(Course.CSharpAdvanced, MarkValue.VeryGood); studentsList[0].AddMark(Course.HTMLFundamentals, MarkValue.Excellent); studentsList[0].AddMark(Course.CSS, MarkValue.Fair); studentsList[1].AddMark(Course.CSharpOOP, MarkValue.Poor); studentsList[1].AddMark(Course.JavaScript, MarkValue.Good); studentsList[2].AddMark(Course.CSharpOOP, MarkValue.Good); studentsList[2].AddMark(Course.JavaScript, MarkValue.Good); studentsList[2].AddMark(Course.CSS, MarkValue.VeryGood); studentsList[2].AddMark(Course.CSharpFundamentals, MarkValue.Good); studentsList[3].AddMark(Course.CSharpOOP, MarkValue.Excellent); studentsList[3].AddMark(Course.JavaScript, MarkValue.Excellent); studentsList[3].AddMark(Course.CSS, MarkValue.VeryGood); studentsList[3].AddMark(Course.CSharpFundamentals, MarkValue.Excellent); studentsList[4].AddMark(Course.CSharpOOP, MarkValue.Poor); studentsList[4].AddMark(Course.JavaScript, MarkValue.Good); studentsList[4].AddMark(Course.CSS, MarkValue.VeryGood); studentsList[4].AddMark(Course.CSharpFundamentals, MarkValue.Good); studentsList[5].AddMark(Course.CSharpOOP, MarkValue.Poor); studentsList[5].AddMark(Course.JavaScript, MarkValue.Good); studentsList[5].AddMark(Course.CSS, MarkValue.VeryGood); studentsList[5].AddMark(Course.CSharpFundamentals, MarkValue.Good); studentsList[6].AddMark(Course.CSharpOOP, MarkValue.VeryGood); studentsList[6].AddMark(Course.JavaScript, MarkValue.Good); studentsList[6].AddMark(Course.CSS, MarkValue.Poor); studentsList[6].AddMark(Course.CSharpFundamentals, MarkValue.Fair); // Adding some phoneNumbers studentsList[0].PhoneNumber = "+359882888777"; studentsList[1].PhoneNumber = "+359884777888"; studentsList[2].PhoneNumber = "+359885222333"; studentsList[3].PhoneNumber = "+359882111222"; studentsList[4].PhoneNumber = "+359882555666"; studentsList[5].PhoneNumber = "+359883123456"; studentsList[6].PhoneNumber = "+359882987654"; Console.WriteLine("List of students: "); studentsList.PrintCollection(); Separator(); // Task 3 Console.WriteLine("Students with first name before last: "); var studentsWithFirstNameBeforeLast = TestStudents.FilterByFirstNameBeforeLast(studentsList); studentsWithFirstNameBeforeLast.PrintCollection(); Separator(); // Task 4 Console.WriteLine("First and last name of studnets between 18 and 24: "); var filteredStudentsByAge = TestStudents.FilterByAge(studentsList); filteredStudentsByAge.PrintCollection(); Separator(); // Task 5 Console.WriteLine("Descending ordered list of students by names : "); // with Query var orderedDescList = TestStudents.OrderByDescendingQuery(studentsList); // with extension methods // var orderedDescList = studentsList.OrderByDescendingExt(); orderedDescList.PrintCollection(); Separator(); // Task 6 Console.WriteLine("Extension Methods: "); var devisibleExt = list .Where(number => number % 21 == 0); devisibleExt.PrintCollection(); Separator(); Console.WriteLine("Query: "); var devisibleQuery = from num in list where num % 21 == 0 select num; devisibleQuery.PrintCollection(); Separator(); // Task 7 var timer = new Timer(2, 3); timer.Methods += FirstMethod; timer.Methods += SecondMethod; timer.Run(); Separator(); // Task 8 - TO DO var timerWithEvent = new TimerEvent(1, 2); timerWithEvent.Methods += FirstMethod; timerWithEvent.Run(); Separator(); // Task 9 Console.WriteLine("Students from goup number 2"); var secondGrStuds = TestStudents.GroupStudsByGroup(studentsList, GroupNumber.second); secondGrStuds.PrintCollection(); Separator(); // Task 10 Console.WriteLine("Students from number 3"); var thirdGrStuds = TestStudents.GroupStudsByGroupMethods(studentsList, GroupNumber.third); thirdGrStuds.PrintCollection(); Separator(); // Task 11 Console.WriteLine("Students with emails by \"abv.bg\" domain:"); var studsAbvBg = TestStudents.ExtractSudsByMail(studentsList, "abv.bg"); studsAbvBg.PrintCollection(); Separator(); // Task 12 Console.WriteLine("Students with phones from Sofia:"); var studsFromSofia = TestStudents.ExtractStudsByPhone(studentsList); studentsList.PrintCollection(); Separator(); // Task 13 - TODO Console.WriteLine("Extracted Students with mark 6:"); TestStudents.ExtractStudsByMarkSix(studentsList); Separator(); // Task 14 Console.WriteLine("Extracted Students with exactly 2 marks:"); TestStudents.ExtractStudsByMakrsCount(studentsList, 2); Separator(); // Task 15 Console.WriteLine("Marks of Students enrolled in 2006:"); TestStudents.ExtractStudsByYear(studentsList, "06"); Separator(); // Task 16 Console.WriteLine("Students from Math Department: "); var mathDeptStuds = TestStudents.ExtractStudsByDepartment(studentsList, "Math"); mathDeptStuds.PrintCollection(); Separator(); // Task 17 var strArr = new string[] { "I am the coolest string", "I am the strongest string", "I am the looooooongest string" }; var longestStr = (from str in strArr orderby str.Length descending select str).First(); Console.WriteLine(longestStr); Separator(); // Task 18 Console.WriteLine("Students grouped by group number:"); TestStudents.PrintStudsByGroup(studentsList); Separator(); // Task 19 Console.WriteLine("Students grouped by department:"); TestStudents.PrintStudsByDepartment(studentsList); Separator(); // Task 20 - TODO }