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);
}
}
}
}
