private void cbFirmaAdi_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(gnl.baglan);
conn.Open();
SqlCommand cmd2 = new SqlCommand("SELECT id FROM firma WHERE firmaadi=@firmaadi", conn);
cmd2.Parameters.AddWithValue("@firmaadi", cbFirmaAdi.Text);
SqlDataAdapter da = new SqlDataAdapter(cmd2);
DataTable dt = new DataTable();
da.Fill(dt);
int id = Convert.ToInt32(dt.Rows[0][0]);
string sorgu = "SELECT tahsilat.id,tahsilat.tarih as Tarih, tahsilat.islemtipi as İşlemTipi, firma.firmaadi as Firma, tahsilat.tutar as Tutar, tahsilat.aciklama as Açıklama FROM tahsilat INNER JOIN firma ON firma.id=tahsilat.firma_id WHERE firma_id = '" + id + "' " +
"UNION SELECT cek.id,cek.tarih as Tarih, cek.islemtipi as İşlemTipi, firma.firmaadi as Firma, cek.tutar as Tutar, cek.aciklama as Açıklama FROM cek INNER JOIN firma ON firma.id=cek.firma_id WHERE firma_id = '" + id + "'" +
"UNION SELECT senet.id,senet.tarih as Tarih, senet.islemtipi as İşlemTipi,firma.firmaadi as Firma, senet.tutar as Tutar, senet.aciklama as Açıklama FROM senet INNER JOIN firma ON firma.id=senet.firma_id WHERE firma_id = '" + id + "'";
//string sorgu = "SELECT tarih, islemtipi, tutar, aciklama FROM tahsilat WHERE firma_id = '" + id + "' UNION SELECT tarih, islemtipi, tutar, aciklama FROM cek WHERE firma_id = '" + id + "'";
gnl.veriGetir(sorgu, dataGridView1);
dataGridView1.Columns[0].Visible = false;
}
public void YemekFiyatGetir()
{
string sorgu = "SELECT yemekadi as [Yemek Fiyat Adı], yemekucret as [Yemeğin Fiyatı] FROM yemekFiyat";
// as [Yemek Fiyat Adı]
// as [Yemeğin Fiyatı]
gnl.veriGetir(sorgu, dtYemekFiyat);
}
public void FisGetirmeyenler()
{
string sorgu = "SELECT firma_detay.id, firma_detay.tarih as Tarih,firma.firmaadi as Firma, firma_detay.aciklama as Açıklama FROM firma_detay INNER JOIN firma ON firma.id=firma_detay.firma_id WHERE firma_detay.fisdurum=0";
gnl.veriGetir(sorgu, dataGridView1);
dataGridView1.Columns[0].Visible = false;
}
private void faturaGetir()
{
string sorgu = "SELECT firma.firmaadi as Firma, fatura.tarih as Tarih, fatura.tutar as Tutar, fatura.kdvtutar as KDV, fatura.toplam as Toplam FROM firma INNER JOIN fatura ON fatura.firma_id=firma.id";
// string bakiyesorgu = "SELECT toplamborc FROM firma_detay WHERE firma_id='"+id+"'";
gnl.veriGetir(sorgu, dataGridView1);
//dataGridView1.Columns[1].Visible = false;
//dataGridView1.Columns[2].Visible = false;
//dataGridView1.Columns[6].Visible = false;
//dataGridView1.Columns[7].Visible = false;
//dataGridView1.Columns[8].Visible = false;
//dataGridView1.Columns[9].Visible = false;
//dataGridView1.Columns[10].Visible = false;
//dataGridView1.Columns[11].Visible = false;
dataGridView1.Refresh();
}
public void FirmaGoser()
{
string sorgu = "SELECT firma.id,firma.firmaadi as FirmaAdı, firma.yetkili as Yetkili, firma.adres as Adres, firma.tel1 as Telefon, firma.tel2, firma.gsm, firma.mail, firma.vdairesi, firma.vno, firma.yemekfiyat, firma.aciklama,((SELECT SUM(firmaoncekiborc.fborcu) FROM firmaoncekiborc WHERE firmaoncekiborc.firma_id=firma.id) +(SELECT SUM(firma_detay.tutar) FROM firma_detay WHERE firma_detay.firma_id=firma.id)+(SELECT SUM(fatura.kdvtutar) FROM fatura WHERE fatura.firma_id=firma.id)-(SELECT SUM(firmaoncekiborc.falacagi) FROM firmaoncekiborc WHERE firmaoncekiborc.firma_id=firma.id)) AS Bakiye FROM firma";
// string bakiyesorgu = "SELECT toplamborc FROM firma_detay WHERE firma_id='"+id+"'";
//string topFirmaDetay = "SELECT ";
// string topOnceki = "";
gnl.veriGetir(sorgu, dataGridView1);
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
dataGridView1.Columns[8].Visible = false;
dataGridView1.Columns[9].Visible = false;
dataGridView1.Columns[10].Visible = false;
dataGridView1.Columns[11].Visible = false;
dataGridView1.Refresh();
}
private void cbFirmaAdi_SelectedIndexChanged(object sender, EventArgs e)
{
string sorgu = "SELECT firma_detay.tarih as Tarih, firma_detay.fis as KişiSayısı,firma.yemekfiyat as YemekFiyatı, firma_detay.tutar as Tutar, firma_detay.aciklama as Açıklama, firma_detay.id FROM firma INNER JOIN firma_detay ON firma.id=firma_detay.firma_id WHERE firma.firmaadi='" + cbFirmaAdi.Text + "'";
gnl.veriGetir(sorgu, dataGridView1);
dataGridView1.Columns[5].Visible = false;
if (dataGridView1.Rows.Count > 1)
{
btnSil.Enabled = true;
groupBox1.Enabled = true;
}
else
{
btnSil.Enabled = false;
groupBox1.Enabled = false;
}
toplam();
}