public static void DeleteSegmentsByRunnerRaceRecordId(long runnerRaceRecordId)
{
using (var db = new CCEntities())
{
db.ExecuteStoreCommand(@"
DELETE FROM RunnerRaceRecordSegment WHERE RunnerRaceRecordId = @runnerRaceRecordId",
new SqlParameter("runnerRaceRecordId", runnerRaceRecordId));
}
}
public static void DeleteWithId(long raceId)
{
using (var db = new CCEntities())
{
var runnerRaceRecordIds = db.RunnerRaceRecords.Where(rr => rr.RaceId == raceId)
.Select(rr => rr.RunnerRaceRecordId);
if (runnerRaceRecordIds.Count() > 0)
{
db.ExecuteStoreCommand(@"
DELETE FROM RunnerRaceRecordSegment
WHERE RunnerRaceRecordId IN(" + string.Join(",", runnerRaceRecordIds) + ");");
}
db.ExecuteStoreCommand(@"
DELETE FROM RunnerRaceRecord WHERE RaceId = @raceId;
DELETE FROM Race WHERE RaceId = @raceId;",
new SqlParameter("raceId", raceId));
}
}
public static void UnEnrollRunners(IEnumerable<long> unenrolledRunnerIds)
{
if (unenrolledRunnerIds.Count() > 0)
{
using (var db = new CCEntities())
{
var ids = string.Join(",", unenrolledRunnerIds);
db.ExecuteStoreCommand(@"
DELETE FROM RunnerRaceRecordSegment
WHERE RunnerRaceRecordId IN(" + ids + @");
DELETE FROM RunnerRaceRecord
WHERE RunnerRaceRecordId IN(" + ids + @");");
}
}
}
