public QuestController(LazyDbContext context) { _context = context; //if (_context.QuestItems.Count() == 0) //{ // var users = new List<QuestViewModel> // { // new QuestViewModel { QuestID = Guid.NewGuid().ToString(), OwnerID = "1001", Type = "Daily" , Text = "Attend all Lectures", Accepted = true, Progress = 1, EndPoint = 3, EndDate = DateTime.Today.AddDays(30), Completed = false}, // new QuestViewModel { QuestID = Guid.NewGuid().ToString(), OwnerID = "1001", Type = "Quest", Text = "Complete Assignment 1", Accepted = true, Progress = 326, EndPoint = 1000, EndDate = DateTime.Now.AddHours(2), Completed = false}, // new QuestViewModel { QuestID = Guid.NewGuid().ToString(), OwnerID = "1001", Type = "Quest", Text = "Write 1000 Word Essay", Accepted = false, Progress = 0, EndPoint = 1000, EndDate = DateTime.Today.AddDays(7), Completed = false}, // new QuestViewModel { QuestID = Guid.NewGuid().ToString(), OwnerID = "1001", Type = "Quest", Text = "Select a Dissertation Topic", Accepted = true, Progress = 1, EndPoint = 1, EndDate = DateTime.Today.AddDays(2), Completed = true} // }; // _context.AddRange(users); //} }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { var connectionStringBuilder = new SqliteConnectionStringBuilder { DataSource = ":memory:" }; var connectionString = connectionStringBuilder.ToString(); var connection = new SqliteConnection(connectionString); DbContextOptions <LazyDbContext> options; var builder = new DbContextOptionsBuilder <LazyDbContext>(); builder.UseSqlite(connection); options = builder.Options; var context = new LazyDbContext(options); context.Database.OpenConnection(); context.Database.EnsureCreated(); services.AddDbContext <LazyDbContext>(opt => opt.UseSqlite(connection)); services.AddMvc(); }
public AchievementController(LazyDbContext context) { _context = context; }
public RewardController(LazyDbContext context) { _context = context; }
public UserController(LazyDbContext context) { _context = context; string id = ""; if (_context.UserItems.Count() == 0) { var users = new List <UserViewModel> { new UserViewModel { ID = "1000", Password = "******", Username = "******" }, new UserViewModel { ID = "1001", Password = "******", Username = "******" }, new UserViewModel { ID = "1002", Password = "******", Username = "******" }, new UserViewModel { ID = "1003", Password = "", Username = "******" } }; id = users[0].ID; _context.AddRange(users); } if (_context.QuestItems.Count() == 0) { var quests = new List <QuestViewModel> { new QuestViewModel { QuestID = Guid.NewGuid().ToString(), OwnerID = id, Type = "Daily", Text = "Attend all Lectures", Accepted = true, Progress = 1, EndPoint = 3, EndDate = DateTime.Today.AddDays(30), Completed = false }, new QuestViewModel { QuestID = Guid.NewGuid().ToString(), OwnerID = id, Type = "Quest", Text = "Complete Assignment 1", Accepted = true, Progress = 326, EndPoint = 1000, EndDate = DateTime.Now.AddHours(2), Completed = false }, new QuestViewModel { QuestID = Guid.NewGuid().ToString(), OwnerID = id, Type = "Quest", Text = "Write 1000 Word Essay", Accepted = false, Progress = 0, EndPoint = 1000, EndDate = DateTime.Today.AddDays(7), Completed = false }, new QuestViewModel { QuestID = Guid.NewGuid().ToString(), OwnerID = id, Type = "Quest", Text = "Select a Dissertation Topic", Accepted = true, Progress = 1, EndPoint = 1, EndDate = DateTime.Today.AddDays(2), Completed = true } }; _context.AddRange(quests); } if (_context.AchievementItems.Count() == 0) { var achievements = new List <AchievementViewModel> { new AchievementViewModel { AchievementID = Guid.NewGuid().ToString(), OwnerID = id, Description = "Attend all lectures in a week", Completed = true, Current = 5, Goal = 5, AssociatedQuests = "Quest", PointsReward = 500 }, new AchievementViewModel { AchievementID = Guid.NewGuid().ToString(), OwnerID = id, Description = "Complete 5 Assignments", Completed = false, Current = 4, Goal = 5, AssociatedQuests = "Quest", PointsReward = 500 }, new AchievementViewModel { AchievementID = Guid.NewGuid().ToString(), OwnerID = id, Description = "Complete 10 Quests", Completed = false, Current = 8, Goal = 10, AssociatedQuests = "Quest", PointsReward = 500 }, new AchievementViewModel { AchievementID = Guid.NewGuid().ToString(), OwnerID = id, Description = "Complete 3 Daily Quests", Completed = false, Current = 1, Goal = 3, AssociatedQuests = "Daily", PointsReward = 500 } }; _context.AddRange(achievements); } _context.SaveChanges(); }