public void Save(SQLiteConnection db) { HeatTime re = db.Find <HeatTime>(x => x.HeatTimeID == this.HeatTimeID); if (re == null) { db.Insert(this); } else { db.Update(this); } }
public void CreateHeats(SQLiteConnection db) { // each race must run on each lane once. // x lanes are available to race on simultaneously // heatcount = racers * x / x = racers int HeatCount = this.Racers.Count; int iTracks = this.TrackCount; //generate shuffled list of racers Random rng = new Random(); List <Racer> shuffledRacers = this.Racers.Shuffle(rng).ToList(); // create the heats + heat times for (int i = 0; i < HeatCount; i++) { RaceHeat h = new RaceHeat(); h.EventID = this.EventID; h.HeatID = Guid.NewGuid(); h.HeatNumber = (i + 1); this.Heats.Add(h); for (int j = 0; j < iTracks; j++) { HeatTime ht = new HeatTime(this); ht.HeatTimeID = Guid.NewGuid(); ht.HeatID = h.HeatID; ht.TrackNumber = j + 1; ht.RaceTime = null; ht.RacerID = null; h.HeatTimes.Add(ht); } } for (int i = 0; i < iTracks; i++) { using (IEnumerator <Racer> ienumShuffled = shuffledRacers.GetEnumerator()) { foreach (RaceHeat heat in this.Heats) { if (!ienumShuffled.MoveNext()) { break; } HeatTime ht = heat.HeatTimes.First(x => x.TrackNumber == (i + 1)); ht.RacerID = ienumShuffled.Current.RacerID; } } Racer[] rgShuffledRacers = shuffledRacers.ToArray(); int RotateBy = HeatCount / iTracks; // if less tracks than racers, we'll run into an issue where we won't rotate if (RotateBy == 0) { RotateBy = 1; } rgShuffledRacers.RotateLeft(RotateBy); shuffledRacers = new List <Racer>(rgShuffledRacers); } #if DEBUG StringBuilder sb = new StringBuilder(); foreach (RaceHeat rh in this.Heats) { sb.AppendFormat("Heat {0}: ", rh.HeatNumber.ToString().PadLeft(2)); foreach (HeatTime ht in rh.HeatTimes) { sb.AppendFormat("({0}): {1} {2}. ", ht.TrackNumber, ht.Racer.FirstName, ht.Racer.LastName.Substring(0, 1)); } sb.AppendLine(); } //System.Diagnostics.Debug.Print(sb.ToString()); #endif }