private void DrawHeaderInvoice(XGraphics gfx, PdfPage page, SO curso)
{
XTextFormatter tf = new XTextFormatter(gfx);
XImage image = XImage.FromGdiPlusImage(Image.FromFile(@"\\10.0.0.14\API\Images\Excologo.png"));
gfx.DrawImage(image, start_X, start_Y - 10, 130, 40);
XRect rect = new XRect(start_X, start_Y + 31, 100, row_headerheight);
gfx.DrawRectangle(XBrushes.White, rect);
tf.DrawString("Exco Tooling Solutions", font1, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X + 105, start_Y + 31, 200, 8);
gfx.DrawRectangle(XBrushes.White, rect);
tf.DrawString("T. 905.477.1208 / 800.461.6298", font1, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X, start_Y + row_headerheight + 32, 100, 8);
gfx.DrawRectangle(XBrushes.White, rect);
tf.DrawString("130 Spy Court, 1st Floor", font1, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X + 105, start_Y + row_headerheight + 32, 200, 8);
gfx.DrawRectangle(XBrushes.White, rect);
tf.DrawString("F. 905.477.6304 / 877.336.3356", font1, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X, start_Y + row_headerheight * 2 + 33, 100, 8);
gfx.DrawRectangle(XBrushes.White, rect);
tf.DrawString("Markham, ON, L3R 5H6", font1, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X + 105, start_Y + row_headerheight * 2 + 33, 200, 8);
gfx.DrawRectangle(XBrushes.White, rect);
tf.DrawString("www.etsdies.com", font1, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X + 270, start_Y + 31, 38, 8);
gfx.DrawRectangle(XBrushes.White, rect);
tf.DrawString("Remit to:", font1, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X + 309, start_Y + 31, 120, 8);
gfx.DrawRectangle(XBrushes.White, rect);
tf.DrawString("Lockbox #15629, TD Bank Tower", font2, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X + 309, start_Y + row_headerheight + 32, 120, 8);
gfx.DrawRectangle(XBrushes.White, rect);
tf.DrawString("66 Wellington St. W., Suite 4500", font2, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X + 309, start_Y + row_headerheight * 2 + 33, 120, 8);
gfx.DrawRectangle(XBrushes.White, rect);
tf.DrawString("Toronto, Ontario M5K 1E7", font2, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X + 340, start_Y - 18, 120, 30);
gfx.DrawRectangle(XBrushes.White, rect);
tf.DrawString("INVOICE", font5, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X + 470, start_Y - 18, 100, 30);
gfx.DrawRectangle(XBrushes.White, rect);
tf.DrawString(curso.invoicenumber, font5, XBrushes.Black, rect, XStringFormats.TopLeft);
XPen pen = new XPen(Color.Black, 0.5);
int cur_Y = 35;
gfx.DrawLine(pen, start_X + 470, cur_Y, start_X + 570, cur_Y);
gfx.DrawLine(pen, start_X + 470, cur_Y + row_boxheight * 4, start_X + 570, cur_Y + row_boxheight * 4);
gfx.DrawLine(pen, start_X + 470, cur_Y, start_X + 470, cur_Y + row_boxheight * 4);
gfx.DrawLine(pen, start_X + 570, cur_Y, start_X + 570, cur_Y + row_boxheight * 4);
gfx.DrawLine(pen, start_X + 470, cur_Y + row_boxheight, start_X + 570, cur_Y + row_boxheight);
gfx.DrawLine(pen, start_X + 470, cur_Y + row_boxheight * 2, start_X + 570, cur_Y + row_boxheight * 2);
gfx.DrawLine(pen, start_X + 470, cur_Y + row_boxheight * 3, start_X + 570, cur_Y + row_boxheight * 3);
rect = new XRect(start_X + 471, cur_Y + 1, 98, row_boxheight - 2);
gfx.DrawRectangle(XBrushes.LightGray, rect);
rect = new XRect(start_X + 471, cur_Y + row_boxheight * 2 + 1, 98, row_boxheight - 2);
gfx.DrawRectangle(XBrushes.LightGray, rect);
rect = new XRect(start_X + 470, cur_Y + 2, 98, row_boxheight);
tf.Alignment = XParagraphAlignment.Center;
tf.DrawString("INVOICE DATE", font3, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X + 470, cur_Y + row_boxheight + 2, 98, row_boxheight);
tf.Alignment = XParagraphAlignment.Center;
tf.DrawString(curso.invoicedate.ToShortDateString(), font4, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X + 470, cur_Y + row_boxheight * 2 + 2, 98, row_boxheight);
tf.Alignment = XParagraphAlignment.Center;
tf.DrawString("SHIP DATE", font3, XBrushes.Black, rect, XStringFormats.TopLeft);
rect = new XRect(start_X + 470, cur_Y + row_boxheight * 3 + 2, 98, row_boxheight);
tf.Alignment = XParagraphAlignment.Center;
tf.DrawString(curso.shipdate.ToShortDateString(), font4, XBrushes.Black, rect, XStringFormats.TopLeft);
}
private void GetCustInfo()
{
SqlCommand objCmd = null;
using (SqlConnection objConn = new SqlConnection(Global.ConnectionStr))
{
objConn.Open();
objCmd = objConn.CreateCommand();
objCmd.CommandText = String.Format(
"select a.customercode,a.name,b.name as aname,b.address1,b.address2,b.address3,b.address4,b.postalcode "
+ " from d_customer as a, d_customeraddress as b where a.customercode=b.customercode and a.customercode='{0}'",
custcode);
using (SqlDataReader objReader = objCmd.ExecuteReader())
{
if (objReader.HasRows)
{
while (objReader.Read())
{
if (objReader["aname"].ToString().Trim() == "SHIPPING")
{
saddress1 = objReader["address1"].ToString().Trim();
saddress2 = objReader["address2"].ToString().Trim();
saddress3 = objReader["address3"].ToString().Trim();
saddress4 = objReader["address4"].ToString().Trim();
spostalcode = objReader["postalcode"].ToString().Trim();
}
else if (objReader["aname"].ToString().Trim() == "BILLING")
{
baddress1 = objReader["address1"].ToString().Trim();
baddress2 = objReader["address2"].ToString().Trim();
baddress3 = objReader["address3"].ToString().Trim();
baddress4 = objReader["address4"].ToString().Trim();
bpostalcode = objReader["postalcode"].ToString().Trim();
}
}
}
}
}
using (SqlConnection objConn =
new SqlConnection(Global.ConnectionStr))
{
objConn.Open();
objCmd = objConn.CreateCommand();
objCmd.CommandText = String.Format(
"select a.ordernumber,a.customercode,b.name,b.terms,a.invoicenumber,a.invoicedate,a.shipdate,a.sales,"
+ " a.fasttrackcharge,a.discountamount,a.orderdate,a.note,a.designtype,a.freight,a.freightweight,a.freightcharge,a.customerpo,a.shopdate,b.accountset,a.total,a.steelrate,a.shipvia,b.taxgroup,b.taxcode "
+ " from d_order as a, d_customer as b "
+ " where a.customercode = b.customercode "
+ " and a.ordernumber = '{0}' "
//+ " and (a.customerpo not like '%CANCEL%' or a.customerpo is null) "
+ " order by b.name, a.ordernumber", ordernumber);
using (SqlDataReader objReader = objCmd.ExecuteReader())
{
if (objReader.HasRows)
{
while (objReader.Read())
{
custcode = objReader["customercode"].ToString().Trim();
custname = objReader["name"].ToString().Trim();
terms = objReader["terms"].ToString().Trim();
accountset = objReader["accountset"].ToString().Trim();
taxgroup = objReader["taxgroup"].ToString().Trim();
taxcode = objReader["taxcode"].ToString().Trim();
newSO = new SO();
newSO.ordernumber = objReader["ordernumber"].ToString().Trim();
newSO.shipvia = objReader["shipvia"].ToString().Trim();
newSO.note = objReader["note"].ToString().Trim();
newSO.designtype = GetDesignType(objReader["designtype"].ToString().Trim());
newSO.invoicenumber = objReader["invoicenumber"].ToString().Trim();
newSO.invoicedate = Convert.ToDateTime(objReader["invoicedate"].ToString());
newSO.shipdate = Convert.ToDateTime(objReader["shipdate"].ToString());
newSO.orderdate = Convert.ToDateTime(objReader["orderdate"].ToString());
newSO.shopdate = Convert.ToDateTime(objReader["shopdate"].ToString());
newSO.customerpo = objReader["customerpo"].ToString().Trim();
newSO.total = Convert.ToDouble(objReader["total"]);
newSO.sales = Convert.ToDouble(objReader["sales"]);
newSO.steelrate = Convert.ToDouble(objReader["steelrate"]);
newSO.freight = Convert.ToDouble(objReader["freight"]);
newSO.freightweight = Convert.ToDouble(objReader["freightweight"]);
newSO.freightcharge = Convert.ToDouble(objReader["freightcharge"]);
newSO.discountamount = Convert.ToDouble(objReader["discountamount"]);
newSO.fasttrackcharge = Convert.ToDouble(objReader["fasttrackcharge"]);
GetSOInfo();
GetTaxInfo();
}
}
}
}
}
