private void AddItemToInvoice_button_Click(object sender, RoutedEventArgs e)
{
DataBaseCon.Query(Invoice.AddItemToInvoice(DataBaseCon.ReadData("SELECT TOP 1 id_invoice FROM Invoice ORDER BY id_invoice DESC"), Item_text.Text, Quantity_text.Text, netto_text.Text));
Item_text.Text = null;
Quantity_text.Text = null;
netto_text.Text = null;
DataBaseCon.GridViewSelect("SELECT * FROM invoiceGoods where id_invoice=" + DataBaseCon.ReadData("SELECT TOP 1 id_invoice FROM Invoice ORDER BY id_invoice DESC"), "invoiceGoods", invoiceGoods_GridView);
}
private void TextBox_TextChanged(object sender, TextChangedEventArgs e)
{
DataBaseCon.GridViewSelect("SELECT * FROM Company where nip like" + AddInvoiceToCompany_TextBox.Text + ";", "Company", AddCompanyToInvoice_DataGrid);
}
public AddCompanyToInvoice()
{
InitializeComponent();
DataBaseCon.GridViewSelect("SELECT * FROM Company", "Company", AddCompanyToInvoice_DataGrid);
}
public GeneratePDF()
{
InitializeComponent();
DataBaseCon.GridViewSelect("SELECT id_invoice,id_company, issue_date, payment_date, status FROM Invoice", "Invoice", Invoices_DataGrid);
}
public AddInvoice()
{
InitializeComponent();
DataBaseCon.GridViewSelect("SELECT * FROM invoiceGoods where id_invoice=" + id_company1, "invoiceGoods", invoiceGoods_GridView);
}
public Invoices()
{
InitializeComponent();
DataBaseCon.GridViewSelect("SELECT * FROM invoice ", "invoice", Invoices_datagrid);
}
private void AddCompany_Button(object sender, RoutedEventArgs e)
{
DataBaseCon.Query(Company.AddCompany(AddNip_TextBox.Text, AddName_TextBox.Text, AddCity_TextBox.Text, AddStreet_TextBox.Text, AddBuilding_TextBox.Text, AddPostcode_TextBox.Text));
DataBaseCon.GridViewSelect("SELECT * FROM Company", "Company", AddingCompany_DataGridView);
}
public AddCompany()
{
InitializeComponent();
DataBaseCon.GridViewSelect("SELECT * FROM Company", "Company", AddingCompany_DataGridView);
}