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);
}
