Storing and Retrieving Images in SQL Server

-
I typically use the File System for storing images, that doesn't work so well when using a web farm.  Below is an example of storing the image information into SQL server and then retrieving and rendering image back on the page.
The datatype for the image column I am using is the varbinary(max).  For this example I am allowing the upload of an image so I limit both the size and file extension type.

Upload Action



 [HttpPost]
public ActionResult Upload(HttpPostedFileBase file, DataModel.MyClass imginfo)
{
if (ModelState.IsValid)
   {
     if (file == null)
    {
     
     }
else if (file.ContentLength > 0)
    {
int MaxContentLength = 1024 * 1024 * 3; //3 MB - Could put this in a config

 string[] AllowedFileExtensions = new string[] { ".jpg", ".gif", ".png", ".JPG", ".jpeg", ".JPEG", ".GIF", ".PNG" };

 if (!AllowedFileExtensions.Contains(file.FileName.Substring(file.FileName.LastIndexOf('.'))))
{


 ViewBag.Message = "Your file must be JPG, GIF or PNG";
}
else if (file.ContentLength > MaxContentLength)
{

ViewBag.Message = "Your file is too large, maximum allowed size is 3 meg";
}
else
{
//imginfo is the dataclass I passed in

imginfo.imageContentType = file.ContentType;

 //This is a temp save
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/Assets/"), imginfo.imageName);
file.SaveAs(path);

 imginfo.imagePath = "Assets/" + imginfo.imageName;
imginfo.imageFile = ImageTypeOptions.GetPhoto(path);

 //adding straight into my table
dt.TableName.Add(imginfo);
dt.SaveChanges();

 //deleting the temp image 
//since file system deletions can be buggy we are going to throw into a static method
//with a try catch just so it doesn't stop us

 TryToDelete(path);

ViewBag.Message = "File uploaded successfully";
}
}
}
return RedirectToAction("Final", new { id = imginfo.AccountCode, dppID = imginfo.dppID, message = "Successfully Uploaded image" });


}

 Static TrytoDelete method


     private static bool TryToDelete(string f)
        {
            try
            {
                System.IO.File.Delete(f);
                return true;
            }
            catch (IOException)
            {
                return false;
            }

        }

  Static method to convert the image to a format to insert into database
 public static byte[] GetPhoto(string filePath)
        {
            FileStream stream = new FileStream(
                filePath, FileMode.Open, FileAccess.Read);
            BinaryReader reader = new BinaryReader(stream);

             byte[] photo = reader.ReadBytes((int)stream.Length);

             reader.Close();
            stream.Close();

             return photo;

        }

 Then to display on the page just use it like this we are passing in the ID of the row (AssetID):

   <img src="@Url.Action( "DisplayImage", "Fran", new { id = item.AssetID })" width="50" height="50" />

 And the action that we are calling

    public ActionResult DisplayImage(int id)
        {
            var img = db.TableName.Find(id);
            byte[] imageData = img.imageFile;
            var contType = img.imageContentType;
            return new FileStreamResult(new System.IO.MemoryStream(imageData), contType);
           

        }


Comments

Post a Comment

Popular posts from this blog

Grouping with Data Entities

-
I am really loving the data entity in my new projects but have come across a couple of issues already. Tonight I learned about using a field that is not a part of your database and not in the entity but is a consolidation field from a group.  Once I found some good samples it worked incredibly well and I had a little summary grid on the page in just a couple of minutes.  So here is what I did  using (myEntityName context = new myEntityName())     { //First I declared a couple of variables because I was looking at data between specific dates          DateTime startdate = DateTime.Parse("2014-02-01");             DateTime enddate = DateTime.Parse("2014-02-01");          var dbRecords = (from c in context.myTableName                           where (c.MemberStartDate >= startdate && c.MemberStart...
Read more

Localizer in Controller

-
Localizer in Controller Using using Microsoft.Extensions. Localization; Includes private readonly IStringLocalizer< AppAccessController>  _localizer; Resource file must be in a Controller Folder in Resources Method example public Dictionary<string,string> GetRoleList(string appName, bool includeX) { //Code here return allItems.ToDictionary<string, string, string>(i => i, i =>  _localizer[i] ); }
Read more

Sticky Footer made simple

-
CSS Footers are simple but people tend to overthink them.  Here is how it works You have two pieces A container that all your other stuff is in A footer that you want to always stay at the bottom of the page In Blazor I put this container on my content pages and not my host page because I didn't want my left hand nav to be involved <div class="container"> All my content </div> <footer> Centered footer content </footer> And the CSS .container {     width:100%;     padding: 0 15px; } footer {     font-size: 12px; (you could also use a vw value here)     padding-top:20px;     background-color: #xxx;     color: #fff;     margin: auto;     height: 60px;     width: 100%;     position: sticky; //absolute;     bottom: 0;     text-align: center; }
Read more