private void Bind_AllAvailableItems() { List <string> itemki = new List <string>(); foreach (var item in ItemsList) { itemki.Add(item + ": " + dataBaseManager.GetCountItems(item)); } txtAllAvailableItems.Text = bindData.getTextForUI(itemki); }
private void Bind_AllAvailableItems() { List <string> itemki = new List <string>(); foreach (var item in ItemsList) { if (item.Contains("Battery")) { itemki.Add(item + ": " + dataBaseManager.Execute($"Select `sztuki` From `Items` where `name` = '{item}' ")); } else { itemki.Add(item + ": " + dataBaseManager.GetCountItems(item)); } } txtAllAvailableItems.Text = bindData.getTextForUI(itemki); }
private void Button_Click_3(object sender, RoutedEventArgs e) { List <Item> Lista_itemow = new List <Item>(); foreach (var item in ((MainWindow)System.Windows.Application.Current.MainWindow).ItemsList) { try { for (int i = 0; i < int.Parse(dataBaseManagerEdit.GetCountItems(item)); i++) { List <string> IDReport = dataBaseManagerEdit.GetIdItems(item, true); int j = 0; while (j < IDReport.Count()) { Lista_itemow.Add(dataBaseManagerEdit.GetItem(item, IDReport[j])); j++; } } } catch (Exception) { MessageBox.Show("please try again, during generate report was connection error"); // return; } } FileStream fs = new FileStream("Report.pdf", FileMode.Create, FileAccess.Write, FileShare.None); Document doc = new Document(); PdfWriter writer = PdfWriter.GetInstance(doc, fs); doc.Open(); int ii = 0; while (ii < Lista_itemow.Count()) { doc.Add(new iTextSharp.text.Paragraph(Lista_itemow[ii].Get_stringfor_QR(Lista_itemow[ii]))); ii++; } doc.Close(); }