Multiple file upload with ASP.NET WebApi

Multiple file upload store the file path in sql with ASP.NET WebApi.I can store multiple image on folder. But image path store only once.I want to store image path also multiple time

public string UploadFiles()
{
int iUploadedCnt = 0;
// DEFINE THE PATH WHERE WE WANT TO SAVE THE FILES.
string sPath = "";
sPath = System.Web.Hosting.HostingEnvironment.MapPath("~/Images/");
System.Web.HttpFileCollection hfc = System.Web.HttpContext.Current.Request.Files;
// CHECK THE FILE COUNT.
for (int iCnt = 0; iCnt <= hfc.Count - 1; iCnt++)
{
System.Web.HttpPostedFile hpf = hfc[iCnt];
if (hpf.ContentLength > 0)
{
// CHECK IF THE SELECTED FILE(S) ALREADY EXISTS IN FOLDER. (AVOID DUPLICATE)
if (!File.Exists(sPath + Path.GetFileName(hpf.FileName)))
{
// SAVE THE FILES IN THE FOLDER.
hpf.SaveAs(sPath + Path.GetFileName(hpf.FileName));
iUploadedCnt = iUploadedCnt + 1;
//Read the File data from Request.Form collection.
HttpPostedFile postedFile = HttpContext.Current.Request.Files[0];
//Insert the File to Database Table.
WebApiDatabaseEntities entities = new WebApiDatabaseEntities();
ImageUpload file = new ImageUpload();
file.ImagePath = Path.GetFileName(postedFile.FileName);
file.Title = postedFile.ContentType;
file.CreatedDate = DateTime.Now;
entities.ImageUploads.Add(file);
entities.SaveChanges();
}
}
}
}

You are doing everything correctly except you are taking the same image each time, instead of do this.

for (int iCnt = 0; iCnt <= hfc.Count - 1; iCnt++)
{
System.Web.HttpPostedFile hpf = hfc[iCnt];
if (hpf.ContentLength > 0)
{
// CHECK IF THE SELECTED FILE(S) ALREADY EXISTS IN FOLDER. (AVOID DUPLICATE)
if (!File.Exists(sPath + Path.GetFileName(hpf.FileName)))
{
// SAVE THE FILES IN THE FOLDER.
hpf.SaveAs(sPath + Path.GetFileName(hpf.FileName));
iUploadedCnt = iUploadedCnt + 1;
//Read the File data from Request.Form collection.
HttpPostedFile postedFile = HttpContext.Current.Request.Files[iCnt ]; // look here
//Insert the File to Database Table.
WebApiDatabaseEntities entities = new WebApiDatabaseEntities();
ImageUpload file = new ImageUpload();
file.ImagePath = Path.GetFileName(postedFile.FileName);
file.Title = postedFile.ContentType;
file.CreatedDate = DateTime.Now;
entities.ImageUploads.Add(file);
entities.SaveChanges();
}
}
}

1 Reply

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

Sachin Singh5y ago
Accepted answer
You are doing everything correctly except you are taking the same image each time, instead of do this.
for (int iCnt = 0; iCnt <= hfc.Count - 1; iCnt++)
    {
        System.Web.HttpPostedFile hpf = hfc[iCnt];

        if (hpf.ContentLength > 0)
        {
            // CHECK IF THE SELECTED FILE(S) ALREADY EXISTS IN FOLDER. (AVOID DUPLICATE)
            if (!File.Exists(sPath + Path.GetFileName(hpf.FileName)))
            {
                // SAVE THE FILES IN THE FOLDER.
                hpf.SaveAs(sPath + Path.GetFileName(hpf.FileName));
                iUploadedCnt = iUploadedCnt + 1;
                //Read the File data from Request.Form collection.
                HttpPostedFile postedFile = HttpContext.Current.Request.Files[iCnt ];  // look here

                //Insert the File to Database Table.
                WebApiDatabaseEntities entities = new WebApiDatabaseEntities();
                ImageUpload file = new ImageUpload();

                    file.ImagePath = Path.GetFileName(postedFile.FileName);
                    file.Title = postedFile.ContentType;
                    file.CreatedDate = DateTime.Now;

                entities.ImageUploads.Add(file);
                entities.SaveChanges();
            }
        }
    }
0