private void btnPersonelEncokSatisYapan_Click(object sender, EventArgs e)
{
string komut = "spEnCokSatanPersoneller";
if (tbPersonelAd.Text == string.Empty && tbPersonelSoyad.Text == string.Empty)
{
SqlDataAdapter da = new SqlDataAdapter(komut, baglanti);
DataTable dt = new DataTable();
da.Fill(dt);
dgVeriler.DataSource = dt;
}
sonForm = Formlar.PERSONELENCOK;
}
private void btnMusteriGetir_Click(object sender, EventArgs e)
{
string komut = "SELECT ad AS[AD], soyad AS[SOYAD], tckNo AS[TC KIMLIK NO], telefon AS[TELEFON], eposta AS[E-POSTA], adres AS[ADRES] FROM musteri ";
if (mtbMusteriTCNo.Text == string.Empty && tbMusteriAd.Text == string.Empty && tbMusteriSoyad.Text == string.Empty)
{
SqlDataAdapter da = new SqlDataAdapter(komut, baglanti);
DataTable dt = new DataTable();
da.Fill(dt);
dgVeriler.DataSource = dt;
}
else if (mtbMusteriTCNo.Text != string.Empty && tbMusteriAd.Text == string.Empty && tbMusteriSoyad.Text == string.Empty)
{
komut += "WHERE tckNo='" + mtbMusteriTCNo.Text + "'";
SqlDataAdapter da = new SqlDataAdapter(komut, baglanti);
DataTable dt = new DataTable();
da.Fill(dt);
dgVeriler.DataSource = dt;
}
else if (mtbMusteriTCNo.Text == string.Empty && tbMusteriAd.Text != string.Empty && tbMusteriSoyad.Text == string.Empty)
{
komut += "WHERE ad = '" + tbMusteriAd.Text + "'";
SqlDataAdapter da = new SqlDataAdapter(komut, baglanti);
DataTable dt = new DataTable();
da.Fill(dt);
dgVeriler.DataSource = dt;
}
else if (mtbMusteriTCNo.Text == string.Empty && tbMusteriAd.Text == string.Empty && tbMusteriSoyad.Text != string.Empty)
{
komut += "WHERE soyad = '" + tbMusteriSoyad.Text + "'";
SqlDataAdapter da = new SqlDataAdapter(komut, baglanti);
DataTable dt = new DataTable();
da.Fill(dt);
dgVeriler.DataSource = dt;
}
else if (mtbMusteriTCNo.Text == string.Empty && tbMusteriAd.Text != string.Empty && tbMusteriSoyad.Text != string.Empty)
{
komut += "WHERE ad = '" + tbMusteriAd.Text + "' AND soyad = '" + tbMusteriSoyad.Text + "'";
SqlDataAdapter da = new SqlDataAdapter(komut, baglanti);
DataTable dt = new DataTable();
da.Fill(dt);
dgVeriler.DataSource = dt;
}
sonForm = Formlar.MUSTERI;
}
private void btnPersonelGetir_Click(object sender, EventArgs e)
{
string komut = "SELECT ad AS[AD], soyad AS[SOYAD], tckNo AS[TC KIMLIK NO], eposta AS[E-POSTA], adres AS[ADRES] FROM personel ";
if (tbPersonelAd.Text == string.Empty && tbPersonelSoyad.Text == string.Empty)
{
SqlDataAdapter da = new SqlDataAdapter(komut, baglanti);
DataTable dt = new DataTable();
da.Fill(dt);
dgVeriler.DataSource = dt;
}
else if (tbPersonelAd.Text != string.Empty && tbPersonelSoyad.Text == string.Empty)
{
komut += "WHERE ad = '" + tbPersonelAd.Text + "'";
SqlDataAdapter da = new SqlDataAdapter(komut, baglanti);
DataTable dt = new DataTable();
da.Fill(dt);
dgVeriler.DataSource = dt;
}
else if (tbPersonelAd.Text == string.Empty && tbPersonelSoyad.Text != string.Empty)
{
komut += "WHERE soyad = '" + tbPersonelSoyad.Text + "'";
SqlDataAdapter da = new SqlDataAdapter(komut, baglanti);
DataTable dt = new DataTable();
da.Fill(dt);
dgVeriler.DataSource = dt;
}
else if (tbPersonelAd.Text != string.Empty && tbPersonelSoyad.Text != string.Empty)
{
komut += "WHERE ad = '" + tbPersonelAd.Text + "' AND soyad = '" + tbPersonelSoyad.Text + "'";
SqlDataAdapter da = new SqlDataAdapter(komut, baglanti);
DataTable dt = new DataTable();
da.Fill(dt);
dgVeriler.DataSource = dt;
}
sonForm = Formlar.PERSONEL;
}
private void btnArabaGetir_Click(object sender, EventArgs e)
{
string komut = "SELECT sasiNo AS [ŞASI NO], motorNo AS [MOTOR NO], plaka AS [PLAKA], model AS [MODEL], marka AS [MARKA], renk AS [RENK] FROM araba ";
Boolean andGerekli = false;
if (tbMarka.Text.Count() > 0)
{
komut += "WHERE marka = '" + tbMarka.Text + "'";
andGerekli = true;
}
if (tbModel.Text.Count() > 0)
{
if (andGerekli)
{
komut += " AND model = '" + tbModel.Text + "'";
}
else
{
komut += "WHERE model = '" + tbModel.Text + "'";
andGerekli = true;
}
}
if (tbRenk.Text.Count() > 0)
{
if (andGerekli)
{
komut += " AND renk = '" + tbRenk.Text + "'";
}
else
{
komut += "WHERE renk = '" + tbRenk.Text + "'";
andGerekli = true;
}
}
if (rbSatilmamisAraba.Checked)
{
if (andGerekli)
{
komut += " AND sasiNo NOT IN (SELECT sasiNo FROM satis)";
}
else
{
komut += "WHERE sasiNo NOT IN (SELECT sasiNo FROM satis)";
andGerekli = true;
}
}
if (rbSatilmisAraba.Checked)
{
if (andGerekli)
{
komut += " AND sasiNo IN (SELECT sasiNo FROM satis)";
}
else
{
komut += "WHERE sasiNo IN (SELECT sasiNo FROM satis)";
andGerekli = true;
}
}
SqlDataAdapter da = new SqlDataAdapter(komut, baglanti);
DataTable dt = new DataTable();
da.Fill(dt);
dgVeriler.DataSource = dt;
sonForm = Formlar.ARABA;
}
