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