private void Button_Click(object sender, RoutedEventArgs e)
{
SQLiteConnection sqliteCon = new SQLiteConnection(dbConnectionString);
try
{
sqliteCon.Open();
if (datapic1.Text == "" || datapic2.Text == "") //|| textbox3.Text == "" || textbox4.Text == "" || cmb1.Text =="")
{
MessageBox.Show("Bitte Datum ausfüllen ");
}
else
{
//string Query = " SELECT Buchung_nummer fROM Buchen";
//string Query = " SELECT Buchung_nummer, Name , Vorname, Geburtsdatum , type , Preis_zimmer from Buchung,Kunden,Zimmer WHERE Buchung.Kunden_id = Kunden.Kunden_id And Buchung.Zimmer_id = Zimmer.Zimmer_id ";
//string Query = " SELECT Buchung_nummer, Name , Vorname, Geburtsdatum , type , Preis_zimmer from Buchung,Kunden,Zimmer WHERE Von between '" +datapicke1.ToString()+ "' AND Bis'" + datapik2.ToString() + "' And Buchung.Kunden_id = Kunden.Kunden_id And Buchung.Zimmer_id = Zimmer.Zimmer_id And Buchung.Zimmer_id = Zimmer.Zimmer_id";
string Query = " SELECT Buchung_nummer,Name , Vorname, Von, Bis, Datum , Preis FROM Buchung ,Kunden WHERE Von between '" + datapic1.ToString() + "'and '" + datapic2.ToString() + "' And Buchung.Kunden_id = Kunden.Kunden_id ";
//string Query = "SELECT * FROM Buchung JOIN Kunden , Zimmer ON Buchung.Kunden_id = Kunden.Kunden_id And Buchung.Zimmer_id = Zimmer.Zimmer_id WHERE Buchung_nummer = @Buchungsnummer";
//string Query = " SELECT Buchung_nummer from Buchung";
SQLiteCommand CreateCommand = new SQLiteCommand(Query, sqliteCon);
SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter(CreateCommand);
Zimmer_verwalten ds = new Zimmer_verwalten();
SQLiteDataReader reader;
reader = CreateCommand.ExecuteReader();
dataGrid.ItemsSource = reader;
//sqliteCon.Close();
//DataTable dt = new DataTable();
//dataAdapter.Fill(dt);
//dataGrid.DataSource = dt;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Button_Click_4(object sender, RoutedEventArgs e)
{
Zimmer_verwalten win2 = new Zimmer_verwalten();
win2.Show();
}
private void btn_zimmer(object sender, RoutedEventArgs e)
{
Zimmer_verwalten win2 = new Zimmer_verwalten();
win2.Show();
}