private static int AddCourseMaterial(StudentSystemData data) { Material material = new Material { Name = "JSAdvanced Simulating OOP Homework", Link = "https://softuni.bg/downloads/svn/javascript-oop/March-2015/2.%20Simulating-OOP-in-JavaScript-Homework.docx", MaterialType = MaterialType.HomeworkAssignment }; data.Materials.Add(material); return data.SaveChanges(); }
private static int AddStudent(StudentSystemData data) { Student student = new Student { Name = "Gergana Gencheva", RegistrationDate = DateTime.Now, BirthDay = new DateTime(1825, 02, 02), PhoneNumber = "123469899" }; data.Students.Add(student); return data.SaveChanges(); }
public static void Main(string[] args) { var studentDb = new StudentSystemData(); var newResource = new Resource { Link = "www.abv.bg", Name = "Email", Type = ResourceType.Other }; studentDb.Resources.Add(newResource); Student student = new Student { FirstName = "Ta Pepelqqq", LastName = "Ne vyrvi", Birthday = new DateTime(1825, 02, 02), PhoneNumber = "123469899" }; studentDb.Students.Add(student); Course course = new Course { Description = "Za Strugari", Name = "Strug mania", Price = 1.1M, EndDate = new DateTime(2016, 12, 1), StartDate = DateTime.Now }; course.Resources.Add(newResource); studentDb.Courses.Add(course); studentDb.SaveChanges(); var studentsHomeworks = GetStudentsWithHomeworks(studentDb); foreach (var studentHomeworks in studentsHomeworks) { Console.WriteLine(studentHomeworks.FirstName + " " + studentHomeworks.LastName); var homeworks = studentHomeworks.Homeworks; foreach (var homework in homeworks) { Console.WriteLine(" " + homework.CourseName + "-" + homework.SentOn.Date); } Console.WriteLine(); } var coursesWithResources = GetCoursesWithResources(studentDb); foreach (var courseWithResources in coursesWithResources) { Console.WriteLine(courseWithResources.Name); var resources = courseWithResources.Resources; foreach (var resource in resources) { Console.WriteLine(" " + resource.Name + "-" + resource.Link); } Console.WriteLine(); } }
private static IEnumerable<dynamic> GetStudentsWithHomeworks(StudentSystemData studentDb) { var studentsHomeworks = studentDb.Students.All() .Select( s => new { s.FirstName, s.LastName, Homeworks = s.Homeworks.Select(h => new { CourseName = h.Course.Name, h.SentOn }) }); return studentsHomeworks.ToList(); }
private static void ListCoursesWithMaterials(StudentSystemData data) { StringBuilder sb = new StringBuilder(); var courses = data.Courses.All().ToList(); foreach (Course course in courses.ToList()) { sb.AppendFormat("Course {0}", course.Name); sb.Append("\n\tMaterials:"); foreach (var material in course.Materials) { sb.AppendFormat("\n\t\tMaterial: {0}", material.Name); } sb.AppendLine(); } Console.WriteLine(sb.ToString()); }
private static int AddCourseWithMaterials(StudentSystemData data) { Course course = new Course { Name = "JS Advanced", Description = "JavaScript course for advanced programmers", StartDate = new DateTime(2015, 02, 27), EndDate = new DateTime(2015, 04, 21), Price = 0m }; Material material = new Material { Name = "JSAdvanced Function Expressions Demo", Link = "https://github.com/SoftUni/Advanced-JavaScript/tree/master/1.%20Functions-and-Function-Expressions", MaterialType = MaterialType.CodeStubs }; data.Materials.Add(material); course.Materials.Add(material); //material.Courses.Add(course); data.Courses.Add(course); return data.SaveChanges(); }
private static void ListStudentsWithHomeworks(StudentSystemData data) { StringBuilder sb = new StringBuilder(); var students = data.Students.All().ToList(); foreach (Student student in students.ToList()) { sb.AppendFormat("Student {0}", student.Name); sb.Append("\n\tHomeworks:"); foreach (var hw in student.Homeworks) { sb.AppendFormat("\n\t\tHomework Sent on:{0}, Course: {1}", hw.SentDate.ToString(), hw.Course.Name); } sb.AppendLine(); } Console.WriteLine(sb.ToString()); }
static void Main(string[] args) { var data = new StudentSystemData(); string input = string.Empty; do { PrintMenu(); input = Console.ReadLine(); switch (input.ToLower()) { case "1": ListStudentsWithHomeworks(data); break; case "2": ListCoursesWithMaterials(data); break; case "3": if (AddCourseWithMaterials(data) > 0) { Console.WriteLine("Course with material added successfully"); } break; case "4": if (AddStudent(data) > 0) { Console.WriteLine("Student added successfully"); } break; case "5": if (AddCourseMaterial(data) > 0) { Console.WriteLine("Course material added successfully"); } break; case "end": Console.WriteLine("Good Bye!"); break; default: Console.WriteLine("Invalid Input. Try again".ToUpper()); break; } } while (input.ToLower() != "end"); }
protected BaseApiController() { var context = new StudentSystemDbContext(); this.Data = new StudentSystemData(context); }
private static List<Course> GetCoursesWithResources(StudentSystemData studentDb) { var coursesResources = studentDb.Courses.All().Include(s => s.Resources); return coursesResources.ToList(); }
public static void Main() { var data = new StudentSystemData(); //var firstStudentContactInfo = new ContactInfo() //{ // Email = "*****@*****.**", // Number = "53453465352353", // Skype = "sdfsdgdfgdfgd" //}; #region filling some date //var courses = new[] //{ // new Course { Name = "EF Course" }, // new Course { Name = ".NET MVC" } //}; //data.Courses.Add(courses[0]); //data.Courses.Add(courses[1]); //data.Courses.SaveChanges(); //var firstStudent = new Student() //{ // FirstName = "Vani", // LastName = "Banani", // Age = 27, // StudentStatus = StudentStatus.Online, // ContactInfo = firstStudentContactInfo, // Courses = courses //}; //data.Students.Add(firstStudent); //data.Students.SaveChanges(); //var secodnStudentContactInfo = new ContactInfo() //{ // Email = "*****@*****.**" //}; //var secondStudent = new Student() //{ // FirstName = "Goshkata", // LastName = "Goshkov", // Age = 23, // ContactInfo = secodnStudentContactInfo, // Courses = data.Courses.All().ToList() //}; //data.Students.Add(secondStudent); //data.Students.SaveChanges(); #endregion Console.WriteLine("Students:"); foreach (var student in data.Students.All()) { Console.WriteLine(student + Environment.NewLine); } Console.WriteLine("Courses:"); foreach (var course in data.Courses.All()) { Console.WriteLine(course); } }