public virtual List <QuestionViewModel> GetQuestions(int difficulty)
{
if (difficulty != 1 && difficulty != 2 && difficulty != 3)
{
return(new List <QuestionViewModel>());
}
var allCapitalsOfSameDifficulty = _context.WorldCapitals.Where(c => c.Difficulty == difficulty);
WorldCapital[] quizQuestions = new WorldCapital[12];
for (var i = 0; i < 12; i++)
{
var randomQuestion = GetRandomQuestion(allCapitalsOfSameDifficulty, quizQuestions);
quizQuestions[i] = randomQuestion;
}
List <QuestionViewModel> quizQuestionsAsViewModel = CreateQuestionViewModel(quizQuestions);
return(quizQuestionsAsViewModel);
}
private List <string> GetRandomOtherOptions(WorldCapital worldCapital)
{
var allCapitalNames = _context.WorldCapitals.Select(c => c.CapitalName).ToList();
List <string> questionOptions = new List <string>();
for (var i = 0; i < 3; i++)
{
var rnd = new Random();
var option = allCapitalNames.Skip(rnd.Next(0, allCapitalNames.Count())).Take(1).FirstOrDefault();
questionOptions.Add(option);
}
questionOptions.Add(worldCapital.CapitalName);
var result = questionOptions.Distinct().Count() == questionOptions.Count();
if (result)
{
questionOptions.Remove(worldCapital.CapitalName);
return(questionOptions);
}
return(GetRandomOtherOptions(worldCapital));
}
public static void Seed(QuizContext context)
{
context.Database.EnsureCreated();
if (context.WorldCapitals.Any())
{
return;
}
var countries = new WorldCapital[]
{
new WorldCapital {
CountryName = "Afghanistan", CapitalName = "Kabul", Difficulty = 2
},
new WorldCapital {
CountryName = "Albania", CapitalName = "Tirana", Difficulty = 2
},
new WorldCapital {
CountryName = "Algeria", CapitalName = "Algiers", Difficulty = 2
},
new WorldCapital {
CountryName = "Andorra", CapitalName = "Andorra", Difficulty = 2
},
new WorldCapital {
CountryName = "Angola", CapitalName = "Luanda", Difficulty = 3
},
new WorldCapital {
CountryName = "Antigua And Barbuda", CapitalName = "Saint John\'s", Difficulty = 3
},
new WorldCapital {
CountryName = "Argentina", CapitalName = "Buenos Aires", Difficulty = 1
},
new WorldCapital {
CountryName = "Armenia", CapitalName = "Yerevan", Difficulty = 2
},
new WorldCapital {
CountryName = "Australia", CapitalName = "Canberra", Difficulty = 1
},
new WorldCapital {
CountryName = "Austria", CapitalName = "Vienna", Difficulty = 1
},
new WorldCapital {
CountryName = "Azerbaijan", CapitalName = "Baku", Difficulty = 3
},
new WorldCapital {
CountryName = "Bahamas", CapitalName = "Nassau", Difficulty = 3
},
new WorldCapital {
CountryName = "Bahrain", CapitalName = "Manama", Difficulty = 3
},
new WorldCapital {
CountryName = "Bangladesh", CapitalName = "Dhaka", Difficulty = 3
},
new WorldCapital {
CountryName = "Barbados", CapitalName = "Bridgetown", Difficulty = 3
},
new WorldCapital {
CountryName = "Belarus", CapitalName = "Minsk", Difficulty = 2
},
new WorldCapital {
CountryName = "Belgium", CapitalName = "Brussels", Difficulty = 1
},
new WorldCapital {
CountryName = "Belize", CapitalName = "Belmopan", Difficulty = 3
},
new WorldCapital {
CountryName = "Benin", CapitalName = "Porto-Novo", Difficulty = 3
},
new WorldCapital {
CountryName = "Bhutan", CapitalName = "Thimphu", Difficulty = 3
},
new WorldCapital {
CountryName = "Bolivia", CapitalName = "Sucre", Difficulty = 3
},
new WorldCapital {
CountryName = "Bosnia And Herzegovina", CapitalName = "Sarajevo", Difficulty = 2
},
new WorldCapital {
CountryName = "Botswana", CapitalName = "Gaborone", Difficulty = 3
},
new WorldCapital {
CountryName = "Brazil", CapitalName = "Brasilia", Difficulty = 1
},
new WorldCapital {
CountryName = "Brunei", CapitalName = "Bandar Seri Begawan", Difficulty = 3
},
new WorldCapital {
CountryName = "Bulgaria", CapitalName = "Sofia", Difficulty = 2
},
new WorldCapital {
CountryName = "Burkina Faso", CapitalName = "Ouagadougou", Difficulty = 3
},
new WorldCapital {
CountryName = "Burundi", CapitalName = "Bujumbura", Difficulty = 3
},
new WorldCapital {
CountryName = "Cabo Verde", CapitalName = "Praia", Difficulty = 3
},
new WorldCapital {
CountryName = "Cambodia", CapitalName = "Phnom Penh", Difficulty = 3
},
new WorldCapital {
CountryName = "Cameroon", CapitalName = "Yaounde", Difficulty = 3
},
new WorldCapital {
CountryName = "Canada", CapitalName = "Ottawa", Difficulty = 1
},
new WorldCapital {
CountryName = "Central African Republic", CapitalName = "Bangui", Difficulty = 3
},
new WorldCapital {
CountryName = "Chad", CapitalName = "Ndjamena", Difficulty = 3
},
new WorldCapital {
CountryName = "Chile", CapitalName = "Santiago", Difficulty = 2
},
new WorldCapital {
CountryName = "China", CapitalName = "Beijing", Difficulty = 1
},
new WorldCapital {
CountryName = "Colombia", CapitalName = "Bogota", Difficulty = 2
},
new WorldCapital {
CountryName = "Comoros", CapitalName = "Moroni", Difficulty = 3
},
new WorldCapital {
CountryName = "Republic of Congo", CapitalName = "Brazzaville", Difficulty = 3
},
new WorldCapital {
CountryName = "Democratic Republic of Congo", CapitalName = "Kinshasa", Difficulty = 3
},
new WorldCapital {
CountryName = "Costa Rica", CapitalName = "San Jose", Difficulty = 3
},
new WorldCapital {
CountryName = "Cote d\'Ivoire", CapitalName = "Yamoussoukro", Difficulty = 3
},
new WorldCapital {
CountryName = "Croatia", CapitalName = "Zagreb", Difficulty = 2
},
new WorldCapital {
CountryName = "Cuba", CapitalName = "Havana", Difficulty = 2
},
new WorldCapital {
CountryName = "Cyprus", CapitalName = "Nicosia", Difficulty = 3
},
new WorldCapital {
CountryName = "Czech Republic", CapitalName = "Prague", Difficulty = 1
},
new WorldCapital {
CountryName = "Denmark", CapitalName = "Copenhagen", Difficulty = 1
},
new WorldCapital {
CountryName = "Djibouti", CapitalName = "Djibouti", Difficulty = 3
},
new WorldCapital {
CountryName = "Dominica", CapitalName = "Roseau", Difficulty = 3
},
new WorldCapital {
CountryName = "Dominican Republic", CapitalName = "Santo Domingo", Difficulty = 3
},
new WorldCapital {
CountryName = "Ecuador", CapitalName = "Quito", Difficulty = 3
},
new WorldCapital {
CountryName = "Egypt", CapitalName = "Cairo", Difficulty = 1
},
new WorldCapital {
CountryName = "El Salvador", CapitalName = "San Salvador", Difficulty = 2
},
new WorldCapital {
CountryName = "Equatorial Guinea", CapitalName = "Malabo", Difficulty = 3
},
new WorldCapital {
CountryName = "Eritrea", CapitalName = "Asmara", Difficulty = 3
},
new WorldCapital {
CountryName = "Estonia", CapitalName = "Tallinn", Difficulty = 2
},
new WorldCapital {
CountryName = "Ethiopia", CapitalName = "Addis Ababa", Difficulty = 1
},
new WorldCapital {
CountryName = "Fiji", CapitalName = "Suva", Difficulty = 3
},
new WorldCapital {
CountryName = "Finland", CapitalName = "Helsinki", Difficulty = 1
},
new WorldCapital {
CountryName = "France", CapitalName = "Paris", Difficulty = 1
},
new WorldCapital {
CountryName = "Gabon", CapitalName = "Libreville", Difficulty = 3
},
new WorldCapital {
CountryName = "Gambia", CapitalName = "Banjul", Difficulty = 3
},
new WorldCapital {
CountryName = "Georgia", CapitalName = "Tbilisi", Difficulty = 2
},
new WorldCapital {
CountryName = "Germany", CapitalName = "Berlin", Difficulty = 1
},
new WorldCapital {
CountryName = "Ghana", CapitalName = "Accra", Difficulty = 3
},
new WorldCapital {
CountryName = "Greece", CapitalName = "Athens", Difficulty = 1
},
new WorldCapital {
CountryName = "Grenada", CapitalName = "Saint George\'s", Difficulty = 3
},
new WorldCapital {
CountryName = "Guatemala", CapitalName = "Guatemala City", Difficulty = 2
},
new WorldCapital {
CountryName = "Guinea", CapitalName = "Conakry", Difficulty = 3
},
new WorldCapital {
CountryName = "Guinea-Bissau", CapitalName = "Bissau", Difficulty = 3
},
new WorldCapital {
CountryName = "Guyana", CapitalName = "Georgetown", Difficulty = 3
},
new WorldCapital {
CountryName = "Haiti", CapitalName = "Port-au-Prince", Difficulty = 2
},
new WorldCapital {
CountryName = "Honduras", CapitalName = "Tegucigalpa", Difficulty = 3
},
new WorldCapital {
CountryName = "Hungary", CapitalName = "Budapest", Difficulty = 1
},
new WorldCapital {
CountryName = "Iceland", CapitalName = "Reykjavik", Difficulty = 2
},
new WorldCapital {
CountryName = "India", CapitalName = "New Delhi", Difficulty = 2
},
new WorldCapital {
CountryName = "Indonesia", CapitalName = "Jakarta", Difficulty = 2
},
new WorldCapital {
CountryName = "Iran", CapitalName = "Tehran", Difficulty = 2
},
new WorldCapital {
CountryName = "Iraq", CapitalName = "Baghdad", Difficulty = 2
},
new WorldCapital {
CountryName = "Ireland", CapitalName = "Dublin", Difficulty = 1
},
new WorldCapital {
CountryName = "Israel", CapitalName = "Jerusalem", Difficulty = 1
},
new WorldCapital {
CountryName = "Italy", CapitalName = "Rome", Difficulty = 1
},
new WorldCapital {
CountryName = "Jamaica", CapitalName = "Kingston", Difficulty = 3
},
new WorldCapital {
CountryName = "Japan", CapitalName = "Tokyo", Difficulty = 1
},
new WorldCapital {
CountryName = "Jordan", CapitalName = "Amman", Difficulty = 2
},
new WorldCapital {
CountryName = "Kazakhstan", CapitalName = "Astana", Difficulty = 3
},
new WorldCapital {
CountryName = "Kenya", CapitalName = "Nairobi", Difficulty = 2
},
new WorldCapital {
CountryName = "Kiribati", CapitalName = "Tarawa", Difficulty = 3
},
new WorldCapital {
CountryName = "Kosovo", CapitalName = "Pristina", Difficulty = 3
},
new WorldCapital {
CountryName = "Kuwait", CapitalName = "Kuwait", Difficulty = 2
},
new WorldCapital {
CountryName = "Kyrgyzstan", CapitalName = "Bishkek", Difficulty = 3
},
new WorldCapital {
CountryName = "Laos", CapitalName = "Vientiane", Difficulty = 3
},
new WorldCapital {
CountryName = "Latvia", CapitalName = "Riga", Difficulty = 2
},
new WorldCapital {
CountryName = "Lebanon", CapitalName = "Beirut", Difficulty = 2
},
new WorldCapital {
CountryName = "Lesotho", CapitalName = "Maseru", Difficulty = 3
},
new WorldCapital {
CountryName = "Liberia", CapitalName = "Monrovia", Difficulty = 3
},
new WorldCapital {
CountryName = "Libya", CapitalName = "Tripoli", Difficulty = 2
},
new WorldCapital {
CountryName = "Liechtenstein", CapitalName = "Vaduz", Difficulty = 3
},
new WorldCapital {
CountryName = "Lithuania", CapitalName = "Vilnius", Difficulty = 2
},
new WorldCapital {
CountryName = "Luxembourg", CapitalName = "Luxembourg", Difficulty = 1
},
new WorldCapital {
CountryName = "Macedonia", CapitalName = "Skopje", Difficulty = 3
},
new WorldCapital {
CountryName = "Madagascar", CapitalName = "Antananarivo", Difficulty = 3
},
new WorldCapital {
CountryName = "Malawi", CapitalName = "Lilongwe", Difficulty = 3
},
new WorldCapital {
CountryName = "Malaysia", CapitalName = "Kuala Lumpur", Difficulty = 2
},
new WorldCapital {
CountryName = "Maldives", CapitalName = "Male", Difficulty = 3
},
new WorldCapital {
CountryName = "Mali", CapitalName = "Bamako", Difficulty = 3
},
new WorldCapital {
CountryName = "Malta", CapitalName = "Valletta", Difficulty = 2
},
new WorldCapital {
CountryName = "Marshall Islands", CapitalName = "Majuro", Difficulty = 3
},
new WorldCapital {
CountryName = "Mauritania", CapitalName = "Nouakchott", Difficulty = 3
},
new WorldCapital {
CountryName = "Mauritius", CapitalName = "Port Louis", Difficulty = 3
},
new WorldCapital {
CountryName = "Mexico", CapitalName = "Mexico City", Difficulty = 1
},
new WorldCapital {
CountryName = "Micronesia", CapitalName = "Palikir", Difficulty = 3
},
new WorldCapital {
CountryName = "Moldova", CapitalName = "Chisinau", Difficulty = 3
},
new WorldCapital {
CountryName = "Monaco", CapitalName = "Monaco", Difficulty = 1
},
new WorldCapital {
CountryName = "Mongolia", CapitalName = "Ulaanbaatar", Difficulty = 3
},
new WorldCapital {
CountryName = "Montenegro", CapitalName = "Podgorica", Difficulty = 3
},
new WorldCapital {
CountryName = "Morocco", CapitalName = "Rabat", Difficulty = 2
},
new WorldCapital {
CountryName = "Mozambique", CapitalName = "Maputo", Difficulty = 3
},
new WorldCapital {
CountryName = "Myanmar", CapitalName = "Naypyidaw", Difficulty = 3
},
new WorldCapital {
CountryName = "Namibia", CapitalName = "Windhoek", Difficulty = 3
},
new WorldCapital {
CountryName = "Nepal", CapitalName = "Kathmandu", Difficulty = 2
},
new WorldCapital {
CountryName = "Netherlands", CapitalName = "Amsterdam", Difficulty = 1
},
new WorldCapital {
CountryName = "New Zealand", CapitalName = "Wellington", Difficulty = 2
},
new WorldCapital {
CountryName = "Nicaragua", CapitalName = "Managua", Difficulty = 3
},
new WorldCapital {
CountryName = "Niger", CapitalName = "Niamey", Difficulty = 3
},
new WorldCapital {
CountryName = "Nigeria", CapitalName = "Abuja", Difficulty = 3
},
new WorldCapital {
CountryName = "North Korea", CapitalName = "Pyongyang", Difficulty = 2
},
new WorldCapital {
CountryName = "Norway", CapitalName = "Oslo", Difficulty = 1
},
new WorldCapital {
CountryName = "Oman", CapitalName = "Muscat", Difficulty = 3
},
new WorldCapital {
CountryName = "Palestine", CapitalName = "Ramallah", Difficulty = 3
},
new WorldCapital {
CountryName = "Pakistan", CapitalName = "Islamabad", Difficulty = 2
},
new WorldCapital {
CountryName = "Palau", CapitalName = "Ngerulmud", Difficulty = 3
},
new WorldCapital {
CountryName = "Panama", CapitalName = "Panama City", Difficulty = 1
},
new WorldCapital {
CountryName = "Papua New Guinea", CapitalName = "Port Moresby", Difficulty = 3
},
new WorldCapital {
CountryName = "Paraguay", CapitalName = "Asuncion", Difficulty = 3
},
new WorldCapital {
CountryName = "Peru", CapitalName = "Lima", Difficulty = 2
},
new WorldCapital {
CountryName = "Philippines", CapitalName = "Manila", Difficulty = 2
},
new WorldCapital {
CountryName = "Poland", CapitalName = "Warsaw", Difficulty = 2
},
new WorldCapital {
CountryName = "Portugal", CapitalName = "Lisbon", Difficulty = 1
},
new WorldCapital {
CountryName = "Qatar", CapitalName = "Doha", Difficulty = 3
},
new WorldCapital {
CountryName = "Romania", CapitalName = "Bucharest", Difficulty = 2
},
new WorldCapital {
CountryName = "Russia", CapitalName = "Moscow", Difficulty = 1
},
new WorldCapital {
CountryName = "Rwanda", CapitalName = "Kigali", Difficulty = 3
},
new WorldCapital {
CountryName = "Saint Kitts And Nevis", CapitalName = "Basseterre", Difficulty = 3
},
new WorldCapital {
CountryName = "Saint Lucia", CapitalName = "Castries", Difficulty = 3
},
new WorldCapital {
CountryName = "Saint Vincent And The Grenadines", CapitalName = "Kingstown", Difficulty = 3
},
new WorldCapital {
CountryName = "Samoa", CapitalName = "Apia", Difficulty = 3
},
new WorldCapital {
CountryName = "San Marino", CapitalName = "San Marino", Difficulty = 2
},
new WorldCapital {
CountryName = "Sao Tome And Principe", CapitalName = "Sao Tome", Difficulty = 3
},
new WorldCapital {
CountryName = "Saudi Arabia", CapitalName = "Riyadh", Difficulty = 2
},
new WorldCapital {
CountryName = "Senegal", CapitalName = "Dakar", Difficulty = 2
},
new WorldCapital {
CountryName = "Serbia", CapitalName = "Belgrade", Difficulty = 2
},
new WorldCapital {
CountryName = "Seychelles", CapitalName = "Victoria", Difficulty = 3
},
new WorldCapital {
CountryName = "Sierra Leone", CapitalName = "Freetown", Difficulty = 3
},
new WorldCapital {
CountryName = "Singapore", CapitalName = "Singapore", Difficulty = 1
},
new WorldCapital {
CountryName = "Slovakia", CapitalName = "Bratislava", Difficulty = 2
},
new WorldCapital {
CountryName = "Slovenia", CapitalName = "Ljubljana", Difficulty = 2
},
new WorldCapital {
CountryName = "Solomon Islands", CapitalName = "Honiara", Difficulty = 3
},
new WorldCapital {
CountryName = "Somalia", CapitalName = "Mogadishu", Difficulty = 2
},
new WorldCapital {
CountryName = "South Africa", CapitalName = "Pretoria", Difficulty = 2
},
new WorldCapital {
CountryName = "South Korea", CapitalName = "Seoul", Difficulty = 1
},
new WorldCapital {
CountryName = "South Sudan", CapitalName = "Juba", Difficulty = 3
},
new WorldCapital {
CountryName = "Spain", CapitalName = "Madrid", Difficulty = 1
},
new WorldCapital {
CountryName = "Sri Lanka", CapitalName = "Sri Jawewardenepura Kotte", Difficulty = 3
},
new WorldCapital {
CountryName = "Sudan", CapitalName = "Khartoum", Difficulty = 3
},
new WorldCapital {
CountryName = "Suriname", CapitalName = "Paramaribo", Difficulty = 3
},
new WorldCapital {
CountryName = "Swaziland", CapitalName = "Mbabane", Difficulty = 3
},
new WorldCapital {
CountryName = "Sweden", CapitalName = "Stockholm", Difficulty = 1
},
new WorldCapital {
CountryName = "Switzerland", CapitalName = "Bern", Difficulty = 2
},
new WorldCapital {
CountryName = "Syria", CapitalName = "Damascus", Difficulty = 2
},
new WorldCapital {
CountryName = "Taiwan", CapitalName = "Taipei", Difficulty = 2
},
new WorldCapital {
CountryName = "Tajikistan", CapitalName = "Dushanbe", Difficulty = 3
},
new WorldCapital {
CountryName = "Tanzania", CapitalName = "Dodoma", Difficulty = 2
},
new WorldCapital {
CountryName = "Thailand", CapitalName = "Bangkok", Difficulty = 1
},
new WorldCapital {
CountryName = "Timor-Leste", CapitalName = "Dili", Difficulty = 3
},
new WorldCapital {
CountryName = "Togo", CapitalName = "Lome", Difficulty = 3
},
new WorldCapital {
CountryName = "Tonga", CapitalName = "Nukualofa", Difficulty = 3
},
new WorldCapital {
CountryName = "Trinidad And Tobago", CapitalName = "Port-of-Spain", Difficulty = 3
},
new WorldCapital {
CountryName = "Tunisia", CapitalName = "Tunis", Difficulty = 2
},
new WorldCapital {
CountryName = "Turkey", CapitalName = "Ankara", Difficulty = 1
},
new WorldCapital {
CountryName = "Turkmenistan", CapitalName = "Ashgabat", Difficulty = 3
},
new WorldCapital {
CountryName = "Tuvalu", CapitalName = "Funafuti", Difficulty = 3
},
new WorldCapital {
CountryName = "Uganda", CapitalName = "Kampala", Difficulty = 3
},
new WorldCapital {
CountryName = "Ukraine", CapitalName = "Kiev", Difficulty = 2
},
new WorldCapital {
CountryName = "United Arab Emirates", CapitalName = "Abu Dhabi", Difficulty = 2
},
new WorldCapital {
CountryName = "United Kingdom", CapitalName = "London", Difficulty = 1
},
new WorldCapital {
CountryName = "United States", CapitalName = "Washington", Difficulty = 1
},
new WorldCapital {
CountryName = "Uruguay", CapitalName = "Montevideo", Difficulty = 2
},
new WorldCapital {
CountryName = "Uzbekistan", CapitalName = "Tashkent", Difficulty = 3
},
new WorldCapital {
CountryName = "Vanuatu", CapitalName = "Port Vila", Difficulty = 3
},
new WorldCapital {
CountryName = "Venezuela", CapitalName = "Caracas", Difficulty = 2
},
new WorldCapital {
CountryName = "Vietnam", CapitalName = "Hanoi", Difficulty = 1
},
new WorldCapital {
CountryName = "Yemen", CapitalName = "Sanaa", Difficulty = 3
},
new WorldCapital {
CountryName = "Zambia", CapitalName = "Lusaka", Difficulty = 3
},
new WorldCapital {
CountryName = "Zimbabwe", CapitalName = "Harare", Difficulty = 3
}
};
foreach (WorldCapital capital in countries)
{
context.WorldCapitals.Add(capital);
}
context.SaveChanges();
}
