WeekDTO GetPastMatchesByWeekId(long weekId, DateTime date)
{
match[] _matches = null;
List <MatchDTO> matches = new List <MatchDTO>();
week _week = null;
using (var context = new escorcenterdbEntities())
{
_week = (from w in context.weeks where w.enabled == true && w.id == weekId select w).FirstOrDefault <week>();
_matches = (from m in context.matches where m.enabled == true && m.week == _week.id && m.date < date select m).OrderByDescending(m => m.date).ToArray <match>();
}
matches = ParseMatches(_matches);
if (matches == null || _week == null)
{
return(null);
}
WeekDTO week = new WeekDTO()
{
DateFrom = _week.dateFrom.ToString(),
DateTo = _week.dateTo.ToString(),
Description = _week.description,
Id = _week.id,
Season = _week.season,
Title = _week.title
};
week.matches.AddRange(matches);
return(week);
}
List <MatchDTO> ParseMatches(match[] _matches)
{
List <MatchDTO> matches = new List <MatchDTO>();
using (var context = new escorcenterdbEntities())
{
foreach (match _match in _matches)
{
team team1 = (from t in context.teams where t.Id == _match.team1 select t).FirstOrDefault <team>();
team team2 = (from t in context.teams where t.Id == _match.team2 select t).FirstOrDefault <team>();
field field = (from f in context.fields where f.Id == _match.field select f).FirstOrDefault <field>();
MatchDTO match = new MatchDTO
{
Team1 = AutoMapper.Mapper.Map <team, TeamDTO>(team1),
ScoreTeam1 = _match.scoreTeam1,
Team2 = AutoMapper.Mapper.Map <team, TeamDTO>(team2),
ScoreTeam2 = _match.scoreTeam2,
Date = _match.date.ToString(),
Details = _match.details,
Field = AutoMapper.Mapper.Map <field, FieldDTO>(field),
Finished = _match.finished,
Forfeit = _match.forfeit,
Id = _match.Id,
ScoreExtraTimeTeam1 = 0,
ScoreExtraTimeTeam2 = 0
};
matches.Add(match);
}
}
return(matches);
}
public int getLeagueIdByTeamId(long id)
{
int leagueId = 0;
using (var context = new escorcenterdbEntities())
{
leagueId = (from t in context.teams where t.Id == id select t.League).FirstOrDefault <int>();
}
return(leagueId);
}
public String getLeagueNameById(long id)
{
league l;
using (var context = new escorcenterdbEntities())
{
l = (from t in context.leagues where t.Id == id select t).FirstOrDefault();
}
return(l.Name);
}
public static int getWeekId(long id)
{
int weekId = 0;
using (var context = new escorcenterdbEntities())
{
weekId = (from w in context.weeks where w.id == id select w.id).FirstOrDefault <int>();
}
return(weekId);
}
public IHttpActionResult GetWeekId(long id)
{
int weekId = getWeekId(id);
week _week;
using (var context = new escorcenterdbEntities())
{
_week = (from w in context.weeks where w.id == weekId select w).FirstOrDefault <week>();
}
return(Ok(_week));
}
public IHttpActionResult GetLeagueByTeamId(long id)
{
int leagueId = getLeagueIdByTeamId(id);
league league;
using (var context = new escorcenterdbEntities())
{
league = (from l in context.leagues where l.Id == leagueId select l).FirstOrDefault <league>();
}
return(Ok(league));
}
public IHttpActionResult DeleteField(long id)
{
field f;
using (var context = new escorcenterdbEntities())
{
f = (from r in context.fields where r.Id == id select r).FirstOrDefault();
context.SaveChanges();
}
return(Ok(f));
}
public IHttpActionResult DeleteWeek(long id)
{
week w;
using (var context = new escorcenterdbEntities())
{
w = (from r in context.weeks where r.id == id select r).FirstOrDefault();
context.SaveChanges();
}
return(Ok(w));
}
public IHttpActionResult DeleteMatch(long id)
{
match _match;
using (var context = new escorcenterdbEntities())
{
_match = (from m in context.matches where m.Id == id select m).FirstOrDefault();
context.matches.Remove(_match);
context.SaveChanges();
}
return(Ok(_match));
}
public IHttpActionResult DeleteNotification(long id)
{
notification _notification;
using (var context = new escorcenterdbEntities())
{
_notification = (from n in context.notifications where n.Id == id select n).FirstOrDefault();
context.notifications.Remove(_notification);
context.SaveChanges();
}
return(Ok(_notification));
}
public IHttpActionResult DeleteTeams(long id)
{
team _team;
using (var context = new escorcenterdbEntities())
{
_team = (from t in context.teams where t.Id == id select t).FirstOrDefault();
context.teams.Remove(_team);
context.SaveChanges();
}
return(Ok(_team));
}
public IHttpActionResult DeleteLeague(long id)
{
league l;
using (var context = new escorcenterdbEntities())
{
l = (from r in context.leagues where r.Id == id select r).FirstOrDefault();
context.leagues.Remove(l);
context.SaveChanges();
}
return(Ok(l));
}
public IHttpActionResult UpdateField([FromBody] FieldDTO _field)
{
field fieldMap = AutoMapper.Mapper.Map <FieldDTO, field>(_field);
field f;
using (var context = new escorcenterdbEntities())
{
f = (from r in context.fields where r.Id == fieldMap.Id select r).FirstOrDefault();
f = fieldMap;
context.SaveChanges();
}
return(Ok(f));
}
public IHttpActionResult UpdateNotification([FromBody] NotificationDTO notificationDTO)
{
notification notificationMap = AutoMapper.Mapper.Map <NotificationDTO, notification>(notificationDTO);
notification _notification;
using (var context = new escorcenterdbEntities())
{
_notification = (from n in context.notifications where n.Id == notificationMap.Id select n).FirstOrDefault();
_notification = notificationMap;
context.SaveChanges();
}
return(Ok(_notification));
}
public IHttpActionResult UpdateWeeks([FromBody] WeekDTO _week)
{
week weekMap = AutoMapper.Mapper.Map <WeekDTO, week>(_week);
week w;
using (var context = new escorcenterdbEntities())
{
w = (from r in context.weeks where r.id == weekMap.id select r).FirstOrDefault();
w = weekMap;
context.SaveChanges();
}
return(Ok(w));
}
public IHttpActionResult CreateField([FromBody] FieldDTO field)
{
field f = new field {
address = field.Address, description = field.Description, enabled = true, latitude = (float)field.latitude, longitude = (float)field.longitude, name = field.Name, sport = (int)field.sport
};
using (var context = new escorcenterdbEntities())
{
context.fields.Add(f);
context.SaveChanges();
}
return(Ok(f));
}
public IHttpActionResult CreateWeek(WeekDTO _week)
{
week w = new week {
dateFrom = DateTime.Now, dateTo = new DateTime(2016, 02, 29), enabled = true, description = _week.Description, season = (int)_week.Season, title = _week.Title
};
using (var context = new escorcenterdbEntities())
{
context.weeks.Add(w);
context.SaveChanges();
}
return(Ok(w));
}
public IHttpActionResult insertarequipos()
{
team t = null;
using (var context = new escorcenterdbEntities())
{
t = new team {
Name = "", League = 2, Enabled = true, Description = "Omar es Joto", Logo = "http://pintarimagenes.org/wp-content/uploads/2014/04/toro5.jpg"
};
context.teams.Add(t);
}
return(Ok(t));
}
public IHttpActionResult UpdateTeams([FromBody] TeamDTO teamDTO)
{
team teamMap = AutoMapper.Mapper.Map <TeamDTO, team>(teamDTO);
team _team;
using (var context = new escorcenterdbEntities())
{
_team = (from t in context.teams where t.Id == teamMap.Id select t).FirstOrDefault();
_team = teamMap;
context.SaveChanges();
}
return(Ok(_team));
}
public IHttpActionResult UpdateMatch([FromBody] MatchDTO matchDTO)
{
match matchMap = AutoMapper.Mapper.Map <MatchDTO, match>(matchDTO);
match _match;
using (var context = new escorcenterdbEntities())
{
_match = (from m in context.matches where m.Id == matchMap.Id select m).FirstOrDefault();
_match = matchMap;
context.SaveChanges();
}
return(Ok(_match));
}
public IHttpActionResult UpdateLeague([FromBody] LeagueDTO leagueDto)
{
league leagueMap = AutoMapper.Mapper.Map <LeagueDTO, league>(leagueDto);
league l;
using (var context = new escorcenterdbEntities())
{
l = (from r in context.leagues where r.Id == leagueMap.Id select r).FirstOrDefault();
l = leagueMap;
context.SaveChanges();
}
return(Ok(l));
}
public ActionResult League(int regionId)
{
region region = null;
using (var context = new escorcenterdbEntities())
{
region = context.regions.Find(regionId);
}
if (region != null)
{
ViewBag.regionName = region.Name;
}
return(View());
}
public IHttpActionResult CreateMatch(MatchDTO _match)
{
int weekId = WeeksApiController.getWeekId(_match.Id);
match m = new match {
date = DateTime.Parse(_match.Date), details = _match.Details, enabled = true, field = (int)_match.Field.Id, scoreTeam1 = (sbyte)_match.ScoreTeam1, scoreTeam2 = (sbyte)_match.ScoreTeam2, team1 = (int)_match.Team1.Id, team2 = (int)_match.Team2.Id, week = weekId
};
using (var context = new escorcenterdbEntities())
{
context.matches.Add(m);
context.SaveChanges();
}
return(Ok(m));
}
public IHttpActionResult CreateSeason([FromBody] SeasonDTO _season)
{
season s = new season()
{
description = _season.Description, league = (int)_season.League, dateFrom = DateTime.Now, dateTo = new DateTime(2016, 04, 29), title = _season.Title
};
using (var context = new escorcenterdbEntities())
{
context.seasons.Add(s);
context.SaveChanges();
}
return(Ok(s));
}
public IHttpActionResult GetSeasons()
{
season[] _season = null;
using (var context = new escorcenterdbEntities())
{
_season = (from s in context.seasons select s).ToArray <season>();
}
if (_season == null)
{
return(Ok());
}
SeasonDTO[] seasons = AutoMapper.Mapper.Map <season[], SeasonDTO[]>(_season);
return(Ok(seasons));
}
public IHttpActionResult CreateLeague([FromBody] LeagueDTO _league)
{
league l = new league()
{
Name = _league.Name, Description = _league.Description, Enabled = true, Region = _league.Region
};
using (var context = new escorcenterdbEntities())
{
context.leagues.Add(l);
context.SaveChanges();
}
return(Ok(l));
}
public long GetCurrentSeasonId(long leagueId, DateTime date)
{
season _season = null;
using (var context = new escorcenterdbEntities())
{
_season = (from s in context.seasons where s.league == leagueId && s.dateFrom <= date && s.dateTo >= date && s.enabled == true select s).FirstOrDefault <season>();
}
if (_season == null)
{
return(0);
}
return(_season.id);
}
public IHttpActionResult GetNotifications(string AllValues)
{
string[] values = AllValues.Split('/');
HashSet <int> leagueId = new HashSet <int>();
HashSet <int> teamId = new HashSet <int>();
bool teamAppeared = false;
foreach (string value in values)
{
if (value.Equals("teams"))
{
teamAppeared = true;
}
else if (teamAppeared)
{
teamId.Add(int.Parse(value));
}
else
{
leagueId.Add(int.Parse(value));
}
}
List <notification> _notifications;
using (var context = new escorcenterdbEntities())
{
_notifications = ((from n in context.notifications.AsEnumerable()
where IncludeNotification(n, teamId, leagueId)
select n).OrderBy(n => n.Date).ToList <notification>());
}
if (_notifications == null)
{
return(Ok());
}
_notifications = _notifications.OrderBy(n => n.Id).ToList().ToList <notification>();
NotificationDTO[] notifications = AutoMapper.Mapper.Map <notification[], NotificationDTO[]>(_notifications.ToArray());
NotificationListDTO notificationList = new NotificationListDTO();
notificationList.items.AddRange(notifications);
if (notificationList.items.Count == 0)
{
return(Ok());
}
return(Ok(notificationList));
}
public IHttpActionResult CreateTeam([FromBody] TeamDTO _team)
{
LeaguesApiController leaguesApiController = new LeaguesApiController();
int leagueId = leaguesApiController.getLeagueIdByTeamId(_team.Id);
team t = new team {
Name = _team.Name, Description = _team.Description, League = leagueId, Enabled = true, Logo = _team.Logo
};
using (var context = new escorcenterdbEntities())
{
context.teams.Add(t);
context.SaveChanges();
}
return(Ok(t));
}
