Little Programming

 AngularJs Code:

 var formData = new FormData();
      
        formData.append('files', data);
        formData.append('fileName', data.name);

        return $http({
            url: _urlBase + 'api/app/CustomerExcelUpload',
            method: 'POST',
            //data: JSON.stringify(data),
            processData: false,
            contentType: false,
            data: (formData),
            headers: { 'content-type': undefined, 'Authorization': username + ':' + password }
                    //, transformRequest: angular.identity
            });

ASP.NET WebApi (4.5)

  [HttpPost]
        [Route("api/app/CustomerExcelUpload")]
        public async Task<IHttpActionResult> CustomerExcelUpload()
        {
            //HttpResponseMessage result = null;
            ResponseObj responsobj = new ResponseObj();
            responsobj.COUNT = 0;
            responsobj.CODE = 0;

            try
            {
                

                if (HttpContext.Current.Request.Files.AllKeys.Any())
                {
                    // Get the uploaded image from the Files collection
                    var httpPostedFile = HttpContext.Current.Request.Files["files"];
                    var httpFileName = HttpContext.Current.Request.Form["fileName"];

                    if (httpPostedFile != null)
                    {
                        // Validate the uploaded image(optional)

                        // Get the complete file path
                        var fileSavePath = System.IO.Path.Combine(HttpContext.Current.Server.MapPath("~/upload_doc"), httpPostedFile.FileName);

                        // Save the uploaded file to "UploadedFiles" folder
                        httpPostedFile.SaveAs(fileSavePath);
                    }
                }

                responsobj.Message = "OK";
                responsobj.Success = true;
                responsobj.CODE = 0;
                return Content(HttpStatusCode.OK, responsobj);

            }
            catch (Exception ex)
            {
                Log.Debug("Bad Request");
                responsobj.Message = ex.Message;
                responsobj.Success = false;
                responsobj.CODE = 2;
                return Content(HttpStatusCode.OK, responsobj);

            }
        }

<system.web>
  <httpRuntime executionTimeout="240000" maxRequestLength="2147483647" />
</system.web>

<security>
  <requestFiltering>
    <requestLimits maxAllowedContentLength="4294967295"/>
  </requestFiltering>
</security>

 

https://jsfiddle.net/imamulkarim/gLy7neh2/30/

HttpContext.Current.Response.ContentType = "application/x-download";
                HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=RosterFormat.xlsx");
                HttpContext.Current.Response.Clear();
                HttpContext.Current.Response.WriteFile(path);
                HttpContext.Current.Response.End();

 DECLARE @FromDate DATETIME
 SET @FromDate='01/01/2020'

 DECLARE @ToDate DATETIME
 SET @ToDate= CONVERT(DATETIME, CAST(  DATEPART(MONTH,GETDATE()) AS NVARCHAR(50) ) + '/01/' + CAST( DATEPART(YEAR,GETDATE()) AS NVARCHAR(50)) ,101 )

 DECLARE @TableName NVARCHAR(50)

 WHILE (@FromDate <= @ToDate)
 BEGIN

     SET @TableName = 'Sales'+ CAST( DATEPART(YEAR,@FromDate) AS NVARCHAR(50)) + RIGHT('00'+ISNULL( CAST( DATEPART(MONTH,@FromDate) AS NVARCHAR(50)) ,''),2)
     PRINT @TableName

     SET @FromDate = DATEADD(MONTH,1,@FromDate)
 END

I fixed the issue by doing following modifications to the Project file. have VS 2012 and the web application was MVC 4

1. Unload the project and start editing the csproj file.

2. Added following lines.

<PropertyGroup>
    <VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">10.0</VisualStudioVersion>
    <VSToolsPath Condition="'$(VSToolsPath)' == ''">$(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v$(VisualStudioVersion)</VSToolsPath>
 </PropertyGroup>

3. Added following lines.(Note that some of the Import statments may already exisits. In such case you do not need to add them.

 <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
  <Import Project="$(VSToolsPath)\WebApplications\Microsoft.WebApplication.targets" Condition="'$(VSToolsPath)' != ''" />
  <Import Project="$(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v10.0\WebApplications\Microsoft.WebApplication.targets" Condition="false" />

Source : https://forums.asp.net/t/1838524.aspx?The+target+GatherAllFilesToPublish+does+not+exist

Answer by :  dilanh

Installation : https://l-lin.github.io/angular-datatables/#/getting-started

Add a table to angular view

Type ScriptCode




C# Server Side Code

When table is not refresing after data added then add following code

Add trigger in html page


Type Script code

declaration code




Call rerender method for table data reload.

Invoke(new Action(() =>
                            {
                                //progressBar1.Value = newValue;
                           


                            }));