MVC image upload with filename stored in db

Question

Hello i will like to implement this code in my application but i don't know how to add the image name into database when a file is uploaded

sing System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using accomm2.Models;
using System.IO;
using System.Drawing;
using System.Drawing.Drawing2D;

namespace accomm2.Controllers
{
    public class AdminController : Controller
    {
        dataEntities3 _db = new dataEntities3();

        //fileupload

        public ActionResult UploadImage()
        {
            ViewBag.Message = "Welcome to GeeksShip.com! Example Upload & Resize Images";
            const string folderThumbPath = "/Content/StoredImages/Thumbs/";

            var directoryThumbs = new DirectoryInfo(Server.MapPath(folderThumbPath));

            var listImages = directoryThumbs.GetFiles().Select(file => file.Name).ToList();
            ViewBag.listImages = listImages;

            return View("UploadImage");
        }



        [AcceptVerbs(HttpVerbs.Post)]
        public ActionResult UploadImage(string str)
        {
            if (ModelState.IsValid)
            {
                if (Request.Files != null)
                {

                    var posted = Request.Files["uploadFile"];
                    if (posted.FileName != "")
                    {


                        const string pathStoredImage = "/Content/StoredImages/Images/";
                        const string pathStoredThumbs = "/Content/StoredImages/Thumbs/";


                        var imageName = Path.GetFileName(posted.FileName);
                        var filePath = pathStoredImage + imageName;

                        posted.SaveAs(Server.MapPath(filePath));
                        ResizeImage(filePath, 150);

                        ViewBag.message = ViewBag.message + "<br >" +
                        "Đã upload <b>" + posted.FileName + "</b> hình ảnh thành công!";


                    }
                }

            }
            return RedirectToAction("UploadImage");
        }

        public void ResizeImage(string filepath, int imageSize)
        {
            var newImage = new Bitmap(Server.MapPath(filepath));
            int thumbnailSize = imageSize;
            int newWidth, newHeight;

            if (newImage.Width > newImage.Height)
            {
                newWidth = thumbnailSize;
                newHeight = newImage.Height * thumbnailSize / newImage.Width;
            }
            else
            {
                newWidth = newImage.Width * thumbnailSize / newImage.Height;
                newHeight = thumbnailSize;
            }

            var thumbnailBitmap = new Bitmap(newWidth, newHeight);

            var thumbnailGraph = Graphics.FromImage(thumbnailBitmap);
            thumbnailGraph.CompositingQuality = CompositingQuality.HighQuality;
            thumbnailGraph.SmoothingMode = SmoothingMode.HighQuality;
            thumbnailGraph.InterpolationMode = InterpolationMode.HighQualityBicubic;

            var imageRectangle = new Rectangle(0, 0, newWidth, newHeight);
            thumbnailGraph.DrawImage(newImage, imageRectangle);

            filepath = filepath.Replace("/StoredImages/Images/", "/StoredImages/Thumbs/");
            thumbnailBitmap.Save(Server.MapPath(filepath));
            thumbnailGraph.Dispose();
            thumbnailBitmap.Dispose();
            newImage.Dispose();
        }

}
}

My actual db:

model

thank you

You should read some tutorials about Entity Framework. Your problem is not really related to uploading images, but you don't know how to perform basic operations in EF. — LukLed
– LukLed, Commented Feb 13, 2011 at 14:37
thank you .. i know is something like _db.PropPicture.AddObject(Prop); _db.SaveChanges(); but i don't know how to integrate with this upload .. i'm sure there are people interested in this answer , thanks — Teodor
– Teodor, Commented Feb 13, 2011 at 16:01
How to upload an image into the database is a widely covered topic. Are you sure SO does't already have an answer for this? — John Farrell
– John Farrell, Commented Feb 13, 2011 at 19:54
i don't want to upload binary the images in db .. i don't think is a good practice specially if you have big sized images i just want to add the image name in the db. — Teodor
– Teodor, Commented Feb 13, 2011 at 22:11

Davidson Sousa · Accepted Answer · 2011-02-14 00:12:09Z

2

Just add the line for inserting the record on the database right after you save the image. The code should be something like this:

if (Request.Files != null)
                {

                    var posted = Request.Files["uploadFile"];
                    if (posted.FileName != "")
                    {


                        const string pathStoredImage = "/Content/StoredImages/Images/";
                        const string pathStoredThumbs = "/Content/StoredImages/Thumbs/";


                        var imageName = Path.GetFileName(posted.FileName);
                        var filePath = pathStoredImage + imageName;

                        posted.SaveAs(Server.MapPath(filePath));
                        ResizeImage(filePath, 150);

                        /**** begin db saving ****/
                        PropPicture prop = new PropPicture();
                        prop.PictureName = imageName;
                        _db.PropPicture.AddObject(prop);
                        _db.SaveChanges();
                        /**** end db saving ****/

                        ViewBag.message = ViewBag.message + "<br >" +
                        "Đã upload <b>" + posted.FileName + "</b> hình ảnh thành công!";


                    }
                }

Just double check the "db saving" code. I don't have Visual Studio on this computer so I can't test to see if it's correct. :)

answered Feb 14, 2011 at 0:12

Davidson Sousa

1,3532 gold badges15 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Teodor Over a year ago

Thank you you save my day .. i know it was simple but because i'm begginer in the whole .NET topic i didn't found the solution

Collectives™ on Stack Overflow

MVC image upload with filename stored in db

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related