public IHttpActionResult InsertCompetitor(Competitor competitor)
{
PenOCDataContext db = new PenOCDataContext();
try
{
tblCompetitor competitorRecord = new tblCompetitor
{
strFirstName = competitor.firstName,
strSurname = competitor.surname,
intGender = competitor.genderId,
};
db.tblCompetitors.InsertOnSubmit(competitorRecord);
db.SubmitChanges();
competitor.id = competitorRecord.idCompetitor;
return Ok(competitor);
}
catch(Exception e)
{
return BadRequest(e.Message);
}
}
public IHttpActionResult InsertOEvent(OEvent oevent)
{
PenOCDataContext db = new PenOCDataContext();
tblEvent eventRecord = new tblEvent
{
strName = oevent.name,
strControllerReport = oevent.controllerReport,
intVenue = oevent.venueId,
strCourses = oevent.courses,
dteDate = oevent.date,
strDirections = oevent.directions,
intPlanner = oevent.plannerId,
intController = oevent.controllerId,
strRegTime = oevent.registrationTime,
strStarts = oevent.startTime,
strClose = oevent.close,
strSpecialNote = oevent.specialNote,
decCoordinateLat = oevent.coordinateLatitude,
decCoordinateLong = oevent.coordinateLongitude,
strCost = oevent.cost,
intMaxPoints = oevent.maxPoints,
strPlannerReport = oevent.plannerReport,
intOrganisingClub = oevent.organizingClubId
};
db.tblEvents.InsertOnSubmit(eventRecord);
db.SubmitChanges();
oevent.id = eventRecord.idEvent;
return Ok(oevent);
}
public IHttpActionResult DeleteClub(int clubId)
{
PenOCDataContext db = new PenOCDataContext();
IQueryable<lutClub> queryResults = db.lutClubs.Where(club => club.idClub == clubId);
db.lutClubs.DeleteAllOnSubmit(queryResults);
db.SubmitChanges();
return Ok();
}
public IHttpActionResult DeleteVenue(int venueId)
{
PenOCDataContext db = new PenOCDataContext();
IQueryable<tblVenue> queryResults = db.tblVenues.Where(venue => venue.idVenue == venueId);
db.tblVenues.DeleteAllOnSubmit(queryResults);
db.SubmitChanges();
return Ok();
}
public IHttpActionResult UpdateVenue(Venue venue)
{
PenOCDataContext db = new PenOCDataContext();
tblVenue venueRecord = db.tblVenues.Single(v => v.idVenue == venue.id);
venueRecord.strName = venue.name;
db.SubmitChanges();
return Ok(venue);
}
public IHttpActionResult DeleteCourseResults(int idCourse)
{
PenOCDataContext db = new PenOCDataContext();
IQueryable<tblResult> queryResults = db.tblResults.Where(r => r.intCourse == idCourse);
db.tblResults.DeleteAllOnSubmit(queryResults);
// Ask the DataContext to save all the changes.
db.SubmitChanges();
return Ok();
}
public IHttpActionResult UpdateClub(Club club)
{
PenOCDataContext db = new PenOCDataContext();
lutClub clubRecord = db.lutClubs.Single(c => c.idClub == club.id);
clubRecord.strFullName = club.fullName;
clubRecord.strShortName = club.shortName;
db.SubmitChanges();
return Ok(club);
}
public IHttpActionResult UpdateNewsItem(NewsItem newsItem)
{
PenOCDataContext db = new PenOCDataContext();
tblNews newsItemRecord = db.tblNews.Single(n => n.idNews == newsItem.id);
newsItemRecord.dteDate = newsItem.date;
newsItemRecord.strTitle = newsItem.title;
newsItemRecord.strNews = newsItem.news;
db.SubmitChanges();
return Ok(newsItem);
}
public IHttpActionResult DeleteCourse(int courseId)
{
PenOCDataContext db = new PenOCDataContext();
IQueryable<tblResult> queryResults = db.tblResults.Where(result => result.intCourse == courseId);
db.tblResults.DeleteAllOnSubmit(queryResults);
IQueryable<tblCourse> queryCourses = db.tblCourses.Where(course => course.idCourse == courseId);
db.tblCourses.DeleteAllOnSubmit(queryCourses);
db.SubmitChanges();
return Ok();
}
public IHttpActionResult InsertVenue(Venue venue)
{
PenOCDataContext db = new PenOCDataContext();
tblVenue venueRecord = new tblVenue
{
strName = venue.name,
};
db.tblVenues.InsertOnSubmit(venueRecord);
db.SubmitChanges();
venue.id = venueRecord.idVenue;
return Ok(venue);
}
public IHttpActionResult InsertClub(Club club)
{
PenOCDataContext db = new PenOCDataContext();
lutClub clubRecord = new lutClub
{
strFullName = club.fullName,
strShortName = club.shortName
};
db.lutClubs.InsertOnSubmit(clubRecord);
db.SubmitChanges();
club.id = clubRecord.idClub;
return Ok(club);
}
public IHttpActionResult InsertNewsItem(NewsItem newsItem)
{
PenOCDataContext db = new PenOCDataContext();
tblNews newsItemRecord = new tblNews
{
dteDate = newsItem.date,
strTitle = newsItem.title,
strNews = newsItem.news
};
db.tblNews.InsertOnSubmit(newsItemRecord);
db.SubmitChanges();
newsItem.id = newsItemRecord.idNews;
return Ok(newsItem);
}
public IHttpActionResult UpdateResult(Result result)
{
PenOCDataContext db = new PenOCDataContext();
tblResult resultRecord = db.tblResults.Single(r => r.intCourse == result.courseId && r.intCompetitor == result.competitorId);
resultRecord.intCategory = result.categoryId;
resultRecord.intClub = result.clubId;
resultRecord.intPoints = result.points;
resultRecord.intPosition = result.position;
resultRecord.strComment = result.comment;
resultRecord.strRaceNumber = result.raceNumber;
resultRecord.blnDisqualified = result.disqualified;
resultRecord.dteTime = result.time;
db.SubmitChanges();
return Ok(result);
}
public IHttpActionResult InsertCourse(Course course)
{
PenOCDataContext db = new PenOCDataContext();
tblCourse courseRecord = new tblCourse
{
strName = course.name,
intEvent = course.eventId,
intLength = course.length,
intClimb = course.climb,
intControls = course.controls,
intTechnical = course.difficultyId,
intListOrder = course.listOrder
};
db.tblCourses.InsertOnSubmit(courseRecord);
db.SubmitChanges();
course.id = courseRecord.idCourse;
return Ok(course);
}
public IHttpActionResult UpdateResult(int courseId, Result[] courseResults)
{
PenOCDataContext db = new PenOCDataContext();
IQueryable<tblResult> queryResults = db.tblResults.Where(r => r.intCourse == courseId);
db.tblResults.DeleteAllOnSubmit(queryResults);
foreach (Result courseResult in courseResults) {
tblResult resultRecord = new tblResult
{
intCourse = courseId,
intPosition = courseResult.position,
intCompetitor = courseResult.competitorId,
intClub = courseResult.clubId,
intCategory = courseResult.categoryId,
strRaceNumber = courseResult.raceNumber,
dteTime = courseResult.time,
intPoints = courseResult.points,
blnDisqualified = courseResult.disqualified,
strComment = courseResult.comment
};
db.tblResults.InsertOnSubmit(resultRecord);
db.SubmitChanges();
};
return Ok();
}
public IHttpActionResult UpdateCompetitor(Competitor competitor)
{
PenOCDataContext db = new PenOCDataContext();
tblCompetitor competitorRecord = db.tblCompetitors.Single(c => c.idCompetitor == competitor.id);
competitorRecord.strFirstName = competitor.firstName;
competitorRecord.strSurname = competitor.surname;
competitorRecord.intGender = competitor.genderId;
competitorRecord.intCategory = competitor.categoryId;
competitorRecord.intEmitNumber = competitor.emitNumber;
competitorRecord.strEmail = competitor.email;
competitorRecord.strTelephone1 = competitor.telephone1;
competitorRecord.strTelephone2 = competitor.telephone2;
db.SubmitChanges();
return Ok(competitor);
}
public IHttpActionResult UpdateCourse(Course course)
{
PenOCDataContext db = new PenOCDataContext();
tblCourse theCourse = db.tblCourses.Single(c => c.idCourse == course.id);
theCourse.intEvent = course.eventId;
theCourse.strName = course.name;
theCourse.intLength = course.length;
theCourse.intClimb = course.climb;
theCourse.intControls = course.controls;
theCourse.intTechnical = course.difficultyId;
theCourse.intListOrder = course.listOrder;
db.SubmitChanges();
return Ok(course);
}
public IHttpActionResult UpdateOEvent(OEvent oevent)
{
PenOCDataContext db = new PenOCDataContext();
tblEvent eventRecord = db.tblEvents.Single(e => e.idEvent == oevent.id);
eventRecord.strName = oevent.name;
eventRecord.intVenue = oevent.venueId;
eventRecord.strCourses = oevent.courses;
eventRecord.dteDate = oevent.date;
eventRecord.strDirections = oevent.directions;
eventRecord.intPlanner = oevent.plannerId;
eventRecord.intController = oevent.controllerId;
eventRecord.strRegTime = oevent.registrationTime;
eventRecord.strStarts = oevent.startTime;
eventRecord.strClose = oevent.close;
eventRecord.strSpecialNote = oevent.specialNote;
eventRecord.decCoordinateLat = oevent.coordinateLatitude;
eventRecord.decCoordinateLong = oevent.coordinateLongitude;
eventRecord.strCost = oevent.cost;
eventRecord.intMaxPoints = oevent.maxPoints;
eventRecord.strPlannerReport = oevent.plannerReport;
eventRecord.strControllerReport = oevent.controllerReport;
eventRecord.intOrganisingClub = oevent.organizingClubId;
db.SubmitChanges();
return Ok(oevent);
}