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 = ""; } }