private void GetQuotePrint()
{
ObjectParameter tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
ObjectParameter result = new ObjectParameter("Result", typeof(Int32?));
string path = Path.GetTempPath();
path = path + @"QuotePrints\";
if (Directory.Exists(path))
{
System.IO.Directory.Delete(path, true);
}
System.IO.Directory.CreateDirectory(path);
string attachmentCategory = "QuotePrint";
string fileName = "";
byte[] fileContents;
try
{
int r = gridView1.GetSelectedRows()[0];
string quoteNumber = gridView1.GetRowCellValue(r, "QuoteNumber").ToString();
var collection = _context.usp_QT_FileManagement_Get(quoteNumber, attachmentCategory, tranDT, result);
var item = collection.First();
fileName = item.FileName;
fileContents = item.FileContents;
//fileName = fileName.Remove(fileName.Length - 4);
//filePathQuotePrint = path + fileName + "_" + DateTime.Now.ToString("yyyyMMdd") + ".pdf";
string filePathQuotePrint = path + fileName;
var fs = new System.IO.FileStream(filePathQuotePrint, FileMode.OpenOrCreate);
fs.Write(fileContents, 0, fileContents.Length);
fs.Flush();
fs.Close();
System.Diagnostics.Process.Start(filePathQuotePrint);
}
catch (Exception ex)
{
string err = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
MessageBox.Show(err, "Error at GetQuotePrint()");
}
}
private void ShowQuotePrintFileInfo()
{
ObjectParameter tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
ObjectParameter result = new ObjectParameter("Result", typeof(Int32?));
string attachmentCategory = "QuotePrint";
string fileName = "";
try
{
var collection = _context.usp_QT_FileManagement_Get(QuoteNumber, attachmentCategory, tranDT, result);
foreach (var item in collection)
{
fileName = item.FileName;
}
if (fileName == "")
{
lnkGetQuotePrint.Enabled = lnkDeleteQuotePrint.Enabled = false;
lblQuotePrint.Text = "";
}
else
{
lnkGetQuotePrint.Enabled = lnkDeleteQuotePrint.Enabled = true;
lblQuotePrint.Text = fileName;
}
}
catch (Exception ex)
{
string err = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
MessageBox.Show("Failed to return Quote Print information from the database. " + err, "Error at ShowQuotePrintFileInfo()");
lnkGetQuotePrint.Enabled = lnkSaveQuotePrint.Enabled = lnkDeleteQuotePrint.Enabled = false;
lblQuotePrint.Text = "";
}
}