private void FrmIstatıstık_Load(object sender, EventArgs e)
{
labelControl2.Text = db.TBLURUN.Count().ToString();
labelControl3.Text = db.TBLKATEGORİ.Count().ToString();
labelControl7.Text = db.TBLURUN.Sum(x => x.STOK).ToString();
labelControl19.Text = (from x in db.TBLURUN
orderby x.STOK descending
select x.AD).FirstOrDefault();
labelControl17.Text = (from x in db.TBLURUN
orderby x.STOK ascending
select x.AD).FirstOrDefault();
labelControl13.Text = (from x in db.TBLURUN
orderby x.SATISFIYAT descending
select x.AD).FirstOrDefault();
labelControl11.Text = (from x in db.TBLURUN
orderby x.SATISFIYAT ascending
select x.AD).FirstOrDefault();
labelControl37.Text = db.TBLURUN.Count(x => x.KATEGORI == 4).ToString();
labelControl35.Text = db.TBLURUN.Count(x => x.KATEGORI == 1).ToString();
labelControl33.Text = db.TBLURUN.Count(x => x.KATEGORI == 3).ToString();
labelControl29.Text = (from x in db.TBLURUN select x.MARKA).Distinct().Count().ToString();
labelControl25.Text = db.TBLURUNKABUL.Count().ToString();
labelControl15.Text = db.MAKSKATEGORI().FirstOrDefault();
labelControl27.Text = db.MARKSURUNMARKA().FirstOrDefault();
labelControl5.Text = db.TBLURUN.Count(x => x.STOK < 30).ToString();
}
private void FrmMarkalar_Load(object sender, EventArgs e)
{
var degerler = db.TBLURUN.OrderBy(x => x.MARKA).GroupBy(y => y.MARKA).Select(z => new
{
Marka = z.Key,
Toplam = z.Count()
});
gridControl1.DataSource = degerler.ToList();
labelControl29.Text = db.TBLURUN.Count().ToString();
labelControl27.Text = (from x in db.TBLURUN select x.MARKA).Distinct().Count().ToString();
labelControl23.Text = (from x in db.TBLURUN
orderby x.SATISFIYAT descending
select x.MARKA).FirstOrDefault();
labelControl25.Text = db.MARKSURUNMARKA().FirstOrDefault();
//Grafik1 kısmını doldurduk
SqlConnection baglanti = new SqlConnection(@"Data Source=DESKTOP-DNNFR5;Initial Catalog=DbTeknikServis;Integrated Security=True");
baglanti.Open();
SqlCommand komut = new SqlCommand("SELECT MARKA,COUNT(*) FROM TBLURUN GROUP BY MARKA", baglanti);
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
chartControl1.Series["Series 1"].Points.AddPoint(dr[0].ToString(), int.Parse(dr[1].ToString()));
}
baglanti.Close();
//GRAFİK 2 KISMI
baglanti.Open();
SqlCommand komut1 = new SqlCommand("SELECT TBLKATEGORİ.AD ,COUNT(*) FROM TBLURUN INNER JOIN TBLKATEGORİ ON TBLKATEGORİ.ID = TBLURUN.KATEGORI GROUP BY TBLKATEGORİ.AD", baglanti);
SqlDataReader dr1 = komut.ExecuteReader();
while (dr1.Read())
{
chartControl2.Series["Kategoriler"].Points.AddPoint(dr1[0].ToString(), int.Parse(dr1[1].ToString()));
}
baglanti.Close();
}
