/* public void ConvertHTMLtoPDF(PurchaseOrdersItem response, Warehouses wh) * { * var readFile = AppDomain.CurrentDomain.BaseDirectory + @"Bill\Page.html"; * * var html = System.IO.File.ReadAllText(readFile); * var warehouse = wh.Items.Count > 0 ? wh.Items.SingleOrDefault() : new Warehouse(); * * * var logoPath = AppDomain.CurrentDomain.BaseDirectory + @"bill\customhtml.html"; * string path = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); * string requiredDate = string.Empty; * string orderDate = string.Empty; * string orderNumber = string.Empty; * string supplierCode = string.Empty; * string referenceNumber = string.Empty; * //string subTotal = string.Empty; * //string taxTotal = string.Empty; * //string completeTotal = string.Empty; * StringBuilder sBuilder = new StringBuilder(); * var item = response; * * requiredDate = item.RequiredDate.ToString("dd/MM/yyyy"); * orderDate = item.OrderDate.ToString("dd/MM/yyyy"); * orderNumber = item.OrderNumber; * supplierCode = item.Supplier == null ? "" : item.Supplier.SupplierCode; * referenceNumber = item.Guid; * double subTotal = item.SubTotal ?? 0; * double taxTotal = item.TaxTotal ?? 0; * double completeTotal = item.Total ?? 0; * * html = html.Replace("##DeliveryName##", warehouse == null ? "" : warehouse.StreetNo); * html = html.Replace("##StreetAddress##", warehouse == null ? "" : warehouse.AddressLine1); * html = html.Replace("##Suburb##", warehouse == null ? "" : warehouse.AddressLine2); * html = html.Replace("##State##", warehouse == null ? "" : warehouse.Region); * html = html.Replace("##PostalCode##", warehouse == null ? "" : warehouse.PostCode); * html = html.Replace("##SupCode##", supplierCode); * html = html.Replace("##PhoneNumber##", warehouse == null ? "" : warehouse.PhoneNumber); * * foreach (var item1 in item.PurchaseOrderLines) * { * var Product = CommonCode.GetProductInformation(item1.Product != null ? item1.Product.ProductCode : ""); * var suppCode = (Product.Items.Count > 0 && Product.Items.FirstOrDefault().Supplier != null) ? Product.Items.FirstOrDefault().Supplier.SupplierProductCode : ""; * string lineNumber = item1.LineNumber.ToString(); * string productCode = item1.Product.ProductCode; * string productDescription = item1.Product.ProductDescription; * string quantity = item1.OrderQuantity.ToString(); * string units = item1.Product != null && item1.Product.UnitOfMeasure != null ? item1.Product.UnitOfMeasure.Name : ""; * double unitPrice = item1.UnitPrice ?? 0; * double amount = item1.LineTotal ?? 0; * double tax = item1.LineTax ?? 0; * string htmlFormat = string.Format("<tr style='border-bottom:2px solid #ddd;'><th style = 'padding: 5px 0; border-bottom:1px solid #ddd;'><p style = 'margin:0; font-weight:normal; font-size: 13px;' >{0}</p></th>" + "<th style = 'padding:5px 0; border-bottom:1px solid #ddd;'><p style = 'margin:0; font-weight:normal;font-size: 13px;'>{1}</p></th>" + "<th style = 'padding:5px 0; border-bottom:1px solid #ddd;'><p style = 'margin:0; font-weight:normal;font-size: 13px;'> {2} </p></th>" + "<th style = 'padding:5px 0; border-bottom:1px solid #ddd;'><p style = 'margin:0; font-weight:normal;font-size: 13px;'> {3}</p></th>" + "<th style = 'padding:5px 0; border-bottom:1px solid #ddd;'><p style = 'margin:0; font-weight:normal;font-size: 13px;'> {4} </p></th>" + "<th style = 'padding:5px 0; border-bottom:1px solid #ddd;'><p style = 'margin:0; font-weight:normal;font-size: 13px;'> {5} </p></th>" + "<th style = 'padding:5px 0; border-bottom:1px solid #ddd;'><p style = 'margin:0; font-weight:normal;font-size: 13px;'> {6} </p></th>" + "<th style = 'padding:5px 0; border-bottom:1px solid #ddd;'><p style = 'margin:0; font-weight:normal;font-size: 13px;'> {7} </p></th>" + "<th style = 'padding:5px 0; border-bottom:1px solid #ddd;'><p style = 'margin:0; font-weight:normal;font-size: 13px;'> {8} </p></th></tr>", lineNumber, suppCode, productCode, productDescription, quantity, units, unitPrice.ToString("0.00"), amount.ToString("0.00"), tax.ToString("0.00") + ); + sBuilder.Append(htmlFormat); + } + + html = html.Replace("##RequiredDate##", requiredDate); + html = html.Replace("##OrderDate##", orderDate); + html = html.Replace("##OrderNumber##", orderNumber); + html = html.Replace("##SupplierCode##", supplierCode); + html = html.Replace("##ReferenceNumber##", referenceNumber); + html = html.Replace("##ReplaceBodyContent##", sBuilder.ToString()); + + html = html.Replace("##SubTotal##", subTotal.ToString("0.00")); + html = html.Replace("##TaxTotal##", taxTotal.ToString("0.00")); + html = html.Replace("##CompleteTotal##", completeTotal.ToString("0.00")); + html = html.Replace("##Instruments##", item.Supplier.SupplierName); + html = html.Replace("##Comments##", item.Comments); + System.IO.File.WriteAllText(logoPath, html); + + SelectPdf.HtmlToPdf converter = new SelectPdf.HtmlToPdf(); + converter.Options.MarginRight = 5; + converter.Options.MarginLeft = 5; + SelectPdf.PdfDocument doc = converter.ConvertUrl(logoPath); + string WriteExcel = path + "//Purchase Orders"; + if (!Directory.Exists(WriteExcel)) + { + Directory.CreateDirectory(WriteExcel); + } + //string excelFile = WriteExcel + "//Purchase Order_" + item.OrderNumber + "_" + DateTime.Now.ToShortDateString().Replace("/", ".") + "_" + DateTime.Now.ToShortTimeString().Replace(":", ".").Replace(" ", "") + "_Excel" + ".pdf"; + string excelFile = WriteExcel + "//Purchase Order_" + item.OrderNumber + "_" + DateTime.Now.ToString("yyyy.dd.MM").Replace("/", ".") + "-" + item.Supplier.SupplierName.Replace("/", "_") + ".pdf"; + doc.Save(excelFile); + doc.Close(); + } */ private void UnleashedData_CurrentCellDirtyStateChanged(object sender, EventArgs e) { if (UnleashedData.IsCurrentCellDirty) { UnleashedData.CommitEdit(System.Windows.Forms.DataGridViewDataErrorContexts.Commit); } }
private void UnleashedData_MouseMove(object sender, System.Windows.Forms.MouseEventArgs e) { System.Windows.Forms.DataGridView.HitTestInfo testInfo = UnleashedData.HitTest(e.X, e.Y); //Need to check to make sure that the row index is 0 or greater as the first //row is a zero and where there is no rows the row index is a -1 if (testInfo.RowIndex >= 0 && testInfo.RowIndex != previousRow) { //UnleashedData.Rows[previousRow].Selected = false; //UnleashedData.Rows[testInfo.RowIndex].Selected = true; //previousRow = testInfo.RowIndex; //UnleashedData.DefaultCellStyle.SelectionBackColor = System.Drawing.Color.Blue; } }
private void UnleashedData_CellValueChanged(object sender, System.Windows.Forms.DataGridViewCellEventArgs e) { if (e.ColumnIndex == 4 && e.RowIndex != -1) { // Handle checkbox state change here if (UnleashedData.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == "True") { //do something string supplier = UnleashedData.Rows[e.RowIndex].Cells[6].Value.ToString(); string productgroup = UnleashedData.Rows[e.RowIndex].Cells[14].Value.ToString(); if (glbSupplier == string.Empty || glbSupplier == supplier) { glbSupplier = supplier; } else { MessageBox.Show("Please choose same supplier.", "Information", MessageBoxButton.OK, MessageBoxImage.Information); UnleashedData.Rows[e.RowIndex].Cells[4].Value = false; UnleashedData.CancelEdit(); } if (glbProduct == string.Empty || glbProduct == productgroup) { switch (productgroup) { case "Meters": glbWarehouse = "MWF"; break; case "Sensors": glbWarehouse = "MWQ"; break; case "Projects": glbWarehouse = "Projects"; break; default: break; } glbProduct = productgroup; } else { MessageBox.Show("Please choose same product group.", "Information", MessageBoxButton.OK, MessageBoxImage.Information); UnleashedData.Rows[e.RowIndex].Cells[4].Value = false; UnleashedData.CancelEdit(); } } else { //do something int encountercheck = 0; foreach (System.Windows.Forms.DataGridViewRow row in UnleashedData.Rows) { System.Windows.Forms.DataGridViewCheckBoxCell chk = (System.Windows.Forms.DataGridViewCheckBoxCell)row.Cells[4]; if (chk.Value != null) { bool checkTrue = (bool)chk.Value; //because chk.Value is initialy null if (checkTrue) { encountercheck = 1; } } } if (encountercheck == 0) { glbSupplier = string.Empty; glbProduct = string.Empty; } } } }
private void UnleashedData_CellContentClick(object sender, System.Windows.Forms.DataGridViewCellEventArgs e) { UnleashedData.CommitEdit(System.Windows.Forms.DataGridViewDataErrorContexts.Commit); }