private void Frmistatistik_Load(object sender, EventArgs e)
{
label2.Text = db.TBLKATEGORI.Count().ToString();
label3.Text = db.TBLURUN.Count().ToString();
label5.Text = db.TBLMUSTERI.Count(x => x.DURUM == true).ToString();
label7.Text = db.TBLMUSTERI.Count(x => x.DURUM == false).ToString();
label13.Text = db.TBLURUN.Sum(y => y.STOK).ToString();
label21.Text = db.TBLSATIS.Sum(z => z.FIYAT).ToString() + " TL";
label11.Text = (from x in db.TBLURUN orderby x.FIYAT descending select x.URUNAD).FirstOrDefault();
label9.Text = (from x in db.TBLURUN orderby x.FIYAT ascending select x.URUNAD).FirstOrDefault();
label15.Text = db.TBLURUN.Count(x => x.KATEGORI == 1).ToString();
label17.Text = db.TBLURUN.Count(x => x.URUNAD == "LAPTOP").ToString();
label23.Text = (from x in db.TBLMUSTERI select x.SEHIR).Distinct().Count().ToString();
label19.Text = db.MARKAGETIR().FirstOrDefault();
}
private void Frmİstatistik_Load(object sender, EventArgs e)
{
label2.Text = db.Tbl_Kategori.Count().ToString();
label3.Text = db.Tbl_Urun.Count().ToString();
label5.Text = db.Tbl_Müsteri.Count(x => x.Durum == true).ToString();
label7.Text = db.Tbl_Müsteri.Count(x => x.Durum == false).ToString();
label13.Text = db.Tbl_Urun.Sum(x => x.STOK).ToString();
label21.Text = db.Tbl_satis.Sum(x => x.Fiyat).ToString() + " TL";
label11.Text = (from x in db.Tbl_Urun orderby x.FİYAT descending select x.UrunAD).FirstOrDefault();
label9.Text = (from x in db.Tbl_Urun orderby x.FİYAT ascending select x.UrunAD).FirstOrDefault();
label15.Text = db.Tbl_Urun.Count(x => x.KATEGORİ == 3).ToString();
label17.Text = db.Tbl_Urun.Count(x => x.UrunAD == "Buzdolabı").ToString();
label23.Text = (from x in db.Tbl_Müsteri select x.Sehir).Distinct().Count().ToString();
label19.Text = db.MARKAGETIR().FirstOrDefault();
}
