public IList<Club> GetClubAutoComplete(string searchText) { var clubs = new List<Club>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); if(searchText.Equals("**")) { clubs = _core.Clubs .Where(c => c.DateActivated.HasValue && !c.DateCancelled.HasValue) .OrderBy(c => c.FullName) .ToList(); } else { clubs = _core.Clubs .Where(c => c.DateActivated.HasValue && !c.DateCancelled.HasValue && (c.FullName.ToLower().Contains(searchText) || c.Acronym.ToLower().Contains(searchText))) .OrderBy(c => c.FullName) .ToList(); } } return clubs; }
public void SaveMessage(Message message) { using (EntityConnection connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); _core.Messages.AddObject(message); _core.SaveChanges(); } }
public Location SaveNewLocation(Location location) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); _core.Locations.AddObject(location); _core.SaveChanges(); } return location; }
public Event SaveNewEvent(Event comp) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); _core.Events.AddObject(comp); _core.SaveChanges(); } return comp; }
public Series SaveNewSeries(Series series) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); _core.Series.AddObject(series); _core.SaveChanges(); } return series; }
public IList<Region> GetRegions() { var regions = new List<Region>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); regions = _core.Regions.ToList(); } return regions; }
public IList<Location> GetLocationsByClubId(int clubId) { var locations = new List<Location>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); locations = _core.Locations.Where(l => l.ClubId == clubId).ToList(); } return locations; }
public void DeleteResult(Result result) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); string query = string.Format("delete from Result where ResultId = {0}", result.ResultId); _core.ExecuteStoreCommand(query); _core.SaveChanges(); } }
public IList<Country> GetCountries() { var countries = new List<Country>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); countries = _core.Countries.ToList(); } return countries; }
public IList<State> GetStates() { var states = new List<State>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); states = _core.States.ToList(); } return states; }
public IList<Driver> GetApprovedDrivers(int clubId) { var drivers = new List<Driver>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); drivers = _core.Drivers.Where(d => d.HomeClubId == clubId && d.DateActivated.HasValue && !d.DateCancelled.HasValue).ToList(); } return drivers; }
public Class GetClassById(int classId) { var compClass = new Class(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); compClass = _core.Classes.Where(c => c.ClassId == classId).Single(); } return compClass; }
public IList<Class> GetAllClasses() { var classes = new List<Class>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); classes = _core.Classes.OrderBy(c => c.DisplayOrder).ToList(); } return classes; }
public Event UpdateEvent(Event comp) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); _core.Events.Attach(_core.Events.Single(s => s.EventId == comp.EventId)); _core.Events.ApplyCurrentValues(comp); _core.SaveChanges(); } return comp; }
public Location UpdateLocation(Location location) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); _core.Locations.Attach(_core.Locations.Single(l => l.LocationId == location.LocationId)); _core.Locations.ApplyCurrentValues(location); _core.SaveChanges(); } return location; }
public IList<Club> GetAppliedClubs() { var clubs = new List<Club>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); clubs = _core.Clubs .Include("RegisteringDriver") .Where(c => !c.DateActivated.HasValue && !c.DateCancelled.HasValue) .ToList(); } return clubs; }
public IList<Club> GetActiveClubs() { var clubs = new List<Club>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); clubs = _core.Clubs .Include("CurrentPresident") .Where(c => c.DateActivated.HasValue && !c.DateCancelled.HasValue) .ToList(); } return clubs; }
public Series DeleteAllSeriesClasses(Series series) { foreach (var seriesClass in series.SeriesClasses) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); string query = string.Format("delete from SeriesClass where SeriesClassId = {0}", seriesClass.SeriesClassId); _core.ExecuteStoreCommand(query); } } return series; }
public void DeleteScores(EntityCollection<Score> scores) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); foreach (var score in scores) { string query = string.Format("delete from Score where ScoreId = {0}", score.ScoreId); _core.ExecuteStoreCommand(query); } _core.SaveChanges(); } }
public Location GetLocationById(int locationId) { var location = new Location(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); location = _core.Locations .Include("Club") .Where(l => l.LocationId == locationId) .FirstOrDefault(); } return location; }
public void UpdateScores(IList<Score> scores) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); foreach (var score in scores) { _core.Scores.Attach(_core.Scores.Single(s => s.ScoreId == score.ScoreId)); _core.Scores.ApplyCurrentValues(score); _core.SaveChanges(); } } }
public IList<Series> GetAllAvailableSeries(int clubId) { var allAvailableSeries = new List<Series>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); allAvailableSeries = _core.Series .Include("Events.Location") .Include("Events.Results.Scores") .Include("SeriesClasses.Class") .Where(s => s.ClubId == clubId && !s.DateCancelled.HasValue).ToList(); } return allAvailableSeries; }
public Series GetSeriesById(int seriesId) { var series = new Series(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); series = _core.Series .Include("Club") .Include("SeriesClasses") .Where(s => s.SeriesId == seriesId) .FirstOrDefault(); } return series; }
public IList<Event> GetEventsBySeriesId(int seriesId) { var events = new List<Event>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); events = _core.Events .Include("Results.Scores") .Include("Results.Driver") .Include("Series.SeriesClasses.Class") .Where(e => e.SeriesId == seriesId) .ToList(); } return events; }
public Event GetEventById(int eventId) { var comp = new Event(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); comp = _core.Events .Include("Results.Scores") .Include("Results.Driver") .Include("Series.SeriesClasses.Class") .Where(e => e.EventId == eventId) .FirstOrDefault(); } return comp; }
public Result GetIndividualResult(int eventId, int driverId, int classId) { var result = new Result(); using(var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); result = _core.Results .Include("Class") .Include("Driver") .Include("Scores") .Include("Event") .Where(r => r.EventId == eventId && r.ClassId == classId && r.DriverId == driverId) .FirstOrDefault(); } return result; }
public Result GetResultById(int resultId) { var result = new Result(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); result = _core.Results .Include("Class") .Include("Driver") .Include("Scores") .Include("Event") .Where(r => r.ResultId == resultId) .FirstOrDefault(); } return result; }
public IList<Result> GetResultsByEventAndClass(int eventId, int classId) { IList<Result> results = new List<Result>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); results = _core.Results .Include("Class") .Include("Driver") .Include("Scores") .Include("Event") .Where(r => r.EventId == eventId && r.ClassId == classId) .ToList(); } return results.OrderBy(r => r.TotalScore).ToList(); }
public IList<Driver> GetDriverAutoComplete(string searchText, int maxResults, int clubId, bool clubOnly) { var drivers = new List<Driver>(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); if(clubOnly) { drivers = _core.Drivers .Where(d => d.HomeClubId == clubId && d.DateActivated.HasValue && !d.DateCancelled.HasValue && (d.FirstName.ToLower().Contains(searchText) || d.LastName.ToLower().Contains(searchText) || d.RccScreenName.ToLower().Contains(searchText) || (d.FirstName + " " + d.LastName).ToLower().Contains(searchText))) .OrderBy(d => d.FirstName) .ToList(); } else { drivers = _core.Drivers .Where(d => !d.DateCancelled.HasValue && (d.FirstName.ToLower().Contains(searchText) || d.LastName.ToLower().Contains(searchText) || d.RccScreenName.ToLower().Contains(searchText) || (d.FirstName + " " + d.LastName).ToLower().Contains(searchText))) .OrderBy(d => d.FirstName) .ToList(); } } return drivers; }
public Driver GetDriverByEmailAddress(string emailAddress) { var driver = new Driver(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); driver = _core.Drivers .Include("HomeClub") .Where(d => d.EmailAddress == emailAddress) .FirstOrDefault(); } return driver; }