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(); } }
static void Main(string[] args) { //You may need to change the data source of the connection string in the App.cofig file because I am using .\SQLEXPRESS!!! var data = new StudentSystemData(); while (true) { Console.WriteLine("Enter 1 to list all students\n 2 to list all courses\n 3 to list all materials\n 4 to list all homeworks\n exit to exit the program"); string command = Console.ReadLine(); switch (command) { case "1": var students = data.Students.All(); foreach (var student in students) { Console.WriteLine(student.FirstName + " " + student.LastName + " " + student.Number); } break; case "2": var courses = data.Courses.All(); foreach (var course in courses) { Console.WriteLine(course.Name); Console.WriteLine(course.Description); } break; case "3": var materials = data.Materials.All(); foreach (var material in materials) { Console.WriteLine(material.Content + " " + material.Course.Name); } break; case "4": var homeworks = data.Homeworks.All(); foreach (var homework in homeworks) { Console.WriteLine(homework.Content + " " + homework.TimeSent); } break; case "exit": Console.WriteLine("Goodbye"); return; default: Console.WriteLine("Unknown comand"); break; } } }
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()); }
static void Main(string[] args) { // this can be set in StudentSystemDbContext.cs //Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentSystemDbContext, Configuration>()); // OR //Database.SetInitializer(new DropCreateDatabaseAlways<StudentSystemDbContext>()); //var db = new StudentSystemDbContext(); //var studentsDB = new GenericRepository<Student>(db); var data = new StudentSystemData(); foreach (var student in data.Students.All()) { Console.WriteLine(student.FirstName); } data.Students.Add(new Student { FirstName = "Goshko", LastName = "Peshkov" }); data.Students.SaveChanges(); //db.Database.Initialize(true); //var student = new Student //{ // FirstName = "Boyan", // LastName = "Ivanov", // Age = 32, // ContactInfo = new StudentContactInfo // { // Email = "*****@*****.**" // }, // StudentStatus = StudentStatus.Online //}; //student.Courses.Add(new Course //{ // Name = "Entity Framework", // Description = "Entity Framework for Dumies" //}); //db.Students.Add(student); //db.SaveChanges(); //var savedStudent = db.Students.First(); //Console.WriteLine(savedStudent.FirstName + " " + savedStudent.LastName + " Age: " + savedStudent.Age + " Status: " + savedStudent.StudentStatus); }
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()); }
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"); }
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 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 List <IGrouping <int, PdfRow> > GetSalesByDate() { StudentSystemData db = new StudentSystemData(); List <IGrouping <int, PdfRow> > collection; collection = db.Students.All().Select(x => new PdfRow { FirstName = x.FirstName, LastName = x.LastName, Age = x.Age, Number = x.Number }) .GroupBy(x => x.Age) .ToList(); return(collection); }
public static void Main() { var data = new StudentSystemData(); IQueryable<Course> courses = data.Courses.All(); foreach (var course in courses) { Console.WriteLine(course.Name); } data.Courses.Add(new Course { Name = "Repo Pattern", Description = "Cool" }); data.SaveChanges(); }
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 void Main() { var data = new StudentSystemData(); var hw = new Homework { FileName = "Domestic rakia", Deadline = new DateTime(2014, 08, 31), TimeSent = new DateTime(2014, 08, 29) }; var student = new Student { FirstName = "Pesho", LastName = "Piandeto", PhoneNumber = "082569875", Homeworks = new List <Homework> { hw } }; data.Homeworks.Add(hw); data.Students.Add(student); data.Courses.Add(new Course { Name = "Kukuruz seller", Description = "Corn, corn, corn", Students = new List <Student> { student } }); data.SaveChanges(); }
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()); }
public HomeController() { this.data = new StudentSystemData(); }
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 students = data.Students.All(); var count = 1; foreach (var student in students) { student.FirstName += count.ToString(); count++; } data.SaveChanges(); var updatedStudents = data.Students.All(); foreach (var student in updatedStudents) { data.Students.Delete(student); } var selectedStudents = data.Students .All() .Where(st => st.FirstName.Contains("Ivaylo")) .Select(st => new { FirstName = st.FirstName, LastName = st.LastName }) .ToList(); Console.WriteLine(selectedStudents.Count()); data.SaveChanges(); Console.WriteLine(data.Students.All().Count()); var course = new Course { Name = "Pesho's course", Description = "The best course in the world" }; data.Courses.Add(course); data.SaveChanges(); var someStudent = new Student { FirstName = "Peshlqka", LastName = "Goshlqka", Information = new StudentInfo { Email = "*****@*****.**" }, StudentNumber = 12345 }; data.Students.Add(someStudent); data.SaveChanges(); someStudent.Courses.Add(course); var homework = new Homework { FileUrl = "pesho.com/pesho.zip", Course = course, TimeSent = DateTime.Now }; someStudent.Homeworks.Add(homework); data.SaveChanges(); var studentFromDB = data.Students.All().FirstOrDefault(); Console.WriteLine(studentFromDB.Homeworks.FirstOrDefault().FileUrl); }
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); } }