TableRow addCountRow(SaskSubmittedSchoolCount entry)
{
TableRow newRow = new TableRow();
TableCell nameCell = new TableCell();
TableCell countCell = new TableCell();
TableCell successesCell = new TableCell();
TableCell failuresCell = new TableCell();
nameCell.Text = entry.schoolName;
countCell.Text = entry.totalCount.ToString();
successesCell.Text = entry.successes.ToString();
failuresCell.Text = entry.failures.ToString();
newRow.Cells.Add(nameCell);
newRow.Cells.Add(successesCell);
newRow.Cells.Add(failuresCell);
newRow.Cells.Add(countCell);
return(newRow);
}
protected void Page_Load(object sender, EventArgs e)
{
// Populate school dropdown list
// Load school counts
List <SkSubmittedEntry> allEntries = new List <SkSubmittedEntry>();
List <School> allSchools = new List <School>();
using (SqlConnection connection = new SqlConnection(LSKYCommon.dbConnectionString_SchoolLogic))
{
allSchools = School.loadAllSchools(connection);
foreach (School school in allSchools)
{
ListItem newItem = new ListItem();
newItem.Text = school.getName();
newItem.Value = school.getGovID().ToString();
drpSchoolList.Items.Add(newItem);
}
allEntries = SkSubmittedEntry.loadAllSaskSubmittedEntries(connection);
}
//Dictionary<string, int> schoolsWithCounts = new Dictionary<string, int>();
List <SaskSubmittedSchoolCount> schoolsWithCounts = new List <SaskSubmittedSchoolCount>();
int totalCount = 0;
int totalSuccesses = 0;
int totalFailures = 0;
foreach (School school in allSchools)
{
int thisSchoolCount = 0;
int thisSchoolSuccess = 0;
int thisSchoolFailures = 0;
foreach (SkSubmittedEntry entry in allEntries)
{
if (entry.schoolID == int.Parse(school.getSchoolLogicID()))
{
thisSchoolCount++;
totalCount++;
if (entry.failed)
{
thisSchoolFailures++;
totalFailures++;
}
else
{
thisSchoolSuccess++;
totalSuccesses++;
}
}
}
if (thisSchoolCount > 0)
{
schoolsWithCounts.Add(new SaskSubmittedSchoolCount(school.getName(), thisSchoolCount, thisSchoolFailures, thisSchoolSuccess));
}
}
SaskSubmittedSchoolCount totals = new SaskSubmittedSchoolCount("<b>Totals</b>", totalCount, totalFailures, totalSuccesses);
tblCounts.Rows.Add(addCountRow(totals));
foreach (SaskSubmittedSchoolCount entry in schoolsWithCounts)
{
tblCounts.Rows.Add(addCountRow(entry));
}
}