private void Form1_Load(object sender, EventArgs e)
{
BuildGrid();
if (!Directory.Exists(AppDomain.CurrentDomain.BaseDirectory + @"\Temp"))
{
Directory.CreateDirectory(AppDomain.CurrentDomain.BaseDirectory + @"\Temp");
}
if (!Directory.Exists(AppDomain.CurrentDomain.BaseDirectory + @"\Temp\Orders"))
{
Directory.CreateDirectory(AppDomain.CurrentDomain.BaseDirectory + @"\Temp\Orders");
}
DirectoryInfo di = new DirectoryInfo(AppDomain.CurrentDomain.BaseDirectory + @"Temp");
FileInfo[] fi = di.GetFiles();
foreach (FileInfo f in fi)
{
f.Delete();
}
foreach (DataGridViewRow row in gridOrders.Rows)
{
ProccessNewOrder(Convert.ToInt32(row.Cells["ORD_ID"].Value), Convert.ToInt32(row.Cells["ORD_ScreenW"].Value), Convert.ToInt32(row.Cells["ORD_ScreenH"].Value));
Canvas_DB.updateOrderStatus(Convert.ToInt32(row.Cells["ORD_ID"].Value), 2);
}
BuildGrid();
}
private void gridOrders_MouseClick(object sender, MouseEventArgs e)
{
if (gridOrders.Rows.GetRowCount(DataGridViewElementStates.Selected) > 0)
{
DataTable dtClient = Canvas_DB.getClient(Convert.ToInt32(gridOrders.SelectedRows[0].Cells["ORD_ID"].Value));
txtFullName.Text = dtClient.Rows[0]["CLI_FullName"].ToString();
txtAddress.Text = dtClient.Rows[0]["CLI_Address"].ToString();
txtCity.Text = dtClient.Rows[0]["CLI_City"].ToString();
txtDelivery.Text = dtClient.Rows[0]["DeliveryMethod"].ToString();
txtMail.Text = dtClient.Rows[0]["CLI_EMail"].ToString();
txtPhone.Text = dtClient.Rows[0]["CLI_Phone"].ToString();
txtPOB.Text = dtClient.Rows[0]["CLI_POB"].ToString();
txtZip.Text = dtClient.Rows[0]["CLI_Zip"].ToString();
}
}
private void ProccessNewOrder(int OrderID, int origWidth, int origHeight)
{
DataTable dtPictures = Canvas_DB.getPictures(OrderID);
DataTable dtTexts = Canvas_DB.getTexts(OrderID);
/*
* byte[] ss = Encoding.Default.GetBytes(s);
* string sss = Encoding.UTF8.GetString(ss);
* int mod4 = s.Length % 4;
* if (mod4 > 0)
* {
* s += new string('=', 4 - mod4);
* }
* byte[] result = Convert.FromBase64String(s);
*/
for (int i = 0; i < dtPictures.Rows.Count; i++)
{
byte[] result = (byte[])dtPictures.Rows[i]["PIC_FileBody"];
MemoryStream ms = new MemoryStream(result, 0, result.Length);
string fileName = AppDomain.CurrentDomain.BaseDirectory + @"Temp\" + dtPictures.Rows[i]["PIC_FileName"].ToString();
FileStream fs = File.Create(fileName);
ms.CopyTo(fs);
ms.Close();
fs.Close();
/*-----------------------*/
int canvWidth = 4724, canvHeight = 4724, border = 600;
float newWidth = (float)canvWidth / origWidth;
float newHeight = (float)canvHeight / origHeight;
Bitmap b = new Bitmap(canvWidth, canvHeight);
Graphics g = Graphics.FromImage(b);
g.FillRectangle(Brushes.White, new Rectangle(0, 0, canvWidth, canvHeight));
Bitmap img = new Bitmap(AppDomain.CurrentDomain.BaseDirectory + @"Temp\" + dtPictures.Rows[i]["PIC_FileName"].ToString());
// g.DrawImage(img, (float.Parse(dtPictures.Rows[i]["PIC_Size"].ToString()) * float.Parse(dtPictures.Rows[i]["PIC_Left"].ToString())), (float.Parse(dtPictures.Rows[i]["PIC_Size"].ToString()) * float.Parse(dtPictures.Rows[i]["PIC_Top"].ToString())), (float.Parse(dtPictures.Rows[i]["PIC_Size"].ToString()) * img.Width), (float.Parse(dtPictures.Rows[i]["PIC_Size"].ToString()) * img.Height));
g.DrawImage(img, (newWidth * float.Parse(dtPictures.Rows[i]["PIC_Left"].ToString())), (newHeight * float.Parse(dtPictures.Rows[i]["PIC_Top"].ToString())), (newWidth * float.Parse(dtPictures.Rows[i]["PIC_Size"].ToString()) * img.Width), (newHeight * float.Parse(dtPictures.Rows[i]["PIC_Size"].ToString()) * img.Height));
ImageConverter converter = new ImageConverter();
result = (byte[])converter.ConvertTo(b, typeof(byte[]));
ms = new MemoryStream(result, 0, result.Length);
fs = File.Create(AppDomain.CurrentDomain.BaseDirectory + @"Temp\tmp" + OrderID + ".jpg");
ms.CopyTo(fs);
ms.Close();
fs.Close();
img = new Bitmap(AppDomain.CurrentDomain.BaseDirectory + @"Temp\tmp" + OrderID + ".jpg");
b = new Bitmap(canvWidth + border, canvHeight + border);
g = Graphics.FromImage(b);
g.FillRectangle(Brushes.White, new Rectangle(0, 0, canvWidth + border, canvHeight + border));
g.DrawImage(img, border / 2, border / 2, canvWidth, canvHeight);
g.SmoothingMode = SmoothingMode.AntiAlias;
g.InterpolationMode = InterpolationMode.HighQualityBicubic;
g.PixelOffsetMode = PixelOffsetMode.HighQuality;
StringFormat format = new StringFormat();
format.Alignment = StringAlignment.Center;
g.DrawString("Order #" + OrderID.ToString(), new Font("Arial", 70), Brushes.Black, new Rectangle(0, canvHeight + border * 3 / 4, canvWidth + border, canvHeight + border), format);
g.Flush();
converter = new ImageConverter();
result = (byte[])converter.ConvertTo(b, typeof(byte[]));
ms = new MemoryStream(result, 0, result.Length);
fs = File.Create(AppDomain.CurrentDomain.BaseDirectory + @"Temp\Orders\" + OrderID + ".jpg");
ms.CopyTo(fs);
g.Dispose();
ms.Close();
fs.Close();
img.Dispose();
b.Dispose();
Image imRes = Image.FromFile(fileName);
float resolution = imRes.HorizontalResolution;
int pdfSizeW = Convert.ToInt32(resolution * 300 / 25.4);
int pdfSizeH = Convert.ToInt32(resolution * 300 / 25.4);
PdfDocument pdf = new PdfDocument();
PdfPage pdfPage = pdf.AddPage();
pdfPage.Orientation = PdfSharp.PageOrientation.Portrait;
pdfPage.Width = XUnit.FromMillimeter(400);
pdfPage.Height = XUnit.FromMillimeter(400);
XGraphics gfx = XGraphics.FromPdfPage(pdfPage);
XImage image = XImage.FromFile(AppDomain.CurrentDomain.BaseDirectory + @"Temp\Orders\" + OrderID + ".jpg");
gfx.DrawImage(image, 0, 0, pdfSizeW, pdfSizeH);
// XFont font = new XFont("Verdana", 60, XFontStyle.Regular);
// gfx.DrawString("This is new order number", font, XBrushes.Black, new XRect(25, 380, pdfPage.Width.Millimeter, pdfPage.Height.Millimeter), XStringFormats.Center);
string pdfFilename = AppDomain.CurrentDomain.BaseDirectory + @"Temp\Orders\" + OrderID + ".pdf";
pdf.Save(pdfFilename);
Process.Start(pdfFilename);
//System.Diagnostics.Process.Start(AppDomain.CurrentDomain.BaseDirectory + @"Temp\" + OrderID + ".jpg");
}
}
private void BuildGrid()
{
DataTable dtOrders = Canvas_DB.getNewOrders();
gridOrders.DataSource = dtOrders.DefaultView;
}
private void btnCloseOrder_Click(object sender, EventArgs e)
{
Canvas_DB.updateOrderStatus(Convert.ToInt32(gridOrders.SelectedRows[0].Cells["ORD_ID"].Value), 3);
BuildGrid();
Clear();
}
