public static void Import(SchoolDatabaseContext db, int count) { var generator = RandomGenerator.Instance; var studentsIDs = db.Students.Select(s => s.Id).OrderBy(s => Guid.NewGuid()).ToList(); for (int i = 0; i < count; i++) { var course = new Course() { Name = generator.GetRandomString(5, 20), Description = generator.GetRandomString(50, 200), Materials = generator.GetRandomString(10, 100), }; var studentsInCourse = generator.GetRandomNumber(20, 30); for (int j = 0; j < studentsInCourse; j++) { var studentID = studentsIDs[generator.GetRandomNumber(0, studentsIDs.Count - 1)]; course.Students.Add(db.Students.Where(s => s.Id == studentID).First()); } db.Courses.Add(course); } db.SaveChanges(); Console.WriteLine("{0} Courses imported", count); }
public static void Import(SchoolDatabaseContext db, int count) { var generator = RandomGenerator.Instance; var coursesIDs = db.Courses.Select(c => c.Id).OrderBy(c => Guid.NewGuid()).ToList(); for (int i = 0; i < count; i++) { var courseID = coursesIDs[generator.GetRandomNumber(0, coursesIDs.Count - 1)]; var course = db.Courses .Where(c => c.Id == courseID) .First(); var studentsIDsFromCourse = course.Students.Select(s => s.Id).ToList(); var studentID = studentsIDsFromCourse[generator.GetRandomNumber(0, studentsIDsFromCourse.Count - 1)]; db.Homeworks.Add(new Homework() { Content = generator.GetRandomString(100, 300), TimeSent = generator.GetRandomDate(DateTime.Now.AddDays(-100), DateTime.Now), StudentId = studentID, CourseId = courseID }); } db.SaveChanges(); Console.WriteLine("{0} Homeworks imported", count); }
public static void Import(SchoolDatabaseContext db, int count) { var generator = RandomGenerator.Instance; for (int i = 0; i < count; i++) { db.Students.Add(new Student() { Name = generator.GetRandomString(5, 20), Number = generator.GetRandomNumber(10000, 99999), }); } db.SaveChanges(); Console.WriteLine("{0} Students imported", count); }
public IHttpActionResult GetAllStudents() { IList <StudentViewModel> students = null; using (var ctx = new SchoolDatabaseContext()) { students = ctx.Students .Select(s => new StudentViewModel() { Id = s.StudentID, FirstName = s.FirstName, LastName = s.LastName }).ToList <StudentViewModel>(); } if (students.Count == 0) { return(NotFound()); } return(Ok(students)); }
static void Main(string[] args) { Console.WriteLine("Importing data... Be patient, it will take 5-10 seconds"); using (var db = new SchoolDatabaseContext()) { StudentsImporter.Import(db, 300); CoursesImporter.Import(db, 7); HomeworksImporter.Import(db, 1200); } using (var db = new SchoolDatabaseContext()) { var course = db.Courses.Where(c => c.Id == 2).First(); var homeworks = course.Homeworks.Where(h => h.TimeSent > DateTime.Now.AddDays(-7)); Console.WriteLine("Homeworks from course with ID 2 that have been sent in the last week:"); foreach (var homework in homeworks) { Console.WriteLine("Content: {0}", homework.Content); Console.WriteLine("Send by: {0}", homework.Student.Name); } } }
public static void Main() { //Be patient it is not fast, it will take 5-10 seconds :) using (var db = new SchoolDatabaseContext()) { StudentsImporter.Import(db, 300); CoursesImporter.Import(db, 7); HomeworksImporter.Import(db, 1200); } using (var db = new SchoolDatabaseContext()) { var course = db.Courses.Where(c => c.Id == 2).First(); var homeworks = course.Homeworks.Where(h => h.TimeSent > DateTime.Now.AddDays(-7)); Console.WriteLine("Homeworks from course 2 that have been sent in the last week:"); foreach (var homework in homeworks) { Console.WriteLine("Content: {0}", homework.Content); Console.WriteLine("Send by: {0}", homework.Student.Name); } } }
public StudentsController(SchoolDatabaseContext context) { _context = context; }
public ProfesorsController(SchoolDatabaseContext context) { _context = context; }
public TeacherRepository(SchoolDatabaseContext ctx) { context = ctx; }
public TeachersController(SchoolDatabaseContext context) { _context = context; }