Create ASP.NET Web API Service

In this section, you will learn how to create a Web API Service for Report Designer using the new ASP.NET Empty Web Application template.

1. Start Visual Studio 2022 and click Create new project.
2. Select ASP.NET Web Application (.NET Framework).
3. Change the application name, and then select the required .NET Framework in the drop-down.
4. Choose Empty, Web API and then click OK. Now, the Web application project is created with default ASP.NET Web template.

List of dependency Libraries

The Web API service configuration requires reporting server-side assembly references.

1. Right-click the project/solution in the Solution Explorer tab, and choose Manage NuGet Packages… Alternatively, click Tools in menu, then select NuGet Package Manager | Manage NuGet Packages for Solution…

   Refer to the NuGet Packages to learn more details about installing and configuring Report Viewer NuGet packages.

2. Search the BoldReports.Web in the Browse tab and install BoldReports.Web NuGet package in the application.

3. BoldReports.Web package will install the following required dependencies for Report Designer into your application. Click OK.

   Package	Purpose
   BoldReports.Web	Builds the server-side implementations.

4. The following table provides details about the dependency packages and its usage.

   Packages	Purpose
   Syncfusion.Pdf.AspNet	Exports the report to a PDF.
   Syncfusion.DocIO.AspNet	Exports the report to a Word.
   Syncfusion.XlsIO.AspNet	Exports the report to an Excel.
   Syncfusion.Presentation.AspNet	Exports the report to an PowerPoint.

5. Install the Microsoft.AspNet.WebApi.Cors from Nuget to enable the Cross-Origin Resource Sharing (CORS) for Web API.

   Install-Package Microsoft.AspNet.WebApi.Cors

   This command installs the latest package and updates all dependencies, including the core Web API libraries. Use the -Version flag to target a specific version. Browser security prevents Report Designer making requests to your Web API Service when both runs in a different domain. To allow access to your Web API service from a different domain, you must enable cross-origin requests.

Add Routing Information

The following steps guide you to configure the routing to include an action name in the URI.

1. Right-click the project in the solution explorer and select Add > New item.

2. In the Add New Item window, select Global Application class and name it as Global.asax, and then click Add.

3. Open the code-behind file Global.asax.cs and add the following using statement.

       using System.Web.Http;

4. Then add the the following code to the Application_Start method to register CORS.

       protected void Application_Start(object sender, EventArgs e)
       {
           System.Web.Http.GlobalConfiguration.Configuration.EnableCors();
       }

   For more information about CORS, see Configure CORS for WebAPI

5. Add the following code to the Application_Start method to register the Routing configuration:

       protected void Application_Start(object sender, EventArgs e)
       {
           System.Web.Http.GlobalConfiguration.Configuration.EnableCors();
           System.Web.Http.GlobalConfiguration.Configuration.Routes.MapHttpRoute(
                  name: "DefaultApi",
                  routeTemplate: "api/{controller}/{action}/{id}",
                  defaults: new { id = RouteParameter.Optional });
       }

   For more information about routing tables, see Routing in ASP.NET Web API.

Add Web API Controller

1. Right-click the project and select Add > New Item from the context menu.
2. In the Add New Item dialog, select Web API Controller class and name it as ReportingAPIController, and then click Add.

While adding Web API Controller class, name it with the suffix Controller that is mandatory.

Configure Web API

The IReportDesignerController interface contains the required actions and helper methods declaration to process the designer file and data actions. The ReportDesignerHelper and ReportHelper class contains methods that help to process Post or Get request from the control and return the response.

ReportDesignerHelper

The class ReportDesignerHelper contains helper methods that help to process Post or Get request from the Report Designer control and returns the response to the Report Designer control. It has the following methods.

ReportHelper

The class ReportHelper contains helper methods that help process Post or Get request for report preview action and returns the response to the Report Designer. It has the following methods.

1. Open the ReportingAPIController and add the following using statement.

   using BoldReports.Web;
   using BoldReports.Web.ReportDesigner;
   using BoldReports.Web.ReportViewer;
   using System.IO;
   using System.Reflection;
   using System.Web;

2. Next, add the [EnableCors] attribute to the ReportingAPIController class.

   [System.Web.Http.Cors.EnableCors(origins: "*", headers: "*", methods: "*")]
   public class ReportingAPIController : ApiController
   {
   
   }

