private void button2_Click(object sender, EventArgs e)
{
string query = "INSERT INTO trips (Name, Destination, Date_start, Date_end) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "','" + dateTimePicker1.Text + "','" + dateTimePicker2.Text + "')";
DataBaseConnect baza = new DataBaseConnect();
baza.Insert(query);
}
private void button1_Click(object sender, EventArgs e)
{
Logon test = new Logon();
DataBaseConnect baza = new DataBaseConnect();
string query = "UPDATE trips SET Buyer = '" + Logon.login + "' WHERE id = '" + List_new.SelectedItems[0].SubItems[4].Text + "'";
baza.Insert(query);
}
private void button4_Click(object sender, EventArgs e)
{
string query = "UPDATE trips SET Name = '" + textBox1.Text + "' , Destination = '" + textBox2.Text + "', Date_start = '" + dateTimePicker1.Text + "', Date_end = '" + dateTimePicker2.Text + "' WHERE id = '" + List_new.SelectedItems[0].SubItems[4].Text + "'";
DataBaseConnect baza = new DataBaseConnect();
baza.Insert(query);
List_new.SelectedItems[0].Remove();
}
private void button3_Click(object sender, EventArgs e)
{
string query = "DELETE FROM trips WHERE id = '" + List_new.SelectedItems[0].SubItems[4].Text + "'";
DataBaseConnect baza = new DataBaseConnect();
baza.Insert(query);
List_new.SelectedItems[0].Remove();
//MessageBox.Show(List_new.SelectedItems[0].SubItems[4].Text);
}