private void CreateSignature(RadFlowDocumentEditor editor)
{
Table signatureTable = editor.InsertTable(1, 2);
signatureTable.Rows[0].Cells[0].Borders = new TableCellBorders(
new Border(BorderStyle.None),
new Border(BorderStyle.None),
new Border(4, BorderStyle.Single, GreenColor),
new Border(BorderStyle.None));
// Create paragraph with image
signatureTable.Rows[0].Cells[0].PreferredWidth = new TableWidthUnit(140);
Paragraph paragraphWithImage = signatureTable.Rows[0].Cells[0].Blocks.AddParagraph();
paragraphWithImage.Spacing.SpacingAfter = 0;
editor.MoveToParagraphStart(paragraphWithImage);
using (Stream stream = FileHelper.GetSampleResourceStream("TelerikLogoSmall.png"))
{
editor.InsertImageInline(stream, "png", new Size(118, 42));
}
// Create cell with name and position
signatureTable.Rows[0].Cells[1].PreferredWidth = new TableWidthUnit(140);
signatureTable.Rows[0].Cells[1].Padding = new Documents.Primitives.Padding(12, 0, 0, 0);
Paragraph cellParagraph = signatureTable.Rows[0].Cells[1].Blocks.AddParagraph();
cellParagraph.Spacing.SpacingAfter = 0;
editor.MoveToParagraphStart(cellParagraph);
editor.CharacterFormatting.FontSize.LocalValue = 12;
editor.InsertText("Jane Doe").FontWeight = FontWeights.Bold;
editor.InsertParagraph().Spacing.SpacingAfter = 0;
editor.InsertText("Support Officer");
}
private void CreateSignature(RadFlowDocumentEditor editor)
{
Table signatureTable = editor.InsertTable(1, 2);
signatureTable.Rows[0].Cells[0].Borders = new TableCellBorders(
new Border(BorderStyle.None),
new Border(BorderStyle.None),
new Border(4, BorderStyle.Single, greenColor),
new Border(BorderStyle.None));
// Create paragraph with image
signatureTable.Rows[0].Cells[0].PreferredWidth = new TableWidthUnit(140);
Paragraph paragraphWithImage = signatureTable.Rows[0].Cells[0].Blocks.AddParagraph();
paragraphWithImage.Spacing.SpacingAfter = 0;
editor.MoveToParagraphStart(paragraphWithImage);
using (Stream stream = File.OpenRead(this.sampleDataFolder + "Telerik_logo.png"))
{
editor.InsertImageInline(stream, "png", new Size(118, 28));
}
// Create cell with name and position
signatureTable.Rows[0].Cells[1].Padding = new Telerik.Windows.Documents.Primitives.Padding(12, 0, 0, 0);
Paragraph cellParagraph = signatureTable.Rows[0].Cells[1].Blocks.AddParagraph();
cellParagraph.Spacing.SpacingAfter = 0;
editor.MoveToParagraphStart(cellParagraph);
editor.CharacterFormatting.FontSize.LocalValue = 12;
editor.InsertText("Jane Doe").FontWeight = FontWeights.Bold;
editor.InsertParagraph().Spacing.SpacingAfter = 0;
editor.InsertText("Support Officer");
}
private RadFlowDocument CreateDocument()
{
RadFlowDocument document = new RadFlowDocument();
RadFlowDocumentEditor editor = new RadFlowDocumentEditor(document);
editor.ParagraphFormatting.TextAlignment.LocalValue = Alignment.Justified;
Table bodyTable = editor.InsertTable(1, 2);
Paragraph paragraphWithText = bodyTable.Rows[0].Cells[0].Blocks.AddParagraph();
editor.MoveToParagraphStart(paragraphWithText);
editor.InsertLine("Dear Telerik User,");
editor.InsertLine("We're happy to introduce the Telerik RadWordsProcessing component. High performance library that enables you to read, write and manipulate documents in DOCX, RTF, HTML and plain text format.");
editor.InsertText("The current beta version comes with full rich-text capabilities including ");
editor.InsertText("bold, ").FontWeight = FontWeights.Bold;
editor.InsertText("italic, ").FontStyle = FontStyles.Italic;
Run underlined = editor.InsertText("underline,");
underlined.Underline.Pattern = UnderlinePattern.Dotted;
underlined.Underline.Color = new ThemableColor(Colors.Black);
editor.InsertText(" font sizes and ").FontSize = 20;
editor.InsertText("colors ").ForegroundColor = GreenColor;
editor.InsertLine("as well as text alignment and indentation. Other options include tables, lists, hyperlinks, bookmarks and comments, inline and floating images. Even more sweetness is added by the built-in styles and themes.");
editor.InsertLine("We hope you'll enjoy RadWordsProcessing as much as we do. Happy coding!");
editor.InsertParagraph().Spacing.SpacingAfter = 0;
editor.InsertLine("Regards,");
editor.InsertHyperlink("Telerik Team ", "http://www.telerik.com", false, "Telerik Site");
Paragraph paragraphWithImage = bodyTable.Rows[0].Cells[1].Blocks.AddParagraph();
editor.MoveToParagraphStart(paragraphWithImage);
#if NETCOREAPP
using (Stream stream = File.OpenRead(SampleDataFolder + "WordsProcessing.jpg"))
{
editor.InsertImageInline(stream, "jpg", new Size(470, 261));
}
#else
using (Stream stream = File.OpenRead(SampleDataFolder + "WordsProcessing.png"))
{
editor.InsertImageInline(stream, "png", new Size(470, 261));
}
#endif
return(document);
}
private void CreateFooter(RadFlowDocumentEditor editor)
{
Footer footer = editor.Document.Sections.First().Footers.Add();
Paragraph paragraph = footer.Blocks.AddParagraph();
paragraph.TextAlignment = Alignment.Right;
editor.MoveToParagraphStart(paragraph);
}
private void CreateHeader(RadFlowDocumentEditor editor)
{
Header header = editor.Document.Sections.First().Headers.Add();
editor.MoveToParagraphStart(header.Blocks.AddParagraph());
using (Stream stream = File.OpenRead(sampleDataFolder + "Telerik_develop_experiences.png"))
{
editor.InsertImageInline(stream, "png", new Size(660, 237));
}
}
private void CreateFooter(RadFlowDocumentEditor editor)
{
if (this.IncludeFooter)
{
Footer footer = editor.Document.Sections.First().Footers.Add();
Paragraph paragraph = footer.Blocks.AddParagraph();
paragraph.TextAlignment = Alignment.Right;
editor.MoveToParagraphStart(paragraph);
editor.InsertHyperlink("telerik.com", "http://www.telerik.com", false, "Telerik Site");
}
}
private void CreateHeader(RadFlowDocumentEditor editor)
{
if (this.IncludeHeader)
{
Header header = editor.Document.Sections.First().Headers.Add();
editor.MoveToParagraphStart(header.Blocks.AddParagraph());
using (Stream stream = FileHelper.GetSampleResourceStream("Telerik_develop_experiences.png"))
{
editor.InsertImageInline(stream, "png", new Size(660, 237));
}
}
}
private void InsertFieldInFragment(RadFlowDocumentEditor editor, RadFlowDocument document)
{
#region radwordsprocessing-editing-radflowdocumenteditor_7
// Create header and move the editor
Header header = document.Sections[0].Headers.Add();
editor.MoveToParagraphStart(header.Blocks.AddParagraph());
editor.InsertText("Page ");
editor.InsertField("PAGE", "1");
editor.InsertText(" of ");
editor.InsertField("NUMPAGES", "1");
#endregion
}
private void CreateHeader(RadFlowDocumentEditor editor)
{
if (this.IncludeHeader)
{
Header header = editor.Document.Sections.First().Headers.Add();
editor.MoveToParagraphStart(header.Blocks.AddParagraph());
using (Stream stream = this.resourceService.GetResourceStream("telerikLogo.jpg"))
{
editor.InsertImageInline(stream, "png", new Telerik.Documents.Primitives.Size(660, 265));
}
}
}
private void CreateSignature(RadFlowDocumentEditor editor)
{
Table signatureTable = editor.InsertTable(1, 2);
signatureTable.Rows[0].Cells[0].Borders = new TableCellBorders(
new Border(BorderStyle.None),
new Border(BorderStyle.None),
new Border(4, BorderStyle.Single, GreenColor),
new Border(BorderStyle.None));
signatureTable.Rows[0].Cells[0].PreferredWidth = new TableWidthUnit(140);
Paragraph paragraphWithImage = signatureTable.Rows[0].Cells[0].Blocks.AddParagraph();
paragraphWithImage.Spacing.SpacingAfter = 0;
editor.MoveToParagraphStart(paragraphWithImage);
using (Stream stream = this.resourceService.GetResourceStream("telerikLogo.jpg"))
{
editor.InsertImageInline(stream, "png", new Telerik.Documents.Primitives.Size(93, 42));
}
signatureTable.Rows[0].Cells[1].PreferredWidth = new TableWidthUnit(140);
signatureTable.Rows[0].Cells[1].Padding = new Padding(12, 0, 0, 0);
Paragraph cellParagraph = signatureTable.Rows[0].Cells[1].Blocks.AddParagraph();
cellParagraph.Spacing.SpacingAfter = 0;
editor.MoveToParagraphStart(cellParagraph);
editor.CharacterFormatting.FontSize.LocalValue = 12;
editor.InsertText("Jane Doe").FontWeight = FontWeights.Bold;
editor.InsertParagraph().Spacing.SpacingAfter = 0;
editor.InsertText("Support Officer");
}
private void SetupAndInsertSdt(RadFlowDocumentEditor editor, InlineBase inline, string text, SdtType sdtType, DocumentElementBase start = null, DocumentElementBase end = null)
{
if (sdtType == SdtType.RepeatingSection)
{
editor.MoveToParagraphStart(inline.Paragraph);
}
else
{
editor.MoveToInlineStart(inline);
}
SdtProperties sdt = new SdtProperties(sdtType)
{
// All SDTs should not allow deleting them
Lock = Lock.SdtLocked
};
if (!string.IsNullOrEmpty(text))
{
// Add a placeholder if text for it is available.
sdt.Placeholder = new Placeholder()
{
PlaceholderText = text,
ShowPlaceholder = true
};
}
if (start == null)
{
editor.InsertStructuredDocumentTag(sdt);
}
else
{
end = end ?? start;
editor.InsertStructuredDocumentTag(sdt, start, end);
}
}
private void CreateHeader(RadFlowDocumentEditor editor)
{
if (this.IncludeHeader)
{
Header header = editor.Document.Sections.First().Headers.Add();
editor.MoveToParagraphStart(header.Blocks.AddParagraph());
using (Stream stream = FileHelper.GetSampleResourceStream("TelerikLogo.png"))
{
editor.InsertImageInline(stream, "png", new Size(660, 265));
}
}
}
private void CreateFooter(RadFlowDocumentEditor editor)
{
if (this.IncludeFooter)
{
Footer footer = editor.Document.Sections.First().Footers.Add();
Paragraph paragraph = footer.Blocks.AddParagraph();
paragraph.TextAlignment = Alignment.Right;
editor.MoveToParagraphStart(paragraph);
editor.InsertHyperlink("telerik.com", "http://www.telerik.com", false, "Telerik Site");
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
try {
DocumentReplacemetsController cont = new DocumentReplacemetsController();
List <DocumentReplacemetB> reps = new List <DocumentReplacemetB>();
reps = cont.GetDocumentReplacemets(sqlUniqueName);
string imgFolderPath = Server.MapPath(fileUploadFolder);
DocumentReplacemetB curRep;
BookmarkRangeStart bookmarkRangeStart;
RadFlowDocument curDoc = LoadSampleDocument(sqlUniqueName);
RadFlowDocumentEditor editor = new RadFlowDocumentEditor(curDoc);
//System.Text.RegularExpressions.Regex textRegex = new System.Text.RegularExpressions.Regex("ΣΑΟΥΣΟΠΟΥΛΟΥ ΑΝΝΑ");
//editor.ReplaceText("ΣΑΟΥΣΟΠΟΥΛΟΥ ΑΝΝΑ", txtNew.Text, true, true);
List <BookmarkRangeStart> test = editor.Document.EnumerateChildrenOfType <BookmarkRangeStart>().ToList();
Telerik.Windows.Documents.Flow.Model.TableCell currCell;
Run currRun;
Header defaultHeader = editor.Document.Sections.First().Headers.Default;
Footer defaultFooter = editor.Document.Sections.First().Footers.Default;
//Telerik.Windows.Documents.Flow.Model.Table headerTable = defaultHeader.Blocks.OfType<Telerik.Windows.Documents.Flow.Model.Table>().First();
//Telerik.Windows.Documents.Flow.Model.TableCell firstCell = headerTable.Rows[0].Cells[0];
Telerik.Windows.Documents.Flow.Model.Styles.Style tableStyle = new Telerik.Windows.Documents.Flow.Model.Styles.Style("TableStyle", StyleType.Table);
tableStyle.Name = "Table Style";
tableStyle.TableProperties.Borders.LocalValue = new TableBorders(new Border(1, Telerik.Windows.Documents.Flow.Model.Styles.BorderStyle.Single, new ThemableColor(System.Windows.Media.Colors.Black)));
tableStyle.TableProperties.Alignment.LocalValue = Alignment.Left;
tableStyle.TableCellProperties.VerticalAlignment.LocalValue = VerticalAlignment.Center;
tableStyle.TableCellProperties.PreferredWidth.LocalValue = new TableWidthUnit(TableWidthUnitType.Percent, 100);
tableStyle.TableCellProperties.Padding.LocalValue = new Telerik.Windows.Documents.Primitives.Padding(8);
editor.Document.StyleRepository.Add(tableStyle);
curRep = reps.Find(o => o.UniqueName == "KET_Header_OTELogo");
currCell = (Telerik.Windows.Documents.Flow.Model.TableCell)test.Where(o => o.Bookmark.Name == curRep.BookmarkTitle).FirstOrDefault().Paragraph.BlockContainer;
using (Stream firstImage = File.OpenRead(imgFolderPath + curRep.Text)) {
var inImage = ((Paragraph)currCell.Blocks.First()).Inlines.AddImageInline();
inImage.Image.ImageSource = new Telerik.Windows.Documents.Media.ImageSource(firstImage, curRep.Text.Split('.').Last());
if (curRep.ImageHeight != null && curRep.ImageWidth != null)
{
inImage.Image.Height = curRep.ImageHeight.Value;
inImage.Image.Width = curRep.ImageWidth.Value;
}
}
curRep = reps.Find(o => o.UniqueName == "KET_Header_OTEMoto");
currCell = (Telerik.Windows.Documents.Flow.Model.TableCell)test.Where(o => o.Bookmark.Name == curRep.BookmarkTitle).FirstOrDefault().Paragraph.BlockContainer;
currRun = ((Paragraph)currCell.Blocks.First()).Inlines.AddRun();
currRun.Text = curRep.Text;
currRun.Properties.FontFamily.LocalValue = new ThemableFontFamily("Arial");
currRun.Properties.FontSize.LocalValue = 13.0;
currRun.Properties.FontWeight.LocalValue = FontWeights.Normal;
currRun.Properties.FontStyle.LocalValue = FontStyles.Normal;
curRep = reps.Find(o => o.UniqueName == "KET_Header_Title");
currCell = (Telerik.Windows.Documents.Flow.Model.TableCell)test.Where(o => o.Bookmark.Name == curRep.BookmarkTitle).FirstOrDefault().Paragraph.BlockContainer;
currRun = ((Paragraph)currCell.Blocks.First()).Inlines.AddRun();
currRun.Text = curRep.Text;
currRun.Properties.FontFamily.LocalValue = new ThemableFontFamily("Arial");
currRun.Properties.FontSize.LocalValue = 15.0;
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currRun.Properties.FontStyle.LocalValue = FontStyles.Normal;
curRep = reps.Find(o => o.UniqueName == "KET_Header_Department");
currCell = (Telerik.Windows.Documents.Flow.Model.TableCell)test.Where(o => o.Bookmark.Name == curRep.BookmarkTitle).FirstOrDefault().Paragraph.BlockContainer;
string[] arrText = curRep.Text.Replace("\r\n", "#").Replace("\n", "#").Split(new char[] { '#' });
Paragraph newPar = (Paragraph)currCell.Blocks.First();
newPar.Properties.TextAlignment.LocalValue = Alignment.Center;
editor.MoveToInlineStart(((Paragraph)currCell.Blocks.First()).Inlines.First());
for (int i = 0; i < arrText.Length; i++)
{
currRun = editor.InsertLine(arrText[i]);
currRun.Paragraph.Properties.TextAlignment.LocalValue = Alignment.Center;
currRun.Properties.FontFamily.LocalValue = new ThemableFontFamily("Times New Roman");
currRun.Properties.FontSize.LocalValue = 15.0;
currRun.Properties.FontWeight.LocalValue = FontWeights.Normal;
currRun.Properties.FontStyle.LocalValue = FontStyles.Normal;
}
currCell.Blocks.Remove(currCell.Blocks.Last());
curRep = reps.Find(o => o.UniqueName == "KET_Header_EDEPPOI");
currCell = (Telerik.Windows.Documents.Flow.Model.TableCell)test.Where(o => o.Bookmark.Name == curRep.BookmarkTitle).FirstOrDefault().Paragraph.BlockContainer;
currRun = ((Paragraph)currCell.Blocks.First()).Inlines.AddRun();
currRun.Text = curRep.Text;
currRun.Properties.FontFamily.LocalValue = new ThemableFontFamily("Arial");
currRun.Properties.FontSize.LocalValue = 15.0;
currRun.Properties.FontWeight.LocalValue = FontWeights.Normal;
currRun.Properties.FontStyle.LocalValue = FontStyles.Normal;
curRep = reps.Find(o => o.UniqueName == "KET_Header_PageNo");
currCell = (Telerik.Windows.Documents.Flow.Model.TableCell)test.Where(o => o.Bookmark.Name == curRep.BookmarkTitle).FirstOrDefault().Paragraph.BlockContainer;
editor.MoveToParagraphStart((Paragraph)currCell.Blocks.First());
editor.InsertText("ΣΕΛΙΔΑ ");
editor.InsertField("PAGE", "3");
if (curRep.Text == "Σελίδα Χ από Υ")
{
editor.InsertText(" ΑΠΟ ");
editor.InsertField("NUMPAGES", "5");
}
curRep = reps.Find(o => o.UniqueName == "KET_Header_Date");
bookmarkRangeStart = defaultHeader.EnumerateChildrenOfType <BookmarkRangeStart>().Where(rangeStart => rangeStart.Bookmark.Name == curRep.BookmarkTitle).FirstOrDefault();
editor.MoveToInlineEnd(bookmarkRangeStart);
editor.InsertText(DateTime.Now.ToString(curRep.Text, new System.Globalization.CultureInfo("el-GR")));
curRep = reps.Find(o => o.UniqueName == "KET_Header_To");
bookmarkRangeStart = defaultHeader.EnumerateChildrenOfType <BookmarkRangeStart>().Where(rangeStart => rangeStart.Bookmark.Name == curRep.BookmarkTitle).FirstOrDefault();
editor.MoveToInlineEnd(bookmarkRangeStart);
editor.InsertText(curRep.Text);
curRep = reps.Find(o => o.UniqueName == "KET_Footer_OTELogo");
currCell = (Telerik.Windows.Documents.Flow.Model.TableCell)test.Where(o => o.Bookmark.Name == curRep.BookmarkTitle).FirstOrDefault().Paragraph.BlockContainer;
using (Stream firstImage = File.OpenRead(imgFolderPath + curRep.Text)) {
var inImage = ((Paragraph)currCell.Blocks.First()).Inlines.AddImageInline();
inImage.Image.ImageSource = new Telerik.Windows.Documents.Media.ImageSource(firstImage, curRep.Text.Split('.').Last());
if (curRep.ImageHeight != null && curRep.ImageWidth != null)
{
inImage.Image.Height = curRep.ImageHeight.Value;
inImage.Image.Width = curRep.ImageWidth.Value;
}
}
curRep = reps.Find(o => o.UniqueName == "KET_Footer_ELOT");
currCell = (Telerik.Windows.Documents.Flow.Model.TableCell)test.Where(o => o.Bookmark.Name == curRep.BookmarkTitle).FirstOrDefault().Paragraph.BlockContainer;
using (Stream firstImage = File.OpenRead(imgFolderPath + curRep.Text)) {
var inImage = ((Paragraph)currCell.Blocks.First()).Inlines.AddImageInline();
inImage.Image.ImageSource = new Telerik.Windows.Documents.Media.ImageSource(firstImage, curRep.Text.Split('.').Last());
if (curRep.ImageHeight != null && curRep.ImageWidth != null)
{
inImage.Image.Height = curRep.ImageHeight.Value;
inImage.Image.Width = curRep.ImageWidth.Value;
}
}
List <TaskForH> lstDummy = createDummyList();
bookmarkRangeStart = editor.Document.EnumerateChildrenOfType <BookmarkRangeStart>().Where(rangeStart => rangeStart.Bookmark.Name == "Body_Main").FirstOrDefault();
editor.MoveToInlineEnd(bookmarkRangeStart);
Telerik.Windows.Documents.Flow.Model.Table tblContent = editor.InsertTable();
tblContent.StyleId = "TableStyle";
tblContent.LayoutType = TableLayoutType.AutoFit;
ThemableColor cellBackground = new ThemableColor(System.Windows.Media.Colors.Beige);
for (int i = 0; i < lstDummy.Count; i++)
{
Telerik.Windows.Documents.Flow.Model.TableRow row = tblContent.Rows.AddTableRow();
for (int j = 0; j < 5; j++)
{
Telerik.Windows.Documents.Flow.Model.TableCell cell = row.Cells.AddTableCell();
if (i == 0)
{
if (j == 0)
{
currRun = cell.Blocks.AddParagraph().Inlines.AddRun("A/A");
currRun.Properties.FontFamily.LocalValue = new ThemableFontFamily("Arial");
currRun.Properties.FontSize.LocalValue = 15.0;
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currRun.Properties.FontStyle.LocalValue = FontStyles.Normal;
cell.PreferredWidth = new TableWidthUnit(TableWidthUnitType.Percent, 5);
}
else if (j == 1)
{
currRun = cell.Blocks.AddParagraph().Inlines.AddRun("ΑΙΤΩΝ");
currRun.Properties.FontFamily.LocalValue = new ThemableFontFamily("Arial");
currRun.Properties.FontSize.LocalValue = 15.0;
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currRun.Properties.FontStyle.LocalValue = FontStyles.Normal;
cell.PreferredWidth = new TableWidthUnit(TableWidthUnitType.Percent, 20);
}
else if (j == 2)
{
currRun = cell.Blocks.AddParagraph().Inlines.AddRun("ΑΠΟ");
currRun.Properties.FontFamily.LocalValue = new ThemableFontFamily("Arial");
currRun.Properties.FontSize.LocalValue = 15.0;
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currRun.Properties.FontStyle.LocalValue = FontStyles.Normal;
cell.PreferredWidth = new TableWidthUnit(TableWidthUnitType.Percent, 20);
}
else if (j == 3)
{
currRun = cell.Blocks.AddParagraph().Inlines.AddRun("ΩΡΑ");
currRun.Properties.FontFamily.LocalValue = new ThemableFontFamily("Arial");
currRun.Properties.FontSize.LocalValue = 15.0;
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currRun.Properties.FontStyle.LocalValue = FontStyles.Normal;
cell.PreferredWidth = new TableWidthUnit(TableWidthUnitType.Percent, 20);
}
else if (j == 4)
{
currRun = cell.Blocks.AddParagraph().Inlines.AddRun("ΠΑΡΑΤΗΡΗΣΕΙΣ");
currRun.Properties.FontFamily.LocalValue = new ThemableFontFamily("Arial");
currRun.Properties.FontSize.LocalValue = 15.0;
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currRun.Properties.FontStyle.LocalValue = FontStyles.Normal;
cell.PreferredWidth = new TableWidthUnit(TableWidthUnitType.Percent, 35);
}
}
else
{
if (j == 0)
{
currRun = cell.Blocks.AddParagraph().Inlines.AddRun(lstDummy.Where(o => o.Count == i).FirstOrDefault().Count.ToString());
currRun.Properties.FontFamily.LocalValue = new ThemableFontFamily("Arial");
currRun.Properties.FontSize.LocalValue = 15.0;
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currRun.Properties.FontStyle.LocalValue = FontStyles.Normal;
}
else if (j == 1)
{
cell.Blocks.AddParagraph().Inlines.AddRun(lstDummy.Where(o => o.Count == i).FirstOrDefault().Customer);
}
else if (j == 2)
{
cell.Blocks.AddParagraph().Inlines.AddRun(lstDummy.Where(o => o.Count == i).FirstOrDefault().FromPlace);
}
else if (j == 3)
{
cell.Blocks.AddParagraph().Inlines.AddRun(lstDummy.Where(o => o.Count == i).FirstOrDefault().FromTime + " - " + lstDummy.Where(o => o.Count == i).FirstOrDefault().ToTime);
}
else if (j == 4)
{
cell.Blocks.AddParagraph().Inlines.AddRun(lstDummy.Where(o => o.Count == i).FirstOrDefault().Comments);
}
}
}
}
curDoc.UpdateFields();
exportDOCX(curDoc);
}
catch (Exception ex) { }
}
private RadFlowDocument CreateDocument()
{
RadFlowDocument document = new RadFlowDocument();
RadFlowDocumentEditor editor = new RadFlowDocumentEditor(document);
editor.ParagraphFormatting.TextAlignment.LocalValue = Alignment.Justified;
Table bodyTable = editor.InsertTable(1, 2);
Paragraph paragraphWithText = bodyTable.Rows[0].Cells[0].Blocks.AddParagraph();
editor.MoveToParagraphStart(paragraphWithText);
editor.InsertLine("Dear Telerik User,");
editor.InsertLine("We're happy to introduce the new Telerik RadWordsProcessing component for WPF. High performance library that enables you to read, write and manipulate documents in DOCX, RTF, HTML and plain text format.");
editor.InsertText("The current beta version comes with full rich-text capabilities including ");
editor.InsertText("bold, ").FontWeight = FontWeights.Bold;
editor.InsertText("italic, ").FontStyle = FontStyles.Italic;
Run underlined = editor.InsertText("underline,");
underlined.Underline.Pattern = UnderlinePattern.Dotted;
underlined.Underline.Color = new ThemableColor(Colors.Black);
editor.InsertText(" font sizes and ").FontSize = 20;
editor.InsertText("colors ").ForegroundColor = GreenColor;
editor.InsertLine("as well as text alignment and indentation. Other options include tables, lists, hyperlinks, bookmarks and comments, inline and floating images. Even more sweetness is added by the built-in styles and themes.");
editor.InsertLine("We hope you'll enjoy RadWordsProcessing as much as we do. Happy coding!");
editor.InsertParagraph().Spacing.SpacingAfter = 0;
editor.InsertLine("Regards,");
editor.InsertHyperlink("Telerik Team ", "http://www.telerik.com", false, "Telerik Site");
Paragraph paragraphWithImage = bodyTable.Rows[0].Cells[1].Blocks.AddParagraph();
editor.MoveToParagraphStart(paragraphWithImage);
using (Stream stream = FileHelper.GetSampleResourceStream("WordsProcessing.png"))
{
editor.InsertImageInline(stream, "png", new Size(470, 261));
}
return document;
}
protected void gridMain_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "invPrint")
{
GridDataItem item = (GridDataItem)e.Item;
int orderID = (int)((GridDataItem)e.Item).GetDataKeyValue("ID");
OrdersController oCont = new OrdersController();
OrderB curOrder = oCont.GetOrder(orderID);
TasksController lCont = new TasksController();
List <TaskB> tasksForOrder = lCont.GetTasksForOrder(orderID);
CustomersController cCont = new CustomersController();
CustomerB curCust = cCont.GetCustomer(curOrder.Customer1.ID);
try {
DocumentReplacemetsController cont = new DocumentReplacemetsController();
List <DocumentReplacemetB> reps = new List <DocumentReplacemetB>();
reps = cont.GetDocumentReplacemets(sqlUniqueName);
DocumentReplacemetB curRep;
string imgFolderPath = Server.MapPath(fileUploadFolder);
RadFlowDocument curDoc = LoadTemplateDocument(docTemplate);
RadFlowDocumentEditor editor = new RadFlowDocumentEditor(curDoc);
Run currRun;
Paragraph currPar;
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
currPar.TextAlignment = Alignment.Right;
currRun = editor.InsertText("ATHENS " + DateTime.Now.ToString("dd/MM/yyyy"));
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = insertParagraph(editor);
currPar.TextAlignment = Alignment.Right;
string regNo = curOrder.RegNo == null ? "" : curOrder.RegNo;
currRun = editor.InsertText("REF. " + regNo);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
Telerik.Windows.Documents.Flow.Model.Table infoTable = editor.InsertTable(4, 2);
infoTable.Borders = new TableBorders(new Border(Telerik.Windows.Documents.Flow.Model.Styles.BorderStyle.None));
currPar = infoTable.Rows[0].Cells[0].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
currRun = currPar.Inlines.AddRun("Information:");
currPar = infoTable.Rows[0].Cells[1].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
curRep = reps.Where(o => o.Title == "Πληροφορίες").FirstOrDefault();
if (curRep != null)
{
currRun = currPar.Inlines.AddRun(curRep.Text);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
}
currPar = infoTable.Rows[1].Cells[0].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
currRun = currPar.Inlines.AddRun("Phone:");
currPar = infoTable.Rows[1].Cells[1].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
curRep = reps.Where(o => o.Title == "Τηλέφωνο").FirstOrDefault();
if (curRep != null)
{
currRun = currPar.Inlines.AddRun(curRep.Text);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
}
currPar = infoTable.Rows[2].Cells[0].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
currRun = currPar.Inlines.AddRun("FAX:");
currPar = infoTable.Rows[2].Cells[1].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
curRep = reps.Where(o => o.Title == "FAX").FirstOrDefault();
if (curRep != null)
{
currRun = currPar.Inlines.AddRun(curRep.Text);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
}
currPar = infoTable.Rows[3].Cells[0].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
currRun = currPar.Inlines.AddRun("Email:");
currPar = infoTable.Rows[3].Cells[1].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
curRep = reps.Where(o => o.Title == "Email").FirstOrDefault();
if (curRep != null)
{
Run currRun2 = currPar.Inlines.AddRun();
editor.MoveToInlineEnd(currRun2);
editor.InsertHyperlink(curRep.Text, "mailto:" + curRep.Text, false);
editor.MoveToTableEnd(infoTable);
}
currPar = insertParagraph(editor);
editor.MoveToParagraphStart(currPar);
Telerik.Windows.Documents.Flow.Model.Table toTable = editor.InsertTable(3, 2);
toTable.Borders = new TableBorders(new Border(Telerik.Windows.Documents.Flow.Model.Styles.BorderStyle.None));
currPar = toTable.Rows[0].Cells[0].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
currRun = currPar.Inlines.AddRun("ATT.:");
currPar = toTable.Rows[0].Cells[1].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
if (!string.IsNullOrEmpty(tasksForOrder[0].Customer.NameEN))
{
currRun = currPar.Inlines.AddRun(tasksForOrder[0].Customer.NameEN);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
}
currPar = toTable.Rows[1].Cells[0].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
currRun = currPar.Inlines.AddRun("Phone:");
currPar = toTable.Rows[1].Cells[1].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
if (!string.IsNullOrEmpty(tasksForOrder[0].Customer.Telephone1))
{
currRun = currPar.Inlines.AddRun(tasksForOrder[0].Customer.Telephone1);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
}
currPar = toTable.Rows[2].Cells[0].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
currRun = currPar.Inlines.AddRun("FAX:");
currPar = toTable.Rows[2].Cells[1].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
if (!string.IsNullOrEmpty(tasksForOrder[0].Customer.FAX1))
{
currRun = currPar.Inlines.AddRun(tasksForOrder[0].Customer.FAX1);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
}
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
currRun = editor.InsertText("SUBJECT: TEMPORARΥ TELEPHONE LINES");
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
currPar.TextAlignment = Alignment.Justified;
currRun = editor.InsertText("You are kindly requested to provide " + tasksForOrder.Count.ToString() + " temporary telephone lines.");
currPar = insertParagraph(editor);
Telerik.Windows.Documents.Flow.Model.Table eventTable = editor.InsertTable(2, 2);
eventTable.Borders = new TableBorders(new Border(Telerik.Windows.Documents.Flow.Model.Styles.BorderStyle.None));
currPar = eventTable.Rows[0].Cells[0].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
currRun = currPar.Inlines.AddRun("in:");
currPar = eventTable.Rows[0].Cells[1].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
string curP = curOrder.Event.Place.NameEN == null ? "" : curOrder.Event.Place.NameEN;
currRun = currPar.Inlines.AddRun(curP);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = eventTable.Rows[1].Cells[0].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
currRun = currPar.Inlines.AddRun("event:");
currPar = eventTable.Rows[1].Cells[1].Blocks.AddParagraph();
currPar.Spacing.SpacingAfter = 0;
string curE = curOrder.Event.NameEN == null ? "" : curOrder.Event.NameEN;
currRun = currPar.Inlines.AddRun(curE);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
int tRows = tasksForOrder.Count + 1;
Telerik.Windows.Documents.Flow.Model.Table contentTable = editor.InsertTable(tRows, 5);
toTable.Borders = new TableBorders(new Border(Telerik.Windows.Documents.Flow.Model.Styles.BorderStyle.None));
currPar = contentTable.Rows[0].Cells[0].Blocks.AddParagraph();
currRun = currPar.Inlines.AddRun("Customer Name");
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = contentTable.Rows[0].Cells[1].Blocks.AddParagraph();
currRun = currPar.Inlines.AddRun("From");
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = contentTable.Rows[0].Cells[2].Blocks.AddParagraph();
currRun = currPar.Inlines.AddRun("To");
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = contentTable.Rows[0].Cells[3].Blocks.AddParagraph();
currRun = currPar.Inlines.AddRun("Place of Instal.");
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = contentTable.Rows[0].Cells[4].Blocks.AddParagraph();
currRun = currPar.Inlines.AddRun("");
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
int curRow = 1;
foreach (TaskB curTask in tasksForOrder)
{
currPar = contentTable.Rows[curRow].Cells[0].Blocks.AddParagraph();
currRun = currPar.Inlines.AddRun(curCust.NameEN);
currPar = contentTable.Rows[curRow].Cells[1].Blocks.AddParagraph();
currRun = currPar.Inlines.AddRun(curTask.DateTimeStartOrder.ToString());
currPar = contentTable.Rows[curRow].Cells[2].Blocks.AddParagraph();
currRun = currPar.Inlines.AddRun(curTask.DateTimeEndOrder.ToString());
currPar = contentTable.Rows[curRow].Cells[3].Blocks.AddParagraph();
currRun = currPar.Inlines.AddRun(curTask.RequestedPosition.NameEN);
currPar = contentTable.Rows[curRow].Cells[4].Blocks.AddParagraph();
string LineType2Print = curTask.LineType.Name;
if (curTask.Internet == true)
{
LineType2Print += " + WIFI ROUTER";
}
currRun = currPar.Inlines.AddRun(LineType2Print);
curRow++;
}
var distinctTasksLT = tasksForOrder.Select(m => new { m.LineTypeID, m.Internet, m.MSN }).Distinct().ToList();
string concatString = "";
int distinctItems = 0;
foreach (var dItem in distinctTasksLT)
{
if (distinctItems > 0 && distinctItems < distinctTasksLT.Count - 1)
{
concatString += ", ";
}
else if (distinctItems > 0 && distinctItems == distinctTasksLT.Count - 1)
{
concatString += " & ";
}
TaskB demoTask = tasksForOrder.Where(k => k.LineTypeID == dItem.LineTypeID && k.Internet == dItem.Internet && k.MSN == dItem.MSN).FirstOrDefault();
int itemCount = tasksForOrder.Where(k => k.LineTypeID == dItem.LineTypeID && k.Internet == dItem.Internet && k.MSN == dItem.MSN).Count();
concatString += itemCount.ToString() + " " + demoTask.LineType.Name;
if (demoTask.Internet == true && demoTask.MSN == true)
{
concatString += " with router and MSN";
}
else if (demoTask.Internet == true)
{
concatString += " with router";
}
else if (demoTask.MSN == true)
{
concatString += " with MSN";
}
distinctItems++;
}
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
currRun = editor.InsertText("Please provide " + concatString);
currRun.Properties.FontSize.LocalValue = Telerik.Windows.Documents.Media.Unit.PointToDip(9);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = insertParagraph(editor);
currRun = editor.InsertText("Contact Person: " + reps.Where(o => o.Title == "Contact Person").FirstOrDefault().Text + " Mob:" + reps.Where(o => o.Title == "Κινητό C.P.").FirstOrDefault().Text);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = insertParagraph(editor);
currRun = editor.InsertText("Please advise on allocated numbers A.S.A.P. to the e-mail address: ");
editor.InsertHyperlink(curRep.Text, "mailto:" + curRep.Text, false);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
currRun = editor.InsertText("HELLENIC TELECOMMUNICATIONS ORGANIZATION SA (OTE GROUP OF COMPANIES)");
currPar = insertParagraph(editor);
currRun = editor.InsertText("VAT Number: ");
currRun = editor.InsertText("EL 094019245");
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
currRun = editor.InsertText("Responsible for the payments is our company:");
currPar = insertParagraph(editor);
currRun = editor.InsertText("HELLENIC TELECOMMUNICATIONS ORGANIZATION SA (OTE GROUP OF COMPANIES) via its Billing department bellow");
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
currRun = editor.InsertText("Delivery invoice address for the original invoice (Post mail):");
currPar = insertParagraph(editor);
currRun = editor.InsertText("OTE INTERNATIONAL SOLUTION SA (OTEGLOBE)");
curRep = reps.Where(o => o.Title == "OTEGlobe Διεύθυνση 1").FirstOrDefault();
currPar = insertParagraph(editor);
if (curRep != null)
{
//currPar = insertParagraph(editor);
//currRun = editor.InsertText(curRep.Text);
currRun = editor.InsertLine(curRep.Text);
}
curRep = reps.Where(o => o.Title == "OTEGlobe Διεύθυνση 2").FirstOrDefault();
if (curRep != null)
{
//currPar = insertParagraph(editor);
//currRun = editor.InsertText(curRep.Text);
currRun = editor.InsertLine(curRep.Text);
}
curRep = reps.Where(o => o.Title == "OTEGlobe Site").FirstOrDefault();
if (curRep != null)
{
//currPar = insertParagraph(editor);
editor.InsertHyperlink(curRep.Text, "http://" + curRep.Text, false);
}
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
string rep = "";
curRep = reps.Where(o => o.Title == "Person In Charge").FirstOrDefault();
if (curRep != null)
{
rep += curRep.Text;
}
curRep = reps.Where(o => o.Title == "Person In Charge (Phone)").FirstOrDefault();
if (curRep != null)
{
rep += curRep.Text;
}
if (!string.IsNullOrEmpty(rep))
{
currRun = editor.InsertText("(Person in charge " + rep + ")");
currPar = insertParagraph(editor);
}
curRep = reps.Where(o => o.Title == "Person In Charge (Email)").FirstOrDefault();
if (curRep != null)
{
currRun = editor.InsertText("Email: ");
editor.InsertHyperlink(curRep.Text, "mailto:" + curRep.Text, false);
currPar = insertParagraph(editor);
}
currRun = editor.InsertText("Email: ");
editor.InsertHyperlink("*****@*****.**", "mailto:[email protected]", false);
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
curRep = reps.Where(o => o.Title == "Email").FirstOrDefault();
if (curRep != null)
{
currPar = insertParagraph(editor);
currRun = editor.InsertText("You could notify a copy of the invoice (as a pdf) to this e-mail: ");
editor.InsertHyperlink(curRep.Text, "mailto:" + curRep.Text, false);
currRun.Properties.FontWeight.LocalValue = FontWeights.Bold;
}
currPar = insertParagraph(editor);
currRun = editor.InsertText("The charges will be settled via Bank transfer.");
currPar = insertParagraph(editor);
currPar = insertParagraph(editor);
currRun = editor.InsertText("Best regards,");
currPar = insertParagraph(editor);
currRun = editor.InsertText("SAOUSOPOULOU ANNA");
currPar = insertParagraph(editor);
currRun = editor.InsertText("MANAGER OF GENTRANS, ATHENS");
curDoc.UpdateFields();
exportDOCX(curDoc);
}
catch (Exception ex) { }
}
}
