Upload image file in entity framework database

You can do something like below
create a model like this

public class AdminDetailsViewModel

{

public int AdminID { get; set; }

[Display(Name = "Admin Name")]

[Required(ErrorMessage = "Name is Required")]

public string AdminName { get; set; }

[Display(Name = "Admin Photo")]

public byte[] AdminImage { get; set; }

}

create a class like ImageRepository whic uses DbContext class

public class ImageRepository

{

private readonly ERPDbContext db = new ERPDbContext();

public int UploadImageInDatabase(HttpPostedFileBase file, AdminDetailsViewModel viewmodel)

{

viewmodel.AdminImage = ConvertToByte(file);

var model = new AdminDetailsModel

{

AdminName = viewmodel.AdminName,

AdminImage = viewmodel.AdminImage,

};

db.AdminDetails.Add(model);

int i = db.SaveChanges();

if (i == 1)

{

return 1;

}

else

{

return 0;

}

private byte[] ConvertToByte(HttpPostedFileBase file)

{

byte[] imageByte = null;

BinaryReader rdr = new BinaryReader(file.InputStream);

imageByte = rdr.ReadBytes((int)file.ContentLength);

return imageByte;

}

create your controller like this

[HttpPost]

public ActionResult Create(AdminDetailsViewModel viewmodel)

{

if (ModelState.IsValid)

{

viewmodel.CreatedDate = DateTime.Now;

HttpPostedFileBase file = Request.Files["ImageData"];

ImageRepository IR = new ImageRepository();

int i = IR.UploadImageInDatabase(file, viewmodel);

if (i == 1)

{

return RedirectToAction("Index");

}

return View(viewmodel);

}

Its not full code but i think u get some idea

1 Reply

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

Prakash Joshi11y ago
You can do something like below
create a model like this

public class AdminDetailsViewModel
{
public int AdminID { get; set; }
[Display(Name = "Admin Name")]
[Required(ErrorMessage = "Name is Required")]
public string AdminName { get; set; }
[Display(Name = "Admin Photo")]
public byte[] AdminImage { get; set; }

}

create a class like ImageRepository whic uses DbContext class
public class ImageRepository
{
private readonly ERPDbContext db = new ERPDbContext();
public int UploadImageInDatabase(HttpPostedFileBase file, AdminDetailsViewModel viewmodel)
{
viewmodel.AdminImage = ConvertToByte(file);
var model = new AdminDetailsModel
{
AdminName = viewmodel.AdminName,
AdminImage = viewmodel.AdminImage,

};
db.AdminDetails.Add(model);
int i = db.SaveChanges();
if (i == 1)
{
return 1;
}
else
{
return 0;
}
}

private byte[] ConvertToByte(HttpPostedFileBase file)
{
byte[] imageByte = null;
BinaryReader rdr = new BinaryReader(file.InputStream);
imageByte = rdr.ReadBytes((int)file.ContentLength);
return imageByte;
}
}

create your controller like this

[HttpPost]
public ActionResult Create(AdminDetailsViewModel viewmodel)
{
if (ModelState.IsValid)
{
viewmodel.CreatedDate = DateTime.Now;
HttpPostedFileBase file = Request.Files["ImageData"];

ImageRepository IR = new ImageRepository();
int i = IR.UploadImageInDatabase(file, viewmodel);
if (i == 1)
{
return RedirectToAction("Index");
}
}
return View(viewmodel);

}

Its not full code but i think u get some idea