private RunningModel.runner AddRunner(string fname, string sname) { RunningModel.runner thisRunner = new RunningModel.runner(); thisRunner.firstname = fname; thisRunner.secondname = sname; thisRunner.Active = true; db.runners.Add(thisRunner); db.SaveChanges(); return(thisRunner); }
private void AddRace(double distance, int racetime, RunningModel.runner thisRunner) { RunningModel.LastRace newRace = new RunningModel.LastRace(); newRace.Date = DateTime.Now; newRace.Time = racetime; newRace.Distance = distance; newRace.RunnerId = thisRunner.EFKey; db.LastRaces.Add(newRace); db.SaveChanges(); }
private void AddRunnerToDb(ExcelWorksheet workSheet, int row, IEnumerable <RunningModel.runner> Allrunners) { var fname = GetFirstName(workSheet, row); var sname = GetSecondName(workSheet, row); var distance = GetDistance(workSheet, row); var racetime = GetTime(workSheet, row); var result = from x in Allrunners where x.firstname.Contains(fname) && x.secondname.Contains(sname) select x; if (result.Count() == 0) { RunningModel.runner thisRunner = AddRunner(fname, sname); if (distance > 0) { AddRace(distance, racetime, thisRunner); } } else { var ourRunner = result.First(); var lastRace = db.runners.Find(ourRunner.EFKey).LastRaces.OrderBy(r => r.Date).FirstOrDefault(); if (lastRace != null) { if (distance > 0) { EditLastRace(distance, racetime, lastRace); } } else { if (distance > 0) { AddRace(distance, racetime, ourRunner); } } } }