static void Main(string[] args)
{
IStoresRepository repository = new StoresRepository();
var stores = repository.GetStores();
foreach (var name in stores)
{
if (name.Bill.Any(x => x.Item.Engine == "Electric"))
{
Console.WriteLine(name.City);
}
}
//var q = stores.SelectMany(x => x.Bill.GroupBy(y => y.Client).Select(g => new {Name = g.Key.Name, Count = g.Count()}));
//foreach (var store in q)
//{
// if(store.Count > 1)
// Console.WriteLine("Name: " + store.Name + " count: " + store.Count);
//}
//var sumMoneyKharkov =
//stores.Where(x => x.City == "Kharkiv").SelectMany(k => k.Bill.Where(y => y.SoldDate.Date.Year == DateTime.Today.Year)).Sum(h => h.Price);
//var storeYears = stores.SelectMany(x => x.Bill.Where(y => y.SoldDate.Date.Year == DateTime.Today.Year)).ToList();
//var storeYears = stores.SelectMany(x => x.Bill.GroupBy(y => y.Client));
//количество транзакция за 2016 год = 4
//var countTranzation = stores.SelectMany(x => x.Bill.Where(y => y.SoldDate.Year == new DateTime(2016, 1, 1).Year)).Count();
//на какую сумуу продал киевский магазин за 2016 год
//var kievStoreSum =
//stores.Where(x => x.City == "Kiev")
// .SelectMany(y => y.Bill.Where(h => h.SoldDate.Year == new DateTime(2016, 1, 1).Year))
// .Sum(p => p.Price);
//имя владельца, что имеет 2 машины
}
public DatabaseProvider(ApplicationDbContext context)
{
_context = context;
stores = new StoresRepository(context);
articles = new ArticlesRepository(context);
}
public HomeController()
{
_DBContext = new Zoughaibandco_DBEntities();
_homeRepository = new HomeRepository();
_storesRepository = new StoresRepository();
}
