File upload MVC Core EntityFrameworkCore mysql please help

The application does save files but not on the server. Which data type supports IFormFile? How do i change the code to store to the database?

Below is my code:

My model

namespace EmpApp.Models

{

public class UserViewModel

{

[Required(ErrorMessage = "Please select a file.")]

[DataType(DataType.Upload)]

public IFormFile Photo { get; set; }

}

View

@model EmpApp.Models.UserViewModel

Controller

namespace EmpApp.Controllers

{

public class UserViewController : Controller

{

private readonly IHostingEnvironment environment;

private readonly AppDataContext context;

public UserViewController(AppDataContext context, IHostingEnvironment environment)

{

this.environment = environment;

this.context = context;

}

public IActionResult Index()

{

var model = new UserViewModel();

return View(model);

}

[HttpPost]

[ValidateAntiForgeryToken]

public async Task Index(UserViewModel userViewModel)

{

if (ModelState.IsValid)

{

var formFile = userViewModel.Photo;

if (formFile == null || formFile.Length == 0)

{

ModelState.AddModelError("", "Uploaded file is empty or null.");

return View(viewName: "Index");

}

var uploadsRootFolder = Path.Combine(environment.WebRootPath, "~/uploads/");

if (!Directory.Exists(uploadsRootFolder))

{

Directory.CreateDirectory(uploadsRootFolder);

}

var filePath = Path.Combine(uploadsRootFolder, formFile.FileName);

using (var fileStream = new FileStream(filePath, FileMode.Create))

{

await formFile.CopyToAsync(fileStream).ConfigureAwait(false);

}

RedirectToAction("Index");

}

return View(viewName: "Index");

}

my database table

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Leah Kunkie7y ago
The application does save files but not on the server. Which data type supports IFormFile? How do i change the code to store to the database?

Below is my code:

My model

namespace EmpApp.Models
{
public class UserViewModel
{
[Required(ErrorMessage = "Please select a file.")]
[DataType(DataType.Upload)]
public IFormFile Photo { get; set; }
}
}
View
@model EmpApp.Models.UserViewModel
asp-action="Index"
asp-controller="UserView"
enctype="multipart/form-data">

Controller

namespace EmpApp.Controllers
{
public class UserViewController : Controller
{
private readonly IHostingEnvironment environment;
private readonly AppDataContext context;
public UserViewController(AppDataContext context, IHostingEnvironment environment)
{
this.environment = environment;
this.context = context;
}
public IActionResult Index()
{
var model = new UserViewModel();
return View(model);
}
[HttpPost]
[ValidateAntiForgeryToken]
public async Task Index(UserViewModel userViewModel)
{
if (ModelState.IsValid)
{
var formFile = userViewModel.Photo;
if (formFile == null || formFile.Length == 0)
{
ModelState.AddModelError("", "Uploaded file is empty or null.");
return View(viewName: "Index");
}
var uploadsRootFolder = Path.Combine(environment.WebRootPath, "~/uploads/");
if (!Directory.Exists(uploadsRootFolder))
{
Directory.CreateDirectory(uploadsRootFolder);
}
var filePath = Path.Combine(uploadsRootFolder, formFile.FileName);
using (var fileStream = new FileStream(filePath, FileMode.Create))
{
await formFile.CopyToAsync(fileStream).ConfigureAwait(false);
}
RedirectToAction("Index");
}
return View(viewName: "Index");
}
}
}
my database table

0
Madan Shekar7y ago
go through bellow blog
https://www.c-sharpcorner.com/article/asp-net-mvc-form-with-file-upload/

if it helps mark as a answer.
0
Leah Kunkie7y ago
Thanks Madan, Please refer me to a source.
0
Madan Shekar7y ago
Hi,

You have to follow normal appraoch only create one folder inside your solution and store all images to there.
save image name in Database.

login to your Cpanel and particular fileupload folder set permision or write access.

That's it
0