Radzen Multiple file upload in Blazor web assembly app

Question

Radzen Multiple file upload in Blazor web assembly app

rohith bs 1

Radzen Multiple file upload in Blazor web assembly app to SQL Server uploads only latest file by overwriting previous files stored as Varbinary(Max). Please share me the asp.net core code to upload multiple file with new records inserted for all files

Olaf Helper 47,436 Reputation points

2022-10-14T05:50:30.047+00:00

code to upload multiple file with new records inserted for all files

Sorry, but your post is more then unclear and very vague.
What for file with what for records to what for a database / tables?
That's really to less on information and we can not guess the details, so please provide them.

rohith bs 1

CREATE TABLE [dbo].[Document](
[Id] [int] IDENTITY(1,1) NOT NULL,
[FileName] nvarchar NOT NULL,
[FileType] varchar NULL,
[FileData] varbinary NOT NULL,
[Created] [datetime] NOT NULL,
[Modified] [datetime] NOT NULL,

code to insert into database

   var filename = Path.GetFileName(formFile.FileName);  
            //Get file Extension  
            var fileextension = Path.GetExtension(filename);  
            // concatenating  File Name and File Extension  
            var newfilename = String.Concat(Convert.ToString(Guid.NewGuid()), fileextension);  

            var documentViewmodel = new DocumentViewmodel()  
            {  
                Id = 0,  
                FileName = newfilename,  
                FileType = fileextension,  
                Created = DateTime.Now,  
                Modified = DateTime.Now  
            };  

            using (var target = new MemoryStream())  
            {  
                formFile.CopyTo(target);  
                documentViewmodel.FileData = target.ToArray();  
                _document.AddFile(documentViewmodel);  
            }

public class DocumentViewmodel
{
public int Id { get; set; }
[MaxLength(250)]
public string FileName { get; set; }
[MaxLength(100)]
public string FileType { get; set; }
[MaxLength]
public byte[] FileData { get; set; }
public DateTime Created { get; set; }
public DateTime Modified { get; set; }
}

rohith bs 1

[HttpPost("upload/multiple")]
public IActionResult Multiple(IFormFile[] files)
{
foreach (var item in files)
{
UploadFile(item);
}

            return StatusCode(200);  
   }

public async Task UploadFile(IFormFile formFile)
{
if (formFile != null && formFile.Length > 0)
{
var filename = Path.GetFileName(formFile.FileName);
//Get file Extension
var fileextension = Path.GetExtension(filename);
// concatenating File Name and File Extension
var newfilename = String.Concat(Convert.ToString(Guid.NewGuid()), fileextension);

            var documentViewmodel = new DocumentViewmodel()  
            {  
                Id = 0,  
                FileName = newfilename,  
                FileType = fileextension,  
                Created = DateTime.Now,  
                Modified = DateTime.Now  
            };  

            using (var target = new MemoryStream())  
            {  
                formFile.CopyTo(target);  
                documentViewmodel.FileData = target.ToArray();  
                _document.AddFile(documentViewmodel);  
            }  
     }

}

Anonymous

2022-10-14T06:33:20.133+00:00

Hi @rohith bs ,

Do you mean when upload multiple files, only the last file was stored in the database, other files will lose? If that is the case, first, try to add a break point in the Multiple(IFormFile[] files) method, and check the files, whether the files variable contain all files or not? If not check the client-side code. If you can find all file from the files variable, try to check the _document.AddFile(documentViewmodel) method, make sure it has already called the SaveChanges method and saved the new item into database.

1 answer

Your answer

Olaf Helper 47,436 Reputation points

2022-10-14T05:50:30.047+00:00

code to upload multiple file with new records inserted for all files

Sorry, but your post is more then unclear and very vague.
What for file with what for records to what for a database / tables?
That's really to less on information and we can not guess the details, so please provide them.
rohith bs 1 Reputation point

2022-10-14T06:12:47.87+00:00

CREATE TABLE [dbo].[Document](
[Id] [int] IDENTITY(1,1) NOT NULL,
[FileName] nvarchar NOT NULL,
[FileType] varchar NULL,
[FileData] varbinary NOT NULL,
[Created] [datetime] NOT NULL,
[Modified] [datetime] NOT NULL,

code to insert into database

var filename = Path.GetFileName(formFile.FileName); //Get file Extension var fileextension = Path.GetExtension(filename); // concatenating File Name and File Extension var newfilename = String.Concat(Convert.ToString(Guid.NewGuid()), fileextension); var documentViewmodel = new DocumentViewmodel() { Id = 0, FileName = newfilename, FileType = fileextension, Created = DateTime.Now, Modified = DateTime.Now }; using (var target = new MemoryStream()) { formFile.CopyTo(target); documentViewmodel.FileData = target.ToArray(); _document.AddFile(documentViewmodel); }

public class DocumentViewmodel
{
public int Id { get; set; }
[MaxLength(250)]
public string FileName { get; set; }
[MaxLength(100)]
public string FileType { get; set; }
[MaxLength]
public byte[] FileData { get; set; }
public DateTime Created { get; set; }
public DateTime Modified { get; set; }
}
rohith bs 1 Reputation point

2022-10-14T06:16:07.677+00:00

[HttpPost("upload/multiple")]
public IActionResult Multiple(IFormFile[] files)
{
foreach (var item in files)
{
UploadFile(item);
}

return StatusCode(200); }

public async Task UploadFile(IFormFile formFile)
{
if (formFile != null && formFile.Length > 0)
{
var filename = Path.GetFileName(formFile.FileName);
//Get file Extension
var fileextension = Path.GetExtension(filename);
// concatenating File Name and File Extension
var newfilename = String.Concat(Convert.ToString(Guid.NewGuid()), fileextension);

var documentViewmodel = new DocumentViewmodel() { Id = 0, FileName = newfilename, FileType = fileextension, Created = DateTime.Now, Modified = DateTime.Now }; using (var target = new MemoryStream()) { formFile.CopyTo(target); documentViewmodel.FileData = target.ToArray(); _document.AddFile(documentViewmodel); } }

}
Anonymous

2022-10-14T06:33:20.133+00:00

Hi @rohith bs ,

Do you mean when upload multiple files, only the last file was stored in the database, other files will lose? If that is the case, first, try to add a break point in the Multiple(IFormFile[] files) method, and check the files, whether the files variable contain all files or not? If not check the client-side code. If you can find all file from the files variable, try to check the _document.AddFile(documentViewmodel) method, make sure it has already called the SaveChanges method and saved the new item into database.

Answer 1

rohith bs 1

yes thanks for the information, changing from SaveChangesAsync to SaveChages in AddFile method worked

earlier

_dbContext.DocumentViewmodels.Add(file);
_dbContext.SaveChangesAsync();
}

now

_dbContext.DocumentViewmodels.Add(file);
_dbContext.SaveChanges();
}

Anonymous

2022-10-14T07:38:02.28+00:00

Hi @rohith bs ,

Glad to hear it helped you solved the problem. I change convert your solution to an answer, hope it can help others who will meet the similar issue in the future.

Best regards,
Dillion

Share via

Radzen Multiple file upload in Blazor web assembly app

1 answer

Your answer