public Form1()
{
InitializeComponent();
bazaClass baza = new bazaClass();
baza.wyswietl_tabele_klientow(dataGridView1);
}
private void button2_Click(object sender, EventArgs e)
{
bazaClass baza = new bazaClass();
string upKlient = "UPDATE Klient SET id_Klienta ='" + numer + "', Pesel = '" + textBox1.Text + "' , Imie = '" + textBox3.Text + "', Nazwisko = '" + textBox2.Text + "' WHERE id_Klienta= '" + numer + "';";
baza.Insert(upKlient);
baza.wyswietl_tabele_klientow(dataGridView1);
}
private void button13_Click(object sender, EventArgs e)
{
bazaClass baza = new bazaClass();
String KontoIn = "INSERT INTO Karta VALUES('','" + numer2 + "','2020-01-01');";
baza.Insert(KontoIn);
baza.wyswietl_tabele_klientow(dataGridView1);
}
private void button12_Click(object sender, EventArgs e)
{
string uKlient = "DELETE FROM Klient WHERE id_Klienta = '" + numer + "';";
bazaClass baza = new bazaClass();
baza.Insert(uKlient);
baza.wyswietl_tabele_klientow(dataGridView1);
}
private void button1_Click(object sender, EventArgs e)
{
int test = (String.Compare(textBox3.Text, ""));
test = test + (String.Compare(textBox2.Text, ""));
test = test + (String.Compare(textBox1.Text, ""));
if (test != 0)
{
string KlientIn = "INSERT INTO Klient Values('','";
bazaClass baza = new bazaClass();
KlientIn = KlientIn + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "');";
baza.Insert(KlientIn);
baza.wyswietl_tabele_klientow(dataGridView1);
}
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
public void button11_Click_1(object sender, EventArgs e)
{
bazaClass baza = new bazaClass();
baza.wyswietl_tabele_klientow(dataGridView1);
}
