private static void AppendRandomScores(StringBuilder commaSeparatedContent, int year, int quarter)
{
var currentQuarter = GetQuarter(quarter);
commaSeparatedContent.AppendFormat("{0},", Randomizers.GenerateRandomDate(year, currentQuarter.Item1, currentQuarter.Item2));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},", Randomizers.GetRandomNumber(1, 11));
commaSeparatedContent.AppendFormat("{0},\r\n", Randomizers.GetRandomNumber(1, 11));
}
private void PrepareValues(StringBuilder commaSeparatedContent)
{
var schools = GetUniqueEntities(entityType: "School", startIndex: 1, numberOfEntities: numberOfSchools);
var schoolsWithParents = GetParentsForEverySchool(schools);
var numberOfQuarters = quarters.GetLength(0);
foreach (var year in years)
{
for (int quarter = 0; quarter < numberOfQuarters; quarter++)
{
foreach (var school in schoolsWithParents.Keys)
{
SchoolRatesItSelf(commaSeparatedContent, year, quarter, school);
var transportCompany = transportCompanies[Randomizers.GetRandomNumber(0, transportCompanies.Count)];
SchoolRatesEnitity(commaSeparatedContent, year, quarter, school, transportCompany);
EnitityRatesSchool(commaSeparatedContent, year, quarter, school, transportCompany);
var securityService = securityServices[Randomizers.GetRandomNumber(0, securityServices.Count)];
SchoolRatesEnitity(commaSeparatedContent, year, quarter, school, securityService);
EnitityRatesSchool(commaSeparatedContent, year, quarter, school, securityService);
var foodAndCatering = foodAndCaterings[Randomizers.GetRandomNumber(0, foodAndCaterings.Count)];
SchoolRatesEnitity(commaSeparatedContent, year, quarter, school, foodAndCatering);
EnitityRatesSchool(commaSeparatedContent, year, quarter, school, foodAndCatering);
var healthcareProvider = healthcareProviders[Randomizers.GetRandomNumber(0, healthcareProviders.Count)];
SchoolRatesEnitity(commaSeparatedContent, year, quarter, school, healthcareProvider);
EnitityRatesSchool(commaSeparatedContent, year, quarter, school, healthcareProvider);
if (quarter != Randomizers.GetRandomNumber(0, numberOfQuarters))
{
ParentsRateSchool(commaSeparatedContent, schoolsWithParents, year, quarter, school);
}
}
}
}
}
