public ComfortDevUnitOfWork(ComfortDevContext db)
{
this.db = db;
CourseTasks = new CourseTaskRepository(db);
Tasks = new TaskRepository(db);
TestAnswers = new TestAnswerRepository(db);
TestQuestions = new TestQuestionRepository(db);
Topics = new TopicRepository(db);
Users = new UserRepository(db);
UserCourses = new UserCourseRepository(db);
}
public UnitOfWork(MemoContext context)
{
this.dbContext = new MemoContext();
Answers = new AnswerRepository(dbContext);
Cards = new CardRepository(dbContext);
CardTypes = new CardTypeRepository(dbContext);
Categories = new CategoryRepository(dbContext);
Comments = new CommentRepository(dbContext);
Course = new CourseRepository(dbContext);
DeckCourses = new DeckCourseRepository(dbContext);
Decks = new DeckRepository(dbContext);
Reports = new ReportRepository(dbContext);
Roles = new RoleRepository(dbContext);
Statistics = new StatisticRepository(dbContext);
UserCourses = new UserCourseRepository(dbContext);
Users = new UserRepository(dbContext);
UserRoles = new UserRoleRepository(dbContext);
}
public void FixBundleCourseAccessProblem(out string emails)
{
emails = string.Empty;
var from = DateTime.Now.AddDays(-3);
var bundlePurchases = OrderLinesViewRepository.GetMany(x => x.BundleId != null && x.OrderDate > from).OrderByDescending(x => x.OrderDate).ToList();
foreach (var orderLine in bundlePurchases)
{
var line = orderLine;
var bundleCourses = BundleCourseRepository.Count(x => x.BundleId == line.BundleId);
var userCourses = UserCourseRepository.Count(x => x.UserId == line.BuyerUserId && x.OrderLineId == line.LineId);
if (bundleCourses == userCourses)
{
continue;
}
string error;
AttachCourseOrBundle2User(line.BuyerUserId, line.LineId, null, line.BundleId, null, out error);
emails += String.Format("{0}-{1}-{2}-{3}-{4},", line.BuyerEmail, line.SellerFirstName + " " + line.SellerLastName, line.OrderDate, bundleCourses, userCourses);
}
}
public UserCourseController()
{
_repo = new UserCourseRepository();
}
