protected void SummaryTab() { Worksheet sht = Workbook.Worksheets.AddNamed("Summary"); sht.Cells.AddValueCell(1, 1, "Group No", _fmtHeaderCell); sht.Cells.AddValueCell(1, 2, "Group Name", _fmtHeaderCell); sht.Cells.AddValueCell(1, 3, "Category", _fmtHeaderCell); sht.Cells.AddValueCell(1, 4, "Total Points", _fmtHeaderCell); sht.Cells.AddValueCell(1, 5, "Total Time", _fmtHeaderCell); sht.Cells.AddValueCell(1, 6, "Time Disqualified", _fmtHeaderCell); sht.Cells.AddValueCell(1, 7, "Nett Points", _fmtHeaderCell); for (int r = 0; r < _dataSet.ReportGroup.Rows.Count; r++) { EmitScoreDataSet.ReportGroupRow g = _dataSet.ReportGroup[r]; EmitScoreDataSet.CategoryRow category = _dataSet.Category.FindByCategoryId(g.CategoryId); sht.Cells.AddValueCell(r + 2, 1, g.GroupId, _fmtText); sht.Cells.AddValueCell(r + 2, 2, g.GroupName, _fmtText); sht.Cells.AddValueCell(r + 2, 3, category.CategoryName, _fmtText); EmitScoreDataSet.ReportGroupResultRow[] gr = (EmitScoreDataSet.ReportGroupResultRow[]) _dataSet.ReportGroupResult.Select(String.Format("GroupId='{0}'", g.GroupId)); if (!g.IsTotalPointsNull()) { sht.Cells.AddValueCell(r + 2, 4, g.TotalPoints, _fmtData); } if (!g.IsTotalTimeSecondsNull()) { DateTime totalTime = Swipe.CreateBaseDate(); totalTime = totalTime.AddSeconds(g.TotalTimeSeconds); sht.Cells.AddValueCell(r + 2, 5, totalTime.ToString("HH:mm:ss"), _fmtTimestamp); } if (!g.IsTimeDisqualifiedNull()) { if (g.TimeDisqualified == 1) { sht.Cells.AddValueCell(r + 2, 6, "Yes", _fmtText); } } if (!g.IsNettPointsNull()) { sht.Cells.AddValueCell(r + 2, 7, g.NettPoints, _fmtData); } } }
protected void GroupTabs() { foreach (EmitScoreDataSet.CategoryRow category in _dataSet.Category) { Worksheet sht = Workbook.Worksheets.AddNamed(ValidSheetName(category.CategoryCode)); sht.Cells.AddValueCell(1, 1, "Group Name", _fmtHeaderCell); sht.Cells.AddValueCell(1, 2, "Total Points", _fmtHeaderCell); sht.Cells.AddValueCell(1, 3, "Total Time", _fmtHeaderCell); sht.Cells.AddValueCell(1, 4, "Nett Points", _fmtHeaderCell); sht.Cells.AddValueCell(1, 5, "Time Disqualified", _fmtHeaderCell); EmitScoreDataSet.ReportGroupRow[] tr = (EmitScoreDataSet.ReportGroupRow[]) _dataSet.ReportGroup.Select(String.Format("CategoryId='{0}'", category.CategoryId)); for (int r = 0; r < tr.Length; r++) { sht.Cells.AddValueCell(r + 2, 1, tr[r].GroupName, _fmtText); if (!tr[r].IsTotalPointsNull()) { sht.Cells.AddValueCell(r + 2, 2, tr[r].TotalPoints, _fmtData); } if (!tr[r].IsTotalTimeSecondsNull()) { DateTime totalTime = Swipe.CreateBaseDate(); totalTime = totalTime.AddSeconds(tr[r].TotalTimeSeconds); sht.Cells.AddValueCell(r + 2, 3, totalTime.ToString("HH:mm:ss"), _fmtTimestamp); } if (!tr[r].IsNettPointsNull()) { sht.Cells.AddValueCell(r + 2, 4, tr[r].NettPoints, _fmtData); } if (!tr[r].IsTimeDisqualifiedNull()) { if (tr[r].TimeDisqualified == 1) { sht.Cells.AddValueCell(r + 2, 5, "Yes", _fmtText); } } } } }
protected override void Create() { XF fmtHeaderCell = NewXF(); fmtHeaderCell.Font.Bold = true; XF fmtText = NewXF(); XF fmtTimestamp = NewXF(); fmtTimestamp.Format = "hh:mm:ss"; XF fmtData = NewXF(); fmtData.Format = "#,##0"; foreach (EmitScoreDataSet.CategoryRow category in _dataSet.Category) { Worksheet sht = Workbook.Worksheets.AddNamed(category.CategoryName); sht.Cells.AddValueCell(1, 1, "Team", fmtHeaderCell); sht.Cells.AddValueCell(1, 2, "Total Points", fmtHeaderCell); sht.Cells.AddValueCell(1, 3, "Total Time", fmtHeaderCell); sht.Cells.AddValueCell(1, 4, "Nett Points", fmtHeaderCell); sht.Cells.AddValueCell(1, 5, "Time Disqualified", fmtHeaderCell); EmitScoreDataSet.ReportTeamResultRow[] tr = (EmitScoreDataSet.ReportTeamResultRow[]) _dataSet.ReportTeamResult.Select(String.Format("CategoryId='{0}'", category.CategoryId)); for (int r = 0; r < tr.Length; r++) { sht.Cells.AddValueCell(r + 2, 1, tr[r].TeamName, fmtText); if (!tr[r].IsTotalPointsNull()) { sht.Cells.AddValueCell(r + 2, 2, tr[r].TotalPoints, fmtData); } if (!tr[r].IsTotalTimeSecondsNull()) { DateTime totalTime = Swipe.CreateBaseDate(); totalTime = totalTime.AddSeconds(tr[r].TotalTimeSeconds); sht.Cells.AddValueCell(r + 2, 3, totalTime.ToString("HH:mm:ss"), fmtTimestamp); } if (!tr[r].IsNettPointsNull()) { sht.Cells.AddValueCell(r + 2, 4, tr[r].NettPoints, fmtData); } if (!tr[r].IsTimeDisqualifiedNull()) { if (tr[r].TimeDisqualified == 1) { sht.Cells.AddValueCell(r + 2, 5, "Yes", fmtText); } } } } foreach (EmitScoreDataSet.CategoryRow category in _dataSet.Category) { Worksheet sht = Workbook.Worksheets.AddNamed(String.Format("{0} Detail", category.CategoryName)); sht.Cells.AddValueCell(1, 1, "Team", fmtHeaderCell); sht.Cells.AddValueCell(1, 2, "Group", fmtHeaderCell); sht.Cells.AddValueCell(1, 3, "Group Id", fmtHeaderCell); sht.Cells.AddValueCell(1, 4, "Location Id", fmtHeaderCell); sht.Cells.AddValueCell(1, 5, "Points", fmtHeaderCell); sht.Cells.AddValueCell(1, 6, "Time", fmtHeaderCell); sht.Cells.AddValueCell(1, 7, "Cum.Time", fmtHeaderCell); sht.Cells.AddValueCell(1, 8, "Sequence", fmtHeaderCell); EmitScoreDataSet.ReportGroupResultRow[] tr = (EmitScoreDataSet.ReportGroupResultRow[]) _dataSet.ReportGroupResult.Select(String.Format("CategoryId='{0}'", category.CategoryId)); for (int r = 0; r < tr.Length; r++) { if (!tr[r].IsTeamNameNull()) { sht.Cells.AddValueCell(r + 2, 1, tr[r].TeamName, fmtText); } sht.Cells.AddValueCell(r + 2, 2, tr[r].GroupName, fmtText); sht.Cells.AddValueCell(r + 2, 3, tr[r].GroupId, fmtText); sht.Cells.AddValueCell(r + 2, 4, tr[r].LocationId, fmtText); if (!tr[r].IsPointsNull()) { sht.Cells.AddValueCell(r + 2, 5, tr[r].Points, fmtData); } if (!tr[r].IsTimeNull()) { sht.Cells.AddValueCell(r + 2, 6, tr[r].Time.ToString("HH:mm:ss"), fmtTimestamp); } if (!tr[r].IsCumTimeNull()) { sht.Cells.AddValueCell(r + 2, 7, tr[r].CumTime.ToString("HH:mm:ss"), fmtTimestamp); } sht.Cells.AddValueCell(r + 2, 8, tr[r].ResultId, fmtData); } } }
protected void SummaryTab() { EmitScoreDataSet.LocationRow[] lr = (EmitScoreDataSet.LocationRow[])_dataSet.Location.Select(); int lastLocCol = lr.Length + 3; Worksheet sht = Workbook.Worksheets.AddNamed("Summary"); sht.Cells.AddValueCell(2, 1, "Group No", _fmtHeaderCell); sht.Cells.AddValueCell(2, 2, "Group Name", _fmtHeaderCell); sht.Cells.AddValueCell(2, 3, "Category", _fmtHeaderCell); for (int c = 0; c < lr.Length; c++) { sht.Cells.AddValueCell(1, c + 4, lr[c].LocationId, _fmtHeaderCell); if (!lr[c].IsLocationNameNull()) { // Output the name if there is one sht.Cells.AddValueCell(2, c + 4, lr[c].LocationName, _fmtHeaderCell); } else { // Or simply the index otherwise sht.Cells.AddValueCell(2, c + 4, c + 1, _fmtHeaderCell); } } sht.Cells.AddValueCell(2, lastLocCol + 1, "Total Points", _fmtHeaderCell); sht.Cells.AddValueCell(2, lastLocCol + 2, "Nett Points", _fmtHeaderCell); sht.Cells.AddValueCell(2, lastLocCol + 3, "Total Time", _fmtHeaderCell); sht.Cells.AddValueCell(2, lastLocCol + 4, "Time Disqualified", _fmtHeaderCell); for (int r = 0; r < _dataSet.ReportGroup.Rows.Count; r++) { EmitScoreDataSet.ReportGroupRow g = _dataSet.ReportGroup[r]; EmitScoreDataSet.CategoryRow category = _dataSet.Category.FindByCategoryId(g.CategoryId); sht.Cells.AddValueCell(r + 3, 1, g.GroupId, _fmtText); sht.Cells.AddValueCell(r + 3, 2, g.GroupName, _fmtText); sht.Cells.AddValueCell(r + 3, 3, category.CategoryName, _fmtText); EmitScoreDataSet.ReportGroupResultRow[] gr = (EmitScoreDataSet.ReportGroupResultRow[]) _dataSet.ReportGroupResult.Select(String.Format("GroupId='{0}'", g.GroupId)); // Now export the points for each Location for (int c = 0; c < lr.Length; c++) { for (int p = 0; p < gr.Length; p++) { if (gr[p].LocationId == lr[c].LocationId) { // Found the Location sht.Cells.AddValueCell(r + 3, c + 4, gr[p].Points, _fmtData); } } } if (!g.IsTotalPointsNull()) { sht.Cells.AddValueCell(r + 3, lastLocCol + 1, g.TotalPoints, _fmtData); } if (!g.IsNettPointsNull()) { sht.Cells.AddValueCell(r + 3, lastLocCol + 2, g.NettPoints, _fmtData); } if (!g.IsTotalTimeSecondsNull()) { DateTime totalTime = Swipe.CreateBaseDate(); totalTime = totalTime.AddSeconds(g.TotalTimeSeconds); sht.Cells.AddValueCell(r + 3, lastLocCol + 3, totalTime.ToString("HH:mm:ss"), _fmtTimestamp); } if (!g.IsTimeDisqualifiedNull()) { if (g.TimeDisqualified == 1) { sht.Cells.AddValueCell(r + 3, lastLocCol + 4, "Yes", _fmtText); } } } }