private void generateStatisticData() { IEnumerable <VashmagazinApartment> apartments = _vashmagazinRepository.GetListOfLastApartments(); IEnumerable <string> districts = _vashmagazinRepository.GetDistinctDistricts(apartments); IEnumerable <Statistic> statistics = _statisticRepository.GetAllStatistics(); foreach (Statistic statistic in statistics) { statistic.IsOld = true; } _statisticRepository.SaveChanges(); foreach (string district in districts) { IEnumerable <VashmagazinApartment> apartmentsInDistrict = apartments.Where(a => (a.Address.District == district) && (a.Price > 0) && (a.TotalSquare.Value > 0) && (a.TotalSquare.Unit == SquareUnit.SquareMeters)); double p = apartmentsInDistrict.Average(a => (double)a.Price / a.TotalSquare.Value); decimal avaragePricePerMeter = (decimal)p; Statistic stat = new Statistic(); stat.District = district; stat.Date = DateTime.Today; stat.IsOld = false; stat.PricePerMeter = avaragePricePerMeter; _statisticRepository.Add(stat); } _statisticRepository.SaveChanges(); }
public async Task Handle(IMessageContext context, AddContactInformationEvent message) { Console.WriteLine("AddContactInformationEvent occured"); statisticRepository.Add(new Statistic(personId: message.personId, location: message.location, phoneNumber: message.phoneNumber)); await statisticRepository.UnitOfWork.SaveChangesAsync(); return; }
public ActionResult Create([Bind(Include = "StatisticID,PlayerID,MatchID,goals,assists,minutes")] Statistic statistic) { if (ModelState.IsValid) { _statisticRepository.Add(statistic); _statisticRepository.Save(); return(RedirectToAction("Index")); } ViewBag.MatchID = new SelectList(_statisticRepository.GetAllMatches(), "MatchID", "City", statistic.MatchID); ViewBag.PlayerID = new SelectList(_statisticRepository.GetAllPlayers(), "ID", "LastName", statistic.PlayerID); return(View(statistic)); }
public void Add(Statistic statistic) { _statisticRepository.Add(statistic); }