public string GetFile(int rowID, out string fileName, out byte[] fileContents)
{
string error = "";
string partVendorQuoteNumber = "PVQ_" + rowID.ToString();
string attachmentCategory = "VendorQuote";
fileName = "";
fileContents = null;
ObjectParameter tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
ObjectParameter result = new ObjectParameter("Result", typeof(Int32?));
try
{
using (var context = new MONITOREntities4())
{
var collection = context.usp_PVQ_FileManagement_Get(partVendorQuoteNumber, attachmentCategory, tranDT, result);
var item = collection.ToList().First();
fileName = item.FileName;
fileContents = item.FileContents;
}
}
catch (EntityCommandExecutionException e)
{
error = (e.InnerException != null) ? e.InnerException.Message : e.Message;
}
catch (Exception e)
{
error = (e.InnerException != null) ? e.InnerException.Message : e.Message;
}
return(error);
}
public static void MultiSelection_FileUploadComplete(object sender, FileUploadCompleteEventArgs args)
{
try
{
_uploadError = "";
var rowID = _rowID;
ObjectParameter tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
ObjectParameter result = new ObjectParameter("Result", typeof(Int32?));
string partVendorQuoteNumber = "PVQ_" + rowID.ToString();
string attachmentCategory = "VendorQuote";
// Save uploaded file to the file server
using (var context = new MONITOREntities4())
{
context.usp_PVQ_FileManagement_Save(partVendorQuoteNumber, attachmentCategory, args.UploadedFile.FileName, args.UploadedFile.FileBytes, tranDT, result);
}
}
catch (EntityCommandExecutionException e)
{
_uploadError = "SQL Error: " + e.Message + " " + e.InnerException?.Message;
//throw new Exception("SQL Error: " + e.Message + " " + e.InnerException?.Message);
}
catch (Exception e)
{
_uploadError = "SQL Error: " + e.Message + " " + e.InnerException?.Message;
//throw new Exception("NON-SQL Error:" + e.Message + e.InnerException?.Message);
}
}