public ActionResult RichEditCustomPartial(int?position)
{
ViewData["RTF"] = rtf;
if (position != null)
{
MemoryStream memoryStream = new MemoryStream();
RichEditExtension.SaveCopy("RichEdit", memoryStream, DocumentFormat.Rtf);
memoryStream.Position = 0;
var server = new RichEditDocumentServer();
server.LoadDocument(memoryStream, DocumentFormat.Rtf);
var pos = server.Document.CreatePosition(position.Value);
server.Document.InsertRtfText(pos, rtf);
memoryStream = new MemoryStream();
server.SaveDocument(memoryStream, DocumentFormat.Rtf);
var model = new RichEditData
{
DocumentId = Guid.NewGuid().ToString(),
Document = memoryStream.ToArray(),
DocumentFormat = DocumentFormat.Rtf
};
return(PartialView("_RichEditPartial", model));
}
return(PartialView("_RichEditPartial"));
}
private static void SaveDocument(string dir, RichEditDocumentServer documentServer)
{
var fileName = Path.Combine(dir, $"{Guid.NewGuid()}.docx");
documentServer.SaveDocument(fileName, DocumentFormat.OpenXml);
Process.Start(fileName);
}
private static void ConvertFilesODTtoDOCX(DirectoryInfo directory)
{
RichEditDocumentServer server = new RichEditDocumentServer();
String newName = string.Empty;
server.Options.Export.Html.EmbedImages = true;
foreach (FileInfo file in directory.GetFiles())
{
if (file.Extension.Equals(".odt") || file.Extension.Equals("odt"))
{
server.LoadDocument(@file.FullName, DocumentFormat.OpenDocument);
//Console.WriteLine(file.FullName);
newName = file.Name.Replace(file.Extension, "");
//Console.WriteLine(newName);
server.SaveDocument(directory.FullName + Path.DirectorySeparatorChar + newName, DocumentFormat.OpenXml);
try
{
file.Delete();
}
catch (Exception)
{
//Do nothing
}
}
}
foreach (DirectoryInfo dir in directory.GetDirectories())
{
if (!dir.Name.Equals("TEMPORALES") && !dir.Name.Equals("ERROR_LOGS"))
{
ConvertFilesODTtoDOCX(dir);
}
}
}
static void Main(string[] args)
{
RichEditDocumentServer server = new RichEditDocumentServer();
server.EncryptedFilePasswordRequested += Server_EncryptedFilePasswordRequested;
server.EncryptedFilePasswordCheckFailed += Server_EncryptedFilePasswordCheckFailed;
server.DecryptionFailed += Server_DecryptionFailed;
server.Options.Import.EncryptionPassword = "******";
server.LoadDocument("Documents//testEncrypted.docx");
EncryptionSettings encryptionOptions = new EncryptionSettings();
encryptionOptions.Type = EncryptionType.Strong;
encryptionOptions.Password = "******";
Console.WriteLine("Select the file format: DOCX/DOC");
string answerFormat = Console.ReadLine()?.ToLower();
DocumentFormat documentFormat;
if (answerFormat == "docx")
{
documentFormat = DocumentFormat.OpenXml;
}
else
{
documentFormat = DocumentFormat.Doc;
}
string fileName = String.Format("EncryptedwithNewPassword.{0}", answerFormat);
server.SaveDocument(fileName, documentFormat, encryptionOptions);
Console.WriteLine("The document is saved with new password. Continue? (y/n)");
string answer = Console.ReadLine()?.ToLower();
if (answer == "y")
{
Console.WriteLine("Re-opening the file...");
server.LoadDocument(fileName);
}
if (IsValid == true)
{
server.SaveDocument(fileName, documentFormat);
Process.Start(fileName);
}
}
static void ConvertHTMLtoDOCX(RichEditDocumentServer server)
{
#region #ConvertHTMLtoDOCX
server.LoadDocument("Documents\\TextWithImages.htm");
server.SaveDocument("Document_DOCX.docx", DocumentFormat.OpenXml);
System.Diagnostics.Process.Start("Document_DOCX.docx");
#endregion #ConvertHTMLtoDOCX
}
static void SaveDocument(RichEditDocumentServer wordProcessor)
{
#region #SaveDocument
wordProcessor.Document.AppendDocumentContent("Documents\\Grimm.docx", DocumentFormat.OpenXml);
wordProcessor.SaveDocument("SavedDocument.docx", DocumentFormat.OpenXml);
System.Diagnostics.Process.Start("explorer.exe", "/select," + "SavedDocument.docx");
#endregion #SaveDocument
}
static void BeforeExport(RichEditDocumentServer server)
{
#region #HandleBeforeExportEvent
server.LoadDocument("Documents\\Grimm.docx");
server.BeforeExport += BeforeExportHelper.BeforeExport;
server.SaveDocument("Document_HTML.html", DocumentFormat.Html);
System.Diagnostics.Process.Start("Document_HTML.html");
#endregion #HandleBeforeExportEvent
}
// Start the process by merging main template into the document contained within the resultRichEdit server.
public void Start()
{
// Since the main template contains no merge fields requiring no merge data, provide a fake data source.
// Otherwise mailmerge will not start.
mainRichEdit.Options.MailMerge.DataSource = fakeDataSource;
// Trigger the multistage process. After the first mailmerge the CalculateDocumentVariable event
//for the resultRichEdit server fires.
mainRichEdit.MailMerge(resultRichEdit.Document);
resultRichEdit.SaveDocument("result.docx", DocumentFormat.OpenXml);
}
// Create New Invoice
public void InvoiceCreate(string OrderID)
{
MemoryStream rtfStream = new MemoryStream();
MemoryStream pdfStream = new MemoryStream();
RichEditDocumentServer docServer = new RichEditDocumentServer();
docServer.Document.LoadDocument(Server.MapPath("~/App_Data/WorkDirectory/Invoice.rtf"), DocumentFormat.Rtf);
// Rtf file
Document rtf = docServer.Document;
// Customer's Data
var arrayCustomer = SelectOrder(OrderID);
var arrayOrderDetail = SelectOrderDetails(OrderID);
// Replace Header String
SubDocument header = docServer.Document.Sections[0].BeginUpdateHeader();
header.ReplaceAll("#invoiceid", arrayCustomer[7].ToString(), SearchOptions.WholeWord);
// Replace Fields
rtf.ReplaceAll("#orderid", arrayCustomer[0].ToString(), SearchOptions.WholeWord);
rtf.ReplaceAll("#customerid", arrayCustomer[1].ToString(), SearchOptions.WholeWord);
rtf.ReplaceAll("#date", Convert.ToDateTime(arrayCustomer[2]).ToShortDateString(), SearchOptions.WholeWord);
rtf.ReplaceAll("#customer", arrayCustomer[3].ToString(), SearchOptions.WholeWord);
rtf.ReplaceAll("#address", arrayCustomer[4].ToString().Trim(), SearchOptions.WholeWord);
rtf.ReplaceAll("#email", arrayCustomer[5].ToString().Trim(), SearchOptions.WholeWord);
rtf.ReplaceAll("#phone", arrayCustomer[6].ToString(), SearchOptions.WholeWord);
docServer.SaveDocument(rtfStream, DocumentFormat.Rtf);
docServer.ExportToPdf(pdfStream);
using (SqlConnection con = new SqlConnection(conStr))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
cmd.CommandText = @"insert into Invoices (OrderID, InvoiceRtf, InvoicePdf)
values (@OrderID, @InvoiceRtf, @InvoicePdf)";
cmd.Parameters.AddWithValue("@OrderID", OrderID);
cmd.Parameters.AddWithValue("@InvoiceRtf", SqlDbType.VarBinary).Value = rtfStream.ToArray();
cmd.Parameters.AddWithValue("@InvoicePdf", SqlDbType.VarBinary).Value = pdfStream.ToArray();
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
Stream ConvertWordDocument(Stream inputStream)
{
using (RichEditDocumentServer server = new RichEditDocumentServer()) {
server.LoadDocument(inputStream);
MemoryStream resultStream = new MemoryStream();
server.Options.Export.Html.EmbedImages = true;
server.SaveDocument(resultStream, DevExpress.XtraRichEdit.DocumentFormat.Html);
resultStream.Seek(0, SeekOrigin.Begin);
return(resultStream);
}
}
protected void ASPxRichEdit1_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e)
{
DocumentManager.CloseDocument("testID");
MemoryStream stream = new MemoryStream();
RichEditDocumentServer server = new RichEditDocumentServer();
server.LoadDocument(System.Web.HttpContext.Current.Server.MapPath("Doc 1.docx"), DocumentFormat.OpenXml);
server.Document.AppendDocumentContent(System.Web.HttpContext.Current.Server.MapPath("Doc 2.docx"), DocumentFormat.OpenXml);
server.SaveDocument(stream, DocumentFormat.OpenXml);
stream.Position = 0;
ASPxRichEdit1.Open("testID", DevExpress.XtraRichEdit.DocumentFormat.OpenXml, () => { return(stream); });
}
static void ExportToHTML(RichEditDocumentServer server)
{
#region #ExportDocumentToHTML
server.LoadDocument("Documents\\MovieRentals.docx", DocumentFormat.OpenXml);
string filePath = "Document_HTML.html";
using (FileStream htmlFileStream = new FileStream(filePath, FileMode.Create))
{
server.SaveDocument(htmlFileStream, DocumentFormat.Html);
}
System.Diagnostics.Process.Start(filePath);
#endregion #ExportDocumentToHTML
}
static void Main()
{
#region #inlinepictures
RichEditDocumentServer server = new RichEditDocumentServer();
server.LoadDocument("Texts\\InlinePictures.rtf", DocumentFormat.Rtf);
Document doc = server.Document;
// Insert an image from a file.
DocumentRange rangeFound = doc.FindAll("Visual Studio Magazine", SearchOptions.CaseSensitive)[0];
DocumentPosition pos = doc.Paragraphs[doc.Paragraphs.Get(rangeFound.End).Index + 2].Range.Start;
doc.Images.Insert(pos, DocumentImageSource.FromFile("Pictures\\ReadersChoice.png"));
// Insert an image from a stream.
pos = doc.Paragraphs[4].Range.Start;
string imageToInsert = "information.png";
Assembly a = Assembly.GetExecutingAssembly();
Stream imageStream = a.GetManifestResourceStream("InlinePictures.Resources." + imageToInsert);
doc.Images.Insert(pos, DocumentImageSource.FromStream(imageStream));
// Insert an image using its URI.
string imageUri = "http://i.gyazo.com/798a2ed48a3535c6c8add0ea7a4fc4e6.png";
SubDocument docHeader = doc.Sections[0].BeginUpdateHeader();
docHeader.Images.Append(DocumentImageSource.FromUri(imageUri, server));
doc.Sections[0].EndUpdateHeader(docHeader);
// Insert a barcode.
DevExpress.BarCodes.BarCode barCode = new DevExpress.BarCodes.BarCode();
barCode.Symbology = DevExpress.BarCodes.Symbology.QRCode;
barCode.CodeText = "http://www.devexpress.com";
barCode.CodeBinaryData = System.Text.Encoding.Default.GetBytes(barCode.CodeText);
barCode.Module = 0.5;
SubDocument docFooter = doc.Sections[0].BeginUpdateFooter();
docFooter.Images.Append(barCode.BarCodeImage);
doc.Sections[0].EndUpdateFooter(docFooter);
#endregion #inlinepictures
#region #getimages
// Scale down images in the document body.
ReadOnlyDocumentImageCollection images = server.Document.Images.Get(doc.Range);
for (int i = 0; i < images.Count; i++)
{
images[i].ScaleX /= 4;
images[i].ScaleY /= 4;
}
#endregion #getimages
// Save the resulting document.
server.SaveDocument("InlinePictures.docx", DocumentFormat.OpenXml);
Process.Start("InlinePictures.docx");
}
protected void RichEdit_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e)
{
string path = MapPath(UploadControl.FileSystemSettings.UploadFolder) + "\\" + e.Parameter;
using (MemoryStream stream = new MemoryStream()) {
using (RichEditDocumentServer server = new RichEditDocumentServer()) {
server.LoadDocument(path);
server.SaveDocument(stream, DocumentFormat.OpenXml);
stream.Position = 0;
DocumentManager.CloseDocument(uploadedDocId);
RichEdit.Open(uploadedDocId, DocumentFormat.OpenXml, () => stream);
}
}
File.Delete(path);
}
protected internal MemoryStream ExaminationPlanTemplate()
{
Document doc = reds.Document;
doc.Sections[0].Page.PaperKind = System.Drawing.Printing.PaperKind.A4;
doc.DefaultCharacterProperties.FontSize = 12;
doc.Unit = DevExpress.Office.DocumentUnit.Centimeter;
doc.Sections[0].Margins.Bottom = 2;
doc.Sections[0].Margins.Top = 2;
doc.Sections[0].Margins.Left = 2;
doc.Sections[0].Margins.Right = 2;
doc.Sections[0].Margins.FooterOffset = 0.8F;
doc.Unit = DevExpress.Office.DocumentUnit.Point;
Section firstSection = doc.Sections[0];
SubDocument subdoc = firstSection.BeginUpdateHeader(HeaderFooterType.Primary);
DocumentRange textRange = subdoc.AppendText("Kezelési Terv");
CharacterProperties cp1 = subdoc.BeginUpdateCharacters(textRange);
cp1.Bold = true;
cp1.Italic = true;
cp1.FontSize = 18;
subdoc.EndUpdateCharacters(cp1);
subdoc.Paragraphs[0].Alignment = ParagraphAlignment.Center;
subdoc.Paragraphs[0].LineSpacingType = ParagraphLineSpacing.Sesquialteral;
doc.Sections[0].EndUpdateHeader(subdoc);
doc.Protect("admin");
using (MemoryStream ms = new MemoryStream())
{
reds.SaveDocument(ms, DocumentFormat.OpenXml);
return(ms);
}
}
static void Main(string[] args)
{
SetupSecurityProtocol();
RichEditDocumentServer wordProcessor = new RichEditDocumentServer();
wordProcessor.LoadDocument("Dynamic Content.docx");
InsertDocVariableField(wordProcessor.Document);
wordProcessor.CalculateDocumentVariable += WordProcessor_CalculateDocumentVariable;
wordProcessor.Document.Fields.Update();
wordProcessor.SaveDocument("MergedDocument.docx", DocumentFormat.OpenXml);
Process.Start(new ProcessStartInfo("MergedDocument.docx")
{
UseShellExecute = true
});
}
private Stream ExecuteMerge(string templateName, DocumentFormat documentFormat)
{
Stream result = new MemoryStream();
MailMergeOptions mailMergeOptions = documentServer.CreateMailMergeOptions();
if (templateName == "preview1")
{
documentServer.LoadDocument(Page.MapPath("~/App_Data/InvoicesDetail.rtf"));
List <Invoice> invoices = new List <Invoice>(10);
invoices.Add(new Invoice(0, "Invoice1", 10.0m));
invoices.Add(new Invoice(1, "Invoice2", 15.0m));
invoices.Add(new Invoice(2, "Invoice3", 20.0m));
mailMergeOptions.DataSource = invoices;
}
else if (templateName == "preview2")
{
documentServer.LoadDocument(Page.MapPath("~/App_Data/SamplesDetail.rtf"));
mailMergeOptions.DataSource = ManualDataSet.CreateData().Tables[0];
}
else if (templateName == "all")
{
Stream part1 = ExecuteMerge("preview1", documentFormat);
Stream part2 = ExecuteMerge("preview2", documentFormat);
part1.Seek(0, SeekOrigin.Begin);
part2.Seek(0, SeekOrigin.Begin);
documentServer.LoadDocument(part1, documentFormat);
documentServer.Document.AppendDocumentContent(part2, documentFormat);
documentServer.SaveDocument(result, documentFormat);
return(result);
}
documentServer.Options.MailMerge.ViewMergedData = true;
documentServer.Options.Export.Html.EmbedImages = true;
mailMergeOptions.MergeMode = MergeMode.JoinTables;
documentServer.MailMerge(mailMergeOptions, result, documentFormat);
return(result);
}
private void PerformConversion(string filePath, DocumentFormat sourceFormat, DocumentFormat destFormat)
{
FileStream fsIn = File.OpenRead(filePath);
string outFileName = Path.ChangeExtension(filePath, dictF[destFormat]);
server.LoadDocument(fsIn, sourceFormat);
FileStream fsOut = File.Open(outFileName, FileMode.Create);
if (destFormat == DocumentFormat.Rtf)
{
server.Options.Export.Rtf.Compatibility.DuplicateObjectAsMetafile = false;
}
server.SaveDocument(fsOut, destFormat);
fsIn.Close();
fsOut.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (MemoryStream stream = new MemoryStream()) {
RichEditDocumentServer server = new RichEditDocumentServer();
server.CreateNewDocument();
server.Document.AppendText("Hello world!");
server.Document.Paragraphs.Append();
server.Document.AppendText("Some text...");
server.SaveDocument(stream, DocumentFormat.OpenXml);
stream.Position = 0;
DocumentManager.CloseDocument(documentId);
RichEdit.Open(documentId, DocumentFormat.OpenXml, () => stream);
}
RichEdit.Focus();
}
}
private void button2_Click(object sender, RoutedEventArgs e)
{
#region #richserversave
SubDocument doc = richServer.Document.Sections[0].BeginUpdateFooter();
DocumentRange docRange = doc.InsertText(doc.Range.Start, textBox1.Text);
doc.InsertParagraph(docRange.End);
richServer.Document.Sections[0].EndUpdateFooter(doc);
SaveFileDialog sfdlg = new SaveFileDialog();
sfdlg.DefaultExt = ".docx";
sfdlg.Filter = "Word Document (*.docx)|*.docx";
if (sfdlg.ShowDialog() == true)
{
Stream fs = sfdlg.OpenFile();
richServer.SaveDocument(fs, DocumentFormat.OpenXml);
fs.Close();
}
#endregion #richserversave
}
protected void ASPxRichEdit1_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e)
{
MemoryStream memoryStream = new MemoryStream();
ASPxRichEdit1.SaveCopy(memoryStream, DocumentFormat.Rtf);
memoryStream.Position = 0;
var server = new RichEditDocumentServer();
server.LoadDocument(memoryStream, DocumentFormat.Rtf);
var pos = server.Document.CreatePosition(Convert.ToInt32(e.Parameter));
server.Document.InsertRtfText(pos, rtf);
memoryStream = new MemoryStream();
server.SaveDocument(memoryStream, DocumentFormat.Rtf);
ASPxRichEdit1.Open(Guid.NewGuid().ToString(), DocumentFormat.Rtf, () =>
{
return(memoryStream.ToArray());
});
}
private static string GetHtmlTextFromDocumentServer(string rtfText)
{
if (string.IsNullOrEmpty(rtfText))
{
return("No Data");
}
string htmlText;
using (MemoryStream stream = new MemoryStream()) {
RichEditDocumentServer documentServer = new RichEditDocumentServer();
documentServer.Options.Export.Html.ExportRootTag = DevExpress.XtraRichEdit.Export.Html.ExportRootTag.Body;
documentServer.Options.Export.Html.EmbedImages = true;
documentServer.RtfText = rtfText;
documentServer.SaveDocument(stream, DocumentFormat.Html);
stream.Position = 0;
StreamReader reader = new StreamReader(stream);
htmlText = reader.ReadToEnd();
}
return(htmlText);
}
static void SplitDocument(RichEditDocumentServer wordProcessor)
{
#region #SplitDocument
wordProcessor.LoadDocument("Documents\\Grimm.docx", DocumentFormat.OpenXml);
//Split a document per page
int pageCount = wordProcessor.DocumentLayout.GetPageCount();
for (int i = 0; i < pageCount; i++)
{
DevExpress.XtraRichEdit.API.Layout.LayoutPage layoutPage = wordProcessor.DocumentLayout.GetPage(i);
DevExpress.XtraRichEdit.API.Native.DocumentRange mainBodyRange = wordProcessor.Document.CreateRange(layoutPage.MainContentRange.Start, layoutPage.MainContentRange.Length);
using (RichEditDocumentServer tempServer = new RichEditDocumentServer())
{
tempServer.Document.AppendDocumentContent(mainBodyRange);
//Delete last empty paragraph
tempServer.Document.Delete(tempServer.Document.Paragraphs.First().Range);
//Save the result
string fileName = String.Format("doc{0}.rtf", i);
tempServer.SaveDocument(fileName, DocumentFormat.Rtf);
}
}
System.Diagnostics.Process.Start("explorer.exe", "/select," + "doc0.rtf");
#endregion #SplitDocument
}
private void ExportToDOC(string extension, DocumentFormat df)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.FileName = Environment.CurrentDirectory + "\\" + report.ExportOptions.PrintPreview.DefaultFileName + "." + extension;
sfd.Filter = String.Format("{0} File|*.{0}", extension);
if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
using (RichEditDocumentServer docServer = new RichEditDocumentServer())
using (MemoryStream ms = new MemoryStream()) {
report.ExportToRtf(ms, new RtfExportOptions()
{
ExportMode = RtfExportMode.SingleFile
});
ms.Position = 0;
docServer.LoadDocument(ms, DocumentFormat.Rtf);
docServer.SaveDocument(sfd.FileName, df);
}
if (MessageBox.Show("Would you like to open file exported file?", extension + " export", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
Process.Start(sfd.FileName);
}
}
}
private void NewDocument()
{
RichEditDocumentServer server = new RichEditDocumentServer();
server.Document.Sections[0].Page.Landscape = false;
server.Document.Unit = DevExpress.Office.DocumentUnit.Millimeter;
server.Document.Sections[0].Margins.Left = 0.5f;
server.Document.Sections[0].Margins.Right = 0.5f;
server.Document.Sections[0].Margins.Top = 0.5f;
server.Document.Sections[0].Margins.Bottom = 0.5f;
server.Document.DefaultCharacterProperties.FontName = "Arial";
server.Document.DefaultCharacterProperties.FontSize = 12f;
server.Document.DefaultCharacterProperties.ForeColor = Color.Red;
server.Document.Sections[0].Page.PaperKind = System.Drawing.Printing.PaperKind.Custom;
server.Document.Sections[0].Page.Width = 105f;
server.Document.Sections[0].Page.Height = 297f;
MemoryStream memoryStream = new MemoryStream();
server.SaveDocument(memoryStream, DocumentFormat.Rtf);
ASPxRichEdit1.Open("document" + Guid.NewGuid().ToString(), DocumentFormat.Rtf, () => { return(memoryStream.ToArray()); });
}
private void simpleButton1_Click(object sender, EventArgs e)
{
server.SaveDocument("result.docx", DocumentFormat.OpenXml);
System.Diagnostics.Process.Start("result.docx");
}
private void simpleAction1_Execute_1(object sender, SimpleActionExecuteEventArgs e)
{
MauIn mauIn = (MauIn)View.CurrentObject;
NguoiDung nguoiDung = mauIn.Session.GetObjectByKey <NguoiDung>(SecuritySystem.CurrentUserId);
//Name of files
FileData chungNhan = mauIn.fileMau;
string fileName = chungNhan.FileName;
string fileNameTemp = @"TempFile\" + fileName;
string fileNameSave = @"SaveFile\" + fileName;
//Names of fields in files
//if (nguoiDung.thanhVien.TenNguoiDung != null) ;
string tenNguoiDung = nguoiDung.thanhVien.TenNguoiDung != null? nguoiDung.thanhVien.TenNguoiDung:"";
DateTime _ngaySinh = (DateTime)nguoiDung.thanhVien.ngaySinh;
string ngaySinh = _ngaySinh.ToString("dd-MM-yyyy") != null?_ngaySinh.ToString("dd-MM-yyyy") : "";//Edit format of DateTime
string gioiTinh = nguoiDung.thanhVien.ToString() != null?nguoiDung.thanhVien.ToString() : "";
string MSSV = nguoiDung.thanhVien.MSSV != null ? nguoiDung.thanhVien.MSSV : "";
string khoa = nguoiDung.thanhVien.khoaString != null ? nguoiDung.thanhVien.khoaString : "";
string SDT = nguoiDung.thanhVien.SDT != null ? nguoiDung.thanhVien.SDT : "";
string email = nguoiDung.thanhVien.email != null ? nguoiDung.thanhVien.email : "";
string diaChi = nguoiDung.thanhVien.diaChi != null ? nguoiDung.thanhVien.diaChi : "";
//int soLanIn = nguoiDung.soLanIn;
using (RichEditDocumentServer srv = new RichEditDocumentServer())
{
if (srv.LoadDocument(fileNameTemp, DocumentFormat.OpenXml))
{
Document doc = srv.Document;
//tenNguoiDung
DocumentRange[] ranges = doc.FindAll("<tenNguoiDung>", SearchOptions.None);
for (int i = 0; i < ranges.Length; i++)
{
doc.Replace(ranges[i], tenNguoiDung);
}
//ngaySinh
DocumentRange[] range1s = doc.FindAll("<ngaySinh>", SearchOptions.None);
for (int i = 0; i < range1s.Length; i++)
{
doc.Replace(range1s[i], ngaySinh);
}
//gioiTinh
DocumentRange[] range2s = doc.FindAll("<gioiTinh>", SearchOptions.None);
for (int i = 0; i < range2s.Length; i++)
{
doc.Replace(range2s[i], gioiTinh);
}
//MSSV
DocumentRange[] range3s = doc.FindAll("<MSSV>", SearchOptions.None);
for (int i = 0; i < range3s.Length; i++)
{
doc.Replace(range3s[i], MSSV);
}
//khoa
DocumentRange[] range4s = doc.FindAll("<khoa>", SearchOptions.None);
for (int i = 0; i < range4s.Length; i++)
{
doc.Replace(range4s[i], khoa);
}
//SDT
DocumentRange[] range5s = doc.FindAll("<SDT>", SearchOptions.None);
for (int i = 0; i < range5s.Length; i++)
{
doc.Replace(range5s[i], SDT);
}
//email
DocumentRange[] range6s = doc.FindAll("<email>", SearchOptions.None);
for (int i = 0; i < range6s.Length; i++)
{
doc.Replace(range6s[i], email);
}
//diaChi
DocumentRange[] range7s = doc.FindAll("<diaChi>", SearchOptions.None);
for (int i = 0; i < range7s.Length; i++)
{
doc.Replace(range7s[i], diaChi);
}
}
srv.SaveDocument(fileNameSave, DocumentFormat.OpenXml);
//srv.Document.Sections[0].Page.Landscape = true;
//DevExpress.XtraPrinting.PrintableComponentLink link = new DevExpress.XtraPrinting.PrintableComponentLink(new DevExpress.XtraPrinting.PrintingSystem());
if (nguoiDung.soLanIn > 0)
{
srv.Print();
nguoiDung.soLanIn--;
MessageBox.Show("You have " + nguoiDung.soLanIn.ToString() + " more time(s) to PRINT");
nguoiDung.Save();// lưu lại giá trị
}
else
{
MessageBox.Show("Your print time has run out!");
}
//FileStream fsOut = File.Open("FileOut.pdf", FileMode.Create);
//srv.ExportToPdf(fsOut);
//fsOut.Close();
}
//RichEditDocumentServer srv1 = new RichEditDocumentServer();
//srv1.LoadDocument(fileNameTemp, DocumentFormat.OpenXml);
//DevExpress.XtraPrinting.PdfExportOptions options = new DevExpress.XtraPrinting.PdfExportOptions();
//options.Compressed = false;
//options.ImageQuality = DevExpress.XtraPrinting.PdfJpegImageQuality.Highest;
//FileStream pdfFileStream = new FileStream("Document_PDF.pdf", FileMode.Create);
//srv1.ExportToPdf(pdfFileStream, options);
//System.Diagnostics.Process.Start("Document_PDF.pdf");
//System.Diagnostics.Process.Start(fileNameSave);
//FileAttachmentsWindowsFormsModule.GetFileDataManager(Application).Open(chungNhan);//Open FileData
//PreviewPrint previewPrintWindow = new PreviewPrint();
//previewPrintWindow.ShowDialog();
}
public void CorrePlantilla1(string IdCliente, string archivo)
{
try
{
string CodigoCliente = AccesoDatos.RegresaCadena_1_ResultadoSql("Select cliente from CartasClientes where indice = " + IdCliente);
Object oMissing = System.Reflection.Missing.Value;
string carta = AccesoDatos.RegresaCadena_1_ResultadoSql("Select tipo_carta from CartasClientes where indice = " + IdCliente);
try
{
Object oTemplatePath = Direccion(archivo, carta);
RichEditDocumentServer wordDoc = new RichEditDocumentServer();
wordDoc.LoadDocument(oTemplatePath.ToString());
DocumentPosition pos = wordDoc.Document.CreatePosition(60);
string CodigoImagen = AccesoDatos.RegresaCadena_1_ResultadoSql("Select codigo from CartasClientes where indice = " + IdCliente);
Image DataImage = DevuelveImagen(CodigoImagen);
string path = HttpContext.Current.Server.MapPath("~/Files/Copies/" + CodigoImagen + ".bmp");
DataImage.Save(path);
wordDoc.Document.InsertImage(pos, DataImage);
var input = "";
var format = "dddd, MMMM dd, yyyy";
string _poliza = "";
string parrafo1, parrafo2, parrafo3 = "";
string _tituloCarta = "";
System.Data.DataTable poliza = AccesoDatos.RegresaTablaSql("Select * from CartasClientes where indice = " + IdCliente);
foreach (System.Data.DataRow rw in poliza.Rows)
{
DateTime FechaT = DateTime.Parse(rw["Fecha"].ToString());
string _Fecha = FechaT.ToString(format, new CultureInfo("es-ES"));
//_Fecha = _Fecha.Substring(0, 1).ToUpper() + _Fecha.Substring(1, _Fecha.Length - 1);
_Fecha = _Fecha.Replace("enero", "Enero").Replace("febrero", "Febrero").Replace("marzo", "Marzo").Replace("abril", "Abril").Replace("mayo", "Mayo").Replace("junio", "Junio").Replace("julio", "Julio").Replace("agosto", "Agosto").Replace("septiembre", "Septiembre").Replace("octubre", "Octubre").Replace("noviembre", "Noviembre").Replace("diciembre", "Diciembre");
_Fecha = _Fecha.Replace("lunes,", "").Replace("martes,", "").Replace("miercoles,", "").Replace("jueves,", "").Replace("viernes,", "").Replace("sabado,", "").Replace("domingo,", "");
_Fecha = "Guatemala, " + _Fecha + ".";
wordDoc.Document.ReplaceAll("{Fecha}", _Fecha, SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Titulo}", rw["Titulo"].ToString(), SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{NombreCompleto}", rw["NombreCompleto"].ToString(), SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Nombre}", rw["NombreCompleto"].ToString(), SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Direccion}", rw["direccion"].ToString(), SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Apartado}", rw["Apartado"].ToString(), SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{PolizasEjecutivo}", rw["poliza"].ToString(), SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Asistente}", rw["asistente"].ToString(), SearchOptions.WholeWord);
parrafo1 = rw["parrafo1"].ToString().Trim();
parrafo2 = rw["parrafo2"].ToString().Trim();
parrafo3 = rw["parrafo3"].ToString().Trim();
_tituloCarta = rw["TituloPagina"].ToString().Trim();
if (parrafo1 == "")
{
parrafo1 = AccesoDatos.RegresaCadena_1_ResultadoSql("Select ParrafoDefault1 from CartasClientes_Default where NombreCarta = '" + rw["tipo_carta"].ToString() + "'");
}
if (parrafo2 == "")
{
parrafo2 = AccesoDatos.RegresaCadena_1_ResultadoSql("Select ParrafoDefault2 from CartasClientes_Default where NombreCarta = '" + rw["tipo_carta"].ToString() + "'");
}
if (parrafo3 == "")
{
parrafo3 = AccesoDatos.RegresaCadena_1_ResultadoSql("Select ParrafoDefault3 from CartasClientes_Default where NombreCarta = '" + rw["tipo_carta"].ToString() + "'");
}
if (_tituloCarta == "")
{
_tituloCarta = AccesoDatos.RegresaCadena_1_ResultadoSql("Select titulo from CartasClientes_Default where NombreCarta = '" + rw["tipo_carta"].ToString() + "'");
}
wordDoc.Document.ReplaceAll("{TITULO CARTA}", _tituloCarta, SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Parrafo1}", parrafo1, SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Parrafo2}", parrafo2, SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Parrafo3}", parrafo3, SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{bien}", rw["bien"].ToString(), SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Poliza}", rw["poliza"].ToString(), SearchOptions.WholeWord);
_poliza = rw["poliza"].ToString();
wordDoc.Document.ReplaceAll("{aseguradora}", rw["aseguradora"].ToString(), SearchOptions.WholeWord);
string fechavence = rw["vence"].ToString();
if (fechavence.Length > 10)
{
wordDoc.Document.ReplaceAll("{vence}", rw["vence"].ToString().Substring(0, 10), SearchOptions.WholeWord);
}
else
{
wordDoc.Document.ReplaceAll("{vence}", fechavence, SearchOptions.WholeWord);
}
wordDoc.Document.ReplaceAll("{endoso}", rw["endoso"].ToString(), SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Requerimiento}", rw["requerimiento"].ToString(), SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{firma}", rw["firma"].ToString(), SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{correo}", rw["correo"].ToString(), SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{firma_administrativa}", rw["firma_administrativa"].ToString(), SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{correo_administrativa}", rw["correo_administrativa"].ToString(), SearchOptions.WholeWord);
break;
}
wordDoc.Document.ReplaceAll("{Fecha}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Titulo}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{NombreCompleto}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Direccion}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Apartado}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{PolizasEjecutivo}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Asistente}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Parrafo1}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Parrafo2}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Parrafo3}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{bien}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{PolizasEjecutivo}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{aseguradora}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{vence}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{endoso}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Requerimiento}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{firma}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{correo}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{firma_administrativa}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{correo_administrativa}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Nombre}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{TITULO CARTA}", "", SearchOptions.WholeWord);
wordDoc.Document.ReplaceAll("{Doc}", "Doc corr." + IdCliente, SearchOptions.WholeWord);
if (carta == "Envío de Documentos")
{
int filas = Int32.Parse(AccesoDatos.RegresaCadena_1_ResultadoSql("select count(*) from asegurado where poliza = '" + _poliza + "'"));
if (filas > 0)
{
TablaDoc(ref wordDoc, filas, _poliza);
wordDoc.Document.ReplaceAll("{grilla}", "", SearchOptions.WholeWord);
}
else
{
wordDoc.Document.ReplaceAll("{grilla}", "No tiene asegurados.", SearchOptions.WholeWord);
}
}
wordDoc.Document.Protect("UnitySecure");
wordDoc.SaveDocument(path.Replace(".bmp", ".docx"), DocumentFormat.OpenXml);
wordDoc.Dispose();
DataImage.Dispose();
System.GC.Collect();
}
catch (Exception es)
{
Helper.RegistrarEvento("Cargando el documento : " + es.Message);
}
}
catch (Exception ex)
{
Helper.RegistrarEvento(ex.Message);
}
}
private void btnRun_Click(object sender, EventArgs e)
{
wordProcessor.SaveDocument("Result.docx", DocumentFormat.OpenXml);
Process.Start("Result.docx");
}
