private DynamicParameters DonorTotalSummaryParameters(DonorTotalSummaryOptionsModel m, bool useMedianMin = false)
{
var p = new DynamicParameters();
p.Add("@enddt", m.StartDate);
p.Add("@years", m.NumberOfYears);
if(useMedianMin)
p.Add("@medianMin", m.MinimumMedianTotal);
p.Add("@fund", m.Fund.Value.ToInt());
p.Add("@campus", m.Campus.Value.ToInt());
return p;
}
public ActionResult DonorTotalSummaryOptions()
{
var m = new DonorTotalSummaryOptionsModel
{
StartDate = DateTime.Today,
NumberOfYears = 5,
MinimumMedianTotal = 100,
Campus = new CodeInfo("Campus0"),
Fund = new CodeInfo("Fund"),
};
return View(m);
}
public EpplusResult DonorTotalSummary(DonorTotalSummaryOptionsModel m)
{
var ep = new ExcelPackage();
var cn = new SqlConnection(Util.ConnectionString);
var rd = cn.ExecuteReader("dbo.DonorTotalSummary", DonorTotalSummaryParameters(m, useMedianMin: true), commandType: CommandType.StoredProcedure, commandTimeout: 1200);
ep.AddSheet(rd, "MemberNon");
rd = cn.ExecuteReader("dbo.DonorTotalSummaryBySize", DonorTotalSummaryParameters(m), commandType: CommandType.StoredProcedure, commandTimeout: 1200);
ep.AddSheet(rd, "BySize");
rd = cn.ExecuteReader("dbo.DonorTotalSummaryByAge", DonorTotalSummaryParameters(m), commandType: CommandType.StoredProcedure, commandTimeout: 1200);
ep.AddSheet(rd, "ByAge");
return new EpplusResult(ep, "DonorTotalSummary.xlsx");
}
