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