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