private void buttonBestSellersYear_Click(object sender, EventArgs e)
{
using (MyDbContext context = new MyDbContext())
{
try
{
var BestSellersMonth = context.Sellings.AsEnumerable()
.Where(r => r.DateSell.Year == DateTime.Now.Year)
.GroupBy(r => r.IdDisk)
.OrderByDescending(g => g.Sum(r => r.Quantity))
.Select(g => g.First().IdDisk).ToList();
//.Take(3).ToList();
List <Disk> disks = new List <Disk>();
foreach (var item in context.Disks.ToList())
{
foreach (var item2 in BestSellersMonth)
{
if (item.IdDisk == item2)
{
disks.Add(item);
}
}
}
ResultsDiscs f9 = new ResultsDiscs(disks);
f9.ShowDialog();
}
catch (Exception ex) { }
}
}
private void buttonOk_Click(object sender, EventArgs e)
{
if (radioButtonTitle.Checked)
{
using (MyDbContext context = new MyDbContext())
{
try
{
var res = context.Disks.Where(x => x.Title == textBoxTitle.Text).ToList();
ResultsDiscs f9 = new ResultsDiscs(res);
f9.ShowDialog();
}
catch (Exception x) { }
}
}
else
if (radioButtonCollective.Checked)
{
using (MyDbContext context = new MyDbContext())
{
try
{
var res = context.Disks.Where(x => x.Collective.Name == textBoxCollective.Text).ToList();
ResultsDiscs f9 = new ResultsDiscs(res);
f9.ShowDialog();
}
catch (Exception x) { }
}
}
else
if (radioButtonGenre.Checked)
{
using (MyDbContext context = new MyDbContext())
{
try
{
var g = context.Genres.Where(z => z.Title == textBoxGenre.Text).FirstOrDefault();
var res = context.Genres.Select(x => x.Disks).ToList();
List <Disk> result = new List <Disk>();
foreach (var item in res)
{
foreach (var item2 in item)
{
if (item2.Genres.ToList().Contains(g) == true)
{
result.Add(item2);
}
}
}
ResultsDiscs f9 = new ResultsDiscs(result);
f9.ShowDialog();
}
catch (Exception x) { }
}
}
}
private void buttonLatestNewDiscs_Click(object sender, EventArgs e)
{
using (MyDbContext context = new MyDbContext())
{
var res = context.Disks.Where(x => x.DtPublish.Month == DateTime.Now.Month).ToList();
try
{
ResultsDiscs f9 = new ResultsDiscs(res);
f9.ShowDialog();
}
catch (Exception ex) { }
}
}
private void buttonMostPopularGenreMonth_Click(object sender, EventArgs e)
{
using (MyDbContext context = new MyDbContext())
{
try
{
var PopularGenreMonth = context.Sellings.AsEnumerable()
.Where(r => r.DateSell.Month == DateTime.Now.Month)
.GroupBy(r => r.IdDisk)
.OrderByDescending(g => g.Sum(r => r.Quantity))
.Select(g => g.First().IdDisk).ToList();
List <Genre> genre1 = new List <Genre>();
foreach (var item in PopularGenreMonth)
{
foreach (var item2 in context.Disks.ToList())
{
if (item2.IdDisk == item)
{
foreach (var item3 in item2.Genres)
{
Genre g = context.Genres.Where(x => x.IdGenre == item3.IdGenre).FirstOrDefault();
genre1.Add(g);
}
}
}
}
var res = genre1.GroupBy(x => x.IdGenre);
List <Genre> coll2 = new List <Genre>();
foreach (var key in res)
{
foreach (var item in key)
{
coll2.Add(item);
break;
}
}
ResultsDiscs f9 = new ResultsDiscs(coll2);
f9.ShowDialog();
}
catch (Exception ex) { }
}
}