public void ExportCpat(TakeRateParameters parameters)
        {
            var business   = new TakeRateBusiness(DataContext, parameters, false);
            var exportData = business.ExportCpat();
            var fileName   = string.Format("TakeRateCpatExport_{0:yyyyMMdd}_{1}.xlsx",
                                           DateTime.Now,
                                           parameters.TakeRateId);

            Response.ClearContent();
            Response.Buffer = true;
            Response.AddHeader("content-disposition", "attachment; filename=" + fileName);
            Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";

            using (var stream = new MemoryStream())
            {
                exportData.SaveAs(stream);
                stream.WriteTo(Response.OutputStream);
                Response.Flush();
                Response.End();
            }
        }
        public void ExportCpat(TakeRateParameters parameters)
        {
            var business = new TakeRateBusiness(DataContext, parameters, false);
            var exportData = business.ExportCpat();
            var fileName = string.Format("TakeRateCpatExport_{0:yyyyMMdd}_{1}.xlsx",
                DateTime.Now,
                parameters.TakeRateId);

            Response.ClearContent();
            Response.Buffer = true;
            Response.AddHeader("content-disposition", "attachment; filename=" + fileName);
            Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";

            using (var stream = new MemoryStream())
            {
                exportData.SaveAs(stream);
                stream.WriteTo(Response.OutputStream);
                Response.Flush();
                Response.End();
            }
        }