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();
}
