コード例 #1
0
        // GET: NextRaces
        public ActionResult Index()
        {
            var distances = db.distances;
            var list      = distances.ToList();

            ViewBag.distances = buildSelectList(distances);
            // var allRunners = db.runners.Include(n => n.LastRaces).OrderBy(n =>n.secondname);
            var allRunners       = db.runners.OrderBy(n => n.secondname);
            List <nextRaceVM> vm = new List <nextRaceVM>();

            foreach (var m in allRunners)
            {
                var nr   = new nextRaceVM();
                var last = db.LastRaces.SingleOrDefault(l => l.RunnerId == m.EFKey);
                if (last != null)
                {
                    nr.RunnerId     = m.EFKey;
                    nr.LastDistance = db.distances.SingleOrDefault(d => d.Value == last.Distance).Name;
                    nr.LastTime     = RaceCalc.formatTime(last.Time);
                    nr.RunnerName   = m.firstname + " " + m.secondname;
                    nr.Time         = RaceCalc.formatTime(last.Time);
                    vm.Add(nr);
                }
            }
            return(View(vm));
        }
コード例 #2
0
        public ActionResult NewTarget(string distances)
        {
            db.NextRaces.RemoveRange(db.NextRaces);
            var allRunners = db.runners.Include(n => n.LastRaces);

            // foreach runner
            foreach (var r in allRunners)
            {
                var lastRace = r.LastRaces.FirstOrDefault(s => s.RunnerId == r.EFKey);
                if (lastRace != null)
                {
                    var oldDistance   = lastRace.Distance;
                    var oldtime       = lastRace.Time;
                    var predictedTime = (RaceCalc.calcPredictedTime(oldDistance, Convert.ToDouble(distances), oldtime) + RaceCalc.cameron(oldDistance, Convert.ToDouble(distances), oldtime)) / 2;
                    RunningModel.NextRace nextrace = new NextRace();
                    nextrace.RunnerId = r.EFKey;
                    nextrace.Distance = Convert.ToDouble(distances);
                    nextrace.Time     = Convert.ToInt32(predictedTime);
                    nextrace.Active   = true;
                    db.NextRaces.Add(nextrace);
                }
            }
            db.SaveChanges();

            // get last race time and distance
            // calculate next time for next time
            // update next date time and distance
            // contruct view model to display new times.
            var allNextRaces     = db.NextRaces;
            List <nextRaceVM> vm = new List <nextRaceVM>();

            foreach (var m in allNextRaces)
            {
                var nr   = new nextRaceVM();
                var last = db.LastRaces.SingleOrDefault(l => l.RunnerId == m.RunnerId);
                nr.LastDistance = db.distances.SingleOrDefault(d => d.Value == last.Distance).Name;
                nr.LastTime     = RaceCalc.formatTime(last.Time);
                nr.RunnerName   = m.runner.firstname + " " + m.runner.secondname;
                nr.Time         = RaceCalc.formatTime(m.Time);
                vm.Add(nr);
            }
            var ds = Convert.ToDouble(distances);

            ViewBag.NewDistance = db.distances.SingleOrDefault(d => d.Value == ds).Name;
            return(View(vm));
        }