How to Upload Pdf Files to Common Application

Background

Many times, nosotros need to work with the file and storing the physical files on the Server, which is very difficult considering it will swallow lots of retentiveness of the Server. Thus, in this commodity, we will larn, how to upload the files in the binary format into the database and download from the database with the help of ASP.Net MVC, using FileResult. Thus, let's learn pace past stride and so the beginners can also sympathise.

Step i - Create MVC Application.

Now, let usa start with a step by footstep approach from the creation of a uncomplicated MVC Awarding in the post-obit-

1. "Get-go", followed by "All Programs" and select "Microsoft Visual Studio 2015".
2. Click "File", followed past "New" and click "Project". Select "ASP.Internet Web Application Template", provide the Project a name as you lot wish and click OK. Later on clicking, the following Window volition appear,

   

Step 2 - Create Model Class

Now, let united states of america create the model form file, named EmpModel.cs, past right clicking on Models folder and define the following properties in EmpModel.cs class and FileDetailsModel as:

The code snippet of EmpModel.cs and FileDetailsModel .cs will expect like-

1. public class  EmpModel
2. {
3.     [Required]
4.     [DataType(DataType.Upload)]
5.     [Display(Proper name ="Select File" )]
6. public  HttpPostedFileBase files { get ; set up ; }
7. }
9. public class  FileDetailsModel
10. {
11. public int  Id { get ; set up ; }
12.     [Display(Name ="Uploaded File" )]
13. public  String FileName { go ; set ; }
14. public byte [] FileContent { get ; prepare ; }
15. }
    

Step 3 - Create Table and Stored Procedure

Now, create the stored process and the table to store the uploaded files in binary format and display back to the user's view. Use the script, given below, to create the table named FileDetails every bit-

1. CREATE Table  [dbo].[FileDetails](
2.     [Id] [int ] IDENTITY(1,1) NOT NULL ,
3.     [FileName] [varchar ](60) NULL ,
4.     [FileContent] [varbinary](max ) NULL
5. )ON  [ Main ] TEXTIMAGE_ON [ PRIMARY ]
   

As mentioned in the preceding table script, we take created 3 columns Id, which is to identify the files unique key. FileName to store uploaded file proper noun and FileContent to store the uploaded file contents in the binary format.

Create the stored process to insert the file details, using the script, given beneath-

1. Create Process  [dbo].[AddFileDetails]
2. (
3. @FileNamevarchar (60),
4. @FileContent varBinary(Max )
5. )
6. as
7. brainstorm
8. Set  NoCount on
9. Insert into  FileDetails values (@FileName,@FileContent)
11. Finish
    

To get the uploaded file details, apply the code, given beneath-

1. CREATE Procedure  [dbo].[GetFileDetails]
2. (
3. @Idint = null
4. )
5. as
6. begin
8. select  Id,FileName,FileContent from  FileDetails
9. where  Id= isnull (@Id,Id)
10. End
    

We have created the tables and stored procedures. I hope, yous have created the same.

Step 4 - Add Controller Form

Now, let u.s.a. add ASP.NET MVC controller, as shown in the screenshot, given below-

Later on clicking Add button, information technology will prove in the Window. Specify the Controller proper noun as Home with suffix Controller. Now, let's alter the default code of Home controller . Later on modifying the lawmaking of Homecontroller grade, the code will look like-

HomeController.cs

1. using  FileUploadDownLoadInMVC.Models;
2. using  System;
3. using  System.Collections.Generic;
4. using  Arrangement.IO;
5. using  System.Linq;
6. using  System.Web;
7. using  System.Web.Mvc;
8. using  Dapper;
9. using  System.Configuration;
10. using  System.Information.SqlClient;
11. using  System.Data;
13. namespace  FileUploadDownLoadInMVC.Controllers
14. {
15. public class  HomeController : Controller
16.     {
18.         #region Upload Download file
19. public  ActionResult FileUpload()
20.         {
21. render  View();
22.         }
23.         [HttpPost]
24. public  ActionResult FileUpload(HttpPostedFileBase files)
25.         {
27.          String FileExt=Path.GetExtension(files.FileName).ToUpper();
29. if  (FileExt == ".PDF" )
30.             {
31.                 Stream str = files.InputStream;
32.                 BinaryReader Br =new  BinaryReader(str);
33.                 Byte[] FileDet = Br.ReadBytes((Int32)str.Length);
35.                 FileDetailsModel Fd =new  Models.FileDetailsModel();
36.                 Fd.FileName = files.FileName;
37.                 Fd.FileContent = FileDet;
38.                 SaveFileDetails(Fd);
39. return  RedirectToAction( "FileUpload" );
40.             }
41. else
42.             {
44.                 ViewBag.FileStatus ="Invalid file format." ;
45. render  View();
47.             }
49.         }
51.         [HttpGet]
52. public  FileResult DownLoadFile( int  id)
53.         {
54.             List<FileDetailsModel> ObjFiles = GetFileList();
56.             var FileById = (from FCin  ObjFiles
57.                             where FC.Id.Equals(id)
58.                             selectnew  { FC.FileName, FC.FileContent }).ToList().FirstOrDefault();
60. return  File(FileById.FileContent, "application/pdf" , FileById.FileName);
62.         }
63.         

Share this post