public int AddEvent(EventInformation _eventInfo) { int curId = -1; using (CX418DataAccess.cx418timingEntities context = new CX418DataAccess.cx418timingEntities()) { Event eventObj = new CX418DataAccess.Event(); eventObj.EventName = _eventInfo.EventName; eventObj.MultiDay = _eventInfo.MultiDayEvent; eventObj.MultiRace = _eventInfo.MultiRaceEvent; eventObj.Description = _eventInfo.Description; eventObj.StartDay = _eventInfo.EventStartingDate; eventObj.EndDay = _eventInfo.EventEndingDate; context.Events.Add(eventObj); int rowChange = context.SaveChanges(); curId = eventObj.ID; } return(curId); }
public List <RaceInformation> GetRaces(string eventId) { List <RaceInformation> retValue = new List <RaceInformation>(); int intEventId; if (int.TryParse(eventId, out intEventId)) { using (CX418DataAccess.cx418timingEntities context = new CX418DataAccess.cx418timingEntities()) { var races = (from t in context.Races where t.EventId == intEventId select t); foreach (var raceEntity in races) { RaceInformation newRaceInfo = new RaceInformation(raceEntity); retValue.Add(newRaceInfo); } } } return(retValue); }
public List <LapInformation> GetRaceLapTimes(string _raceId) { List <LapInformation> retValue = new List <LapInformation>(); int intRaceId; if (int.TryParse(_raceId, out intRaceId)) { using (CX418DataAccess.cx418timingEntities context = new CX418DataAccess.cx418timingEntities()) { var laps = (from t in context.LapTimes where t.RaceId == intRaceId select t); foreach (var lapEntity in laps) { LapInformation newLapInfo = new LapInformation(lapEntity); retValue.Add(newLapInfo); } } } return(retValue); }
public int AddLapTime(LapInformation _lapInfo) { int curLapTimeSeconds = 0; using (CX418DataAccess.cx418timingEntities context = new CX418DataAccess.cx418timingEntities()) { //context.LapTimes.Add(new CX418DataAccess.LapTime { bib = _bib.ToString(), LapTime1 = DateTime.Now, RaceId = _raceId }); //context.LapTimes.Add(new CX418DataAccess.LapTime { bib = _lapInfo.BibId.ToString(), LapTime1 = _lapInfo.LapTime, RaceId = _lapInfo.RaceId }); curLapTimeSeconds = context.sp_InsertLapTime(_lapInfo.BibId, _lapInfo.RaceId, _lapInfo.LapEndTime); //rowChange = context.SaveChanges(); } return(curLapTimeSeconds); // rowChange == 1 ? true : false; }
public List <EventInformation> GetEvents() { List <EventInformation> retValue = new List <EventInformation>(); using (CX418DataAccess.cx418timingEntities context = new CX418DataAccess.cx418timingEntities()) { var events = (from t in context.Events select t); foreach (var eventEntity in events) { EventInformation newEventInfo = new EventInformation(eventEntity); retValue.Add(newEventInfo); } } return(retValue); }
public EventInformation GetEvent(string _id) { int intEventId; EventInformation retValue = null; if (int.TryParse(_id, out intEventId)) { using (CX418DataAccess.cx418timingEntities context = new CX418DataAccess.cx418timingEntities()) { var curEvent = (from t in context.Events where t.ID == intEventId select t).FirstOrDefault(); if (curEvent != null) { retValue = new EventInformation(curEvent); } } } return(retValue); }
public RaceInformation GetRace(string _id) { int intRaceId; RaceInformation retValue = null; if (int.TryParse(_id, out intRaceId)) { using (CX418DataAccess.cx418timingEntities context = new CX418DataAccess.cx418timingEntities()) { var race = (from t in context.Races where t.ID == intRaceId select t).FirstOrDefault(); if (race != null) { retValue = new RaceInformation(race); } } } return(retValue); }
public LapInformation GetLastLapTime(string _racerBid, string _raceId) { int intRaceId; LapInformation retValue = null; if (int.TryParse(_raceId, out intRaceId)) { using (CX418DataAccess.cx418timingEntities context = new CX418DataAccess.cx418timingEntities()) { var lapInfo = (from t in context.LapTimes where t.RaceId == intRaceId && t.bib == _racerBid select t).FirstOrDefault(); if (lapInfo != null) { retValue = new LapInformation(lapInfo); } } } return(retValue); }
public int AddRace(RaceInformation _raceInfo) { int rowChange = -1; int curIdRace = -1; using (CX418DataAccess.cx418timingEntities context = new CX418DataAccess.cx418timingEntities()) { CX418DataAccess.Race raceObj = new CX418DataAccess.Race(); raceObj.RaceName = _raceInfo.RaceName; raceObj.RaceStartingTime = _raceInfo.RaceStartingTime; raceObj.RaceStartedTime = _raceInfo.RaceStartingTime; raceObj.Description = _raceInfo.Description; raceObj.RaceLenght = _raceInfo.RaceLenght; raceObj.EventId = _raceInfo.EventId; context.Races.Add(raceObj); rowChange = context.SaveChanges(); curIdRace = raceObj.ID; } return(curIdRace); }