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(),
//};
}
