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);
}
