/// <summary>Writes PDF for specified auto-doc commands.</summary>
/// <param name="section">The writer to write to.</param>
/// <param name="tags">The autodoc tags.</param>
/// <param name="workingDirectory">The working directory.</param>
private void TagsToMigraDoc(Section section, List<AutoDocumentation.ITag> tags, string workingDirectory)
{
foreach (AutoDocumentation.ITag tag in tags)
{
if (tag is AutoDocumentation.Heading)
{
AutoDocumentation.Heading heading = tag as AutoDocumentation.Heading;
if (heading.headingLevel > 0 && heading.headingLevel <= 6)
{
if (heading.headingLevel == 1)
section.AddPageBreak();
Paragraph para = section.AddParagraph(heading.text, "Heading" + heading.headingLevel);
if (heading.headingLevel == 1)
para.Format.OutlineLevel = OutlineLevel.Level1;
else if (heading.headingLevel == 2)
para.Format.OutlineLevel = OutlineLevel.Level2;
else if (heading.headingLevel == 3)
para.Format.OutlineLevel = OutlineLevel.Level3;
else if (heading.headingLevel == 4)
para.Format.OutlineLevel = OutlineLevel.Level4;
else if (heading.headingLevel == 5)
para.Format.OutlineLevel = OutlineLevel.Level5;
else if (heading.headingLevel == 6)
para.Format.OutlineLevel = OutlineLevel.Level6;
}
}
else if (tag is AutoDocumentation.Paragraph)
{
AddFormattedParagraphToSection(section, tag as AutoDocumentation.Paragraph);
}
else if (tag is AutoDocumentation.GraphAndTable)
{
CreateGraphPDF(section, tag as AutoDocumentation.GraphAndTable, workingDirectory);
}
else if (tag is AutoDocumentation.Table)
{
CreateTable(section, tag as AutoDocumentation.Table, workingDirectory);
}
else if (tag is Graph)
{
GraphPresenter graphPresenter = new GraphPresenter();
GraphView graphView = new GraphView();
graphView.BackColor = System.Drawing.Color.White;
graphView.FontSize = 12;
graphView.Width = 500;
graphView.Height = 500;
graphPresenter.Attach(tag, graphView, ExplorerPresenter);
string PNGFileName = graphPresenter.ExportToPDF(workingDirectory);
section.AddImage(PNGFileName);
string caption = (tag as Graph).Caption;
if (caption != null)
section.AddParagraph(caption);
graphPresenter.Detach();
}
else if (tag is Map)
{
Form f = new Form();
f.Width = 700; // 1100;
f.Height = 500; // 600;
MapPresenter mapPresenter = new MapPresenter();
MapView mapView = new MapView();
mapView.BackColor = System.Drawing.Color.White;
mapView.Parent = f;
(mapView as Control).Dock = DockStyle.Fill;
f.Show();
mapPresenter.Attach(tag, mapView, ExplorerPresenter);
Application.DoEvents();
Thread.Sleep(2000);
Application.DoEvents();
string PNGFileName = mapPresenter.ExportToPDF(workingDirectory);
section.AddImage(PNGFileName);
mapPresenter.Detach();
f.Close();
}
else if (tag is AutoDocumentation.Image)
{
AutoDocumentation.Image imageTag = tag as AutoDocumentation.Image;
if (imageTag.image.Width > 700)
imageTag.image = ImageUtilities.ResizeImage(imageTag.image, 700, 500);
string PNGFileName = Path.Combine(workingDirectory, imageTag.name);
imageTag.image.Save(PNGFileName, System.Drawing.Imaging.ImageFormat.Png);
section.AddImage(PNGFileName);
}
}
}
private MigraDoc.DocumentObjectModel.Document CreatePrintDocument(PrintDocument pd)
{
string text;
MigraDoc.DocumentObjectModel.Document doc = new MigraDoc.DocumentObjectModel.Document();
doc.DefaultPageSetup.PageWidth = Unit.FromInch((double)pd.DefaultPageSettings.PaperSize.Width / 100);
doc.DefaultPageSetup.PageHeight = Unit.FromInch((double)pd.DefaultPageSettings.PaperSize.Height / 100);
doc.DefaultPageSetup.TopMargin = Unit.FromInch((double)pd.DefaultPageSettings.Margins.Top / 100);
doc.DefaultPageSetup.LeftMargin = Unit.FromInch((double)pd.DefaultPageSettings.Margins.Left / 100);
doc.DefaultPageSetup.RightMargin = Unit.FromInch((double)pd.DefaultPageSettings.Margins.Right / 100);
doc.DefaultPageSetup.BottomMargin = Unit.FromInch((double)pd.DefaultPageSettings.Margins.Bottom / 100);
MigraDoc.DocumentObjectModel.Section section = doc.AddSection();
section.PageSetup.StartingNumber = 1;
MigraDoc.DocumentObjectModel.Font headingFont = MigraDocHelper.CreateFont(13, true);
MigraDoc.DocumentObjectModel.Font bodyFontx = MigraDocHelper.CreateFont(9, false);
MigraDoc.DocumentObjectModel.Font nameFontx = MigraDocHelper.CreateFont(9, true);
MigraDoc.DocumentObjectModel.Font totalFontx = MigraDocHelper.CreateFont(9, true);
Paragraph pageNumParag = new Paragraph();
pageNumParag.AddText(Lan.g(this, "Page") + " ");
pageNumParag.AddPageField();
pageNumParag.AddText(" " + Lan.g(this, "of") + " ");
pageNumParag.AddNumPagesField();
section.Footers.Primary.Add(pageNumParag);
Paragraph par = section.AddParagraph();
ParagraphFormat parformat = new ParagraphFormat();
parformat.Alignment = ParagraphAlignment.Center;
parformat.Font = MigraDocHelper.CreateFont(14, true);
par.Format = parformat;
//Render the reconcile grid.
par = section.AddParagraph();
par.Format.Alignment = ParagraphAlignment.Center;
par.AddFormattedText(Lan.g(this, "RECONCILE"), totalFontx);
par.AddLineBreak();
text = Accounts.GetAccount(ReconcileCur.AccountNum).Description.ToUpper();
par.AddFormattedText(text, totalFontx);
par.AddLineBreak();
text = PrefC.GetString(PrefName.PracticeTitle);
par.AddText(text);
par.AddLineBreak();
text = PrefC.GetString(PrefName.PracticePhone);
if (text.Length == 10 && Application.CurrentCulture.Name == "en-US")
{
text = "(" + text.Substring(0, 3) + ")" + text.Substring(3, 3) + "-" + text.Substring(6);
}
par.AddText(text);
par.AddLineBreak();
par.AddText(MiscData.GetNowDateTime().ToShortDateString());
par.AddLineBreak();
par.AddText(Lan.g(this, "Reconcile Date") + ": " + PIn.Date(textDate.Text).ToShortDateString());
par.AddLineBreak();
par.AddText(labelStart.Text + ": " + PIn.Double(textStart.Text).ToString("n"));
par.AddLineBreak();
par.AddText(labelEnd.Text + ": " + PIn.Double(textEnd.Text).ToString("n"));
MigraDocHelper.InsertSpacer(section, 10);
MigraDocHelper.DrawGrid(section, gridMain);
return(doc);
}
/// <summary>
/// Add header text: school name
/// </summary>
/// <param name="SchoolName"></param>
/// <param name="Location"></param>
public void AddHeaderText_SchoolName(string SchoolName, string Location)
{
_p = _section.AddParagraph(SchoolName);
_p.Format.Alignment = ParagraphAlignment.Center;
_p.Format.Font.Name = "Calibri";
_p.Format.Font.Size = 11;
_p = _section.AddParagraph(Location);
_p.Format.Alignment = ParagraphAlignment.Center;
_p.Format.Font.Name = "Calibri";
_p.Format.Font.Size = 11;
}
public static void CreatePdf(string person1, string person2, DataHandler datahandler, Dictionary <string, string[]> groups)
{
Document document = new Document();
document.UseCmykColor = true;
MigraDoc.DocumentObjectModel.Section section = document.AddSection();
section.PageSetup.Orientation = MigraDoc.DocumentObjectModel.Orientation.Landscape;
MigraDoc.DocumentObjectModel.Paragraph paragraph = section.AddParagraph();
paragraph.Format.Font.Color = MigraDoc.DocumentObjectModel.Color.FromCmyk(100, 20, 30, 50);
if (person1 == "<Ingen sælger valgt>")
{
person1 = null;
}
if (person2 == "<Ingen sælger valgt>")
{
person2 = null;
}
if (person1 != null)
{
paragraph.AddFormattedText(person1, TextFormat.Bold);
paragraph.AddLineBreak();
paragraph.AddLineBreak();
DefineCharts(document, person1, groups, datahandler);
}
if (person2 != null)
{
MigraDoc.DocumentObjectModel.Section newSection = document.AddSection();
newSection.PageSetup.Orientation = MigraDoc.DocumentObjectModel.Orientation.Landscape;
MigraDoc.DocumentObjectModel.Paragraph newParagraph = newSection.AddParagraph();
newParagraph.AddFormattedText(person2, TextFormat.Bold);
newParagraph.AddLineBreak();
newParagraph.AddLineBreak();
DefineCharts(document, person2, groups, datahandler);
}
const bool unicode = false;
const PdfFontEmbedding embedding = PdfFontEmbedding.Always;
PdfDocumentRenderer pdfRenderer = new PdfDocumentRenderer(unicode, embedding);
pdfRenderer.Document = document;
pdfRenderer.RenderDocument();
string time = DateTime.Today.ToShortDateString();
string myfile = time + ".pdf";
pdfRenderer.PdfDocument.Save(myfile);
Process.Start(myfile);
}
public void VisitParagraph(Paragraph element)
{
if (_pdfSection == null)
{
_pdfSection = _document.AddSection();
}
_pdfParagraph = _pdfCell?.AddParagraph() ?? _pdfSection.AddParagraph();
SetParagraphProperties(element.ParagraphProperties);
}
private MigraDoc.DocumentObjectModel.Document CreatePrintDocument()
{
string text;
MigraDoc.DocumentObjectModel.Document doc = new MigraDoc.DocumentObjectModel.Document();
doc.DefaultPageSetup.PageWidth = Unit.FromInch(8.5);
doc.DefaultPageSetup.PageHeight = Unit.FromInch(11);
doc.DefaultPageSetup.TopMargin = Unit.FromInch(.5);
doc.DefaultPageSetup.LeftMargin = Unit.FromInch(.5);
doc.DefaultPageSetup.RightMargin = Unit.FromInch(.5);
MigraDoc.DocumentObjectModel.Section section = doc.AddSection();
MigraDoc.DocumentObjectModel.Font headingFont = MigraDocHelper.CreateFont(13, true);
MigraDoc.DocumentObjectModel.Font bodyFontx = MigraDocHelper.CreateFont(9, false);
MigraDoc.DocumentObjectModel.Font nameFontx = MigraDocHelper.CreateFont(9, true);
MigraDoc.DocumentObjectModel.Font totalFontx = MigraDocHelper.CreateFont(9, true);
Paragraph par = section.AddParagraph();
ParagraphFormat parformat = new ParagraphFormat();
parformat.Alignment = ParagraphAlignment.Center;
parformat.Font = MigraDocHelper.CreateFont(14, true);
par.Format = parformat;
//Render the reconcile grid.
par = section.AddParagraph();
par.Format.Alignment = ParagraphAlignment.Center;
par.AddFormattedText(Lan.g(this, "RECONCILE"), totalFontx);
par.AddLineBreak();
text = Accounts.GetAccount(ReconcileCur.AccountNum).Description.ToUpper();
par.AddFormattedText(text, totalFontx);
par.AddLineBreak();
text = PrefC.GetString(PrefName.PracticeTitle);
par.AddText(text);
par.AddLineBreak();
text = PrefC.GetString(PrefName.PracticePhone);
if (text.Length == 10 && Application.CurrentCulture.Name == "en-US")
{
text = "(" + text.Substring(0, 3) + ")" + text.Substring(3, 3) + "-" + text.Substring(6);
}
par.AddText(text);
MigraDocHelper.InsertSpacer(section, 10);
MigraDocHelper.DrawGrid(section, gridMain);
return(doc);
}
private static void DrawRecipe(RecipeEntry recipe, ref Section section)
{
///<example>
/// [Recipe Name]
/// [Recipe Source]
/// [Recipe Description]
/// [# Recipe Ingredients]
/// [Recipe Preparation Instructions]
/// [Recipe Cooking Instructions]
/// </example>
Paragraph headerText = section.AddParagraph();
Paragraph DescParagraph = section.AddParagraph();
Paragraph ingredientList = section.AddParagraph();
Paragraph PrepInstr = section.AddParagraph();
Paragraph CookInstr = section.AddParagraph();
Font header = new Font("Times New Roman Bold", 20);
Font body = new Font("Times New Roman", 14);
headerText.Format = HeaderFormatter();
headerText.AddFormattedText(recipe.Name, header);
headerText.AddLineBreak();
headerText.AddFormattedText("(" + recipe.Source + ")", new Font("Times New Roman", 16));
DescParagraph.Format = BodyFormatter();
DescParagraph.AddFormattedText(recipe.Description, body);
ingredientList.Format = IngredientFormatter();
int count = 1;
foreach (IngredientEntry i in recipe.Ingredients)
{
string entry = count.ToString() + ") " + i.ToString();
ingredientList.AddFormattedText(entry, body);
ingredientList.AddLineBreak();
count++;
}
PrepInstr.Format = BodyFormatter();
PrepInstr.AddFormattedText(recipe.PrepInstructions, body);
CookInstr.Format = BodyFormatter();
CookInstr.AddFormattedText(recipe.CookInstructions, body);
}
private void PrintReceipt(string receiptStr)
{
string[] receiptLines = receiptStr.Split(new string[] { Environment.NewLine }, StringSplitOptions.None);
MigraDoc.DocumentObjectModel.Document doc = new MigraDoc.DocumentObjectModel.Document();
doc.DefaultPageSetup.PageWidth = Unit.FromInch(3.0);
doc.DefaultPageSetup.PageHeight = Unit.FromInch(0.181 * receiptLines.Length + 0.56); //enough to print receipt text plus 9/16 inch (0.56) extra space at bottom.
doc.DefaultPageSetup.TopMargin = Unit.FromInch(0.25);
doc.DefaultPageSetup.LeftMargin = Unit.FromInch(0.25);
doc.DefaultPageSetup.RightMargin = Unit.FromInch(0.25);
MigraDoc.DocumentObjectModel.Font bodyFontx = MigraDocHelper.CreateFont(8, false);
bodyFontx.Name = FontFamily.GenericMonospace.Name;
MigraDoc.DocumentObjectModel.Section section = doc.AddSection();
Paragraph par = section.AddParagraph();
ParagraphFormat parformat = new ParagraphFormat();
parformat.Alignment = ParagraphAlignment.Left;
parformat.Font = bodyFontx;
par.Format = parformat;
par.AddFormattedText(receiptStr, bodyFontx);
MigraDoc.Rendering.Printing.MigraDocPrintDocument printdoc = new MigraDoc.Rendering.Printing.MigraDocPrintDocument();
MigraDoc.Rendering.DocumentRenderer renderer = new MigraDoc.Rendering.DocumentRenderer(doc);
renderer.PrepareDocument();
printdoc.Renderer = renderer;
#if DEBUG
FormRpPrintPreview pView = new FormRpPrintPreview(printdoc);
pView.ShowDialog();
#else
try {
ODprintout printout = PrinterL.CreateODprintout(
printSit: PrintSituation.Receipt,
auditPatNum: _patCur.PatNum,
auditDescription: Lans.g(this, "PayConnect receipt printed")
);
if (PrinterL.TrySetPrinter(printout))
{
printdoc.PrinterSettings = printout.PrintDoc.PrinterSettings;
printdoc.Print();
}
}
catch (Exception ex) {
MessageBox.Show(Lan.g(this, "Printer not available.") + "\r\n" + Lan.g(this, "Original error") + ": " + ex.Message);
}
#endif
}
public MemoryStream GetPdfStream(bool fitToPage = false)
{
// If we're shrinking to the page, set it here. This will likely propogate to many
// places in the near future
//_shouldFitToOnePage = fitTo
// The document needs at least one section to set the orientation and margins
_section = _document.AddSection();
_section.PageSetup.Orientation = Orientation.Landscape;
_section.PageSetup.LeftMargin = "0.25in";
_section.PageSetup.RightMargin = "0.25in";
_section.PageSetup.TopMargin = "0.25in";
_section.PageSetup.BottomMargin = "0.25in";
// Title (in same section)
Paragraph paragraph = _section.AddParagraph();
paragraph.AddText(_title);
paragraph.AddLineBreak();
paragraph.Style = StyleNames.Heading1;
// Footer (in same section)
paragraph = _section.Footers.Primary.AddParagraph();
paragraph.AddText(_footer);
paragraph.Format.Alignment = ParagraphAlignment.Center;
// Table (in same section)
AddTable();
// Document is now built, so start rendering it
_pdfRenderer = new PdfDocumentRenderer();
// attach document
_pdfRenderer.Document = _document;
// This will output it as a stream which is passed to the browser
MemoryStream memoryStream = new MemoryStream();
_pdfRenderer.RenderDocument();
// "false" doesn't close the stream. If the stream is closed, you get fun HTTP 500 errors
_pdfRenderer.PdfDocument.Save(memoryStream, false);
// Pass it back as a file so it can be passed to the browser
return memoryStream;
}
private void PrintReceipt(string receiptStr)
{
string[] receiptLines = receiptStr.Split(new string[] { Environment.NewLine }, StringSplitOptions.None);
MigraDoc.DocumentObjectModel.Document doc = new MigraDoc.DocumentObjectModel.Document();
doc.DefaultPageSetup.PageWidth = Unit.FromInch(3.0);
doc.DefaultPageSetup.PageHeight = Unit.FromInch(0.181 * receiptLines.Length + 0.56); //enough to print receipt text plus 9/16 inch (0.56) extra space at bottom.
doc.DefaultPageSetup.TopMargin = Unit.FromInch(0.25);
doc.DefaultPageSetup.LeftMargin = Unit.FromInch(0.25);
doc.DefaultPageSetup.RightMargin = Unit.FromInch(0.25);
MigraDoc.DocumentObjectModel.Font bodyFontx = MigraDocHelper.CreateFont(8, false);
bodyFontx.Name = FontFamily.GenericMonospace.Name;
MigraDoc.DocumentObjectModel.Section section = doc.AddSection();
Paragraph par = section.AddParagraph();
ParagraphFormat parformat = new ParagraphFormat();
parformat.Alignment = ParagraphAlignment.Left;
parformat.Font = bodyFontx;
par.Format = parformat;
par.AddFormattedText(receiptStr, bodyFontx);
MigraDoc.Rendering.Printing.MigraDocPrintDocument printdoc = new MigraDoc.Rendering.Printing.MigraDocPrintDocument();
MigraDoc.Rendering.DocumentRenderer renderer = new MigraDoc.Rendering.DocumentRenderer(doc);
renderer.PrepareDocument();
printdoc.Renderer = renderer;
//we might want to surround some of this with a try-catch
#if DEBUG
FormRpPrintPreview pView = new FormRpPrintPreview();
pView.printPreviewControl2.Document = printdoc;
pView.ShowDialog();
#else
if (PrinterL.SetPrinter(pd2, PrintSituation.Receipt, PatCur.PatNum, "PayConnect receipt printed"))
{
printdoc.PrinterSettings = pd2.PrinterSettings;
printdoc.Print();
}
#endif
}
private void RenderCellToPdf(Section section, Whiteboard.Cell cell)
{
// Header
Paragraph paragraph = section.AddParagraph();
paragraph.Format.SpaceBefore = new Unit(10, UnitType.Point);
paragraph.Format.LeftIndent = new Unit(10, UnitType.Point);
paragraph.Format.Font.Color = Color.FromCmyk(100, 30, 20, 50);
paragraph.AddFormattedText(
cell.Column.Caption,
TextFormat.Bold);
// Value
string value = cell.Value ?? "";
paragraph = section.AddParagraph();
paragraph.Format.LeftIndent = new Unit(20, UnitType.Point);
paragraph.Format.Font.Color = Color.FromCmyk(100, 120, 120, 120);
paragraph.AddFormattedText(value);
}
public IActionResult OnGet(string pdf)
{
//get the session first!
UserName = HttpContext.Session.GetString(SessionKeyName1);
FirstName = HttpContext.Session.GetString(SessionKeyName2);
SessionID = HttpContext.Session.GetString(SessionKeyName3);
DatabaseConnect dbstring = new DatabaseConnect(); //creating an object from the class
string DbConnection = dbstring.DatabaseString(); //calling the method from the class
Console.WriteLine(DbConnection);
SqlConnection conn = new SqlConnection(DbConnection);
conn.Open();
using (SqlCommand command = new SqlCommand())
{
command.Connection = conn;
command.CommandText = @"SELECT EmployeeID,
EmpFName + ' ' + EmpLName AS EmployeeName,
EmpDoB AS EmployeeBornOn,
EmpHireDate AS EmployedOn
FROM EmployeesTable;";
var reader = command.ExecuteReader();
Employee = new List <Employee>();
while (reader.Read())
{
Employee Row = new Employee(); //each record found from the table
Row.EmployeeId = reader.GetInt32(0);
Row.EmployeeFirstName = reader.GetString(1);
Row.EmployeeDoB = reader.GetDateTime(2);
Row.EmployeeDateHired = reader.GetDateTime(3);
Employee.Add(Row);
}
}
//PDF code here!
if (pdf == "1")
{
//Create an object for pdf document
Document doc = new Document();
Section sec = doc.AddSection();
Paragraph para = sec.AddParagraph();
para.Format.Font.Name = "Arial";
para.Format.Font.Size = 14;
para.Format.Font.Color = Color.FromCmyk(0, 0, 0, 100); //black colour
para.AddFormattedText("List of Employees", TextFormat.Bold);
para.Format.SpaceAfter = "1.0cm";
para.AddFormattedText();
//Table
Table tab = new Table();
tab.Borders.Width = 0.75;
tab.TopPadding = 5;
tab.BottomPadding = 5;
//Column
Column col = tab.AddColumn(Unit.FromCentimeter(3));
col.Format.Alignment = ParagraphAlignment.Center;
tab.AddColumn(Unit.FromCentimeter(3));
tab.AddColumn(Unit.FromCentimeter(3));
tab.AddColumn(Unit.FromCentimeter(3));
//tab.AddColumn(Unit.FromCentimeter(3));
//Row
Row row = tab.AddRow();
row.Shading.Color = Colors.Coral;//select your preference colour!
//Cell for header
Cell cell = new Cell();
cell = row.Cells[0];
cell.AddParagraph("EmployeeID");
cell = row.Cells[1];
cell.AddParagraph("Employee First Name");
cell = row.Cells[2];
cell.AddParagraph("Employee Date of Birth");
cell = row.Cells[3];
cell.AddParagraph("Employee Hire Date");
//Add data to table
for (int i = 0; i < Employee.Count; i++)
{
row = tab.AddRow();
cell = row.Cells[0];
cell.AddParagraph(Convert.ToString(i + 1));
cell = row.Cells[1];
cell.AddParagraph(Employee[i].EmployeeFirstName);
cell = row.Cells[2];
cell.AddParagraph(Convert.ToString(Employee[i].EmployeeDateHired));
cell = row.Cells[3];
cell.AddParagraph(Convert.ToString(Employee[i].EmployeeDoB));
}
tab.SetEdge(0, 0, 4, (Employee.Count + 1), Edge.Box, BorderStyle.Single, 1.5, Colors.Black);
sec.Add(tab);
//Rendering
PdfDocumentRenderer pdfRen = new PdfDocumentRenderer();
pdfRen.Document = doc;
pdfRen.RenderDocument();
//Create a memory stream
MemoryStream stream = new MemoryStream();
pdfRen.PdfDocument.Save(stream); //saving the file into the stream
Response.Headers.Add("content-disposition", new[] { "inline; filename = ListofEmployees.pdf" });
return(File(stream, "application/pdf"));
}
return(Page());
}
public void CreateCharacterCertificatePDF(string[] CertificateData, string admNo, int admYear)
{
if (CertificateData.Length != 5)
{
return;
}
else
{
// Generate nmhs-nexap directory in my document folder
string containerfolder = this.GenerateDocumentBaseDirectory();
MigraModel.Document doc = new MigraModel.Document();
MigraModel.Section sec = doc.AddSection();
sec.PageSetup = doc.DefaultPageSetup.Clone();
sec.PageSetup.TopMargin = ".7cm";
MigraDoc.DocumentObjectModel.Shapes.TextFrame tframe = sec.AddTextFrame();
tframe.AddImage("nmhs-logo.jpg");
tframe.Left = "-.5cm";
tframe.Top = "0.7cm";
tframe.RelativeVertical = MigraModel.Shapes.RelativeVertical.Page;
tframe.RelativeHorizontal = MigraModel.Shapes.RelativeHorizontal.Margin;
MigraModel.Paragraph paraSchoolName = sec.AddParagraph();
paraSchoolName.Format.Font.Name = "Times New Roman";
paraSchoolName.Format.Alignment = MigraModel.ParagraphAlignment.Center;
paraSchoolName.Format.Font.Size = 25;
paraSchoolName.Format.Font.Color = MigraDoc.DocumentObjectModel.Colors.DarkBlue;
string schoolName = "NAIMOUZA HIGH SCHOOL";
paraSchoolName.AddFormattedText(schoolName, MigraModel.TextFormat.Bold);
MigraModel.Paragraph paraSchoolAddress = sec.AddParagraph();
paraSchoolAddress.Format.Font.Size = 14;
paraSchoolAddress.Format.Alignment = MigraModel.ParagraphAlignment.Center;
string addrs = "Vill. & P.O. Sujapur, Dist. Malda, 732206";
paraSchoolAddress.AddText(addrs);
MigraModel.Paragraph paraSchoolMeta = sec.AddParagraph();
paraSchoolMeta.Format.Font.Size = 10;
paraSchoolMeta.Format.Alignment = MigraModel.ParagraphAlignment.Center;
string meta = "INDEX NO. - R1-110, CONTACT NO. - 03512-246525";
paraSchoolMeta.AddFormattedText(meta, MigraModel.TextFormat.NotBold);
MigraModel.Paragraph paraAdmissionMeta = sec.AddParagraph();
paraAdmissionMeta.Format.Font.Size = 10;
paraAdmissionMeta.Format.Alignment = MigraModel.ParagraphAlignment.Right;
string admYr = (admYear != 0) ? admYear.ToString() : "0000";
string ameta = "Admission Sl. " + admNo + " of " + admYr;
paraAdmissionMeta.AddFormattedText(ameta, MigraModel.TextFormat.Bold);
MigraModel.Paragraph paraCertificateType = sec.AddParagraph();
paraCertificateType.Format.Font.Size = 18;
paraCertificateType.Format.Alignment = MigraModel.ParagraphAlignment.Center;
paraCertificateType.AddLineBreak();
string ctype = "CHARACTER CERTIFICATE";
paraCertificateType.AddFormattedText(ctype, MigraModel.TextFormat.NotBold);
MigraModel.Paragraph para_a = sec.AddParagraph();
para_a.Format.Font.Name = "Lucida Handwriting";
para_a.Format.Font.Size = 16;
para_a.Format.Font.Color = MigraModel.Colors.DarkBlue;
para_a.Format.Alignment = MigraModel.ParagraphAlignment.Justify;
para_a.AddLineBreak();
para_a.AddLineBreak();
para_a.AddLineBreak();
para_a.AddLineBreak();
para_a.AddTab();
string para_aText, para_aTextb, paraTextc, paraTextd, stdName;
para_aText = CertificateData[0].Trim();
para_aTextb = CertificateData[1].Trim();
paraTextc = CertificateData[2].Trim();
paraTextd = CertificateData[3].Trim();
stdName = CertificateData[4].Trim();
para_a.AddText(para_aText);
MigraModel.Paragraph para_b = sec.AddParagraph();
para_b.Format.Font.Name = "Lucida Handwriting";
para_b.Format.Font.Size = 16;
para_b.Format.Font.Color = MigraModel.Colors.DarkBlue;
para_b.Format.Alignment = MigraModel.ParagraphAlignment.Justify;
para_b.AddLineBreak();
para_b.AddTab();
para_b.AddText(para_aTextb);
MigraModel.Paragraph para_c = sec.AddParagraph();
para_c.Format.Font.Name = "Lucida Handwriting";
para_c.Format.Font.Size = 16;
para_c.Format.Font.Color = MigraModel.Colors.DarkBlue;
para_c.Format.Alignment = MigraModel.ParagraphAlignment.Justify;
para_c.AddLineBreak();
para_c.AddTab();
para_c.AddText(paraTextc);
MigraModel.Paragraph para_d = sec.AddParagraph();
para_d.Format.Font.Name = "Lucida Handwriting";
para_d.Format.Font.Size = 16;
para_d.Format.Font.Color = MigraModel.Colors.DarkBlue;
para_d.Format.Alignment = MigraModel.ParagraphAlignment.Justify;
para_d.AddLineBreak();
para_d.AddTab();
para_d.AddText(paraTextd);
MigraDoc.DocumentObjectModel.Shapes.TextFrame tframeHMaster = sec.AddTextFrame();
MigraModel.Paragraph paraHMaster = tframeHMaster.AddParagraph();
paraHMaster.Format.Font.Size = "14";
paraHMaster.Format.Alignment = MigraModel.ParagraphAlignment.Center;
string txt1 = "Headmaster";
string txt2 = "Naimuza High School";
string txt3 = "Sujapur, Malda";
paraHMaster.AddText(txt1);
paraHMaster.AddLineBreak();
paraHMaster.AddText(txt2);
paraHMaster.AddLineBreak();
paraHMaster.AddText(txt3);
tframeHMaster.Width = "6cm";
tframeHMaster.Left = "10cm";
tframeHMaster.Top = "19cm";
tframeHMaster.RelativeVertical = MigraModel.Shapes.RelativeVertical.Page;
tframeHMaster.RelativeHorizontal = MigraModel.Shapes.RelativeHorizontal.Margin;
MigraDoc.Rendering.PdfDocumentRenderer docRend = new MigraDoc.Rendering.PdfDocumentRenderer(false);
docRend.Document = doc;
try
{
docRend.RenderDocument();
}
catch (Exception e)
{
System.Windows.MessageBox.Show(e.Message);
return;
}
string fname = "CHR_" + stdName + DateTime.Now.ToString("yyyy-MM-dd HHmmss") + ".pdf";
string pathString = Path.Combine(containerfolder, fname);
docRend.PdfDocument.Save(pathString);
System.Diagnostics.ProcessStartInfo processInfo = new System.Diagnostics.ProcessStartInfo();
processInfo.FileName = pathString;
System.Diagnostics.Process.Start(processInfo);
}
}
public static void DefineTableOfContentList(Section section, string fontName, Color fontColor, string strName)
{
Paragraph paragraph = section.AddParagraph();
paragraph.Style = "TOC";
Hyperlink hyperlink = paragraph.AddHyperlink(strName);
hyperlink.Font.Name = fontName;
hyperlink.Font.Color = fontColor;
hyperlink.AddText(strName);
hyperlink.AddTab();
hyperlink.AddPageRefField(strName);
}
private void AddLinkOrClusterImg(Section s, byte[] image)
{
var imgPara = s.AddParagraph();
imgPara.AlignWithTable();
var pathName = PdfTools2.ImageBytesToFile(image, _images);
var img = imgPara.AddImage(pathName);
var bmp = new Bitmap(pathName);
int w = bmp.Width;
int h = bmp.Height;
bmp.Dispose();
var maxHeight = 0.3*_document.DefaultPageSetup.PageHeight;
if (h > maxHeight)
{
img.Height = maxHeight;
w = (int) maxHeight*w/h;
h = (int) maxHeight;
}
var maxWidth = 0.5*ContentWidth();
if (w > maxWidth)
{
img.Width = maxWidth;
img.Height = maxWidth*h/w;
}
}
private static void PutScheduleTable(ScheduleRepository repo, Section section,
Dictionary<int, Dictionary<string, Dictionary<int, Tuple<string, List<Tuple<Lesson, int>>, string>>>> schedule,
double scheduleFontsize)
{
var paragraph = section.AddParagraph();
paragraph.Format.SpaceBefore = "1.25cm";
var table = section.AddTable();
table.Style = "Table";
table.Borders.Color = new Color(0, 0, 0);
table.Borders.Width = 0.25;
table.Borders.Left.Width = 0.5;
table.Borders.Right.Width = 0.5;
table.Rows.LeftIndent = 0;
Column column = table.AddColumn("3.7cm");
column.Format.Alignment = ParagraphAlignment.Center;
var timeList = new List<string>();
foreach (var group in schedule)
{
foreach (var time in group.Value.Keys)
{
if (!timeList.Contains(time))
{
timeList.Add(time);
}
}
}
string colWidth = (24.0 / schedule.Count).ToString("F1").Replace(',','.');
for (int i = 0; i < schedule.Count; i++)
{
column = table.AddColumn(colWidth + "cm");
column.Format.Alignment = ParagraphAlignment.Right;
}
int groupColumn = 1;
var plainGroupsListIds = new Dictionary<int, List<int>>();
var nGroupsListIds = new Dictionary<int, List<int>>();
// Create the header of the table
Row row = table.AddRow();
row.HeadingFormat = true;
row.Format.Alignment = ParagraphAlignment.Center;
row.Cells[0].AddParagraph("Время");
foreach (var group in schedule)
{
var groupName = repo.StudentGroups.GetStudentGroup(group.Key).Name;
row.Cells[groupColumn].AddParagraph(groupName.Replace(" (+Н)", ""));
groupColumn++;
if (groupName.Contains(" (+Н)"))
{
var plainGroupName = groupName.Replace(" (+Н)", "");
var nGroupName = groupName.Replace(" (+", "(");
var plainGroupId = repo.StudentGroups.FindStudentGroup(plainGroupName).StudentGroupId;
var plainStudentIds = repo
.StudentsInGroups
.GetAllStudentsInGroups()
.Where(sig => sig.StudentGroup.StudentGroupId == plainGroupId)
.Select(stig => stig.Student.StudentId)
.ToList();
plainGroupsListIds.Add(group.Key, repo
.StudentsInGroups
.GetAllStudentsInGroups()
.Where(sig => plainStudentIds.Contains(sig.Student.StudentId))
.Select(stig => stig.StudentGroup.StudentGroupId)
.Distinct()
.ToList());
var nGroupId = repo.StudentGroups.FindStudentGroup(nGroupName).StudentGroupId;
var nStudentIds = repo
.StudentsInGroups
.GetAllStudentsInGroups()
.Where(sig => sig.StudentGroup.StudentGroupId == nGroupId)
.Select(stig => stig.Student.StudentId)
.ToList();
nGroupsListIds.Add(group.Key, repo
.StudentsInGroups
.GetAllStudentsInGroups()
.Where(sig => nStudentIds.Contains(sig.Student.StudentId))
.Select(stig => stig.StudentGroup.StudentGroupId)
.Distinct()
.ToList());
}
}
var timeRowIndexList = new List<int>();
var timeRowIndex = 2;
foreach (var time in timeList.OrderBy(t => int.Parse(t.Split(':')[0]) * 60 + int.Parse(t.Split(':')[1])))
{
var timeRow = table.AddRow();
timeRow.VerticalAlignment = VerticalAlignment.Center;
var hour = int.Parse(time.Substring(0, 2));
var minute = int.Parse(time.Substring(3, 2));
minute += 80;
while (minute >= 60)
{
hour++;
minute -= 60;
}
timeRowIndexList.Add(timeRowIndex);
timeRow.Cells[0].Format.Alignment = ParagraphAlignment.Center;
timeRow.Cells[0].AddParagraph(time + " - " + hour.ToString("D2") + ":" + minute.ToString("D2"));
var columnGroupIndex = 1;
foreach (var group in schedule)
{
if (group.Value.ContainsKey(time))
{
var cellTable = timeRow.Cells[columnGroupIndex].Elements.AddTable();
cellTable.AddColumn(table.Columns[columnGroupIndex].Width.Centimeter + "cm");
cellTable.Borders.Width = 0;
foreach (var tfdData in group.Value[time].OrderBy(tfd => tfd.Value.Item2.Select(l => repo.CommonFunctions.CalculateWeekNumber(l.Item1.Calendar.Date)).Min()))
{
var cellText = "";
cellText += tfdData.Value.Item2[0].Item1.TeacherForDiscipline.Discipline.Name;
var groupId = tfdData.Value.Item2[0].Item1.TeacherForDiscipline.Discipline.StudentGroup.StudentGroupId;
if (plainGroupsListIds.ContainsKey(group.Key))
{
if (plainGroupsListIds[group.Key].Contains(groupId) && nGroupsListIds[group.Key].Contains(groupId))
{
cellText += " (+Н)";
}
if (!plainGroupsListIds[group.Key].Contains(groupId) && nGroupsListIds[group.Key].Contains(groupId))
{
cellText += " (Н)";
}
}
cellText += Environment.NewLine;
cellText += tfdData.Value.Item2[0].Item1.TeacherForDiscipline.Teacher.FIO + Environment.NewLine;
cellText += "(" + tfdData.Value.Item1 + ")" + Environment.NewLine;
var audWeekList = tfdData.Value.Item2.ToDictionary(l => repo.CommonFunctions.CalculateWeekNumber(l.Item1.Calendar.Date), l => l.Item1.Auditorium.Name);
var grouped = audWeekList.GroupBy(a => a.Value);
var enumerable = grouped as List<IGrouping<string, KeyValuePair<int, string>>> ?? grouped.ToList();
var gcount = enumerable.Count();
if (gcount == 1)
{
cellText += enumerable.ElementAt(0).Key;
}
else
{
for (int j = 0; j < gcount; j++)
{
var jItem = enumerable.OrderBy(e => e.Select(ag => ag.Key).ToList().Min()).ElementAt(j);
cellText += CommonFunctions.CombineWeeks(jItem.Select(ag => ag.Key).ToList()) + " - " + jItem.Key;
if (j != gcount - 1)
{
cellText += Environment.NewLine;
}
}
}
Row cellTableRow = cellTable.AddRow();
cellTableRow.Cells[0].Format.Alignment = ParagraphAlignment.Left;
cellTableRow.Cells[0].Format.Font.Size = scheduleFontsize;
cellTableRow.Cells[0].AddParagraph(cellText);
}
}
columnGroupIndex++;
}
timeRowIndex++;
}
}
/// <summary>
/// Adds Date field to the given section
/// </summary>
/// <param name="section">The section to append the date field to</param>
private void AddDateFields(Section section)
{
var current = DateTime.Now;
var due =
current.AddMonths(SettingsData.Default.MonthsUntilInvoiceDue).AddDays(
SettingsData.Default.DaysUntilInvoiceDue);
var dateParagraph = section.AddParagraph();
dateParagraph.Format.SpaceBefore = "8cm";
dateParagraph.Style = "Reference";
dateParagraph.AddFormattedText("INVOICE #"+id, TextFormat.Bold);
dateParagraph.AddTab();
dateParagraph.AddText(String.Format("Date: {0:yyyy-MM-dd}", current));
dateParagraph.AddLineBreak();
dateParagraph.AddTab();
dateParagraph.AddText(String.Format("Due: {0:yyyy-MM-dd}", due));
}
/// <summary>
/// Creates the static parts of the invoice.
/// </summary>
void CreatePage()
{
// Each MigraDoc document needs at least one section.
Section section = this.document.AddSection();
// Put a logo in the header
Image image = section.AddImage(path);
image.Top = ShapePosition.Top;
image.Left = ShapePosition.Left;
image.WrapFormat.Style = WrapStyle.Through;
// Create footer
Paragraph paragraph = section.Footers.Primary.AddParagraph();
paragraph.AddText("Health And Social Services.");
paragraph.Format.Font.Size = 9;
paragraph.Format.Alignment = ParagraphAlignment.Center;
// Create the text frame for the address
this.addressFrame = section.AddTextFrame();
this.addressFrame.Height = "3.0cm";
this.addressFrame.Width = "7.0cm";
this.addressFrame.Left = ShapePosition.Left;
this.addressFrame.RelativeHorizontal = RelativeHorizontal.Margin;
this.addressFrame.Top = "5.0cm";
this.addressFrame.RelativeVertical = RelativeVertical.Page;
// Put sender in address frame
paragraph = this.addressFrame.AddParagraph("Karachi,Pakistan");
paragraph.Format.Font.Name = "Times New Roman";
paragraph.Format.Font.Size = 7;
paragraph.Format.SpaceAfter = 3;
// Add the print date field
paragraph = section.AddParagraph();
paragraph.Format.SpaceBefore = "6cm";
paragraph.Style = "Reference";
paragraph.AddFormattedText("Patients Detail", TextFormat.Bold);
paragraph.AddTab();
paragraph.AddText("Date, ");
paragraph.AddDateField("dd.MM.yyyy");
// Create the item table
this.table = section.AddTable();
this.table.Style = "Table";
this.table.Borders.Color = TableBorder;
this.table.Borders.Width = 0.25;
this.table.Borders.Left.Width = 0.5;
this.table.Borders.Right.Width = 0.5;
this.table.Rows.LeftIndent = 0;
// Before you can add a row, you must define the columns
Column column;
foreach (DataColumn col in dt.Columns)
{
column = this.table.AddColumn(Unit.FromCentimeter(3));
column.Format.Alignment = ParagraphAlignment.Center;
}
// Create the header of the table
Row row = table.AddRow();
row.HeadingFormat = true;
row.Format.Alignment = ParagraphAlignment.Center;
row.Format.Font.Bold = true;
row.Shading.Color = TableBlue;
for (int i = 0; i < dt.Columns.Count; i++)
{
row.Cells[i].AddParagraph(dt.Columns[i].ColumnName);
row.Cells[i].Format.Font.Bold = false;
row.Cells[i].Format.Alignment = ParagraphAlignment.Left;
row.Cells[i].VerticalAlignment = VerticalAlignment.Bottom;
}
this.table.SetEdge(0, 0, dt.Columns.Count, 1, Edge.Box, BorderStyle.Single, 0.75, Color.Empty);
}
private void ArgPointNode(Section s, ArgPoint ap)
{
//arg.point header table
var t = s.AddTable().TableDefaults(ap.Person.Color);
var c0 = t.AddColumn(0.2*ContentWidth());
var c1 = t.AddColumn(0.8*ContentWidth());
var r1 = t.AddRow();
r1.Format.Font.Bold = true;
r1.Cells[0].AddParagraph().AddBold("Point #" + ap.OrderNumber);
r1.Cells[1].AddParagraph(ap.Point);
//var r0 = t.AddRow();
//r0.Cells[0].AddParagraph("Author");
//r0.Cells[1].AddParagraph(ap.Person.Name);
//description
var descr = s.AddParagraph(ap.Description.Text);
descr.Format.Shading.Color = new MigraDoc.DocumentObjectModel.Color((uint) ap.Person.Color);
descr.AlignWithTable();
//point's media
MediaTable(s, ap.Attachment, ap.Person.Color);
//point's sources
SourcesTable(s, ap.Description.Source, ap.Person.Color);
//point's comments
CommentsTable(s, ap.Comment, ap.Person.Color);
}
public static void createTable(Section section ,string tableHeadder, string [] tableHeaders , dynamic tableData, string typeOfTable )
{
section.AddPageBreak();
section.AddParagraph();
Paragraph headerGroup = section.AddParagraph();
headerGroup.Style = "Header";
headerGroup.Format.Alignment = ParagraphAlignment.Center;
headerGroup.AddText(string.Format(tableHeadder));
section.AddParagraph();
Table table = section.AddTable();
table.Style = EstiloTabla;
table.Borders.Color = ColorBorderTabla;
table.Borders.Width = BorderWidth;
table.Borders.Left.Width = LeftWidth;
table.Borders.Right.Width = RightWidth;
table.Rows.LeftIndent = LeftIndent;
string[] sizes= new []{"16cm"};
if (tableHeaders.Length == 3)
{
sizes = length3;
}
if (tableHeaders.Length == 4)
{
sizes = length4;
}
if (tableHeaders.Length == 6)
{
sizes = length6;
}
for (int i = 0; i < sizes.Length; i++)
{
table.AddColumn(sizes[i]);
}
Row row = table.AddRow();
row.HeadingFormat = true;
row.Format.Alignment = AlineamientoTableHead;
row.Format.Font.Bold = true;
row.Shading.Color = ColorFondoTableHead;
for (int i = 0; i < tableHeaders.Length; i++)
{
row.Cells[i].AddParagraph(tableHeaders[i]);
}
row.HeadingFormat = false;
//Agregar contenido de a la tabla.
int counter = 0;
if (tableData != null)
{
foreach (var dataObj in tableData)
{
row = table.AddRow();
if (counter % 2 == 0)
row.Shading.Color = ColorFondoRow;
if (typeOfTable.Equals("initial") || typeOfTable.Equals("final"))
{
row.Cells[0].AddParagraph((string)dataObj.Descripcion);
row.Cells[1].AddParagraph((string)dataObj.volume);
row.Cells[2].AddParagraph((string)dataObj.Precio);
}
if (typeOfTable.Equals("cargas") || typeOfTable.Equals("descargas"))
{
row.Cells[0].AddParagraph((string)dataObj.Descripcion);
row.Cells[1].AddParagraph((string)dataObj.Cantidad);
row.Cells[2].AddParagraph((string)dataObj.volume);
row.Cells[3].AddParagraph((string)dataObj.Precio);
}
if(typeOfTable.Equals("ralenti")){
row.Cells[0].AddParagraph((string)dataObj.Descripcion);
row.Cells[1].AddParagraph((string)dataObj.Tiempo);
row.Cells[2].AddParagraph((string)dataObj.volume);
row.Cells[3].AddParagraph((string)dataObj.Precio);
}
if(typeOfTable.Equals("consumido")){
row.Cells[0].AddParagraph((string)dataObj.Descripcion);
row.Cells[1].AddParagraph((string)dataObj.distance);
row.Cells[2].AddParagraph((string)dataObj.volume);
row.Cells[3].AddParagraph((string)dataObj.Precio);
}
if(typeOfTable.Equals("comportamiento")){
row.Cells[0].AddParagraph((string)dataObj.Descripcion);
row.Cells[1].AddParagraph((string)dataObj.VMax);
row.Cells[2].AddParagraph((string)dataObj.TMov);
row.Cells[3].AddParagraph((string)dataObj.TMuerto);
row.Cells[4].AddParagraph((string)dataObj.RendBruto);
row.Cells[5].AddParagraph((string)dataObj.RendEfectivo);
}
counter++;
section.AddParagraph();
}
}
}
private void CreatePostListContent(Section section, Order.Order order)
{
// Add payment paragraph
var paragraph = section.AddParagraph();
paragraph.Format.SpaceBefore = "1cm";
paragraph.AddText(ReplaceDocumentPlaceHolder(order.PaymentMethode.Text, order));
// Add the notes paragraph
paragraph = section.AddParagraph();
paragraph.Format.SpaceBefore = "1cm";
paragraph.AddText(ReplaceDocumentPlaceHolder(order.OrderClosingText, order));
}
private void CreatePage()
{
// Each MigraDoc document needs at least one section.
MigraDoc.DocumentObjectModel.Section section = this.document.AddSection();
// Put a logo in the header
Image image = section.Headers.Primary.AddImage("Image_Icons/logo1.png");
image.Height = "2.5cm";
image.Width = "5cm";
image.LockAspectRatio = true;
image.RelativeVertical = RelativeVertical.Line;
image.RelativeHorizontal = RelativeHorizontal.Margin;
image.Top = ShapePosition.Top;
image.Left = ShapePosition.Right;
image.WrapFormat.Style = WrapStyle.Through;
// Create the text frame for the address
this.addressFrame = section.AddTextFrame();
this.addressFrame.Height = "8.0cm";
this.addressFrame.Width = "10.0cm";
this.addressFrame.Left = ShapePosition.Left;
this.addressFrame.RelativeHorizontal = RelativeHorizontal.Margin;
this.addressFrame.Top = "4cm";
this.addressFrame.RelativeVertical = RelativeVertical.Page;
this.PriceFrame = section.AddTextFrame();
this.PriceFrame.Height = "5.0cm";
this.PriceFrame.Width = "5.0cm";
this.PriceFrame.Left = ShapePosition.Right;
this.PriceFrame.RelativeHorizontal = RelativeHorizontal.Margin;
this.PriceFrame.Top = "4.0cm";
this.PriceFrame.RelativeVertical = RelativeVertical.Page;
// Put sender in address frame
//= addressFrame.AddParagraph("ul.Pralki 5, 13-342 Lodówka");
//paragraph.Format.Font.Name = "Times New Roman";
//paragraph.Format.Font.Size = 7;
//paragraph.Format.SpaceAfter = 3;
// Add the print date field
MigraDoc.DocumentObjectModel.Paragraph paragraph = section.AddParagraph();
paragraph.Format.SpaceBefore = "8cm";
paragraph.Style = "Reference";
paragraph.AddFormattedText($"Faktura nr {order.Date.Year}/{order.Id}", TextFormat.Bold);
paragraph.AddTab();
paragraph.AddText("Białystok, ");
paragraph.AddDateField("dd.MM.yyyy");
paragraph = section.Footers.Primary.AddParagraph();
paragraph.AddText($"\u00a9 2021 RTV&AGD \n ul.Pralki 5, 13-342 Lodówka \n Data wydruku: {DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss")} ");
paragraph.Format.Font.Size = 9;
paragraph.Format.Alignment = ParagraphAlignment.Center;
// Create the item table
this.table = section.AddTable();
table.Format.Alignment = ParagraphAlignment.Justify;
table.Borders.Color = MigraDoc.DocumentObjectModel.Colors.Black;
table.Borders.Width = 0.25;
table.Borders.Left.Width = 0.5;
table.Borders.Right.Width = 0.5;
table.Rows.LeftIndent = 5;
table.TopPadding = 10;
table.BottomPadding = 10;
// Before you can add a row, you must define the columns
Column column = this.table.AddColumn("7.5cm");
column.Format.Alignment = ParagraphAlignment.Center;
column = this.table.AddColumn("1.5cm");
column.Format.Alignment = ParagraphAlignment.Right;
column = this.table.AddColumn("3.5cm");
column.Format.Alignment = ParagraphAlignment.Right;
column = this.table.AddColumn("3.5cm");
column.Format.Alignment = ParagraphAlignment.Right;
// Create the header of the table
Row row = table.AddRow();
row.HeadingFormat = true;
row.Format.Alignment = ParagraphAlignment.Left;
row.Format.Font.Bold = true;
row.Shading.Color = TableBlue;
row.Cells[0].AddParagraph("Nazwa");
row.Cells[0].Format.Font.Bold = true;
row.Cells[0].Format.Alignment = ParagraphAlignment.Left;
row.Cells[0].VerticalAlignment = MigraDoc.DocumentObjectModel.Tables.VerticalAlignment.Center;
row.Cells[1].AddParagraph("Ilość");
row.Cells[1].Format.Alignment = ParagraphAlignment.Left;
row.Cells[2].AddParagraph("Cena/szt");
row.Cells[2].Format.Alignment = ParagraphAlignment.Left;
row.Cells[2].VerticalAlignment = MigraDoc.DocumentObjectModel.Tables.VerticalAlignment.Center;
row.Cells[3].AddParagraph("Wartosc");
row.Cells[3].Format.Alignment = ParagraphAlignment.Left;
row.Cells[3].VerticalAlignment = MigraDoc.DocumentObjectModel.Tables.VerticalAlignment.Center;
this.table.SetEdge(0, 0, 4, 1, Edge.Box, BorderStyle.Single, 0.75, MigraDoc.DocumentObjectModel.Color.Empty);
}
/// <summary>Writes PDF for specified auto-doc commands.</summary>
/// <param name="section">The writer to write to.</param>
/// <param name="tags">The autodoc tags.</param>
/// <param name="workingDirectory">The working directory.</param>
private void TagsToMigraDoc(Section section, List<AutoDocumentation.ITag> tags, string workingDirectory)
{
foreach (AutoDocumentation.ITag tag in tags)
{
if (tag is AutoDocumentation.Heading)
{
AutoDocumentation.Heading heading = tag as AutoDocumentation.Heading;
if (heading.headingLevel > 0 && heading.headingLevel < 4)
{
Paragraph para = section.AddParagraph(heading.text, "Heading" + heading.headingLevel);
if (heading.headingLevel == 1)
para.Format.OutlineLevel = OutlineLevel.Level1;
else if (heading.headingLevel == 2)
para.Format.OutlineLevel = OutlineLevel.Level2;
else if (heading.headingLevel == 3)
para.Format.OutlineLevel = OutlineLevel.Level3;
else if (heading.headingLevel == 4)
para.Format.OutlineLevel = OutlineLevel.Level4;
}
}
else if (tag is AutoDocumentation.Paragraph)
{
AddFormattedParagraphToSection(section, tag as AutoDocumentation.Paragraph);
}
else if (tag is AutoDocumentation.GraphAndTable)
{
CreateGraphPDF(section, tag as AutoDocumentation.GraphAndTable, workingDirectory);
}
else if (tag is Graph)
{
GraphPresenter graphPresenter = new GraphPresenter();
GraphView graphView = new GraphView();
graphView.BackColor = System.Drawing.Color.White;
graphPresenter.Attach(tag, graphView, ExplorerPresenter);
string PNGFileName = graphPresenter.ExportToPDF(workingDirectory);
section.AddImage(PNGFileName);
string caption = (tag as Graph).Caption;
if (caption != null)
section.AddParagraph(caption);
graphPresenter.Detach();
}
}
}
///<summary>Supply pd so that we know the paper size and margins.</summary>
public static void CreateDocument(FormRpStatement sender, MigraDoc.DocumentObjectModel.Document doc, PrintDocument pd, Family fam, Patient pat, DataSet dataSet, Statement Stmt)
{
//doc= new MigraDoc.DocumentObjectModel.Document();//don't do this or the reference to the original doc will be lost.
doc.DefaultPageSetup.PageWidth = Unit.FromInch((double)pd.DefaultPageSettings.PaperSize.Width / 100);
doc.DefaultPageSetup.PageHeight = Unit.FromInch((double)pd.DefaultPageSettings.PaperSize.Height / 100);
doc.DefaultPageSetup.TopMargin = Unit.FromInch((double)pd.DefaultPageSettings.Margins.Top / 100);
doc.DefaultPageSetup.LeftMargin = Unit.FromInch((double)pd.DefaultPageSettings.Margins.Left / 100);
doc.DefaultPageSetup.RightMargin = Unit.FromInch((double)pd.DefaultPageSettings.Margins.Right / 100);
doc.DefaultPageSetup.BottomMargin = Unit.FromInch((double)pd.DefaultPageSettings.Margins.Bottom / 100);
MigraDoc.DocumentObjectModel.Section section = doc.AddSection(); //so that Swiss will have different footer for each patient.
string text;
MigraDoc.DocumentObjectModel.Font font;
//GetPatGuar(PatNums[famIndex][0]);
//Family fam=Patients.GetFamily(Stmt.PatNum);
Patient PatGuar = fam.ListPats[0]; //.Copy();
//Patient pat=fam.GetPatient(Stmt.PatNum);
DataTable tableMisc = dataSet.Tables["misc"];
//HEADING------------------------------------------------------------------------------
#region Heading
Paragraph par = section.AddParagraph();
ParagraphFormat parformat = new ParagraphFormat();
parformat.Alignment = ParagraphAlignment.Center;
par.Format = parformat;
font = MigraDocHelper.CreateFont(14, true);
text = "This statement was generated from the plug-in";
par.AddFormattedText(text, font);
text = DateTime.Today.ToShortDateString();
font = MigraDocHelper.CreateFont(10);
par.AddLineBreak();
par.AddFormattedText(text, font);
text = Lan.g("FormRpStatement", "Account Number") + " ";
if (PrefC.GetBool(PrefName.StatementAccountsUseChartNumber))
{
text += PatGuar.ChartNumber;
}
else
{
text += PatGuar.PatNum;
}
par.AddLineBreak();
par.AddFormattedText(text, font);
TextFrame frame;
#endregion
//Practice Address----------------------------------------------------------------------
#region Practice Address
if (PrefC.GetBool(PrefName.StatementShowReturnAddress))
{
font = MigraDocHelper.CreateFont(10);
frame = section.AddTextFrame();
frame.RelativeVertical = RelativeVertical.Page;
frame.RelativeHorizontal = RelativeHorizontal.Page;
frame.MarginLeft = Unit.Zero;
frame.MarginTop = Unit.Zero;
frame.Top = TopPosition.Parse("0.5 in");
frame.Left = LeftPosition.Parse("0.3 in");
frame.Width = Unit.FromInch(3);
if (!PrefC.GetBool(PrefName.EasyNoClinics) && Clinics.List.Length > 0 && //if using clinics
Clinics.GetClinic(PatGuar.ClinicNum) != null) //and this patient assigned to a clinic
{
Clinic clinic = Clinics.GetClinic(PatGuar.ClinicNum);
par = frame.AddParagraph();
par.Format.Font = font;
par.AddText(clinic.Description);
par.AddLineBreak();
par.AddText(clinic.Address);
par.AddLineBreak();
if (clinic.Address2 != "")
{
par.AddText(clinic.Address2);
par.AddLineBreak();
}
if (CultureInfo.CurrentCulture.Name.EndsWith("CH")) //CH is for switzerland. eg de-CH
{
par.AddText(clinic.Zip + " " + clinic.City);
}
else
{
par.AddText(clinic.City + ", " + clinic.State + " " + clinic.Zip);
}
par.AddLineBreak();
text = clinic.Phone;
if (text.Length == 10)
{
text = "(" + text.Substring(0, 3) + ")" + text.Substring(3, 3) + "-" + text.Substring(6);
}
par.AddText(text);
par.AddLineBreak();
}
else
{
par = frame.AddParagraph();
par.Format.Font = font;
par.AddText(PrefC.GetString(PrefName.PracticeTitle));
par.AddLineBreak();
if (CultureInfo.CurrentCulture.Name == "en-AU") //English (Australia)
{
Provider defaultProv = Providers.GetProv(PrefC.GetLong(PrefName.PracticeDefaultProv));
par.AddText("ABN: " + defaultProv.NationalProvID);
par.AddLineBreak();
}
par.AddText(PrefC.GetString(PrefName.PracticeAddress));
par.AddLineBreak();
if (PrefC.GetString(PrefName.PracticeAddress2) != "")
{
par.AddText(PrefC.GetString(PrefName.PracticeAddress2));
par.AddLineBreak();
}
if (CultureInfo.CurrentCulture.Name.EndsWith("CH")) //CH is for switzerland. eg de-CH
{
par.AddText(PrefC.GetString(PrefName.PracticeZip) + " " + PrefC.GetString(PrefName.PracticeCity));
}
else
{
par.AddText(PrefC.GetString(PrefName.PracticeCity) + ", " + PrefC.GetString(PrefName.PracticeST) + " " + PrefC.GetString(PrefName.PracticeZip));
}
par.AddLineBreak();
text = PrefC.GetString(PrefName.PracticePhone);
if (text.Length == 10)
{
text = "(" + text.Substring(0, 3) + ")" + text.Substring(3, 3) + "-" + text.Substring(6);
}
par.AddText(text);
par.AddLineBreak();
}
}
#endregion
//AMOUNT ENCLOSED------------------------------------------------------------------------------------------------------
#region Amount Enclosed
Table table;
Column col;
Row row;
Cell cell;
frame = MigraDocHelper.CreateContainer(section, 450, 110, 330, 29);
if (!Stmt.HidePayment)
{
table = MigraDocHelper.DrawTable(frame, 0, 0, 29);
col = table.AddColumn(Unit.FromInch(1.1));
col = table.AddColumn(Unit.FromInch(1.1));
col = table.AddColumn(Unit.FromInch(1.1));
row = table.AddRow();
row.Format.Alignment = ParagraphAlignment.Center;
row.Borders.Color = Colors.Black;
row.Shading.Color = Colors.LightGray;
row.TopPadding = Unit.FromInch(0);
row.BottomPadding = Unit.FromInch(0);
font = MigraDocHelper.CreateFont(8, true);
cell = row.Cells[0];
par = cell.AddParagraph();
par.AddFormattedText(Lan.g("FormRpStatement", "Amount Due"), font);
cell = row.Cells[1];
par = cell.AddParagraph();
par.AddFormattedText(Lan.g("FormRpStatement", "Date Due"), font);
cell = row.Cells[2];
par = cell.AddParagraph();
par.AddFormattedText(Lan.g("FormRpStatement", "Amount Enclosed"), font);
row = table.AddRow();
row.Format.Alignment = ParagraphAlignment.Center;
row.Borders.Left.Color = Colors.Gray;
row.Borders.Bottom.Color = Colors.Gray;
row.Borders.Right.Color = Colors.Gray;
font = MigraDocHelper.CreateFont(9);
double balTotal = PatGuar.BalTotal;
if (!PrefC.GetBool(PrefName.BalancesDontSubtractIns)) //this is typical
{
balTotal -= PatGuar.InsEst;
}
for (int m = 0; m < tableMisc.Rows.Count; m++)
{
if (tableMisc.Rows[m]["descript"].ToString() == "payPlanDue")
{
balTotal += PIn.Double(tableMisc.Rows[m]["value"].ToString());
//payPlanDue;//PatGuar.PayPlanDue;
}
}
text = balTotal.ToString("F");
cell = row.Cells[0];
par = cell.AddParagraph();
par.AddFormattedText(text, font);
if (PrefC.GetLong(PrefName.StatementsCalcDueDate) == -1)
{
text = Lan.g("FormRpStatement", "Upon Receipt");
}
else
{
text = DateTime.Today.AddDays(PrefC.GetLong(PrefName.StatementsCalcDueDate)).ToShortDateString();
}
cell = row.Cells[1];
par = cell.AddParagraph();
par.AddFormattedText(text, font);
}
#endregion
//Credit Card Info--------------------------------------------------------------------------------------------------------
#region Credit Card Info
if (!Stmt.HidePayment)
{
if (PrefC.GetBool(PrefName.StatementShowCreditCard))
{
float yPos = 60;
font = MigraDocHelper.CreateFont(7, true);
text = Lan.g("FormRpStatement", "CREDIT CARD TYPE");
MigraDocHelper.DrawString(frame, text, font, 0, yPos);
float rowHeight = 26;
System.Drawing.Font wfont = new System.Drawing.Font("Arial", 7, FontStyle.Bold);
System.Drawing.Image img = new Bitmap(500, 30);
Graphics g = Graphics.FromImage(img); //just to measure strings
MigraDocHelper.DrawLine(frame, System.Drawing.Color.Black, g.MeasureString(text, wfont).Width,
yPos + wfont.GetHeight(g), 326, yPos + wfont.GetHeight(g));
yPos += rowHeight;
text = Lan.g("FormRpStatement", "#");
MigraDocHelper.DrawString(frame, text, font, 0, yPos);
MigraDocHelper.DrawLine(frame, System.Drawing.Color.Black, g.MeasureString(text, wfont).Width,
yPos + wfont.GetHeight(g), 326, yPos + wfont.GetHeight(g));
yPos += rowHeight;
text = Lan.g("FormRpStatement", "3 DIGIT CSV");
MigraDocHelper.DrawString(frame, text, font, 0, yPos);
MigraDocHelper.DrawLine(frame, System.Drawing.Color.Black, g.MeasureString(text, wfont).Width,
yPos + wfont.GetHeight(g), 326, yPos + wfont.GetHeight(g));
yPos += rowHeight;
text = Lan.g("FormRpStatement", "EXPIRES");
MigraDocHelper.DrawString(frame, text, font, 0, yPos);
MigraDocHelper.DrawLine(frame, System.Drawing.Color.Black, g.MeasureString(text, wfont).Width,
yPos + wfont.GetHeight(g), 326, yPos + wfont.GetHeight(g));
yPos += rowHeight;
text = Lan.g("FormRpStatement", "AMOUNT APPROVED");
MigraDocHelper.DrawString(frame, text, font, 0, yPos);
MigraDocHelper.DrawLine(frame, System.Drawing.Color.Black, g.MeasureString(text, wfont).Width,
yPos + wfont.GetHeight(g), 326, yPos + wfont.GetHeight(g));
yPos += rowHeight;
text = Lan.g("FormRpStatement", "NAME");
MigraDocHelper.DrawString(frame, text, font, 0, yPos);
MigraDocHelper.DrawLine(frame, System.Drawing.Color.Black, g.MeasureString(text, wfont).Width,
yPos + wfont.GetHeight(g), 326, yPos + wfont.GetHeight(g));
yPos += rowHeight;
text = Lan.g("FormRpStatement", "SIGNATURE");
MigraDocHelper.DrawString(frame, text, font, 0, yPos);
MigraDocHelper.DrawLine(frame, System.Drawing.Color.Black, g.MeasureString(text, wfont).Width,
yPos + wfont.GetHeight(g), 326, yPos + wfont.GetHeight(g));
yPos -= rowHeight;
text = Lan.g("FormRpStatement", "(As it appears on card)");
wfont = new System.Drawing.Font("Arial", 5);
font = MigraDocHelper.CreateFont(5);
MigraDocHelper.DrawString(frame, text, font, 625 - g.MeasureString(text, wfont).Width / 2 + 5, yPos + 13);
g.Dispose();
img = null;
}
}
#endregion
//Patient's Billing Address---------------------------------------------------------------------------------------------
#region Patient Billing Address
font = MigraDocHelper.CreateFont(11);
frame = MigraDocHelper.CreateContainer(section, 62.5f + 12.5f, 225 + 1, 300, 200);
par = frame.AddParagraph();
par.Format.Font = font;
if (Stmt.SinglePatient)
{
par.AddText(fam.GetNameInFamFL(Stmt.PatNum));
}
else
{
par.AddText(PatGuar.GetNameFLFormal());
}
par.AddLineBreak();
par.AddText(PatGuar.Address);
par.AddLineBreak();
if (PatGuar.Address2 != "")
{
par.AddText(PatGuar.Address2);
par.AddLineBreak();
}
if (CultureInfo.CurrentCulture.Name.EndsWith("CH")) //CH is for switzerland. eg de-CH
{
par.AddText(PatGuar.Zip + " " + PatGuar.City);
}
else
{
par.AddText(PatGuar.City + ", " + PatGuar.State + " " + PatGuar.Zip);
}
//perforated line------------------------------------------------------------------------------------------------------
//yPos=350;//3.62 inches from top, 1/3 page down
frame = MigraDocHelper.CreateContainer(section, 0, 350, 850, 30);
if (!Stmt.HidePayment)
{
MigraDocHelper.DrawLine(frame, System.Drawing.Color.LightGray, 0, 0, 850, 0);
text = Lan.g("FormRpStatement", "PLEASE DETACH AND RETURN THE UPPER PORTION WITH YOUR PAYMENT");
font = MigraDocHelper.CreateFont(6, true, System.Drawing.Color.Gray);
par = frame.AddParagraph();
par.Format.Alignment = ParagraphAlignment.Center;
par.Format.Font = font;
par.AddText(text);
}
#endregion
//Australian Provider Legend
#region Australian Provider Legend
int legendOffset = 0;
if (CultureInfo.CurrentCulture.Name == "en-AU") //English (Australia)
{
Providers.RefreshCache();
legendOffset = 25 + 15 * (1 + ProviderC.List.Length);
MigraDocHelper.InsertSpacer(section, legendOffset);
frame = MigraDocHelper.CreateContainer(section, 45, 390, 250, legendOffset);
par = frame.AddParagraph();
par.Format.Font = MigraDocHelper.CreateFont(8, true);
par.AddLineBreak();
par.AddText("PROVIDERS:");
par = frame.AddParagraph();
par.Format.Font = MigraDocHelper.CreateFont(8, false);
for (int i = 0; i < ProviderC.List.Length; i++) //All non-hidden providers are added to the legend.
{
Provider prov = ProviderC.List[i];
string suffix = "";
if (prov.Suffix.Trim() != "")
{
suffix = ", " + prov.Suffix.Trim();
}
par.AddText(prov.Abbr + " - " + prov.FName + " " + prov.LName + suffix + " - " + prov.MedicaidID);
par.AddLineBreak();
}
par.AddLineBreak();
}
#endregion
//Aging-----------------------------------------------------------------------------------
#region Aging
MigraDocHelper.InsertSpacer(section, 275);
frame = MigraDocHelper.CreateContainer(section, 55, 390 + legendOffset, 250, 29);
if (!Stmt.HidePayment)
{
table = MigraDocHelper.DrawTable(frame, 0, 0, 29);
col = table.AddColumn(Unit.FromInch(1.1));
col = table.AddColumn(Unit.FromInch(1.1));
col = table.AddColumn(Unit.FromInch(1.1));
col = table.AddColumn(Unit.FromInch(1.1));
row = table.AddRow();
row.Format.Alignment = ParagraphAlignment.Center;
row.Borders.Color = Colors.Black;
row.Shading.Color = Colors.LightGray;
row.TopPadding = Unit.FromInch(0);
row.BottomPadding = Unit.FromInch(0);
font = MigraDocHelper.CreateFont(8, true);
cell = row.Cells[0];
par = cell.AddParagraph();
par.AddFormattedText(Lan.g("FormRpStatement", "0-30"), font);
cell = row.Cells[1];
par = cell.AddParagraph();
par.AddFormattedText(Lan.g("FormRpStatement", "31-60"), font);
cell = row.Cells[2];
par = cell.AddParagraph();
par.AddFormattedText(Lan.g("FormRpStatement", "61-90"), font);
cell = row.Cells[3];
par = cell.AddParagraph();
par.AddFormattedText(Lan.g("FormRpStatement", "over 90"), font);
row = table.AddRow();
row.Format.Alignment = ParagraphAlignment.Center;
row.Borders.Left.Color = Colors.Gray;
row.Borders.Bottom.Color = Colors.Gray;
row.Borders.Right.Color = Colors.Gray;
font = MigraDocHelper.CreateFont(9);
text = PatGuar.Bal_0_30.ToString("F");
cell = row.Cells[0];
par = cell.AddParagraph();
par.AddFormattedText(text, font);
text = PatGuar.Bal_31_60.ToString("F");
cell = row.Cells[1];
par = cell.AddParagraph();
par.AddFormattedText(text, font);
text = PatGuar.Bal_61_90.ToString("F");
cell = row.Cells[2];
par = cell.AddParagraph();
par.AddFormattedText(text, font);
text = PatGuar.BalOver90.ToString("F");
cell = row.Cells[3];
par = cell.AddParagraph();
par.AddFormattedText(text, font);
}
#endregion
//Floating Balance, Ins info-------------------------------------------------------------------
#region FloatingBalance
frame = MigraDocHelper.CreateContainer(section, 460, 380 + legendOffset, 250, 200);
//table=MigraDocHelper.DrawTable(frame,0,0,90);
par = frame.AddParagraph();
parformat = new ParagraphFormat();
parformat.Alignment = ParagraphAlignment.Right;
par.Format = parformat;
font = MigraDocHelper.CreateFont(10, false);
MigraDoc.DocumentObjectModel.Font fontBold = MigraDocHelper.CreateFont(10, true);
if (PrefC.GetBool(PrefName.BalancesDontSubtractIns))
{
text = Lan.g("FormRpStatement", "Balance:");
par.AddFormattedText(text, fontBold);
//par.AddLineBreak();
//text = Lan.g(this, "Ins Pending:");
//par.AddFormattedText(text, font);
//par.AddLineBreak();
//text = Lan.g(this, "After Ins:");
//par.AddFormattedText(text, font);
//par.AddLineBreak();
}
else //this is more common
{
if (PrefC.GetBool(PrefName.FuchsOptionsOn))
{
text = Lan.g("FormRpStatement", "Balance:");
par.AddFormattedText(text, font);
par.AddLineBreak();
text = Lan.g("FormRpStatement", "-Ins Estimate:");
par.AddFormattedText(text, font);
par.AddLineBreak();
text = Lan.g("FormRpStatement", "=Owed Now:");
par.AddFormattedText(text, fontBold);
par.AddLineBreak();
}
else
{
text = Lan.g("FormRpStatement", "Total:");
par.AddFormattedText(text, font);
par.AddLineBreak();
text = Lan.g("FormRpStatement", "-Ins Estimate:");
par.AddFormattedText(text, font);
par.AddLineBreak();
text = Lan.g("FormRpStatement", "=Balance:");
par.AddFormattedText(text, fontBold);
par.AddLineBreak();
}
}
frame = MigraDocHelper.CreateContainer(section, 730, 380 + legendOffset, 100, 200);
//table=MigraDocHelper.DrawTable(frame,0,0,90);
par = frame.AddParagraph();
parformat = new ParagraphFormat();
parformat.Alignment = ParagraphAlignment.Left;
par.Format = parformat;
font = MigraDocHelper.CreateFont(10, false);
//numbers:
if (PrefC.GetBool(PrefName.BalancesDontSubtractIns))
{
text = PatGuar.BalTotal.ToString("c");
par.AddFormattedText(text, fontBold);
//par.AddLineBreak();
//text = PatGuar.InsEst.ToString("c");
//par.AddFormattedText(text, font);
//par.AddLineBreak();
//text = (PatGuar.BalTotal - PatGuar.InsEst).ToString("c");
//par.AddFormattedText(text, font);
//par.AddLineBreak();
}
else //more common
{
if (Stmt.SinglePatient)
{
double patInsEst = 0;
for (int m = 0; m < tableMisc.Rows.Count; m++)
{
if (tableMisc.Rows[m]["descript"].ToString() == "patInsEst")
{
patInsEst = PIn.Double(tableMisc.Rows[m]["value"].ToString());
}
}
double patBal = pat.EstBalance - patInsEst;
text = pat.EstBalance.ToString("c");
par.AddFormattedText(text, font);
par.AddLineBreak();
text = patInsEst.ToString("c");
par.AddFormattedText(text, font);
par.AddLineBreak();
text = patBal.ToString("c");
par.AddFormattedText(text, fontBold);
}
else
{
text = PatGuar.BalTotal.ToString("c");
par.AddFormattedText(text, font);
par.AddLineBreak();
text = PatGuar.InsEst.ToString("c");
par.AddFormattedText(text, font);
par.AddLineBreak();
text = (PatGuar.BalTotal - PatGuar.InsEst).ToString("c");
par.AddFormattedText(text, fontBold);
par.AddLineBreak();
}
}
MigraDocHelper.InsertSpacer(section, 80);
#endregion FloatingBalance
//Bold note-------------------------------------------------------------------------------
#region Bold note
if (Stmt.NoteBold != "")
{
MigraDocHelper.InsertSpacer(section, 7);
font = MigraDocHelper.CreateFont(10, true, System.Drawing.Color.DarkRed);
par = section.AddParagraph();
par.Format.Font = font;
par.AddText(Stmt.NoteBold);
MigraDocHelper.InsertSpacer(section, 8);
}
#endregion Bold note
//Payment plan grid definition---------------------------------------------------------------------------------
#region PayPlan grid definition
ODGridColumn gcol;
ODGridRow grow;
ODGrid gridPP = new ODGrid();
//this.Controls.Add(gridPP);
gridPP.BeginUpdate();
gridPP.Columns.Clear();
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Date"), 73);
gridPP.Columns.Add(gcol);
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Description"), 270);
gridPP.Columns.Add(gcol);
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Charges"), 60, HorizontalAlignment.Right);
gridPP.Columns.Add(gcol);
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Credits"), 60, HorizontalAlignment.Right);
gridPP.Columns.Add(gcol);
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Balance"), 60, HorizontalAlignment.Right);
gridPP.Columns.Add(gcol);
gridPP.Width = gridPP.WidthAllColumns + 20;
gridPP.EndUpdate();
#endregion PayPlan grid definition
//Payment plan grid. There will be only one, if any-----------------------------------------------------------------
#region PayPlan grid
DataTable tablePP = dataSet.Tables["payplan"];
ODGridCell gcell;
if (tablePP.Rows.Count > 0)
{
//MigraDocHelper.InsertSpacer(section,5);
par = section.AddParagraph();
par.Format.Font = MigraDocHelper.CreateFont(10, true);
par.Format.Alignment = ParagraphAlignment.Center;
//par.Format.SpaceBefore=Unit.FromInch(.05);
//par.Format.SpaceAfter=Unit.FromInch(.05);
par.AddText(Lan.g("FormRpStatement", "Payment Plans"));
MigraDocHelper.InsertSpacer(section, 2);
gridPP.BeginUpdate();
gridPP.Rows.Clear();
for (int p = 0; p < tablePP.Rows.Count; p++)
{
grow = new ODGridRow();
grow.Cells.Add(tablePP.Rows[p]["date"].ToString());
grow.Cells.Add(tablePP.Rows[p]["description"].ToString());
grow.Cells.Add(tablePP.Rows[p]["charges"].ToString());
grow.Cells.Add(tablePP.Rows[p]["credits"].ToString());
gcell = new ODGridCell(tablePP.Rows[p]["balance"].ToString());
if (p == tablePP.Rows.Count - 1)
{
gcell.Bold = YN.Yes;
}
else if (tablePP.Rows[p + 1]["balance"].ToString() == "") //if next row balance is blank.
{
gcell.Bold = YN.Yes;
}
grow.Cells.Add(gcell);
gridPP.Rows.Add(grow);
}
gridPP.EndUpdate();
MigraDocHelper.DrawGrid(section, gridPP);
MigraDocHelper.InsertSpacer(section, 2);
par = section.AddParagraph();
par.Format.Font = MigraDocHelper.CreateFont(10, true);
par.Format.Alignment = ParagraphAlignment.Right;
par.Format.RightIndent = Unit.FromInch(0.25);
double payPlanDue = 0;
for (int m = 0; m < tableMisc.Rows.Count; m++)
{
if (tableMisc.Rows[m]["descript"].ToString() == "payPlanDue")
{
payPlanDue = PIn.Double(tableMisc.Rows[m]["value"].ToString());
}
}
par.AddText(Lan.g("FormRpStatement", "Payment Plan Amount Due: ") + payPlanDue.ToString("c")); //PatGuar.PayPlanDue.ToString("c"));
MigraDocHelper.InsertSpacer(section, 10);
}
#endregion PayPlan grid
//Body Table definition--------------------------------------------------------------------------------------------------------
#region Body Table definition
ODGrid gridPat = new ODGrid();
//this.Controls.Add(gridPat);
gridPat.BeginUpdate();
gridPat.Columns.Clear();
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Date"), 73);
gridPat.Columns.Add(gcol);
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Patient"), 100);
gridPat.Columns.Add(gcol);
//prov
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Code"), 45);
gridPat.Columns.Add(gcol);
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Tooth"), 42);
gridPat.Columns.Add(gcol);
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Description"), 270);
gridPat.Columns.Add(gcol);
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Charges"), 60, HorizontalAlignment.Right);
gridPat.Columns.Add(gcol);
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Credits"), 60, HorizontalAlignment.Right);
gridPat.Columns.Add(gcol);
gcol = new ODGridColumn(Lan.g("FormRpStatement", "Balance"), 60, HorizontalAlignment.Right);
gridPat.Columns.Add(gcol);
gridPat.Width = gridPat.WidthAllColumns + 20;
gridPat.EndUpdate();
#endregion Body Table definition
//Loop through each table. Could be one intermingled, or one for each patient-----------------------------------------
DataTable tableAccount;
string tablename;
long patnum;
for (int i = 0; i < dataSet.Tables.Count; i++)
{
tableAccount = dataSet.Tables[i];
tablename = tableAccount.TableName;
if (!tablename.StartsWith("account"))
{
continue;
}
par = section.AddParagraph();
par.Format.Font = MigraDocHelper.CreateFont(10, true);
par.Format.SpaceBefore = Unit.FromInch(.05);
par.Format.SpaceAfter = Unit.FromInch(.05);
patnum = 0;
if (tablename != "account") //account123 etc.
{
patnum = PIn.Long(tablename.Substring(7));
}
if (patnum != 0)
{
par.AddText(fam.GetNameInFamFLnoPref(patnum));
}
//if(FamilyStatementDataList[famIndex].PatAboutList[i].ApptDescript!=""){
// par=section.AddParagraph();
// par.Format.Font=MigraDocHelper.CreateFont(9);//same as body font
// par.AddText(FamilyStatementDataList[famIndex].PatAboutList[i].ApptDescript);
//}
gridPat.BeginUpdate();
gridPat.Rows.Clear();
//lineData=FamilyStatementDataList[famIndex].PatDataList[i].PatData;
for (int p = 0; p < tableAccount.Rows.Count; p++)
{
grow = new ODGridRow();
grow.Cells.Add(tableAccount.Rows[p]["date"].ToString());
grow.Cells.Add(tableAccount.Rows[p]["patient"].ToString());
grow.Cells.Add(tableAccount.Rows[p]["ProcCode"].ToString());
grow.Cells.Add(tableAccount.Rows[p]["tth"].ToString());
if (CultureInfo.CurrentCulture.Name == "en-AU") //English (Australia)
{
if (tableAccount.Rows[p]["prov"].ToString().Trim() != "")
{
grow.Cells.Add(tableAccount.Rows[p]["prov"].ToString() + " - " + tableAccount.Rows[p]["description"].ToString());
}
else //No provider on this account row item, so don't put the extra leading characters.
{
grow.Cells.Add(tableAccount.Rows[p]["description"].ToString());
}
}
else //Assume English (United States)
{
grow.Cells.Add(tableAccount.Rows[p]["description"].ToString());
}
grow.Cells.Add(tableAccount.Rows[p]["charges"].ToString());
grow.Cells.Add(tableAccount.Rows[p]["credits"].ToString());
grow.Cells.Add(tableAccount.Rows[p]["balance"].ToString());
gridPat.Rows.Add(grow);
}
gridPat.EndUpdate();
MigraDocHelper.DrawGrid(section, gridPat);
//Total
frame = MigraDocHelper.CreateContainer(section);
font = MigraDocHelper.CreateFont(9, true);
float totalPos = ((float)(doc.DefaultPageSetup.PageWidth.Inch //-doc.DefaultPageSetup.LeftMargin.Inch
//-doc.DefaultPageSetup.RightMargin.Inch)
) * 100f) / 2f + (float)gridPat.WidthAllColumns / 2f + 7;
RectangleF rectF = new RectangleF(0, 0, totalPos, 16);
if (patnum != 0)
{
MigraDocHelper.DrawString(frame, " ",
//I decided this was unnecessary:
//dataSet.Tables["patient"].Rows[fam.GetIndex(patnum)]["balance"].ToString(),
font, rectF, ParagraphAlignment.Right);
//MigraDocHelper.DrawString(frame,FamilyStatementDataList[famIndex].PatAboutList[i].Balance.ToString("F"),font,rectF,
// ParagraphAlignment.Right);
}
}
gridPat.Dispose();
//Future appointments---------------------------------------------------------------------------------------------
#region Future appointments
font = MigraDocHelper.CreateFont(9);
DataTable tableAppt = dataSet.Tables["appts"];
if (tableAppt.Rows.Count > 0)
{
par = section.AddParagraph();
par.Format.Font = font;
par.AddText(Lan.g("FormRpStatement", "Scheduled Appointments:"));
}
for (int i = 0; i < tableAppt.Rows.Count; i++)
{
par.AddLineBreak();
par.AddText(tableAppt.Rows[i]["descript"].ToString());
}
if (tableAppt.Rows.Count > 0)
{
MigraDocHelper.InsertSpacer(section, 10);
}
#endregion Future appointments
//Note------------------------------------------------------------------------------------------------------------
font = MigraDocHelper.CreateFont(9);
par = section.AddParagraph();
par.Format.Font = font;
par.AddText(Stmt.Note);
//bold note
if (Stmt.NoteBold != "")
{
MigraDocHelper.InsertSpacer(section, 10);
font = MigraDocHelper.CreateFont(10, true, System.Drawing.Color.DarkRed);
par = section.AddParagraph();
par.Format.Font = font;
par.AddText(Stmt.NoteBold);
}
//return doc;
}
private static void AddCompetitionAndLogo(Client.DataAccess c, Section sec)
{
String competitionName = "Competition: " + c.SelectedCompetition.Name;
Paragraph pg = sec.AddParagraph();
pg.Format.Alignment = ParagraphAlignment.Left;
pg.Format.KeepTogether = false;
pg.Format.KeepWithNext = false;
pg.Format.AddTabStop(Unit.FromCentimeter(21));
FormattedText ft = pg.AddFormattedText(competitionName);
ft.Bold = true;
ft.Size = Unit.FromPoint(16);
pg.AddTab();
Image logo = pg.AddImage(@"Resources\ANR_LOGO.jpg");
logo.Height = Unit.FromCentimeter(1.912);
logo.Width = Unit.FromCentimeter(2.873);
logo.LockAspectRatio = true;
logo.Left = Unit.FromCentimeter(21);
logo.Top = Unit.FromCentimeter(0);
}
/// <summary>Creates the graph.</summary>
/// <param name="writer">The writer.</param>
/// <param name="graphAndTable">The graph and table to convert to html.</param>
/// <param name="workingDirectory">The working directory.</param>
private void CreateGraphPDF(Section section, AutoDocumentation.GraphAndTable graphAndTable, string workingDirectory)
{
// Create a 2 column, 1 row table. Image in first cell, X/Y data in second cell.
Table table = section.AddTable();
table.Style = "GraphAndTable";
table.Rows.LeftIndent = graphAndTable.indent + "cm";
Column column1 = table.AddColumn();
column1.Width = "8cm";
//column1.Format.Alignment = ParagraphAlignment.Right;
Column column2 = table.AddColumn();
column2.Width = "8cm";
//column2.Format.Alignment = ParagraphAlignment.Right;
Row row = table.AddRow();
// Ensure graphs directory exists.
string graphDirectory = Path.Combine(workingDirectory, "Graphs");
Directory.CreateDirectory(graphDirectory);
// Determine the name of the .png file to write.
string PNGFileName = Path.Combine(graphDirectory,
graphAndTable.xyPairs.Parent.Parent.Name + graphAndTable.xyPairs.Parent.Name + ".png");
// Setup graph.
GraphView graph = new GraphView();
graph.Clear();
// Create a line series.
graph.DrawLineAndMarkers("", graphAndTable.xyPairs.X, graphAndTable.xyPairs.Y,
Models.Graph.Axis.AxisType.Bottom, Models.Graph.Axis.AxisType.Left,
System.Drawing.Color.Blue, Models.Graph.LineType.Solid, Models.Graph.MarkerType.None,
Models.Graph.LineThicknessType.Normal, Models.Graph.MarkerSizeType.Normal, true);
// Format the axes.
graph.FormatAxis(Models.Graph.Axis.AxisType.Bottom, graphAndTable.xName, false, double.NaN, double.NaN, double.NaN);
graph.FormatAxis(Models.Graph.Axis.AxisType.Left, graphAndTable.yName, false, double.NaN, double.NaN, double.NaN);
graph.BackColor = System.Drawing.Color.White;
graph.FontSize = 10;
graph.Refresh();
// Export graph to bitmap file.
Bitmap image = new Bitmap(400, 250);
graph.Export(image, false);
image.Save(PNGFileName, System.Drawing.Imaging.ImageFormat.Png);
MigraDoc.DocumentObjectModel.Shapes.Image image1 = row.Cells[0].AddImage(PNGFileName);
// Add x/y data.
Paragraph xyParagraph = row.Cells[1].AddParagraph();
xyParagraph.Style = "xyStyle";
AddFixedWidthText(xyParagraph, "X", 10);
AddFixedWidthText(xyParagraph, "Y", 10);
xyParagraph.AddLineBreak();
for (int i = 0; i < graphAndTable.xyPairs.X.Length; i++)
{
AddFixedWidthText(xyParagraph, graphAndTable.xyPairs.X[i].ToString(), 10);
AddFixedWidthText(xyParagraph, graphAndTable.xyPairs.Y[i].ToString(), 10);
xyParagraph.AddLineBreak();
}
// Add an empty paragraph for spacing.
Paragraph spacing = section.AddParagraph();
}
/// <summary>Writes PDF for specified auto-doc commands.</summary>
/// <param name="section">The writer to write to.</param>
/// <param name="tags">The autodoc tags.</param>
/// <param name="workingDirectory">The working directory.</param>
private void TagsToMigraDoc(Section section, List<AutoDocumentation.ITag> tags, string workingDirectory)
{
foreach (AutoDocumentation.ITag tag in tags)
{
if (tag is AutoDocumentation.Heading)
{
AutoDocumentation.Heading heading = tag as AutoDocumentation.Heading;
if (heading.headingLevel > 0 && heading.headingLevel <= 6)
{
if (heading.headingLevel == 1)
section.AddPageBreak();
Paragraph para = section.AddParagraph(heading.text, "Heading" + heading.headingLevel);
if (heading.headingLevel == 1)
para.Format.OutlineLevel = OutlineLevel.Level1;
else if (heading.headingLevel == 2)
para.Format.OutlineLevel = OutlineLevel.Level2;
else if (heading.headingLevel == 3)
para.Format.OutlineLevel = OutlineLevel.Level3;
else if (heading.headingLevel == 4)
para.Format.OutlineLevel = OutlineLevel.Level4;
else if (heading.headingLevel == 5)
para.Format.OutlineLevel = OutlineLevel.Level5;
else if (heading.headingLevel == 6)
para.Format.OutlineLevel = OutlineLevel.Level6;
}
}
else if (tag is AutoDocumentation.Paragraph)
{
AddFormattedParagraphToSection(section, tag as AutoDocumentation.Paragraph);
}
else if (tag is AutoDocumentation.GraphAndTable)
{
CreateGraphPDF(section, tag as AutoDocumentation.GraphAndTable, workingDirectory);
}
else if (tag is AutoDocumentation.Table)
{
CreateTable(section, tag as AutoDocumentation.Table, workingDirectory);
}
else if (tag is Graph)
{
GraphPresenter graphPresenter = new GraphPresenter();
GraphView graphView = new GraphView(null);
graphView.BackColor = OxyPlot.OxyColors.White;
graphView.FontSize = 12;
graphView.Width = 500;
graphView.Height = 500;
graphPresenter.Attach(tag, graphView, ExplorerPresenter);
string PNGFileName = graphPresenter.ExportToPDF(workingDirectory);
section.AddImage(PNGFileName);
string caption = (tag as Graph).Caption;
if (caption != null)
section.AddParagraph(caption);
graphPresenter.Detach();
graphView.MainWidget.Destroy();
}
else if (tag is Map && (tag as Map).GetCoordinates().Count > 0)
{
MapPresenter mapPresenter = new MapPresenter();
MapView mapView = new MapView(null);
mapPresenter.Attach(tag, mapView, ExplorerPresenter);
string PNGFileName = mapPresenter.ExportToPDF(workingDirectory);
if (!String.IsNullOrEmpty(PNGFileName))
section.AddImage(PNGFileName);
mapPresenter.Detach();
mapView.MainWidget.Destroy();
}
else if (tag is AutoDocumentation.Image)
{
AutoDocumentation.Image imageTag = tag as AutoDocumentation.Image;
if (imageTag.image.Width > 700)
imageTag.image = ImageUtilities.ResizeImage(imageTag.image, 700, 500);
string PNGFileName = Path.Combine(workingDirectory, imageTag.name);
imageTag.image.Save(PNGFileName, System.Drawing.Imaging.ImageFormat.Png);
section.AddImage(PNGFileName);
}
}
}
private void CreatePreListContent(Section section, Order.Order order)
{
// Order ID
var paragraph = section.AddParagraph();
//paragraph.Format.SpaceBefore = "8cm";
paragraph.Style = "Reference";
paragraph.AddFormattedText(order.LocalizedDocumentType + " Nr. " + order.DocumentID, TextFormat.Bold);
// Order opening text
if (!String.IsNullOrEmpty(order.OrderOpeningText))
{
paragraph = section.AddParagraph(order.OrderOpeningText);
paragraph.Format.SpaceAfter = "0.75cm";
}
}
private void CreateTableForAreas(Section section)
{
var table = section.AddTable();
table.Style = "Table";
table.Borders.Width = 0.25;
CreateColumns(table);
foreach (var area in areas) {
CreateTableForArea(table, area);
section.AddParagraph("");
}
}
