public void RaporGetir(DateTime secilenGun) { KahveciContext db = new KahveciContext(); GunlukRaporViewModel rapor = new GunlukRaporViewModel(); try { rapor.ToplamSatisTutari = db.Siparisler .Where(x => DbFunctions.TruncateTime(x.Tarih).Value.Month == secilenGun.Month && DbFunctions.TruncateTime(x.Tarih).Value.Year == secilenGun.Year) .Sum(x => x.SiparistekiUrunler .Sum(y => y.Tutar)); rapor.ToplamSatilanUrunSayisi = db.Siparisler .Where(x => DbFunctions.TruncateTime(x.Tarih).Value.Month == secilenGun.Month && DbFunctions.TruncateTime(x.Tarih).Value.Year == secilenGun.Year) .Sum(x => x.SiparistekiUrunler .Sum(y => y.Miktar)); rapor.KullaniciBasiSatislar = (from sd in db.Siparisler join k in db.Kullanicilar on sd.KaydedenKullaniciId equals k.KullaniciID where DbFunctions.TruncateTime(sd.Tarih).Value.Month == secilenGun.Month && DbFunctions.TruncateTime(sd.Tarih).Value.Year == secilenGun.Year group sd by k.KullaniciAdi into yeni select new KullaniciSatisViewModel() { KullaniciAdi = yeni.Key, ToplamSatisTutari = yeni.Sum(x => x.SiparistekiUrunler.Sum(a => a.Tutar)) } ).ToList(); rapor.UrunBasiSatislar = (from sd in db.SiparisDetaylar where DbFunctions.TruncateTime(sd.Siparis.Tarih).Value.Month == secilenGun.Month && DbFunctions.TruncateTime(sd.Siparis.Tarih).Value.Year == secilenGun.Year group sd by sd.Urun.UrunID into yeni select new UrunBasiSatisViewModel() { UrunID = yeni.Key, UrunAdi = yeni.Max(x => x.Urun.UrunAdi), Adet = yeni.Sum(x => x.Miktar) } ).ToList(); } catch (Exception ex) { label3.Text = ex.Message; MessageBox.Show("Bu ayda kayıt yok."); } label6.Text = rapor.ToplamSatisTutari.ToString("C"); label7.Text = rapor.ToplamSatilanUrunSayisi.ToString(); dataGridView1.DataSource = null; dataGridView2.DataSource = null; dataGridView1.DataSource = rapor.KullaniciBasiSatislar; dataGridView2.DataSource = rapor.UrunBasiSatislar; }
public void Yenile() { flowLayoutPanel1.Controls.Clear(); ctx = new KahveciContext(); listBox2.DataSource = null; listBox2.ValueMember = "UrunID"; listBox2.DisplayMember = "UrunAdi"; listBox2.DataSource = ctx.Urunler.OrderBy(x => x.Fiyat).ToList(); if (ctx.Urunler.Count() != 0) { foreach (Urun urun in ctx.Urunler) { Button btn = new Button(); btn.Width = 100; btn.Height = 40; btn.Name = "Urun_" + urun.UrunID; btn.Text = urun.UrunAdi; //btn.Click += butonMetodu_Click; btn.Click += UrunuSipariseEkle; flowLayoutPanel1.Controls.Add(btn); } } }