private void ShowProductTestList(int planNo, DateTime planDate, int opt) { removeControlsFromForwarderPanel(); lvProdList = new ListView(); lvProdList.Enabled = true; lvProdList.Clear(); lvProdList = ProductTestReportHeaderDB.getProdTestReportListView(planNo, planDate); if (lvProdList.Items.Count == 0) { MessageBox.Show("Report not prepared"); } pnlProdList.BorderStyle = BorderStyle.FixedSingle; pnlProdList.Size = new Size(559, 252); lvProdList.Size = new Size(529, 188); lvProdList.Location = new Point(15, 21); if (opt == 2) { foreach (ListViewItem item in lvProdList.Items) { item.Checked = true; } lvProdList.Enabled = false; } pnlProdList.Controls.Remove(lvProdList); pnlProdList.Controls.Add(lvProdList); Button lvSelectOK = new Button(); lvSelectOK.Text = "OK"; lvSelectOK.Location = new Point(108, 216); lvSelectOK.Click += new System.EventHandler(this.lvOK_Click1); pnlProdList.Controls.Add(lvSelectOK); Button lvSelectCancel = new Button(); lvSelectCancel.Text = "Cancel"; lvSelectCancel.Location = new Point(276, 215); lvSelectCancel.Click += new System.EventHandler(this.lvCancel_Click1); pnlProdList.Controls.Add(lvSelectCancel); pnlProductionList.Visible = true; pnlProductionList.Controls.Add(pnlProdList); pnlProductionList.BringToFront(); pnlProdList.BringToFront(); pnlProdList.Focus(); }
public Boolean PrintReport(Dictionary <Int32, DateTime> ReprotDict, string Dir, string fname, string prodInfo) { Boolean status = true; string pathStr = ""; string ColHeader = ColHeader = "SI No.;Test Description;Expected Result;Result;Status"; string fileName = fname; string footer3 = ""; string subDir = Dir.Substring(0, Dir.IndexOf('-')) + "-" + Dir.Substring(Dir.IndexOf('-') + 1); string dicDir = Main.documentDirectory + "\\" + "PRODUCTTESTREPORT"; string[] ProdInfoStr = prodInfo.Split(';'); HeaderString = "Product Code: " + ProdInfoStr[0].Substring(0, ProdInfoStr[0].IndexOf('-')) + ";Product Description: " + ProdInfoStr[0].Substring(ProdInfoStr[0].IndexOf('-') + 1) + ";ModelNo: " + ProdInfoStr[1].Substring(0, ProdInfoStr[1].IndexOf('-')) + ";ModelName: " + ProdInfoStr[1].Substring(ProdInfoStr[1].IndexOf('-') + 1); //ptrheader.CreateUser ---- // for testDeacriptionID //ptrheader.ForwardUser ---- // for Expected Result //ptrheader.ApproveUser ---- // for Actual Result //ptrheader.Status ---- // for TestStatus try { string dir = dicDir + "\\" + subDir; if (!System.IO.Directory.Exists(dir)) { System.IO.Directory.CreateDirectory(dir); } string Fname = dir + "\\" + fileName; FileStream fs = new FileStream(Fname + ".pdf", FileMode.Create, FileAccess.Write); Rectangle rec = new Rectangle(PageSize.A4); iTextSharp.text.Document doc = new iTextSharp.text.Document(rec); PdfWriter writer = PdfWriter.GetInstance(doc, fs); MyEvent evnt = new MyEvent(); writer.PageEvent = evnt; doc.Open(); iTextSharp.text.Image img = iTextSharp.text.Image.GetInstance(URL); img.Alignment = Element.ALIGN_LEFT; Paragraph paragraph = new Paragraph(new Phrase(Title, font2)); paragraph.Alignment = Element.ALIGN_CENTER; paragraph.SpacingAfter = 10f; int temp = 0; foreach (KeyValuePair <Int32, DateTime> report in ReprotDict) { temp++; doc.NewPage(); string prodSerNo = ""; string no = report.Key.ToString(); string val = report.Value.ToString(); string ColDetailString = ""; List <producttestreportheader> ptrhList = ProductTestReportHeaderDB.getReportListForPrint(report.Key, report.Value); var count = ptrhList.Count(); int n = 1; foreach (producttestreportheader ptrh1 in ptrhList) { if (n == count) { ColDetailString = ColDetailString + n + "+" + ptrh1.CreateUser + "+" + ptrh1.ForwardUser + "+" + ptrh1.ApproveUser + "+" + getStatusCode(ptrh1.Status); } else { ColDetailString = ColDetailString + n + "+" + ptrh1.CreateUser + "+" + ptrh1.ForwardUser + "+" + ptrh1.ApproveUser + "+" + getStatusCode(ptrh1.Status) + ";"; } n++; } foreach (producttestreportheader ptrh in ptrhList) { prodSerNo = "Product Serial No: " + ptrh.ProductSerialNo; footer3 = "Prepared By:" + ptrh.CreatorName + ";Approved By:" + ptrh.ApproverName; } //-- string[] HeaderStr = HeaderString.Split(';'); Paragraph pheader = new Paragraph(); ///pheader.SpacingBefore = 20f; foreach (string str in HeaderStr) { Phrase ph = new Phrase(); ph.Add(new Chunk(str.Substring(0, str.IndexOf(':') + 1), font2)); ph.Add(new Chunk(str.Substring(str.IndexOf(':') + 1) + "\n", font1)); pheader.Add(ph); } Paragraph serial = new Paragraph(); Phrase phr = new Phrase(); phr.Add(new Chunk(prodSerNo.Substring(0, prodSerNo.IndexOf(':') + 1), font2)); phr.Add(new Chunk(prodSerNo.Substring(prodSerNo.IndexOf(':') + 1) + "\n", font1)); serial.Add(phr); serial.SpacingBefore = 20f; string[] ColHeaderStr = ColHeader.Split(';'); PdfPTable table1 = new PdfPTable(5); table1.DefaultCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table1.WidthPercentage = 100; float[] width = new float[] { 3f, 3f, 3f, 3f, 3f }; table1.SetWidths(width); table1.SpacingBefore = 10f; for (int i = 0; i < ColHeaderStr.Length; i++) { PdfPCell hcell = new PdfPCell(new Phrase(ColHeaderStr[i].Trim(), font2)); hcell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table1.AddCell(hcell); //string str = ColHeaderStr[i]; } PdfPCell foot = new PdfPCell(new Phrase("")); foot.Colspan = 5; foot.BorderWidthTop = 0; foot.MinimumHeight = 0.5f; table1.AddCell(foot); table1.HeaderRows = 2; table1.FooterRows = 1; table1.SkipFirstHeader = false; table1.SkipLastFooter = true; string[] DetailStr = ColDetailString.Split(';'); for (int i = 0; i < DetailStr.Length; i++) { string[] str = DetailStr[i].Split('+'); for (int j = 0; j < str.Length; j++) { PdfPCell pcell; string s = str[j]; pcell = new PdfPCell(new Phrase(str[j], font1)); pcell.HorizontalAlignment = PdfPCell.ALIGN_CENTER; table1.AddCell(pcell); } } Paragraph pFooter = new Paragraph(); string[] fillFooter = footer3.Split(';'); Phrase Creator = new Phrase(fillFooter[0] + "\n", font1); Phrase Approver = new Phrase(fillFooter[1] + "\n", font1); pFooter.Add(Creator); pFooter.Add(Approver); if (temp == 1) { doc.Add(img); doc.Add(paragraph); doc.Add(pheader); } doc.Add(serial); doc.Add(table1); doc.Add(pFooter); } doc.Close(); pathStr = dir + "\\" + fileName + ".pdf"; documentStorage ds = new documentStorage(); DocumentStorageDB dsdb = new DocumentStorageDB(); ds.DocumentID = "PRODUCTTESTREPORT"; ds.Directory = subDir; ds.FileName = fileName + ".pdf"; ds.Description = "ProductTestReport " + subDir; if (dsdb.validateDocumentDetails(ds)) { if (dsdb.iskDocumentDuplication(ds)) { if (dsdb.UpdateDocumentDetails(ds)) { MessageBox.Show("DocumetnStorage Updated"); } else { MessageBox.Show("failed to update documentStorage"); } } else { if (dsdb.InsertDocumentDetails(ds)) { MessageBox.Show("DocumetnStorage Updated"); } else { MessageBox.Show("failed to update documentStorage"); } } } } catch (Exception ie) { status = false; } return(status); }