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(); }