private static async Task SeedEvents(VoteDbContext db, IMapper mapper, UserManager <User> userManager, string basePath) { string fullPath = Path.Combine(basePath, VoteConstants.JsonEvents); var jsonEvents = File.ReadAllText(fullPath); var eventDtos = JsonConvert.DeserializeObject <EventDto[]>(jsonEvents); var user1Id = (await userManager.FindByNameAsync("pesho")).Id; var user2Id = (await userManager.FindByNameAsync("gosho")).Id; for (int i = 0; i < eventDtos.Length / 2; i++) { eventDtos[i].CreatorId = user1Id; } for (int i = eventDtos.Length / 2; i < eventDtos.Length; i++) { eventDtos[i].CreatorId = user2Id; } var eventsData = mapper.Map <List <Event> >(eventDtos); db.Events.AddRange(eventsData); db.SaveChanges(); }
protected BaseManagerService(VoteDbContext db, IMapper mapper) { this.db = db; this.mapper = mapper; this.random = new Random(); }
public ProfileViewComponent( SignInManager <ApplicationUser> singInManager, UserManager <ApplicationUser> userManager, VoteDbContext context ) { _singInManager = singInManager; _userManager = userManager; _context = context; }
public static VoteDbContext GetEmptyTestDb() { var options = new DbContextOptionsBuilder <VoteDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()) .EnableSensitiveDataLogging() .Options; var db = new VoteDbContext(options); return(db); }
public AccountController( UserManager <ApplicationUser> userManager, SignInManager <ApplicationUser> signInManager, VoteDbContext context, IVotingService votingService ) { _userManager = userManager; _signInManager = signInManager; _context = context; _votingService = votingService; }
private static void SeedReplies(VoteDbContext db, IMapper mapper, string basePath) { string fullPath = Path.Combine(basePath, VoteConstants.JsonReplies); var jsonReplies = File.ReadAllText(fullPath); var repliesDtos = JsonConvert.DeserializeObject <ReplyDto[]>(jsonReplies); var repliesData = mapper.Map <List <Reply> >(repliesDtos); db.Replies.AddRange(repliesData); db.SaveChanges(); }
private static void SeedQuestions(VoteDbContext db, IMapper mapper, string basePath) { string fullPath = Path.Combine(basePath, VoteConstants.JsonQuestions); var jsonQuestions = File.ReadAllText(fullPath); var questionDtos = JsonConvert.DeserializeObject <QuestionDto[]>(jsonQuestions); var questionsData = mapper.Map <List <Question> >(questionDtos); db.Questions.AddRange(questionsData); db.SaveChanges(); }
public void InitializeTests() { this.mapper = MockAutoMapper.GetAutoMapper(); this.db = MockDbContext.GetTestDb(); this.service = new ParticipantRepliesService(this.db, this.mapper); var testQuestion = new Question() { Id = 1, Content = "First test", EventId = 1 }; db.Questions.Add(testQuestion); db.SaveChanges(); }
public void InitializeTests() { this.db = MockDbContext.GetTestDb(); var question = new Question() { Id = 1, AuthorName = "Pesho", EventId = 1 }; this.db.Questions.Add(question); this.db.SaveChanges(); this.service = new ManagerQuestionsService(this.db, null); }
public static async Task LoadData(bool resetDb = false, bool reloadFiles = false) { DownloadFiles(reloadFiles); using (var dbContext = new VoteDbContext()) { if (resetDb) { await dbContext.Database.EnsureDeletedAsync(); } await dbContext.Database.EnsureCreatedAsync(); Console.WriteLine("Loading data"); foreach (var filePath in Directory.GetFiles($"{AppDomain.CurrentDomain.BaseDirectory}\\nyt-data")) { var state = filePath.Substring(filePath.LastIndexOf('\\') + 1).Replace(".json", string.Empty); state = state[0].ToString().ToUpper() + state.Substring(1); if (!await dbContext.States.AnyAsync(s => s.StateName == state)) { dbContext.States.Add(State.Create(state, Swingers.Contains(state), DateTime.UtcNow)); } if (!await dbContext.Votes.AnyAsync(s => s.StateName == state)) { Console.WriteLine($" Loading {state}..."); var votes = JObject.Parse(await File.ReadAllTextAsync(filePath)); var timeseries = votes?["data"]?["races"]?.FirstOrDefault()?["timeseries"]; if (timeseries == null) { Console.WriteLine($"WARNING: {state} voting data is null!"); continue; } var typedSeries = timeseries.Select(s => (VoteTimeSeries)s.ToObject(typeof(VoteTimeSeries))).OrderBy(s => s.Timestamp).ToArray(); Console.WriteLine($" There are {typedSeries.Length} items for {state}"); typedSeries = typedSeries.Select((ts, i) => i > 0 ? ts.SetPrevious(typedSeries[i - 1]) : ts).ToArray(); foreach (var ts in typedSeries) { dbContext.Votes.Add(Vote.Create(state, ts)); } } await dbContext.SaveChangesAsync(); } } }
public static VoteDbContext GetTestDb() { var options = new DbContextOptionsBuilder <VoteDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()) .Options; var db = new VoteDbContext(options); var activities = new List <Event>() { new Event() { Id = 1, Code = "001", Title = "First", CreatorId = "ABC", StartDate = DateTime.Now, EndDate = DateTime.Now.AddDays(3) }, new Event() { Id = 2, Code = "002", Title = "Second", CreatorId = "ABC", StartDate = DateTime.Now, EndDate = DateTime.Now.AddDays(3) }, new Event() { Id = 3, Code = "003", Title = "Third", CreatorId = "ABC", StartDate = DateTime.Now, EndDate = DateTime.Now.AddDays(3) } }; db.AddRange(activities); db.SaveChanges(); return(db); }
private static async Task SeedUsers(VoteDbContext db, UserManager <User> userManager) { var user = new User() { UserName = "******", Email = "*****@*****.**", EmailConfirmed = true }; var user2 = new User() { UserName = "******", Email = "*****@*****.**", EmailConfirmed = true }; await userManager.CreateAsync(user, "pass"); await userManager.CreateAsync(user2, "pass"); await userManager.AddToRoleAsync(user, RoleType.Manager); await userManager.AddToRoleAsync(user2, RoleType.Manager); }
public void InitializeTests() { this.db = MockDbContext.GetTestDb(); this.mapper = MockAutoMapper.GetAutoMapper(); var question = new Question() { Id = 1, AuthorName = "Pesho", EventId = 1, IsArchived = true }; this.db.Questions.Add(question); this.db.SaveChanges(); this.service = new ManagerQuestionsService(this.db, this.mapper); }
public BaseParticipantController(VoteDbContext db, UserManager <User> userManager) { this.db = db; this.userManager = userManager; }
public VotingService(VoteDbContext context, INextDuoService nextDuoService) { _context = context; _nextDuoService = nextDuoService; }
public void InitializeTests() { this.mapper = MockAutoMapper.GetAutoMapper(); this.db = MockDbContext.GetTestDb(); this.service = new ManagerPollsService(this.db, this.mapper); var testPollQuestion = new PollQuestion() { Id = 1, Content = "Are you ready?" }; var testPollAnswers = new List <PollAnswer>() { new PollAnswer() { Id = 1, Content = "Yes" }, new PollAnswer() { Id = 2, Content = "No" } }; var testPoll = new Poll() { Id = 99, EventId = 1, PollQuestion = testPollQuestion, PollAnswers = testPollAnswers, IsDeleted = false, IsActive = false }; var testPollQuestion2 = new PollQuestion() { Id = 2, Content = "Are you ready again?" }; var testPollAnswers2 = new List <PollAnswer>() { new PollAnswer() { Id = 3, Content = "Yes" }, new PollAnswer() { Id = 4, Content = "No" } }; var testPoll2 = new Poll() { Id = 100, EventId = 1, PollQuestion = testPollQuestion2, PollAnswers = testPollAnswers2, IsDeleted = false, IsActive = false }; db.Polls.AddRange(testPoll, testPoll2); db.SaveChanges(); }
public VoteCountController(VoteDbContext context) { _context = context; }
public void InitializeTests() { this.db = MockDbContext.GetTestDb(); this.mapper = MockAutoMapper.GetAutoMapper(); this.service = new ManagerSettingsService(this.db, this.mapper); }
public ParticipantRepliesService(VoteDbContext db, IMapper mapper) : base(db, mapper) { }
public ManagerPollsService(VoteDbContext db, IMapper mapper) : base(db, mapper) { }
public ManagerQuestionsService(VoteDbContext db, IMapper mapper) : base(db, mapper) { }
public ActivitiesController(VoteDbContext db, UserManager <User> userManager, IMapper mapper) : base(db, userManager, mapper) { }
public DummyController(VoteDbContext ctx) { this._ctx = ctx; }
public VotesRepository(VoteDbContext context) { this._context = context; }
public void InitializeTests() { this.db = MockDbContext.GetTestDb(); this.service = new ManagerSettingsService(this.db, null); }
public RecentVotesController(VoteDbContext context) { _context = context; }
public void InitializeTests() { this.emptyDb = MockDbContext.GetEmptyTestDb(); this.service = new ManagerActivitiesService(this.emptyDb, null); }
public BaseParticipantService(VoteDbContext db, IMapper mapper) { this.db = db; this.mapper = mapper; }
public VoteRepository(VoteDbContext dbContext) : base(dbContext) { }
public void InitializeTests() { this.mapper = MockAutoMapper.GetAutoMapper(); this.emptyDb = MockDbContext.GetEmptyTestDb(); this.service = new ManagerActivitiesService(this.emptyDb, this.mapper); }