/// <summary>
/// Download files to view or download physical copy if broswer doesn't support the file type
/// </summary>
/// <param name="fileId">File ID parameter</param>
/// <returns>Return download file</returns>
public ActionResult DownloadFile(int fileId)
{
UploadDocModel model = new UploadDocModel {
File = null, FileList = new List <InvoiceDetailsModel>()
};
try
{
var fileInfo = _db.spGetFileDetails(fileId).First();
return(this.GetFile(fileInfo.invoice_document, fileInfo.invoice_MIME));
}
catch (Exception ex)
{
Console.Write(ex);
}
return(View(model));
}
/// <summary>
/// GET: Index
/// </summary>
/// <returns>Return index view</returns>
public ActionResult Index()
{
UploadDocModel model = new UploadDocModel {
File = null, FileList = new List <InvoiceDetailsModel>()
};
try
{
model.FileList = _db.spGetetAllFiles().Select(p => new InvoiceDetailsModel
{
InvoiceID = p.invoice_id,
InvoicePO = p.invoice_PO,
InvoiceMIME = p.invoice_MIME
}).ToList();
}
catch (Exception ex)
{
Console.Write(ex);
}
return(View(model));
}
public ActionResult Index(UploadDocModel model)
{
string fileName = string.Empty;
byte[] fileContent;
string fileExt = string.Empty;
try
{
if (ModelState.IsValid)
{
byte[] uploadedFile = new byte[model.File.InputStream.Length];
model.File.InputStream.Read(uploadedFile, 0, uploadedFile.Length);
fileName = Path.GetFileNameWithoutExtension(model.File.FileName);
fileExt = model.File.ContentType;
fileContent = uploadedFile;
//save file to database
_db.spAddFile(fileName, fileExt, fileContent);
}
model.FileList = _db.spGetetAllFiles().Select(p => new InvoiceDetailsModel
{
InvoiceID = p.invoice_id,
InvoicePO = p.invoice_PO,
InvoiceMIME = p.invoice_MIME
}).ToList();
}
catch (Exception ex)
{
Console.Write(ex);
}
return(View(model));
}
