private void cmbItem_SelectionChanged(object sender, SelectionChangedEventArgs e) { cmbItem.Items.Refresh(); txtAvailableItems.Text = bindData.GetcountItems(cmbItem.Text.ToString(), dataBaseManager.DB_connection, dataBaseManager.SQLConnection); if (cmbItem.SelectedIndex <= 6 && cmbItem.SelectedIndex != -1) { Window1 win2 = new Window1(cmbItem.SelectedIndex); win2.ShowDialog(); txtAvailableItems.Text = dataBaseManager.Execute($"Select `sztuki` From `Items` Where `name` ='{cmbItem.Text}'"); //System.Windows.Forms.MessageBox.Show("battery to Rent : "+ Battery_toRent); } else { cmbId.ItemsSource = bindData.BindId(dataBaseManager.DB_connection, dataBaseManager.GetIdItems(cmbItem.Text.ToString(), false)); cmbId.DisplayMemberPath = "Key"; cmbId.SelectedValuePath = "Value"; } }
private void generate(string fileName, string SQL, PdfPTable Table) { List <List <string> > Lista_itemow = new List <List <string> >(); System.Windows.Forms.SaveFileDialog saveFileDialog1 = new System.Windows.Forms.SaveFileDialog(); saveFileDialog1.Filter = "PDF File|*.pdf"; saveFileDialog1.Title = "Save Report File"; saveFileDialog1.FileName = fileName; saveFileDialog1.ShowDialog(); if (saveFileDialog1.FileName != fileName) { fileName = saveFileDialog1.FileName; } else { return; } FileStream fs; try { fs = new FileStream(fileName, FileMode.Create, FileAccess.Write, FileShare.None); } catch (IOException x) { MessageBox.Show("Report is already generated"); return; } catch (Exception y) { return; } Document doc = new Document(); doc.SetPageSize(iTextSharp.text.PageSize.A4.Rotate()); PdfWriter writer = PdfWriter.GetInstance(doc, fs); doc.Open(); //dodać wybieranie miejsca na zapis pliku doc.Add(Table); try { Lista_itemow = (dataBaseManagerReport.GetStock(SQL)); // lista obiektow do raportu for (int i = 0; i < Lista_itemow.Count; i++) { PdfPTable table = new PdfPTable(Table.NumberOfColumns); bool FLAG = false; // flaga na pojawienie się battery w cell string sztuki = ""; foreach (var cell in Lista_itemow[i]) { if (FLAG) { table.AddCell(cell + " / " + sztuki); FLAG = false; sztuki = "0"; } else { if (cell.Contains("Battery")) { table.AddCell(cell); FLAG = true; sztuki = dataBaseManagerReport.Execute($"SELECT `sztuki` FROM `Items` Where `name` = '{cell}'"); } else // jezeli cos innego to : { table.AddCell(cell); } } } doc.Add(new PdfPTable(table)); } } catch (Exception) { MessageBox.Show("please try again, during generate report was connection error"); // return; } try { doc.Close(); MessageBox.Show("done"); } catch (Exception x) { } }