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)
{
}
}
