public ActionResult PrintOffer(string codProduct)
{
var reportName = "";
var dbName = "";
int id = 0;
//carico i documentProduct in preventivo
var docsProduct = documentRepository.GetDocumentProductsByCodProduct(codProduct);
//carico l'ordine
var estimate = documentRepository.GetAll().OfType<Estimate>().FirstOrDefault(x => x.CodDocument == docsProduct.FirstOrDefault().CodDocument);
//cliente dell'ordine
Customer cust = (Customer)customerSupplierRepository.GetSingle(estimate.CodCustomer);
estimate.CustomerSupplier = cust;
string fileNameMain = Path.Combine(Server.MapPath(@"~/Report"), (reportName == "" || reportName == null) ? "OfferHead.docx" : (reportName + ".docx"));
string retName = estimate.EstimateNumberSerie + "-" + estimate.EstimateNumber;
retName = retName.PurgeFileName();
string fileNameSaveAs = Path.Combine(Server.MapPath(@"~/Report"), retName + dbName + ".docx");
string fileNameSaveAsAfterRepair = fileNameSaveAs;// Path.Combine(Server.MapPath(@"~/Report"), retName + "AfterRepair.docx");
// Store a global reference to the executing assembly.
g_assembly = Assembly.GetExecutingAssembly();
//// Create the document in memory:
var docMain = DocX.Load(fileNameMain);
//questo array mi serve per il merge
Queue<string> files = new Queue<string>();
estimate.MergeField(docMain);
var product = productRepository.GetSingle(codProduct);
product.MergeField(docMain);
// product.ProductParts.FirstOrDefault().ProductPartPrintableArticles.FirstOrDefault().MergeField(docMain);
var documentProducts = estimate.DocumentProducts.Where(x => x.CodProduct == codProduct).OrderBy(x => x.Quantity);
String hashControl = "";
String hashControlCalculated = "";
String nomeExtHeaderDest = "";
String costiFileDest = "";
foreach (var docProd in documentProducts)
{
var dProdFileNameSource = Path.Combine(Server.MapPath(@"~/Report"), "DocumentProduct" + dbName + ".docx");
if (!System.IO.File.Exists(dProdFileNameSource))
{
dProdFileNameSource = Path.Combine(Server.MapPath(@"~/Report"), "DocumentProduct" + ".docx");
}
docProd.Product = product;
var docPrint = DocX.Load(dProdFileNameSource);
docProd.MergeField(docPrint);
costiFileDest = Path.Combine(Server.MapPath(@"~/Report"), "DocPro" + docProd.CodDocumentProduct + ".docx");
docPrint.SaveAs(costiFileDest);
#region costi supplementari
//questo array mi serve per il merge
Queue<string> filesExtCost = new Queue<string>();
var costs = docProd.Costs;
//0=incluso, 1=Aux, 2=escluso
var extCost = costs.Where(x => x.TypeOfCalcolous == 1 && (x.Quantity ?? 0) != 0);
//prestampa
foreach (var cost in extCost)
{
var docPrePressFile = Path.Combine(Server.MapPath(@"~/Report"), "ExternalCost" + dbName + ".docx");
if (!System.IO.File.Exists(docPrePressFile))
{
docPrePressFile = Path.Combine(Server.MapPath(@"~/Report"), "ExternalCost.docx");
}
var docPrePress = DocX.Load(docPrePressFile);
cost.MergeField(docPrePress);
docPrePress.SaveAs(Path.Combine(Server.MapPath(@"~/Report"), "ExtCost" + cost.CodCost + ".docx"));
filesExtCost.Enqueue(Path.Combine(Server.MapPath(@"~/Report"), "ExtCost" + cost.CodCost + ".docx"));
hashControlCalculated = cost.Quantity.Value.ToString() + cost.TotalCost;
}
//fusione dei file COSTI SUPPLEMENTARI
#region external cost header
//apro l'header dei costi supplementari e lo salvo
nomeExtHeaderDest = Path.Combine(Server.MapPath(@"~/Report"), "ExtCostHeader" + estimate.CodDocument + ".docx");
var docECHeaderFile = Path.Combine(Server.MapPath(@"~/Report"), "ExternalCostHeader" + dbName + ".docx");
if (!System.IO.File.Exists(docECHeaderFile))
{
docECHeaderFile = Path.Combine(Server.MapPath(@"~/Report"), "ExternalCostHeader.docx");
}
var docECHeader = DocX.Load(docECHeaderFile);
docECHeader.SaveAs(nomeExtHeaderDest);
foreach (var file in filesExtCost.Reverse())
{
using (WordprocessingDocument myDoc = WordprocessingDocument.Open(nomeExtHeaderDest, true))
{
var altChunkId = "AltChunkId" + id++;
Console.WriteLine(altChunkId);
var mainPart = myDoc.MainDocumentPart;
var chunk = mainPart.AddAlternativeFormatImportPart(DocumentFormat.OpenXml.Packaging.AlternativeFormatImportPartType.WordprocessingML, altChunkId);
using (System.IO.FileStream fileStream = System.IO.File.Open(file, System.IO.FileMode.Open))
{
chunk.FeedData(fileStream);
}
var altChunk = new DocumentFormat.OpenXml.Wordprocessing.AltChunk();
altChunk.Id = altChunkId;
var last = mainPart.Document.Body.Elements<DocumentFormat.OpenXml.Wordprocessing.Paragraph>().Last();
mainPart.Document.Body.InsertAfter(altChunk, last);
mainPart.Document.Save();
}
}
#endregion
#endregion
if (hashControl != "")
{
if (hashControl != hashControlCalculated)
{
//metto in coda l'header
files.Enqueue(nomeExtHeaderDest);
}
}
hashControl = hashControlCalculated;
files.Enqueue(costiFileDest);
}
//metto in coda l'header
files.Enqueue(nomeExtHeaderDest);
docMain.SaveAs(fileNameSaveAs);
docMain.Dispose();
foreach (var file in files.Reverse())
{
using (WordprocessingDocument myDoc = WordprocessingDocument.Open(fileNameSaveAs, true))
{
var altChunkId = "AltChunkId" + id++;
Console.WriteLine(altChunkId);
var mainPart = myDoc.MainDocumentPart;
var chunk = mainPart.AddAlternativeFormatImportPart(DocumentFormat.OpenXml.Packaging.AlternativeFormatImportPartType.WordprocessingML, altChunkId);
using (System.IO.FileStream fileStream = System.IO.File.Open(file, System.IO.FileMode.Open))
{
chunk.FeedData(fileStream);
}
var altChunk = new DocumentFormat.OpenXml.Wordprocessing.AltChunk();
altChunk.Id = altChunkId;
var last = mainPart.Document.Body.Elements<DocumentFormat.OpenXml.Wordprocessing.Paragraph>().Last();
mainPart.Document.Body.InsertAfter(altChunk, last);
mainPart.Document.Save();
}
}
return File(fileNameSaveAsAfterRepair, "application/file", retName + ".docx");
}
public ActionResult PrintDocumentsTaskCenter(string codTaskCenter)
{
int id;
string reportName = "DocumentsTaskCenter";
//carico il TaskCenter
TaskCenter tsk = taskCenterRepository.GetSingle(codTaskCenter);
string fileNameMain = Path.Combine(Server.MapPath(@"~/Report"), reportName + ".docx");
string retName = tsk.TaskCenterName + "-" + DateTime.Now.ToString("yyyymmdd");
retName = retName.PurgeFileName();
string fileNameSaveAs = Path.Combine(Server.MapPath(@"~/Report"), retName + ".docx");
string fileNameSaveAsAfterRepair = fileNameSaveAs;// Path.Combine(Server.MapPath(@"~/Report"), retName + "AfterRepair.docx");
// Store a global reference to the executing assembly.
g_assembly = Assembly.GetExecutingAssembly();
//// Create the document in memory:
var docMain = DocX.Load(fileNameMain);
//questo array mi serve per il merge
Queue<string> files = new Queue<string>();
tsk.MergeField(docMain);
var docsTsk = taskCenterRepository.GetDocumentsTaskCenter(codTaskCenter).OrderBy(x => x.IndexOf);
Console.WriteLine(docsTsk);
foreach (var doc in docsTsk)
{
string fileNameDetail = Path.Combine(Server.MapPath(@"~/Report"), "DocumentTaskCenter.docx");
var docPrintCD = DocX.Load(fileNameDetail);
doc.MergeField(docPrintCD);
docPrintCD.SaveAs(Path.Combine(Server.MapPath(@"~/Report"), "DocTskCenter" + doc.CodDocumentTaskCenter + ".docx"));
files.Enqueue(Path.Combine(Server.MapPath(@"~/Report"), "DocTskCenter" + doc.CodDocumentTaskCenter + ".docx"));
}
docMain.SaveAs(fileNameSaveAs);
docMain.Dispose();
id = 0;
foreach (var file in files.Reverse())
{
using (WordprocessingDocument myDoc = WordprocessingDocument.Open(fileNameSaveAs, true))
{
var altChunkId = "AltChunkId" + id++;
Console.WriteLine(altChunkId);
var mainPart = myDoc.MainDocumentPart;
var chunk = mainPart.AddAlternativeFormatImportPart(DocumentFormat.OpenXml.Packaging.AlternativeFormatImportPartType.WordprocessingML, altChunkId);
using (System.IO.FileStream fileStream = System.IO.File.Open(file, System.IO.FileMode.Open))
{
chunk.FeedData(fileStream);
}
var altChunk = new DocumentFormat.OpenXml.Wordprocessing.AltChunk();
altChunk.Id = altChunkId;
var last = mainPart.Document.Body.Elements<DocumentFormat.OpenXml.Wordprocessing.Paragraph>().Last();
mainPart.Document.Body.InsertAfter(altChunk, last);
mainPart.Document.Save();
}
}
UpdateAndReloadPlanning();
return File(fileNameSaveAsAfterRepair, "application/file", retName + ".docx");
}
//public ActionResult PrintOrder(string codDocument)
//{
// //carico l'ordine
// Order order = documentRepository.GetAll().OfType<Order>().FirstOrDefault(x => x.CodDocument == codDocument);
// //cliente dell'ordine
// Customer cust = (Customer)customerSupplierRepository.GetSingle(order.CodCustomer);
// order.CustomerSupplier = cust;
// //il suo prodotto con la sua quantità
// order.OrderProduct = documentRepository.GetDocumentProductByCodDocumentProduct(order.CodDocumentProduct);
// //estimate
// order.OrderProduct.Document = (Estimate)documentRepository.GetSingle(order.OrderProduct.CodDocument);
// string fileNameMain = Path.Combine(Server.MapPath(@"~/Report"), "OrderHead.docx");
// string fileNameCost = Path.Combine(Server.MapPath(@"~/Report"), "Cost.docx");
// string fileNameSaveAs = Path.Combine(Server.MapPath(@"~/Report"), order.OrderNumberSerie + "-" + order.OrderNumber + ".docx");
// string fileNameSaveAsAfterRepair = Path.Combine(Server.MapPath(@"~/Report"), order.OrderNumberSerie + "-" + order.OrderNumber + "AfterRepair.docx");
// // Store a global reference to the executing assembly.
// g_assembly = Assembly.GetExecutingAssembly();
// // Create the document in memory:
// var docMain = DocX.Load(fileNameMain);
// order.MergeField(docMain);
// order.OrderProduct.MergeField(docMain);
// order.OrderProduct.Product.MergeField(docMain);
// var product = productRepository.GetSingle(order.OrderProduct.Product.CodProduct);
// product.ProductParts.FirstOrDefault().MergeField(docMain);
// // product.ProductParts.FirstOrDefault().ProductPartPrintableArticles.FirstOrDefault().MergeField(docMain);
// foreach (var cost in order.OrderProduct.Costs)
// {
// // Create the document in memory:
// //var docCost = DocX.Load(fileNameCost);
// // cost.MergeField(docCost);
// //try
// //{
// var cd = cost.CostDetails.FirstOrDefault();
// if (cd != null)
// {
// cd = costDetailRepository.GetSingle(cd.CodCostDetail);
// cd.InitCostDetail(taskExecutorRepository.GetAll(), articleRepository.GetAll());
// if (cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString() == "PrintedRollArticleCostDetail" ||
// cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString() == "PrintingZRollCostDetail" ||
// cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString() == "ControlTableCostDetail")
// {
// var docPrintCD = DocX.Load(Path.Combine(Server.MapPath(@"~/Report"), cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString() + ".docx"));
// cd.MergeField(docPrintCD);
// cd.TaskCost.MergeField(docPrintCD);
// //il merge con il cost
// try
// {
// cd.TaskCost.ProductPartTask.ProductPart.MergeField(docPrintCD);
// }
// catch
// { }
// docMain.InsertDocument(docPrintCD);
// docPrintCD.Dispose();
// }
// else
// {
// }
// // docMain.InsertDocument(docCost);
// }
// //}
// //catch
// //{ }
// // docCost.Dispose();
// }
// docMain.SaveAs(fileNameSaveAs);
// docMain.Dispose();
// // Open a doc file.
// Application application = new Application();
// Microsoft.Office.Interop.Word.Document document = application.Documents.Open(fileNameSaveAs, OpenAndRepair: true);
// Object fnsa = (Object)fileNameSaveAsAfterRepair;
// // Object of Missing "Null Value".
// Object oMissing = System.Reflection.Missing.Value;
// // Object of false.
// Object oFalse = false;
// // Save the document.
// document.SaveAs
// (
// ref fnsa, ref oMissing, ref oMissing, ref oMissing,
// ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing,
// ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing,
// ref oMissing, ref oMissing
// ); // Close word.
// document.Close();
// application.Quit();
// return File(fileNameSaveAsAfterRepair, "application/file", "stampa.docx");
//}
public ActionResult PrintOrder(string codDocument, string reportName)
{
int id;
var dbName = reportName.Replace("LabelRollHead", "");
//carico l'ordine
Order order = documentRepository.GetAll().OfType<Order>().FirstOrDefault(x => x.CodDocument == codDocument);
//cliente dell'ordine
Customer cust = (Customer)customerSupplierRepository.GetSingle(order.CodCustomer);
order.CustomerSupplier = cust;
//il suo prodotto con la sua quantità
order.OrderProduct = documentRepository.GetDocumentProductByCodDocumentProduct(order.CodDocumentProduct);
//estimate
order.OrderProduct.Document = documentRepository.GetSingle(order.OrderProduct.CodDocument);
string fileNameMain = Path.Combine(Server.MapPath(@"~/Report"), (reportName == "" || reportName == null) ? "OrderHead.docx" : (reportName + ".docx"));
string fileNameCost = Path.Combine(Server.MapPath(@"~/Report"), "Cost" + dbName + ".docx");
if (!System.IO.File.Exists(fileNameCost))
{
fileNameCost = Path.Combine(Server.MapPath(@"~/Report"), "Cost" + ".docx");
}
string retName = order.OrderNumberSerie + "-" + order.OrderNumber;
retName = retName.PurgeFileName();
string fileNameSaveAs = Path.Combine(Server.MapPath(@"~/Report"), retName + dbName + ".docx");
string fileNameSaveAsAfterRepair = fileNameSaveAs;// Path.Combine(Server.MapPath(@"~/Report"), retName + "AfterRepair.docx");
// Store a global reference to the executing assembly.
g_assembly = Assembly.GetExecutingAssembly();
//// Create the document in memory:
var docMain = DocX.Load(fileNameMain);
//questo array mi serve per il merge
Queue<string> files = new Queue<string>();
//questo array mi serve per il merge
Queue<string> filesExtCost = new Queue<string>();
//questo array mi serve per il merge
Queue<string> RepassCost = new Queue<string>();
//questo array mi serve per il merge
Queue<string> filesDelivery = new Queue<string>();
order.MergeField(docMain);
order.OrderProduct.MergeField(docMain);
order.OrderProduct.Product.MergeField(docMain);
var product = productRepository.GetSingle(order.OrderProduct.Product.CodProduct);
product.ProductParts.FirstOrDefault().MergeField(docMain);
try
{
product.ProductParts.FirstOrDefault().productpartprintings.FirstOrDefault().MergeField(docMain);
}
catch (Exception)
{
}
// product.ProductParts.FirstOrDefault().ProductPartPrintableArticles.FirstOrDefault().MergeField(docMain);
var costs = order.OrderProduct.Costs.OrderBy(x => x.IndexOf);
Console.WriteLine(costs);
//group costdetails by taskexecutor
List<CostDetail> costDetails = new List<CostDetail>();
foreach (var item in costs)
{
costDetails.AddRange(item.CostDetails);
}
var TaskExecutorGroups = costDetails.GroupBy(p => p.CodTaskExecutorSelected,
p => p,
(key, g) => new CostDetailGrouped
{
CodTaskExecutorSelected = key,
CostDetails = g.ToList()
});
Console.WriteLine(TaskExecutorGroups);
//end grouping
foreach (var cost in costs)
{
// Create the document in memory:
//var docCost = DocX.Load(fileNameCost);
// cost.MergeField(docCost);
//try
//{
var cd = cost.CostDetails.FirstOrDefault();
if (cd != null)
{
cd = costDetailRepository.GetSingle(cd.CodCostDetail);
cd.InitCostDetail(taskExecutorRepository.GetAll(), articleRepository.GetAll());
if (cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString() == "PrintedRollArticleCostDetail" ||
cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString() == "PrintingZRollCostDetail" ||
cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString() == "PrintedSheetArticleCostDetail" ||
cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString() == "PrintingSheetCostDetail" ||
cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString() == "ControlTableCostDetail")
{
#region SingleCostDetail
var cDFileName = Path.Combine(Server.MapPath(@"~/Report"), cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString() + dbName + ".docx");
if (!System.IO.File.Exists(cDFileName))
{
cDFileName = Path.Combine(Server.MapPath(@"~/Report"), cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString() + ".docx");
}
var docPrintCD = DocX.Load(cDFileName);
cd.MergeField(docPrintCD);
cd.TaskCost.MergeField(docPrintCD);
cd.MergeField(docMain);
cd.TaskCost.MergeField(docMain);
try
{
cd.TaskCost.ProductPartTask.ProductPart.MergeField(docPrintCD);
cd.TaskCost.ProductPartTask.ProductPart.MergeField(docMain);
}
catch
{ }
docPrintCD.SaveAs(Path.Combine(Server.MapPath(@"~/Report"), "Cost" + cost.CodCost + ".docx"));
files.Enqueue(Path.Combine(Server.MapPath(@"~/Report"), "Cost" + cost.CodCost + ".docx"));
#region Merge con Docx (vecchio metodo)
//var xxx = DocX.Load(Path.Combine(Server.MapPath(@"~/Report"), "Cost" + cost.CodCost + ".docx"));
//docMain.InsertDocument(xxx);
//docPrintCD.Dispose();
//xxx.Dispose();
#endregion
#endregion
}
else
{
if (!cost.CostDetails.FirstOrDefault().JustPrintedInOrder)
{
if (cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString() == "RepassRollCostDetail")
{
//il ripasso potrebbe includere diverse lavorazioni!!!
//ripassi con macchine uguali ---> unisco e salvo
#region RepassRollCostDetail
//apro l'header dei costi supplementari e lo salvo
var nomeRepass = Path.Combine(Server.MapPath(@"~/Report"), "RepassCostHeader" + order.CodDocument + ".docx");
var docRepassHeaderFile = Path.Combine(Server.MapPath(@"~/Report"), "RepassRollCostHeader" + dbName + ".docx");
if (!System.IO.File.Exists(docRepassHeaderFile))
{
docRepassHeaderFile = Path.Combine(Server.MapPath(@"~/Report"), "RepassRollCostHeader.docx");
}
var docRepassHeader = DocX.Load(docRepassHeaderFile);
//estraggo per macchina
var relatedCostDetails = TaskExecutorGroups.Where(x => x.CodTaskExecutorSelected == cost.CostDetails.FirstOrDefault().CodTaskExecutorSelected).FirstOrDefault().CostDetails;
docRepassHeader.SaveAs(nomeRepass);
files.Enqueue(nomeRepass);
foreach (var i in relatedCostDetails)
{
var docPrePressFile = Path.Combine(Server.MapPath(@"~/Report"), "RepassRollCostDetail" + dbName + ".docx");
if (!System.IO.File.Exists(docPrePressFile))
{
docPrePressFile = Path.Combine(Server.MapPath(@"~/Report"), "RepassRollCostDetail.docx");
}
var docPrePress = DocX.Load(docPrePressFile);
var cv = costDetailRepository.GetSingle(i.CodCost);
var print = true;
if (cv.TaskCost.ProductPartTask != null)
{
print = !cv.TaskCost.ProductPartTask.OptionTypeOfTask.CodOptionTypeOfTask.Contains("_NO");
}
if (cv.TaskCost.ProductTask != null)
{
print = !cv.TaskCost.ProductTask.OptionTypeOfTask.CodOptionTypeOfTask.Contains("_NO");
}
if (print)
{
cv.MergeField(docPrePress);
docPrePress.SaveAs(Path.Combine(Server.MapPath(@"~/Report"), "RepassRollCost" + i.CodCost + ".docx"));
RepassCost.Enqueue(Path.Combine(Server.MapPath(@"~/Report"), "RepassRollCost" + i.CodCost + ".docx"));
}
i.JustPrintedInOrder = true;
}
id = 0;
foreach (var file in RepassCost.Reverse())
{
using (WordprocessingDocument myDoc = WordprocessingDocument.Open(nomeRepass, true))
{
var altChunkId = "AltChunkId" + id++;
Console.WriteLine(altChunkId);
var mainPart = myDoc.MainDocumentPart;
var chunk = mainPart.AddAlternativeFormatImportPart(DocumentFormat.OpenXml.Packaging.AlternativeFormatImportPartType.WordprocessingML, altChunkId);
using (System.IO.FileStream fileStream = System.IO.File.Open(file, System.IO.FileMode.Open))
{
chunk.FeedData(fileStream);
}
var altChunk = new DocumentFormat.OpenXml.Wordprocessing.AltChunk();
altChunk.Id = altChunkId;
var last = mainPart.Document.Body.Elements<DocumentFormat.OpenXml.Wordprocessing.Paragraph>().Last();
mainPart.Document.Body.InsertAfter(altChunk, last);
mainPart.Document.Save();
}
}
#endregion
}
}
var res = cost.CostDetails.FirstOrDefault().TypeOfCostDetail.ToString();
Console.WriteLine(res);
}
// docMain.InsertDocument(docCost);
}
}
#region costi supplementari
//apro l'header dei costi supplementari e lo salvo
var nomeExt = Path.Combine(Server.MapPath(@"~/Report"), "ExtCostHeader" + order.CodDocument + ".docx");
var docECHeaderFile = Path.Combine(Server.MapPath(@"~/Report"), "ExternalCostHeader" + dbName + ".docx");
if (!System.IO.File.Exists(docECHeaderFile))
{
docECHeaderFile = Path.Combine(Server.MapPath(@"~/Report"), "ExternalCostHeader.docx");
}
var docECHeader = DocX.Load(docECHeaderFile);
docECHeader.SaveAs(nomeExt);
files.Enqueue(nomeExt);
//0=incluso, 1=Aux, 2=escluso
var extCost = costs.Where(x => x.TypeOfCalcolous == 1 && (x.Quantity ?? 0) != 0);
//prestampa
foreach (var cost in extCost)
{
var docPrePressFile = Path.Combine(Server.MapPath(@"~/Report"), "ExternalCost" + dbName + ".docx");
if (!System.IO.File.Exists(docPrePressFile))
{
docPrePressFile = Path.Combine(Server.MapPath(@"~/Report"), "ExternalCost.docx");
}
var docPrePress = DocX.Load(docPrePressFile);
cost.MergeField(docPrePress);
docPrePress.SaveAs(Path.Combine(Server.MapPath(@"~/Report"), "ExtCost" + cost.CodCost + ".docx"));
filesExtCost.Enqueue(Path.Combine(Server.MapPath(@"~/Report"), "ExtCost" + cost.CodCost + ".docx"));
}
id = 0;
foreach (var file in filesExtCost.Reverse())
{
using (WordprocessingDocument myDoc = WordprocessingDocument.Open(nomeExt, true))
{
var altChunkId = "AltChunkId" + id++;
Console.WriteLine(altChunkId);
var mainPart = myDoc.MainDocumentPart;
var chunk = mainPart.AddAlternativeFormatImportPart(DocumentFormat.OpenXml.Packaging.AlternativeFormatImportPartType.WordprocessingML, altChunkId);
using (System.IO.FileStream fileStream = System.IO.File.Open(file, System.IO.FileMode.Open))
{
chunk.FeedData(fileStream);
}
var altChunk = new DocumentFormat.OpenXml.Wordprocessing.AltChunk();
altChunk.Id = altChunkId;
var last = mainPart.Document.Body.Elements<DocumentFormat.OpenXml.Wordprocessing.Paragraph>().Last();
mainPart.Document.Body.InsertAfter(altChunk, last);
mainPart.Document.Save();
}
}
#endregion
#region consegne
//apro l'header dei costi supplementari e lo salvo
var nomeDelivery = Path.Combine(Server.MapPath(@"~/Report"), "DeliveryHeader" + order.CodDocument + ".docx");
var docDHeaderFile = Path.Combine(Server.MapPath(@"~/Report"), "DeliveryHeader" + dbName + ".docx");
if (!System.IO.File.Exists(docDHeaderFile))
{
docDHeaderFile = Path.Combine(Server.MapPath(@"~/Report"), "DeliveryHeader.docx");
}
var docDHeader = DocX.Load(docDHeaderFile);
docDHeader.SaveAs(nomeDelivery);
files.Enqueue(nomeDelivery);
#endregion
#region Immagine
//using (MemoryStream ms = new MemoryStream())
//{
// System.Drawing.Image myImg = System.Drawing.Image.FromFile(Path.Combine(Server.MapPath(@"~/Report"), "montaggio.png"));
// myImg.Save(ms, myImg.RawFormat); // Save your picture in a memory stream.
// ms.Seek(0, SeekOrigin.Begin);
// Novacode.Image img = docMain.AddImage(ms); // Create image.
// // Insert an emptyParagraph into this document.
// Novacode.Paragraph p = docMain.InsertParagraph("", false);
// Picture pic1 = img.CreatePicture(); // Create picture.
// // pic1.SetPictureShape(BasicShapes.cube); // Set picture shape (if needed)
// p.InsertPicture(pic1, 0); // Insert picture into paragraph.
//}
#endregion
docMain.SaveAs(fileNameSaveAs);
docMain.Dispose();
id = 0;
foreach (var file in files.Reverse())
{
using (WordprocessingDocument myDoc = WordprocessingDocument.Open(fileNameSaveAs, true))
{
var altChunkId = "AltChunkId" + id++;
Console.WriteLine(altChunkId);
var mainPart = myDoc.MainDocumentPart;
var chunk = mainPart.AddAlternativeFormatImportPart(DocumentFormat.OpenXml.Packaging.AlternativeFormatImportPartType.WordprocessingML, altChunkId);
using (System.IO.FileStream fileStream = System.IO.File.Open(file, System.IO.FileMode.Open))
{
chunk.FeedData(fileStream);
}
var altChunk = new DocumentFormat.OpenXml.Wordprocessing.AltChunk();
altChunk.Id = altChunkId;
var last = mainPart.Document.Body.Elements<DocumentFormat.OpenXml.Wordprocessing.Paragraph>().Last();
mainPart.Document.Body.InsertAfter(altChunk, last);
mainPart.Document.Save();
}
}
//// Open a doc file.
//Application application = new Application();
//Microsoft.Office.Interop.Word.Document document = application.Documents.Open(fileNameSaveAs, OpenAndRepair: true);
//Object fnsa = (Object)fileNameSaveAsAfterRepair;
//// Object of Missing "Null Value".
//Object oMissing = System.Reflection.Missing.Value;
//// Object of false.
//Object oFalse = false;
//// Save the document.
//document.SaveAs
//(
// ref fnsa, ref oMissing, ref oMissing, ref oMissing,
// ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing,
// ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing,
// ref oMissing, ref oMissing
//); // Close word.
//document.Close();
//application.Quit();
return File(fileNameSaveAsAfterRepair, "application/file", retName + ".docx");
}
