private void kayıtAraToolStripMenuItem_Click(object sender, EventArgs e)
{
kayıtlistesi kytliste = new kayıtlistesi();
kytliste.Show();
kytliste.dataGridView1.DataSource = null;
}
private void kayıtListesiToolStripMenuItem_Click(object sender, EventArgs e)
{
kayıtlistesi kayitliste = new kayıtlistesi();
kayitliste.MdiParent = this;
kayitliste.Show();
}
private void btnara_Click(object sender, EventArgs e)
{
kayıtlistesi kytliste = new kayıtlistesi();
kytliste.Show();
baglanti bgln = new baglanti();
bgln.baglan();
if (checkkurum.Checked == true && checkad.Checked == true)
{
DataTable dt = new DataTable();
if (cbkurum.Text.Trim() == "" && txtad.Text.Trim() == "")
{
SqlDataAdapter da = new SqlDataAdapter("select * from kayitbilgileri", bgln.baglan());
da.Fill(dt);
kytliste.dataGridView1.DataSource = dt;
}
else
{
SqlDataAdapter da = new SqlDataAdapter("select * from kayitbilgileri where ADSOYAD LIKE '%" + txtad.Text + "%' AND KURUM='" + cbkurum.Text + "'", bgln.baglan());
da.Fill(dt);
kytliste.dataGridView1.DataSource = dt;
}
}
else if (checkad.Checked == true)
{
DataTable dt = new DataTable();
if (txtad.Text.Trim() == "")
{
SqlDataAdapter da = new SqlDataAdapter("select * from kayitbilgileri", bgln.baglan());
da.Fill(dt);
kytliste.dataGridView1.DataSource = dt;
}
else
{
SqlDataAdapter da = new SqlDataAdapter("select * from kayitbilgileri where ADSOYAD LIKE '%" + txtad.Text + "%'", bgln.baglan());
da.Fill(dt);
kytliste.dataGridView1.DataSource = dt;
}
}
else if (checkkurum.Checked == true)
{
DataTable dt = new DataTable();
if (cbkurum.Text.Trim() == "")
{
SqlDataAdapter da = new SqlDataAdapter("select * from kayitbilgileri", bgln.baglan());
da.Fill(dt);
kytliste.dataGridView1.DataSource = dt;
}
else
{
SqlDataAdapter da = new SqlDataAdapter("select * from kayitbilgileri where KURUM LIKE '%" + cbkurum.Text + "%'", bgln.baglan());
da.Fill(dt);
kytliste.dataGridView1.DataSource = dt;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
kayıtlistesi kytlistesi = new kayıtlistesi();
kytlistesi.Show();
baglanti bgln = new baglanti();
bgln.baglan();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("SELECT *FROM kayitbilgileri WHERE TARİH BETWEEN '" + dateTimePicker1.Value.ToString() + "' AND '" + dateTimePicker2.Value.ToString() + "'", bgln.baglan());
da.Fill(dt);
kytlistesi.dataGridView1.DataSource = dt;
}
private void btnguncelle_Click(object sender, EventArgs e)
{
baglanti bgln = new baglanti();
bgln.baglan();
kayıtlistesi kytliste = new kayıtlistesi();
kytliste.Show();
SqlCommand kmt = new SqlCommand();
kmt.Connection = bgln.baglan();
kmt.CommandText = "Update kayitbilgileri SET ADSOYAD='" + txtadsoyad.Text + "', KURUM= '" + cbkurum.Text + "',TELEFON='" + txttel.Text + "',SIKAYET ='" + txtsikayet.Text + "',ILGILIBIRIM='" + txtilgili.Text + "',ACIKLAMA='" + txtaciklama.Text + "',ILCE='" + cbilçe.Text + "',MAHALLE='" + cbmah.Text + "',CADDE='" + txtcadde.Text + "',APARTMAN='" + txtapt.Text + "',DISKAPI='" + txtdis.Text + "',ICKAPI='" + txtic.Text + "',INCELEME='" + txtinceleme.Text + "',SONUC='" + txtsonuc.Text + "',TARİH='" + dtpzaman.Value + "'Where ID='" +
textBox1.Text + "'";
kmt.ExecuteNonQuery();
kytliste.displayrecords();
bgln.baglan().Close();
}
private void kayıtListesiToolStripMenuItem_Click_1(object sender, EventArgs e)
{
kayıtlistesi kytliste = new kayıtlistesi();
kytliste.Show();
}