Пример #1
0
        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);
            }
        }
Пример #2
0
        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);
        }
Пример #3
0
        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();
        }
Пример #4
0
        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();
        }
Пример #5
0
        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);
        }
Пример #6
0
        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();
        }
Пример #7
0
        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);
        }
Пример #8
0
        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);
        }
Пример #9
0
        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();
        }
Пример #10
0
        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);
        }
Пример #11
0
        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);
        }
Пример #12
0
        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);
        }
Пример #13
0
        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);
        }
Пример #14
0
        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);
        }
Пример #15
0
        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();
        }
Пример #16
0
        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);
        }
Пример #17
0
        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);
        }
Пример #18
0
        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);
        }