public StudentV2BaseModel CreateV2Summary(Student student) { return new StudentV2BaseModel() { Url = _UrlHelper.Link("Students", new { userName = student.UserName }), Id = student.Id, FullName = string.Format("{0} {1}", student.FirstName, student.LastName), Gender = student.Gender, EnrollmentsCount = student.Enrollments.Count(), CoursesDuration = Math.Round(student.Enrollments.Sum(c => c.Course.Duration)) }; }
public StudentBaseModel CreateSummary(Student student) { return new StudentBaseModel() { Url = _UrlHelper.Link("Students", new { userName = student.UserName }), Id = student.Id, FirstName = student.FirstName, LastName = student.LastName, Gender = student.Gender, EnrollmentsCount = student.Enrollments.Count(), }; }
public StudentModel Create(Student student) { return new StudentModel() { Url = _UrlHelper.Link("Students", new { userName = student.UserName }), Id = student.Id, Email = student.Email, UserName = student.UserName, FirstName = student.FirstName, LastName = student.LastName, Gender = student.Gender, DateOfBirth = student.DateOfBirth, RegistrationDate = student.RegistrationDate.Value, EnrollmentsCount = student.Enrollments.Count(), Enrollments = student.Enrollments.Select(e => Create(e)) }; }
public Enrollment() { Student = new Student(); Course = new Course(); }
public void Seed() { if (_ctx.Courses.Count() > 0) { return; } try { foreach (var subjectName in subjects) { var subject = new Subject { Name = subjectName }; _ctx.Subjects.Add(subject); _ctx.SaveChanges(); } for (int i = 0; i < tutorNames.Length; i++) { var nameGenderMail = SplitValue(tutorNames[i]); var tutor = new Tutor { Email = String.Format("{0}.{1}@{2}", nameGenderMail[0], nameGenderMail[1], nameGenderMail[3]), UserName = String.Format("{0}{1}", nameGenderMail[0], nameGenderMail[1]), Password = RandomString(8), FirstName = nameGenderMail[0], LastName = nameGenderMail[1], Gender = ((Enums.Gender)Enum.Parse(typeof(Enums.Gender), nameGenderMail[2])) }; _ctx.Tutors.Add(tutor); var courseSubject = _ctx.Subjects.Where(s => s.Id == i + 1).Single(); foreach (var CourseDataItem in CoursesSeedData.Where(c => c.SubjectID == courseSubject.Id)) { var course = new Course { Name = CourseDataItem.CourseName, CourseSubject = courseSubject, CourseTutor = tutor, Duration = new Random().Next(3, 6), Description = String.Format("The course will talk in depth about: {0}", CourseDataItem.CourseName) }; _ctx.Courses.Add(course); } } _ctx.SaveChanges(); for (int i = 0; i < studentNames.Length; i++) { var nameGenderMail = SplitValue(studentNames[i]); var student = new Student() { Email = String.Format("{0}.{1}@{2}", nameGenderMail[0], nameGenderMail[1], nameGenderMail[3]), UserName = String.Format("{0}{1}", nameGenderMail[0], nameGenderMail[1]), Password = RandomString(8), FirstName = nameGenderMail[0], LastName = nameGenderMail[1], Gender = ((Enums.Gender)Enum.Parse(typeof(Enums.Gender), nameGenderMail[2])), DateOfBirth = DateTime.UtcNow.AddDays(-new Random().Next(7000, 8000)), RegistrationDate = DateTime.UtcNow.AddDays(-new Random().Next(365, 730)) }; _ctx.Students.Add(student); int maxCoursesId = _ctx.Courses.Max(c => c.Id); //To enroll in 4 courses randomly for (int z = 0; z < 4; z++) { int randomCourseId = new Random().Next(1, maxCoursesId); var enrollment = new Enrollment { Student = student, Course = _ctx.Courses.Where(c => c.Id == randomCourseId).Single(), EnrollmentDate = DateTime.UtcNow.AddDays(-new Random().Next(10, 30)) }; _ctx.Enrollments.Add(enrollment); } } _ctx.SaveChanges(); } catch (Exception ex) { string message = ex.ToString(); throw ex; } }
public bool Update(Student originalStudent, Student updatedStudent) { _ctx.Entry(originalStudent).CurrentValues.SetValues(updatedStudent); return true; }
public bool Insert(Student student) { try { _ctx.Students.Add(student); return true; } catch { return false; } }
public StudentModel Create(Student student) { StudentModel studentModel = Mapper.Map<StudentModel>(student); studentModel.Url = _UrlHelper.Link("Students", new { userName = student.UserName }); return studentModel; //return new StudentModel() //{ // Url = _UrlHelper.Link("Students", new { userName = student.UserName }), // Id = student.Id, // Email = student.Email, // UserName = student.UserName, // FirstName = student.FirstName, // LastName = student.LastName, // Gender = student.Gender, // DateOfBirth = student.DateOfBirth, // RegistrationDate = student.RegistrationDate.Value, // EnrollmentsCount = student.Enrollments.Count(), // Enrollments = student.Enrollments.Select(e => Create(e)) //}; }
public StudentV2BaseModel CreateV2Summary(Student student) { StudentV2BaseModel studentV2BaseModel = Mapper.Map<StudentV2BaseModel>(student); studentV2BaseModel.Url = _UrlHelper.Link("Students", new { userName = student.UserName }); return studentV2BaseModel; //return new StudentV2BaseModel() //{ // Url = _UrlHelper.Link("Students", new { userName = student.UserName }), // Id = student.Id, // FullName = string.Format("{0} {1}", student.FirstName, student.LastName), // Gender = student.Gender, // EnrollmentsCount = student.Enrollments.Count(), // CoursesDuration = Math.Round(student.Enrollments.Sum(c => c.Course.Duration)) //}; }
public StudentBaseModel CreateSummary(Student student) { StudentBaseModel studentBase = Mapper.Map<Student, StudentBaseModel>(student); studentBase.Url = _UrlHelper.Link("Students", new { userName = student.UserName }); return studentBase; //return new StudentBaseModel() //{ // Url = // Id = student.Id, // FirstName = student.FirstName, // LastName = student.LastName, // Gender = student.Gender, // EnrollmentsCount = student.Enrollments.Count(), //}; }