public static void Merge(int checkpointId)
{
using (var context = new Entities())
{
var timestamps = context.Runtimes.Where(runtime => runtime.CheckpointID == checkpointId && !runtime.IsDeleted).OrderBy(runtime => runtime.Runtime1).ToList();
var startnumbers = context.CheckpointOrders.Where(startnumber => startnumber.CheckpointID == checkpointId && !startnumber.IsDeleted).OrderBy(startnumber => startnumber.OrderNumber).ToList();
var raceintermediates = context.RaceIntermediates.Where(intermediate => intermediate.CheckpointID == checkpointId).ToList();
//Removes exicting entries in the database
foreach (var intermediate in raceintermediates)
{
context.DeleteObject(intermediate);
}
context.SaveChanges();
//Creates new entries
int i = 0;
foreach (var timestamp in timestamps)
{
if (startnumbers.Count < i + 1)
break;
Merge(checkpointId, startnumbers[i].ID, timestamp.RuntimeID);
i++;
}
}
var checkpoint = CheckpointModel.getById(checkpointId);
RaceIntermediateModel.MergeAthletes(checkpoint.RaceId.Value);
}
/// <summary>
/// Deletes the raceintermediate.
/// </summary>
/// <param name="cpid">The cpid.</param>
/// <param name="cpOrderid">The cp orderid.</param>
public static void DeleteRaceintermediate(int cpid, int cpOrderid)
{
using (var context = new Entities())
{
var raceintermediateToDelete = context.RaceIntermediates.Where(raceintermediate => raceintermediate.CheckpointID == cpid && raceintermediate.CheckpointOrderID == cpOrderid).SingleOrDefault();
//raceintermediateToDelete.IsDeleted = true;
RuntimeModel.DeleteRuntime(raceintermediateToDelete.RuntimeId);
CheckpointOrderModel.DeleteCheckpointOrder(raceintermediateToDelete.CheckpointOrderID);
context.DeleteObject(raceintermediateToDelete);
context.SaveChanges();
}
}
public static bool Delete(this List<RaceIntermediate> intermediates)
{
try
{
using (var context = new Entities())
{
foreach (var intermediate in intermediates)
{
context.DeleteObject(intermediate);
}
context.SaveChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
private void DeleteUpdated(string name, int distance, DateTime date)
{
using (var ctxDel = new Entities())
{
if (ctxDel.Races.Any(race => (race.Name == name && race.Distance == distance && race.StartDate == date)))
{
var DelRace = ctxDel.Races.Where(race => (race.Name == name && race.Distance == distance && race.StartDate == date)).Single();
ctxDel.DeleteObject(DelRace);
ctxDel.SaveChanges();
}
}
}
private void CheckAndDeletelDuplicateRace(Race existingRace)
{
using (var ctxDel = new Entities())
{
if (ctxDel.Races.Any(race => (race.Name == existingRace.Name && race.Distance == existingRace.Distance && race.StartDate == existingRace.StartDate)))
{
var DelRace = ctxDel.Races.Where(race => (race.Name == existingRace.Name && race.Distance == existingRace.Distance && race.StartDate == existingRace.StartDate)).Single();
ctxDel.DeleteObject(DelRace);
ctxDel.SaveChanges();
}
}
}
public void Delete()
{
using (var context = new Entities())
{
var model = context.AthleteClasses.Where(athleteclass => athleteclass.ID == Id).Single();
context.DeleteObject(model);
context.SaveChanges();
}
}
public static void DeleteRaceintermediatesForRace(int raceid)
{
using (var context = new Entities())
{
var intermediatesToDelete = context.RaceIntermediates.Where(intermediate => intermediate.Checkpoint.RaceID == raceid).ToList();
foreach (var intermediate in intermediatesToDelete)
{
context.DeleteObject(intermediate);
}
var runtimesToDelete = context.Runtimes.Where(runtime => runtime.Checkpoint.RaceID == raceid).ToList();
foreach (var runtime in runtimesToDelete)
{
context.DeleteObject(runtime);
}
var checkpointordersToDelete = context.CheckpointOrders.Where(cpo => cpo.Checkpoint.RaceID == raceid).ToList();
foreach (var cpo in checkpointordersToDelete)
{
context.DeleteObject(cpo);
}
context.SaveChanges();
}
}
public void Delete()
{
using (var context = new Entities())
{
var intermediateToDelete = context.RaceIntermediates.
Single(intermediate => intermediate.CheckpointID == CheckpointID
&& intermediate.CheckpointOrderID == CheckpointOrderID
&& intermediate.RuntimeId == RuntimeId);
context.DeleteObject(intermediateToDelete);
context.SaveChanges();
}
}