3. Inherit the IReportDesignerController interface, and implement its methods (replace the following code in newly created Web API controller).

   [System.Web.Http.Cors.EnableCors(origins: "*", headers: "*", methods: "*")]
   public class ReportingAPIController : ApiController, IReportDesignerController
   {
       [NonAction]
       private string GetFilePath(string itemName, string key)
       {
           string dirPath = Path.Combine(HttpContext.Current.Server.MapPath("~/")+ "Cache", key);
   
           if (!Directory.Exists(dirPath))
           {
               Directory.CreateDirectory(dirPath);
           }
   
           return Path.Combine(dirPath, itemName);
       }
   
       [System.Web.Http.ActionName("GetImage")]
       [AcceptVerbs("GET")]
       public object GetImage(string key, string image)
       {
           return ReportDesignerHelper.GetImage(key, image, this);
       }
   
       public object PostDesignerAction(Dictionary<string, object> jsonResult)
       {
           return ReportDesignerHelper.ProcessDesigner(jsonResult, this, null);
       }
   
       [NonAction]
       public bool SetData(string key, string itemId, ItemInfo itemData, out string errorMessage)
       {
           errorMessage = string.Empty;
   
           if (itemData.Data != null)
           {
               File.WriteAllBytes(this.GetFilePath(itemId, key), itemData.Data);
           }
           else if (itemData.PostedFile != null)
           {
               var fileName = itemId;
               if (string.IsNullOrEmpty(itemId))
               {
                   fileName = Path.GetFileName(itemData.PostedFile.FileName);
               }
               itemData.PostedFile.SaveAs(this.GetFilePath(fileName, key));
           }
   
           return true;
       }
   
       [NonAction]
       public ResourceInfo GetData(string key, string itemId)
       {
           var resource = new ResourceInfo();
           try
           {
               var filePath = this.GetFilePath(itemId, key);
               if (itemId.Equals(Path.GetFileName(filePath), StringComparison.InvariantCultureIgnoreCase) && File.Exists(filePath))
               {
                   resource.Data = File.ReadAllBytes(filePath);
               }
               else
               {
                   resource.ErrorMessage = "File not found from the specified path";
               }
           }
           catch (Exception ex)
           {
               resource.ErrorMessage = ex.Message;
           }
   
           return resource;
       }
   
       public void UploadReportAction()
       {
           ReportDesignerHelper.ProcessDesigner(null, this, System.Web.HttpContext.Current.Request.Files[0]);
       }
   
       [System.Web.Http.ActionName("GetResource")]
       [AcceptVerbs("GET")]
       public object GetResource(string key, string resourcetype, bool isPrint)
       {
           //Returns the report resource for the requested key.
           return ReportHelper.GetResource(key, resourcetype, isPrint);
       }
   
       [NonAction]
       public void OnInitReportOptions(ReportViewerOptions reportOption)
       {
           var resourcesPath = System.Web.Hosting.HostingEnvironment.MapPath("~/Scripts");
   
           reportOption.ReportModel.ExportResources.Scripts = new List<string>
           {
               resourcesPath + @"\bold-reports\common\bold.reports.common.min.js",
               resourcesPath + @"\bold-reports\common\bold.reports.widgets.min.js",
               //Gauge component scripts
               resourcesPath + @"\bold-reports\common\ej2-base.min.js",
               resourcesPath + @"\bold-reports\common\ej2-data.min.js",
               resourcesPath + @"\bold-reports\common\ej2-pdf-export.min.js",
               resourcesPath + @"\bold-reports\common\ej2-svg-base.min.js",
               resourcesPath + @"\bold-reports\data-visualization\ej2-lineargauge.min.js",
               resourcesPath + @"\bold-reports\data-visualization\ej2-circulargauge.min.js",
               //Map component script
               resourcesPath + @"\bold-reports\data-visualization\ej2-maps.min.js",
               //Report viewer Script
               resourcesPath + @"\bold-reports\data-visualization\ej.chart.min.js",
               resourcesPath + @"\bold-reports\bold.report-viewer.min.js"
           };
   
           reportOption.ReportModel.ExportResources.DependentScripts = new List<string>
           {
               resourcesPath + @"\jquery-1.7.1.min.js"
           };
       }
   
       [NonAction]
       public void OnReportLoaded(ReportViewerOptions reportOption)
       {
           //You can update report options here
       }
   
       public object PostReportAction(Dictionary<string, object> jsonResult)
       {
           return ReportHelper.ProcessReport(jsonResult, this as IReportController);
       }
   }

4. Compile and run the Web API service application.