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 CreateInvoice_Button_Click(object sender, RoutedEventArgs e)
{
string id_company = (AddCompanyToInvoice_DataGrid.SelectedCells[0].Column.GetCellContent(AddCompanyToInvoice_DataGrid.SelectedItem) as TextBlock).Text;
DataBaseCon.Query(Invoice.AddInvoice(id_company));
AddInvoice Win1 = new AddInvoice(Convert.ToInt32(id_company));
Win1.Show();
}
private void EditCompany_Button_Click(object sender, RoutedEventArgs e)
{
//DataBaseCon.Query(Company.EditCompany(nip, name, city, street, building,postcode));
DataBaseCon.Query(Company.EditCompany(AddNip_TextBox.Text, AddName_TextBox.Text, AddCity_TextBox.Text, AddStreet_TextBox.Text, AddBuilding_TextBox.Text, AddPostcode_TextBox.Text));
this.Close();
AddCompany Win1 = new AddCompany();
Win1.Show();
}
private void close_invoice_Click(object sender, RoutedEventArgs e)
{
DataBaseCon.Query(Invoice.UpdateInvoice(DataBaseCon.ReadData("SELECT TOP 1 id_invoice FROM Invoice ORDER BY id_invoice DESC"), auth_recieve.Text, Payment_Text.Text));
}
private void DeleteConfirmed_Click(object sender, RoutedEventArgs e)
{
DataBaseCon.Query(Company.DelCompany(nip1));
this.Close();
}
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);
}