public void Save(SQLiteConnection db) { RaceEvent re = db.Find <RaceEvent>(x => x.EventID == this.EventID); if (re == null) { db.Insert(this); } else { db.Update(this); } foreach (Racer r in this.Racers) { r.Save(db); } foreach (RaceHeat rh in this.Heats) { rh.Save(db); } foreach (RaceResult rr in this.Results) { rr.Save(db); } }
public void Load(Guid guidEventID, SQLiteConnection db) { RaceEvent re = db.Table <RaceEvent>().Where(x => x.EventID == guidEventID).First(); this.Completed = re.Completed; this.EventDate = re.EventDate; this.EventID = re.EventID; this.EventName = re.EventName; this.TrackCount = re.TrackCount; List <Racer> liRacer = db.Table <Racer>().Where(x => x.EventID == guidEventID).ToList(); this.Racers = new ObservableCollection <Racer>(liRacer); List <RaceHeat> liHeats = db.Table <RaceHeat>().Where(x => x.EventID == guidEventID).ToList(); this.Heats = new ObservableCollection <RaceHeat>(liHeats); foreach (RaceHeat rh in this.Heats) { List <HeatTime> liHeatTime = db.Table <HeatTime>().Where(x => x.HeatID == rh.HeatID).ToList(); rh.HeatTimes = new ObservableCollection <HeatTime>(liHeatTime); foreach (HeatTime currHT in rh.HeatTimes) { currHT.ParentEvent = this; currHT.RacerID = currHT.RacerID; } } List <RaceResult> liResults = db.Table <RaceResult>().Where(x => x.EventID == guidEventID).ToList(); this.Results = new ObservableCollection <RaceResult>(liResults); foreach (RaceResult currRR in this.Results) { currRR.ParentEvent = this; currRR.RacerID = currRR.RacerID; } }
public HeatTime(RaceEvent raceEvent) { this._parentEvent = raceEvent; }
public RaceResult(RaceEvent raceEvent) { this._parentEvent = raceEvent; }