public static Section AddVerticalSpacing(this Section section, Unit height)
{
var verticalSpace = section.AddTextFrame();
verticalSpace.Height = height;
verticalSpace.Width = section.Document.DefaultPageSetup.PageWidth;
return(section);
}
public static void AddPageBg(Section s, Document doc, byte r, byte g, byte b)
{
var tf = s.AddTextFrame();
tf.FillFormat.Color = new MigraDoc.DocumentObjectModel.Color(r, g, b);
tf.Width = doc.DefaultPageSetup.PageWidth.Point;
tf.Height = doc.DefaultPageSetup.PageHeight.Point;
tf.RelativeHorizontal = RelativeHorizontal.Page;
tf.RelativeVertical = RelativeVertical.Page;
}
///<summary>Creates a somewhat smaller container at an absolute position on the page</summary>
public static TextFrame CreateContainer(Section section,float xPos,float yPos,float width,float height) {
TextFrame framebig=section.AddTextFrame();
framebig.RelativeVertical=RelativeVertical.Page;
framebig.RelativeHorizontal=RelativeHorizontal.Page;
framebig.MarginLeft=Unit.Zero;
framebig.MarginTop=Unit.Zero;
framebig.Top=TopPosition.Parse((yPos/100).ToString()+" in");
framebig.Left=LeftPosition.Parse((xPos/100).ToString()+" in");
framebig.Width=Unit.FromInch(width/100);
framebig.Height=Unit.FromInch(height/100);
return framebig;
}
public static Section AddHeading(this Section section, string heading, Action <TextFrame, Paragraph> callback = null)
{
var headingTextFrame = section.AddTextFrame();
var tmpHeadParagraph = headingTextFrame.AddParagraph(heading);
headingTextFrame.Top = ShapePosition.Top;
tmpHeadParagraph.Format.Font = CallibriFont11.Clone();
tmpHeadParagraph.Format.Font.Size = 15.PixelsToUnitPoints();
if (callback != null)
{
callback(headingTextFrame, tmpHeadParagraph);
}
return(section);
}
///<Summary>Creates a container frame in a section. This allows other objects to be placed absolutely within a given area by adding more textframes within this one. This frame is full width and is automatically placed after previous elements.</Summary>
public static TextFrame CreateContainer(Section section){
TextFrame framebig=section.AddTextFrame();
framebig.RelativeVertical=RelativeVertical.Line;
framebig.RelativeHorizontal=RelativeHorizontal.Page;
framebig.MarginLeft=Unit.Zero;
framebig.MarginTop=Unit.Zero;
framebig.Top=TopPosition.Parse("0 in");
framebig.Left=LeftPosition.Parse("0 in");
if(CultureInfo.CurrentCulture.Name=="en-US"){
framebig.Width=Unit.FromInch(8.5);
}
//don't know about Canada
else{
framebig.Width=Unit.FromInch(8.3);
}
//LineFormat lineformat=new LineFormat();
//lineformat.Width=1;
//framebig.LineFormat=lineformat;
return framebig;
}
private void SetInfo(Order order, ref Section section)
{
TextFrame frame1 = section.AddTextFrame();
frame1.RelativeVertical = RelativeVertical.Page;
frame1.Left = ShapePosition.Right;
frame1.Top = new Unit(1.85, UnitType.Centimeter);
frame1.Width = new Unit(10, UnitType.Centimeter);
Paragraph p = frame1.AddParagraph();
p.Format.Font.Size = 16;
p.Format.Alignment = ParagraphAlignment.Right;
p.AddFormattedText("Order #" + order.Id, TextFormat.Bold);
frame1 = section.AddTextFrame();
TextFrame frame2 = section.AddTextFrame();
if (!String.IsNullOrWhiteSpace(_ecommerceSettings.ReportLogoImage) &&
!_ecommerceSettings.ReportLogoImage.Contains("http"))
{
string logoUrl = _getLogoUrl.Get();
if (!String.IsNullOrWhiteSpace(logoUrl))
{
MigraDoc.DocumentObjectModel.Shapes.Image logo = section.AddImage(logoUrl);
logo.RelativeVertical = RelativeVertical.Page;
logo.Left = ShapePosition.Left;
logo.Top = new Unit(1.85, UnitType.Centimeter);
logo.Height = new Unit(1.5, UnitType.Centimeter);
frame1.MarginTop = new Unit(0.5, UnitType.Centimeter);
frame2.MarginTop = new Unit(0.5, UnitType.Centimeter);
}
}
frame1.RelativeVertical = RelativeVertical.Page;
frame1.Left = ShapePosition.Left;
frame1.Top = new Unit(3.5, UnitType.Centimeter);
frame1.Width = new Unit(10, UnitType.Centimeter);
frame2.RelativeVertical = RelativeVertical.Page;
frame2.Left = ShapePosition.Right;
frame2.Top = new Unit(3.5, UnitType.Centimeter);
frame2.Width = new Unit(8, UnitType.Centimeter);
//BILLING AND SHIPPING
p = frame1.AddParagraph();
p.AddFormattedText("Bill to:", TextFormat.Bold);
p = frame2.AddParagraph();
p.AddFormattedText("Ship to:", TextFormat.Bold);
p = frame1.AddParagraph();
p.AddText(order.BillingAddress.Name);
if (!string.IsNullOrEmpty(order.BillingAddress.Company))
{
p = frame1.AddParagraph();
p.AddText(order.BillingAddress.Company);
}
if (order.ShippingAddress != null)
{
p = frame2.AddParagraph();
p.AddText(order.ShippingAddress.Name);
if (!string.IsNullOrEmpty(order.ShippingAddress.Company))
{
p = frame2.AddParagraph();
p.AddText(order.ShippingAddress.Company);
}
}
p = frame1.AddParagraph();
p.AddText(order.BillingAddress.PhoneNumber);
if (order.ShippingAddress != null)
{
if (!string.IsNullOrWhiteSpace(order.ShippingAddress.PhoneNumber))
{
p = frame2.AddParagraph();
p.AddText(order.ShippingAddress.PhoneNumber);
}
}
p = frame1.AddParagraph();
p.AddText(order.BillingAddress.Address1);
if (order.ShippingAddress != null)
{
if (!string.IsNullOrWhiteSpace(order.ShippingAddress.Address1))
{
p = frame2.AddParagraph();
p.AddText(order.ShippingAddress.Address1);
}
}
if (!string.IsNullOrWhiteSpace(order.BillingAddress.Address2))
{
p = frame1.AddParagraph();
p.AddText(order.BillingAddress.Address2);
}
if (order.ShippingAddress != null)
{
if (!string.IsNullOrWhiteSpace(order.ShippingAddress.Address2))
{
p = frame2.AddParagraph();
p.AddText(order.ShippingAddress.Address2);
}
}
if (!string.IsNullOrWhiteSpace(order.BillingAddress.City))
{
p = frame1.AddParagraph();
p.AddText(order.BillingAddress.City);
}
if (order.ShippingAddress != null)
{
if (!string.IsNullOrWhiteSpace(order.ShippingAddress.City))
{
p = frame2.AddParagraph();
p.AddText(order.ShippingAddress.City);
}
}
if (!string.IsNullOrWhiteSpace(order.BillingAddress.StateProvince))
{
p = frame1.AddParagraph();
p.AddText(order.BillingAddress.StateProvince);
}
if (order.ShippingAddress != null)
{
if (!string.IsNullOrWhiteSpace(order.ShippingAddress.StateProvince))
{
p = frame2.AddParagraph();
p.AddText(order.ShippingAddress.StateProvince);
}
}
string billingCountryName = order.BillingAddress.GetCountryName();
if (!string.IsNullOrWhiteSpace(billingCountryName))
{
p = frame1.AddParagraph();
p.AddText(billingCountryName);
}
if (order.ShippingAddress != null)
{
string shippingCountryName = order.ShippingAddress.GetCountryName();
if (!string.IsNullOrWhiteSpace(shippingCountryName))
{
p = frame2.AddParagraph();
p.AddText(shippingCountryName);
}
}
if (!string.IsNullOrWhiteSpace(order.BillingAddress.PostalCode))
{
p = frame1.AddParagraph();
p.AddText(order.BillingAddress.PostalCode);
}
if (order.ShippingAddress != null)
{
if (!string.IsNullOrWhiteSpace(order.ShippingAddress.PostalCode))
{
p = frame2.AddParagraph();
p.AddText(order.ShippingAddress.PostalCode);
}
}
frame1.AddParagraph("").AddLineBreak();
frame2.AddParagraph("").AddLineBreak();
//PAYMENT AND SHIPPING METHODS
p = frame1.AddParagraph();
p.AddText(string.Format("Payment method: {0}", order.PaymentMethod.BreakUpString()));
p = frame2.AddParagraph();
p.AddText(string.Format("Shipping method: {0}", order.ShippingMethodName));
}
///<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 SetHeaderText(Section section, ScheduleRepository repo, string facultyName, string dow)
{
// Create the text frame for the address
var addressFrame = section.AddTextFrame();
addressFrame.Height = "3.0cm";
addressFrame.Width = "7.0cm";
addressFrame.Left = Unit.FromCentimeter(10);
addressFrame.RelativeHorizontal = RelativeHorizontal.Margin;
addressFrame.Top = "0.5cm";
addressFrame.RelativeVertical = RelativeVertical.Page;
var paragraph = addressFrame.AddParagraph("Расписание");
paragraph.Format.Font.Name = "Calibri";
paragraph.Format.Alignment = ParagraphAlignment.Center;
paragraph.Format.Font.Size = 10;
paragraph.Format.SpaceAfter = 3;
var semesterString = DetectSemesterString(repo);
paragraph = addressFrame.AddParagraph(semesterString);
paragraph.Format.Font.Name = "Calibri";
paragraph.Format.Alignment = ParagraphAlignment.Center;
paragraph.Format.Font.Size = 10;
paragraph.Format.SpaceAfter = 3;
paragraph = addressFrame.AddParagraph(facultyName);
paragraph.Format.Font.Name = "Calibri";
paragraph.Format.Alignment = ParagraphAlignment.Center;
paragraph.Format.Font.Size = 10;
paragraph.Format.SpaceAfter = 3;
paragraph = addressFrame.AddParagraph(dow.ToUpper());
paragraph.Format.Font.Name = "Calibri";
paragraph.Format.Alignment = ParagraphAlignment.Center;
paragraph.Format.Font.Size = 14;
paragraph.Format.SpaceAfter = 3;
}
private static void SetCornerStamp(Section section)
{
// Create the text frame for the address
var addressFrame = section.AddTextFrame();
addressFrame.Height = "2.0cm";
addressFrame.Width = "5.0cm";
addressFrame.Left = Unit.FromCentimeter(23);
addressFrame.RelativeHorizontal = RelativeHorizontal.Margin;
addressFrame.Top = "0.5cm";
addressFrame.RelativeVertical = RelativeVertical.Page;
var paragraph = addressFrame.AddParagraph("«УТВЕРЖДАЮ»");
paragraph.Format.Font.Name = "Calibri";
paragraph.Format.Font.Size = 10;
paragraph.Format.SpaceAfter = 3;
paragraph = addressFrame.AddParagraph("Проректор по учебной работе");
paragraph.Format.Font.Name = "Calibri";
paragraph.Format.Font.Size = 10;
paragraph.Format.SpaceAfter = 3;
paragraph = addressFrame.AddParagraph("______________ А.В.Синицкий");
paragraph.Format.Font.Name = "Calibri";
paragraph.Format.Font.Size = 10;
paragraph.Format.SpaceAfter = 3;
}
/// <summary>
/// Adds the sender and receiver addresses to the given section
/// </summary>
/// <param name="section">The section to append the sender and receiver to</param>
private void AddAddressFrame(Section section)
{
var addressFrame = section.AddTextFrame();
addressFrame.Height = "3.0cm";
addressFrame.Width = "7.0cm";
addressFrame.Left = ShapePosition.Left;
addressFrame.RelativeHorizontal = RelativeHorizontal.Margin;
addressFrame.Top = "5.0cm";
addressFrame.RelativeVertical = RelativeVertical.Page;
// Put sender in address frame
var senderParagraph =
addressFrame.AddParagraph(SettingsData.Default.SenderText);
senderParagraph.Format.Font.Name = "Times New Roman";
senderParagraph.Format.Font.Size = 7;
senderParagraph.Format.SpaceAfter = 3;
// Put receiver in address frame
Paragraph receiverParagraph = addressFrame.AddParagraph();
receiverParagraph.AddText(Company.name);
receiverParagraph.AddLineBreak();
receiverParagraph.AddText(Company.address_line1);
receiverParagraph.AddLineBreak();
if(!String.IsNullOrEmpty(Company.address_line2))
{
receiverParagraph.AddText(Company.address_line2);
receiverParagraph.AddLineBreak();
}
receiverParagraph.AddText(String.Format("{0}, {1} {2}",
Company.city,
Company.state,
Company.zip));
}
///<summary>Vertical spacer.</summary>
public static void InsertSpacer(Section section,int space)
{
TextFrame frame=section.AddTextFrame();
frame.Height=Unit.FromInch((double)space/100);
}
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);
}
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);
}
}
/// <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 Table SetTableStyle(ref Section section, Color tableColor)
{
TextFrame frame = section.AddTextFrame();
frame.MarginTop = new Unit(6, UnitType.Centimeter);
frame.Width = new Unit(16, UnitType.Centimeter);
//TABLE LABEL
Paragraph p = frame.AddParagraph();
p.AddFormattedText("Purchased goods:", TextFormat.Bold);
frame.AddParagraph("").AddLineBreak();
//TABLE
Table table = frame.AddTable();
table.Style = "Table";
table.Borders.Color = tableColor;
table.Borders.Width = 0.25;
table.Borders.Left.Width = 0.5;
table.Borders.Right.Width = 0.5;
table.Rows.LeftIndent = 0;
return table;
}