public ActionResult EventPerformance(vmAdmin_EventFilter filter)
{
var eventFilter = SetEventFilter(filter);
if (filter.EventId.HasValue)
{
var performanceFilter = new vmAdmin_PerformanceFilter { EventId = filter.EventId };
performanceFilter = SetPerformanceFilter(performanceFilter);
var sizeTotals = (_service as ReportingService).GetTShirtSizeTotalsByEventId((int)filter.EventId);
var vm = new vmAdmin_EventPerformance
{
Filter = eventFilter,
Report = GetPerformanceReport(performanceFilter)
};
if (sizeTotals != null)
{
vm.Report.TShirtSizes = (List<Dictionary<String, int>>)sizeTotals;
}
else
{
vm.Report.TShirtSizes = new List<Dictionary<String, int>>();
}
return View(vm);
}
return View(new vmAdmin_EventPerformance { Filter = eventFilter, Report = new vmAdmin_PerformanceReport() });
}
public FileResult ExportEventPerformance(vmAdmin_EventFilter filter)
{
var performanceFilter = new vmAdmin_PerformanceFilter { EventId = filter.EventId };
performanceFilter = SetPerformanceFilter(performanceFilter);
var sizeTotals = (_service as ReportingService).GetTShirtSizeTotalsByEventId((int)filter.EventId);
var report = GetPerformanceReport(performanceFilter) ;
if (sizeTotals != null)
report.TShirtSizes = (List<Dictionary<String, int>>)sizeTotals;
else
report.TShirtSizes = new List<Dictionary<String, int>>();
return ExportPerformanceReport(report, performanceFilter, "Event Performance", "EventPerformance.xls");
}
public FileResult ExportPerformance(vmAdmin_PerformanceFilter filter)
{
vmAdmin_PerformanceFilter performanceFilter = SetPerformanceFilter(filter);
var report = GetPerformanceReport(performanceFilter);
return ExportPerformanceReport(report, performanceFilter, "Performance Report", "PerformanceExport.xls");
}
private vmAdmin_PerformanceFilter SetPerformanceFilter(vmAdmin_PerformanceFilter filter)
{
var newFilter = new vmAdmin_PerformanceFilter
{
EventList = GetEventList(),
EventId = filter.EventId,
startDate = filter.startDate,
endDate = filter.endDate,
fullEvent = false
};
if (filter.EventId.HasValue)
{
var evt = _service.GetEventById(filter.EventId.Value);
if (!filter.startDate.HasValue)
{
newFilter.startDate = evt.EventFees.Min(x => x.EffectiveDate).Date;
newFilter.fullEvent = true;
}
if (!filter.endDate.HasValue)
newFilter.endDate = DateTime.Now >= evt.EventDates.Max(x => x.DateOfEvent).Date ? evt.EventDates.Max(x => x.DateOfEvent) : DateTime.Now.Date;
}
else
{
if (!filter.startDate.HasValue)
newFilter.startDate = DateTime.Now.AddDays(-(DateTime.Now.Day - 1)).Date;
if (!filter.endDate.HasValue)
newFilter.endDate = DateTime.Now.Date;
}
newFilter.endDate = newFilter.endDate.Value.AddDays(1).Date.AddSeconds(-1);
return newFilter;
}
private vmAdmin_PerformanceReport GetPerformanceReport(vmAdmin_PerformanceFilter filter)
{
DateTime sDate = filter.startDate.Value;
if (filter.fullEvent && filter.EventId.HasValue) // if getting a single event, set the start back to the oldest registration
{
var regs = _service.GetRegistrationsByEventId(filter.EventId.Value);
if (regs.Any())
sDate = regs.Min(x => x.DateAdded);
}
return new vmAdmin_PerformanceReport
{
FeeReport = _service.GetFeeReport(filter.EventId, sDate, filter.endDate.Value),
ChargeReport = _service.GetEventChargeReport(filter.EventId, sDate, filter.endDate.Value),
DayCount = (filter.endDate.Value - sDate).Days + 1,
TotalSpots = _service.GetSpotsAvailable(filter.EventId, sDate, filter.endDate.Value),
SpotsTaken = _service.GetSpotsTaken(filter.EventId, sDate, filter.endDate.Value),
RedemptionRegCount = _service.GetRedemptionSpots(filter.EventId, sDate, filter.endDate.Value),
EventCount = _service.GetEventCount(filter.EventId, sDate, filter.endDate.Value)
};
}
private void ExportReportSubheader(NPOI.SS.UserModel.ISheet sheet, vmAdmin_PerformanceFilter filter, StyleContainer allStyles, ref int rowNumber)
{
var row = sheet.CreateRow(rowNumber++);
if (filter.EventId.HasValue && filter.EventId.Value > 0)
{
var thisEvent = _service.GetEventById(filter.EventId.Value);
ReportUtilities.CreateCell(row, 0, string.Format("{0} - {1}", thisEvent.GeneralLocality, thisEvent.EventDates.Min().DateOfEvent.ToShortDateString()), allStyles.Header2Style);
row = sheet.CreateRow(rowNumber++);
}
else
{
if (filter.startDate.HasValue)
{
var value = string.Format("Events from {0} to {1}", filter.startDate.Value.ToShortDateString(), filter.endDate.Value.ToShortDateString());
ReportUtilities.CreateCell(row, 0, value, allStyles.Header2Style);
row = sheet.CreateRow(rowNumber++);
}
}
}
private FileResult ExportPerformanceReport(vmAdmin_PerformanceReport report, vmAdmin_PerformanceFilter filter, string title, string filename)
{
int rowNumber = 0;
NPOI.SS.UserModel.IRow row;
//Create new Excel workbook
var workbook = new HSSFWorkbook();
//Create new Excel sheet
var sheet = CreateSheet(workbook);
var allStyles = ReportUtilities.CreateStyles(workbook);
ReportUtilities.ExportReportHeader(title, sheet, allStyles, ref rowNumber);
ExportReportSubheader(sheet, filter, allStyles, ref rowNumber);
ExportReportValues(report, sheet, allStyles, ref rowNumber);
ExportReportTshirts(report, sheet, allStyles, ref rowNumber);
ExportReportFees(report, sheet, allStyles, ref rowNumber);
ExportReportCharges(report, sheet,allStyles, ref rowNumber);
//Write the workbook to a memory stream
var output = new MemoryStream();
workbook.Write(output);
//Return the result to the end user
return File(output.ToArray(), //The binary data of the XLS file
"application/vnd.ms-excel", //MIME type of Excel files
filename); //Suggested file name in the "Save as" dialog which will be displayed to the end user
}
public ActionResult _AjaxPerformanceReport(vmAdmin_PerformanceFilter filter)
{
var report = GetPerformanceReport(filter);
return PartialView("partial/PerformanceReport", report);
}
public ActionResult Performance(vmAdmin_PerformanceFilter filter)
{
var performanceFilter = SetPerformanceFilter(filter);
var vm = new vmAdmin_Performance
{
Filter = performanceFilter,
Report = GetPerformanceReport(performanceFilter)
};
return View(vm);
}
