public int UploadAllDocuments() { using (var client = new System.Net.WebClient()) { IList <Product> products = _appDbContext.tblProduct.ToList(); foreach (var product in products) { int productId = product.ID; string url = product.Url; tblProductFile productFile = new tblProductFile(); productFile.ProductID = productId; try { productFile.Blob = client.DownloadData(url); productFile.Type = client.ResponseHeaders["Content-Type"]; Console.Out.WriteLine(productFile.Type); } catch (Exception e) { productFile.Blob = null; } _appDbContext.TblProductFile.Add(productFile); _appDbContext.SaveChanges(); } return(1); } }
public byte[] UploadDocument(int id) { Product product = _appDbContext.tblProduct.ToList().Find(product => product.ID == id); int productId = product.ID; string url = product.Url; tblProductFile productFile = new tblProductFile(); productFile.ProductID = productId; using (var client = new System.Net.WebClient()) { productFile.Blob = client.DownloadData(url); _appDbContext.TblProductFile.Add(productFile); _appDbContext.SaveChanges(); } return(productFile.Blob); }