private static void LoadCoursesToDb()
{
using var context = new RateMyPDbContext();
var courses = ParseEntitiesFromCsv <Course>("courses.csv");
context.Courses.AddRange(courses);
context.SaveChanges();
}
private static void LoadTeacherActivitiesToDb()
{
using var context = new RateMyPDbContext();
var teacherActivities = ParseEntitiesFromCsv <TeacherActivity>("teacher_activities.csv");
context.TeacherActivities.AddRange(teacherActivities);
context.SaveChanges();
}
public void SetUp()
{
var options = new DbContextOptionsBuilder <RateMyPDbContext>()
.UseInMemoryDatabase(GetType().Name)
.Options;
Context = new RateMyPDbContext(options);
}
public StudentsController(RateMyPDbContext context)
{
m_context = context;
}
private void Seed(RateMyPDbContext context)
{
m_teacherSingleRating = new Teacher
{
Id = Guid.NewGuid(),
FirstName = "AAA",
LastName = "aaa",
Description = "a desc",
Rank = "Professor",
Faculty = "MIF"
};
m_teacherMultipleRatings = new Teacher
{
Id = Guid.NewGuid(),
FirstName = "BBB",
LastName = "bbb",
Description = "b desc",
Rank = "Professor",
Faculty = "MIF"
};
context.Teachers.AddRange(m_teacherSingleRating, m_teacherMultipleRatings);
var course = new Course
{
Id = Guid.NewGuid(),
Name = "Taikomasis objektinis programavimas",
CourseType = CourseType.Compulsory,
Credits = 5,
Faculty = "MIF"
};
context.Courses.Add(course);
var ratings = new[]
{
new Rating
{
Id = Guid.NewGuid(),
TeacherId = m_teacherSingleRating.Id,
CourseId = course.Id,
OverallMark = 4,
LevelOfDifficulty = 2,
WouldTakeTeacherAgain = true,
Tags = new List <RatingTag>(),
DateCreated = new DateTime(2010, 01, 02),
Comment = "Cool guy"
},
new Rating
{
Id = Guid.NewGuid(),
TeacherId = m_teacherMultipleRatings.Id,
CourseId = course.Id,
OverallMark = 10,
LevelOfDifficulty = 2,
WouldTakeTeacherAgain = true,
Tags = new List <RatingTag>(),
DateCreated = new DateTime(2019, 01, 02),
Comment = "Cool guy"
},
new Rating
{
Id = Guid.NewGuid(),
TeacherId = m_teacherMultipleRatings.Id,
CourseId = course.Id,
OverallMark = 9,
LevelOfDifficulty = 10,
WouldTakeTeacherAgain = true,
Tags = new List <RatingTag>(),
DateCreated = new DateTime(2019, 03, 21),
Comment = "Cool guy"
},
new Rating
{
Id = Guid.NewGuid(),
TeacherId = m_teacherMultipleRatings.Id,
CourseId = course.Id,
OverallMark = 2,
LevelOfDifficulty = 6,
WouldTakeTeacherAgain = false,
Tags = new List <RatingTag>(),
DateCreated = new DateTime(2019, 02, 11),
Comment = "Cool guy"
},
new Rating
{
Id = Guid.NewGuid(),
TeacherId = m_teacherMultipleRatings.Id,
CourseId = course.Id,
OverallMark = 4,
LevelOfDifficulty = 8,
WouldTakeTeacherAgain = true,
Tags = new List <RatingTag>(),
DateCreated = new DateTime(2019, 01, 01),
Comment = "Cool guy"
}
};
context.Ratings.AddRange(ratings);
context.SaveChanges();
}
public CoursesController(RateMyPDbContext context)
{
m_context = context;
}
public MerchandisesController(RateMyPDbContext context)
{
m_context = context;
}
public DbDataLoader(RateMyPDbContext context)
{
m_context = context;
}
public TeachersController(RateMyPDbContext context)
{
m_context = context;
}
private void Seed(RateMyPDbContext context)
{
m_course1 = new Course
{
Id = Guid.NewGuid(),
Name = "Komparchas",
Credits = 5,
Faculty = "MIF",
CourseType = CourseType.BUS
};
m_course2 = new Course
{
Id = Guid.NewGuid(),
Name = "Duomenu strukturos",
Credits = 10,
Faculty = "MIF",
CourseType = CourseType.Complimentary
};
var course3 = new Course
{
Id = Guid.NewGuid(),
Name = "malkos",
Credits = 6,
Faculty = "Zap",
CourseType = CourseType.BUS
};
context.Courses.AddRange(m_course1, m_course2, course3);
m_teacher = new Teacher
{
Id = Guid.NewGuid(),
FirstName = "AAA",
LastName = "aaa",
Description = "a desc",
Rank = "Professor",
Faculty = "MIF"
};
var teacherSingleCourse = new Teacher
{
Id = Guid.NewGuid(),
FirstName = "BBB",
LastName = "bbb",
Description = "b desc",
Rank = "Professor",
Faculty = "MIF"
};
context.Teachers.AddRange(m_teacher, teacherSingleCourse);
var teacherActivity1 = new TeacherActivity
{
Id = Guid.NewGuid(),
TeacherId = m_teacher.Id,
CourseId = m_course1.Id,
DateStarted = DateTime.Now,
LectureType = LectureType.Practice
};
var teacherActivity2 = new TeacherActivity
{
Id = Guid.NewGuid(),
TeacherId = m_teacher.Id,
CourseId = m_course2.Id,
DateStarted = DateTime.Now,
LectureType = LectureType.Practice
};
var teacherSingleCourseActivity = new TeacherActivity
{
Id = Guid.NewGuid(),
TeacherId = teacherSingleCourse.Id,
CourseId = course3.Id,
DateStarted = DateTime.Now,
LectureType = LectureType.Seminar
};
context.TeacherActivities.AddRange(teacherActivity1, teacherActivity2, teacherSingleCourseActivity);
context.SaveChanges();
}
public RatingsController(RateMyPDbContext context, ILeaderboardManager leaderboardManager)
{
m_context = context;
m_leaderboardManager = leaderboardManager;
}
public ReportsController(RateMyPDbContext context)
{
m_context = context;
}
public CourseStatisticsAnalyzer(RateMyPDbContext context)
{
m_context = context;
}
