public IActionResult GetSportsOfaTeam(Guid id) { IEnumerable <Sport> team = teamService.SportsOfATeam(id); if (team == null) { return(NotFound()); } return(Ok(SportModel.ToModel(team))); }
public WidgetSport(SportModel widget) : base(widget) { InitializeComponent(); //var info = JsonConvert.DeserializeObject<SportWidgetInfo>(widget.Infos.First()); //TitleTb.Text = info.Competition; //Score1Tb.Text = info.Score1.ToString(); //Score2Tb.Text = info.Score2.ToString(); //Team1Tb.Text = info.Team1; //Team2Tb.Text = info.Team2; }
public IHttpActionResult Sport([FromUri] Guid Id) { var result = new BaseResult(); result.ResultCode = "1"; result.ResultMessage = "Error"; var sport = new SportRecordDAL().GetListByUserId(Id); SportModel model = new SportModel(); model.Count = sport.Count; model.LastTime = sport.Sum(a => a.SportLastTime.Value); result.ResultCode = "0"; result.ResultMessage = "Success"; result.ResultData = model; return(Ok(result)); }
public ActionResult Details(int id) { var dbmodel = DbContext.Sports.FirstOrDefault(x => x.SportId == id); if (dbmodel == null) { return(HttpNotFound()); } var model = new SportModel { Name = dbmodel.Name, Description = dbmodel.Description, Rules = dbmodel.Rules }; return(View("Details", model)); }
private void SyncEventInDb(Sport currentSport, SportModel updatedSportModel, SyncRequirement syncRequirement, IUnitOfWork uow) { var toAddModel = updatedSportModel.Events.Where(x => syncRequirement.Add.Contains(x.Id)); var toAdd = _mapper.Map <IEnumerable <Event> >(toAddModel); toAdd = toAdd.Select(x => { x.SportId = currentSport.Id; return(x); }); var toUpdateModels = updatedSportModel.Events.Where(x => syncRequirement.Update.Contains(x.Id)); var toUpdate = _mapper.Map <IEnumerable <Event> >(toUpdateModels); toUpdate = toUpdate.Select(x => { x.SportId = currentSport.Id; return(x); }); var toDelete = _mapper.Map <IEnumerable <Event> >(currentSport.Events.Where(x => syncRequirement.Delete.Contains(x.Id))); var eventRepository = uow.GetRepository <Event>(); eventRepository.Delete(toDelete); eventRepository.Add(toAdd); eventRepository.Update(toUpdate); if (toUpdateModels.Any()) { matchesUpdatedEvent?.Invoke(toUpdateModels.SelectMany(x => x.Matches)); } if (toAddModel.Any()) { matchesAddedEvent?.Invoke(toAddModel.SelectMany(x => x.Matches)); } if (syncRequirement.Delete.Any()) { matchesRemovedEvent?.Invoke(syncRequirement.Delete); } }
public List <TournamentModel> GetAllTournaments() { List <TournamentModel> output; using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.GetConnectionString("WISGScoringDB"))) { output = connection.Query <TournamentModel>("dbo.spTournaments_GetAll", commandType: CommandType.StoredProcedure).ToList(); foreach (TournamentModel t in output) { string sportName = ""; List <SportModel> allSports = GetSports(); SportModel sport = allSports.Where(x => x.Id == t.SportId).First(); sportName = sport.SportName; string gender = ""; if (t.Gender == Gender.Boys) { gender = "Boys"; } else if (t.Gender == Gender.Girls) { gender = "Girls"; } else { gender = ""; } if (gender == "") { t.TournamentName = sportName; } else { t.TournamentName = $"{gender} {sportName}"; } } // Populate teams foreach (TournamentModel tm in output) { var p = new DynamicParameters(); p.Add("@TournamentId", tm.Id); tm.EnteredTeams = connection.Query <TeamModel>("dbo.spTeams_GetByTournament", p, commandType: CommandType.StoredProcedure).ToList(); //populate rounds; p = new DynamicParameters(); p.Add("@TournamentId", tm.Id); List <MatchupModel> matchups = connection.Query <MatchupModel>("dbo.spMatchups_GetByTournament", p, commandType: CommandType.StoredProcedure).ToList(); foreach (MatchupModel m in matchups) { p = new DynamicParameters(); p.Add("@MatchupEntryId", m.Id); m.Entries = connection.Query <MatchupEntryModel>("dbo.spMatchupEntries_GetByMatchup", p, commandType: CommandType.StoredProcedure).ToList(); List <TeamModel> allTeams = GetTeams(); if (m.WinnerId > 0) { m.Winner = allTeams.Where(x => x.Id == m.WinnerId).First(); } foreach (var me in m.Entries) { if (me.TeamCompetingId > 0) { me.TeamCompeting = allTeams.Where(x => x.Id == me.TeamCompetingId).First(); } } } // List<List<MatchupModel>> List <MatchupModel> currentRow = new List <MatchupModel>(); int currentRound = 1; foreach (MatchupModel m in matchups) { if (m.MatchupRound > currentRound) { tm.Rounds.Add(currentRow); currentRow = new List <MatchupModel>(); currentRound += 1; } currentRow.Add(m); } tm.Rounds.Add(currentRow); } } return(output); }