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"); }