public void CreateTeam(Team team)
{
using (var context = new Models.BaseballLeagueEntities())
{
Models.Team newTeam = new Models.Team();
newTeam.Manager = team.Manager;
newTeam.TeamName = team.TeamName;
newTeam.LeagueID = team.LeagueID;
context.Teams.Add(newTeam);
context.SaveChanges();
}
}
private Team Parse(TeamVm item)
{
Team details = new Models.Team
{
FacebookUrl = item.FacebookUrl,
GooglePlusUrl = item.GooglePlusUrl,
img = item.img,
Name = item.Name,
TwitterUrl = item.TwitterUrl,
TeamId = item.TeamId
};
return(details);
}
private static DTO.Board ConvertBoard(Models.Board board, Models.Team teamA, Models.Team teamB)
{
return(new DTO.Board
{
Cards = board.Cards.Select(card => new DTO.Card
{
Agent = card.Agent,
Word = card.Word,
HasBeenRevealed = card.HasBeenRevealed
}).ToList(),
KnowAllForTeamA = ConvertPlayer(teamA.Coder), // TODO: move to teamDTO
KnowAllForTeamB = ConvertPlayer(teamB.Coder) // TODO: move to teamDTO
});
}
public async Task <CreatedAtActionResult> AddTeamAsync(CreateTeamDto dto)
{
Models.Team team = new Models.Team
{
IsPaid = dto.IsPaid,
GroupId = dto.GroupId,
Name = dto.Name
};
var createdTeam = await _teamService.CreateAsync(team);
return(CreatedAtAction(nameof(AddTeamAsync), new
{
id = createdTeam.Id
}, dto));
}
private async Task <EmbedBuilder> GetFirstPokemon()
{
Models.Team t = (await DatabaseHelper.GetClosedConnection().GetXMLFromDatabaseAsync("Team", "Trainers", Context.User.Id)).Deserialize <Models.Team>();
Models.Pokemon p = t.First();
PokeAPI.Pokemon pApi = await DataFetcher.GetApiObject <PokeAPI.Pokemon>(p.ID);
EmbedBuilder builder = new EmbedBuilder()
{
Title = $"{(Context.User as IGuildUser).Nickname ?? Context.User.Username}'s {p.Nickname ?? pApi.Name.Capatalize()}",
Color = Color.Teal,
Description = p.ToString(pApi.Name),
ThumbnailUrl = $"https://img.pokemondb.net/sprites/black-white/anim/normal/{pApi.Name}.gif"
};
return(builder);
}
//TODO:
public async Task <BL.Models.Team> CreateTeam(BL.Models.Team team)
{
var newTeam = new Models.Team()
{
Name = team.Name,
CaptainId = team.CaptainId,
ImageId = team.ImageId,
//CreationTime = DateTime.Now
};
await Context.Team.AddAsync(newTeam);
newTeam.Identifier = '#' + newTeam.Id.ToString().PadLeft(4, '0');
await Context.SaveChangesAsync();
return(Mapper.Map <BL.Models.Team>(newTeam));
}
private async Task <string> CreateStarterPokemonXMLAsync(string starterName)
{
PRPGDiscordBot.Models.Team team = new Models.Team();
PokeAPI.Pokemon p = await DataFetcher.GetNamedApiObject <PokeAPI.Pokemon>(starterName.ToLower());
Models.Pokemon pokemon = new Models.Pokemon()
{
ID = p.ID, Level = 5, PokeBallType = Models.PokeBallType.PokeBall, Form = 0, Happiness = 70, Nickname = "", Shiny = false, Status = Models.Status.None
};
pokemon.Stats = Models.Pokemon.GenerateStarterStats(p);
pokemon.Moves = Models.Pokemon.GenerateStarterMoves(p);
pokemon.Ability.Name = p.Abilities[0].Ability.Name;
team.Add(pokemon);
return(team.Serialize());
}
public async Task <String> UpdateTeam(string groupId, string accessToken)
{
string endpoint = ServiceHelper.GraphRootUri + "groups/" + groupId + "/team";
Team team = new Models.Team();
team.guestSettings = new Models.TeamGuestSettings()
{
allowCreateUpdateChannels = true, allowDeleteChannels = false
};
HttpResponseMessage response = await ServiceHelper.SendRequest(new HttpMethod("PATCH"), endpoint, accessToken, team);
if (!response.IsSuccessStatusCode)
{
throw new Exception(response.ReasonPhrase);
}
return(response.ReasonPhrase);
}
public async Task <String> AddTeamToGroup(string groupId, string accessToken)
{
string endpoint = $"{GraphRootUri}/groups/{groupId}/team";
Team team = new Models.Team();
team.guestSettings = new Models.TeamGuestSettings()
{
allowCreateUpdateChannels = false, allowDeleteChannels = false
};
HttpResponseMessage response = await ServiceHelper.SendRequest(HttpMethod.Put, endpoint, accessToken, team);
if (!response.IsSuccessStatusCode)
{
throw new Exception(response.ReasonPhrase);
}
return(response.ReasonPhrase);
}
public ActionResult Team()
{
Team team = new Models.Team();
League league = new League();
foreach (var m in db.Users.ToList())
{
foreach (var t in league.Teams)
{
if (m.Email == t.Email)
{
return(View(t));
}
}
}
// TODO: This should go to ~/Views/Teams/Create.cshtml
return(View(team));
}
public async Task <IHttpActionResult> GetTeamsInClub(string clubReference)
{
bool converts = int.TryParse(clubReference, out int clubId);
if (converts == false)
{
return(BadRequest());
}
DatabaseAccess.ExternalModel.Club databaseClub = await _clubRepository.GetClubAsync(clubId);
if (databaseClub == null)
{
return(NotFound());
}
ReadOnlyCollection <TeamsInClubResult> databaseTeams = await _teamRepository.GetTeamsInClubAsync(clubId);
Club club = new Club();
club.ClubId = databaseClub.ClubId;
club.ShortName = databaseClub.ShortName;
club.Link = Url.Content("~/") + "club/" + club.ClubId;
List <Models.Team> newTeams = new List <Models.Team>();
foreach (TeamsInClubResult team in databaseTeams)
{
Models.Team newTeam = new Models.Team();
newTeam.TeamId = team.TeamId;
newTeam.ShortName = team.TeamName;
newTeam.NclTeam = team.NclTeam;
newTeam.LongName = team.LongName;
newTeam.Link = Url.Content("~/") + "team/" + newTeam.TeamId;
newTeams.Add(newTeam);
}
club.Teams = newTeams;
return(Ok(club));
}
public void FillTeam(Guid?teamId)
{
if (teamId.HasValue)
{
Team = new Models.Team(Service.GetTeam(teamId.Value));
}
else
{
//TODO: build in option to choose which league the team belongs to
ILeagueService league = new LeagueService();
Guid leagueId;
var genericLeague = league.GetGenericLeague();
if (genericLeague != null)
{
leagueId = genericLeague.LeagueId;
}
Team = new Models.Team(leagueId);
}
}
/* <summary>
* This method check if record already have in table.
* </summary>
*
* @method checkAlready
* @returns {int
* }
*/
private int checkAlready(Models.Team newGame)
{
int rowCount = 0;
try
{
using (DefaultConnectionGM db = new DefaultConnectionGM())
{
//write query
var recordAlready = (from record in db.Teams
where record.Name == newGame.Name
select record).First();
if (recordAlready != null)
{
rowCount = 1;
}
}
}
catch (Exception e)
{ }
return(rowCount);
}
public IActionResult AddTeam([FromBody] TeamVO teamVO)
{
try
{
if (teamVO == null)
{
return(BadRequest());
}
List <Member> listaMembros = new List <Member>();
foreach (MemberVO memberVO in teamVO.Members)
{
Models.Member members = new Models.Member
{
FirstName = memberVO.FirstName,
LastName = memberVO.LastName
};
listaMembros.Add(members);
}
Models.Team newTeam = new Models.Team
{
Members = listaMembros,
Name = teamVO.Name
};
_teamRepository.AddTeam(newTeam);
return(Ok(newTeam));
}
catch (Exception e)
{
return(BadRequest());
throw e;
}
}
public ActionResult <Models.Team> UpdateTeam(int tournamentId, int teamId, Models.Team team)
{
return(this._service.UpdateTeam(tournamentId, teamId, team));
}
public void OnGet(int?teamId)
{
Team = meProvider.GetManagedTeam(teamId);
Event = repo.GetEventList(Team?.Id);
}
public void OnGet(int?teamId)
{
Team = repo.GetManagedTeam(teamId);
Post = repo.GetPostList(Team?.Id, 1000);
}
public void OnGet(int?teamId)
{
Team = meProvider.GetManagedTeam(teamId);
}
public void UpdateMetrics(Models.Team Team1, Models.Team Team2, int Score1, int Score2)
{
using (var dbContext = new Foostats2.Models.FoostatsContext()){
Team1 = dbContext.Teams.Include(x => x.Player1).Include(x => x.Player2).SingleOrDefault(x => x.Id == Team1.Id);
Team2 = dbContext.Teams.Include(x => x.Player1).Include(x => x.Player2).SingleOrDefault(x => x.Id == Team2.Id); // reload
var gameInfo = GameInfo.DefaultGameInfo;
var t1p1Trueskill = dbContext.Trueskill.
Include(x => x.Player).
FirstOrDefault(x => x.Player.Id == Team1.Player1.Id);
var t1p2Trueskill = Team1.Player2 == null ? null :
dbContext.Trueskill.
Include(x => x.Player).
FirstOrDefault(x => x.Player.Id == Team1.Player2.Id);
var t2p1Trueskill = dbContext.Trueskill.
Include(x => x.Player).
FirstOrDefault(x => x.Player.Id == Team2.Player1.Id);
var t2p2Trueskill = Team2.Player2 == null ? null :
dbContext.Trueskill.
Include(x => x.Player).
FirstOrDefault(x => x.Player.Id == Team2.Player2.Id);
Rating t1p1, t1p2, t2p1, t2p2;
t1p1 = t1p1Trueskill != null ? new Rating(t1p1Trueskill.Mean, t1p1Trueskill.StandardDeviation) : gameInfo.DefaultRating;
t1p2 = t1p2Trueskill != null ? new Rating(t1p2Trueskill.Mean, t1p2Trueskill.StandardDeviation) : gameInfo.DefaultRating;
t2p1 = t2p1Trueskill != null ? new Rating(t2p1Trueskill.Mean, t2p1Trueskill.StandardDeviation) : gameInfo.DefaultRating;
t2p2 = t2p2Trueskill != null ? new Rating(t2p2Trueskill.Mean, t2p2Trueskill.StandardDeviation) : gameInfo.DefaultRating;
var team1player1 = new Player(Team1.Player1.Id);
var team1player2 = Team1.Player2 == null ? null : new Player(Team1.Player2.Id);
var team2player1 = new Player(Team2.Player1.Id);
var team2player2 = Team2.Player2 == null ? null : new Player(Team2.Player2.Id);
var team1 = new Team();
team1.AddPlayer(team1player1, t1p1);
if (team1player2 != null)
{
team1.AddPlayer(team1player2, t1p2);
}
var team2 = new Team();
team2.AddPlayer(team2player1, t2p1);
if (team2player2 != null)
{
team2.AddPlayer(team2player2, t2p2);
}
var teams = Teams.Concat(team1, team2);
var team1Place = Score1 >= Score2 ? 1 : 2;
var team2Place = Score2 >= Score1 ? 1 : 2;
var newRatings = TrueSkillCalculator.CalculateNewRatings(gameInfo, teams, team1Place, team2Place);
var team1player1NewRating = newRatings[team1player1];
Rating team1player2NewRating = team1player2 == null ? null : newRatings[team1player2];
var team2player1NewRating = newRatings[team2player1];
Rating team2player2NewRating = team2player2 == null ? null : newRatings[team2player2];
if (t1p1Trueskill != null)
{
t1p1Trueskill.Mean = team1player1NewRating.Mean;
t1p1Trueskill.StandardDeviation = team1player1NewRating.StandardDeviation;
t1p1Trueskill.ConservativeRating = team1player1NewRating.ConservativeRating;
}
else
{
dbContext.Trueskill.Add(new Models.Trueskill()
{
Player = Team1.Player1,
Mean = team1player1NewRating.Mean,
StandardDeviation = team1player1NewRating.StandardDeviation,
ConservativeRating = team1player1NewRating.ConservativeRating
});
}
if (team1player2 != null)
{
if (t1p2Trueskill != null)
{
t1p2Trueskill.Mean = team1player2NewRating.Mean;
t1p2Trueskill.StandardDeviation = team1player2NewRating.StandardDeviation;
t1p2Trueskill.ConservativeRating = team1player2NewRating.ConservativeRating;
}
else
{
dbContext.Trueskill.Add(new Models.Trueskill()
{
Player = Team1.Player2,
Mean = team1player2NewRating.Mean,
StandardDeviation = team1player2NewRating.StandardDeviation,
ConservativeRating = team1player2NewRating.ConservativeRating
});
}
}
if (t2p1Trueskill != null)
{
t2p1Trueskill.Mean = team2player1NewRating.Mean;
t2p1Trueskill.StandardDeviation = team2player1NewRating.StandardDeviation;
t2p1Trueskill.ConservativeRating = team2player1NewRating.ConservativeRating;
}
else
{
dbContext.Trueskill.Add(new Models.Trueskill()
{
Player = Team2.Player1,
Mean = team2player1NewRating.Mean,
StandardDeviation = team2player1NewRating.StandardDeviation,
ConservativeRating = team2player1NewRating.ConservativeRating
});
}
if (team2player2 != null)
{
if (t2p2Trueskill != null)
{
t2p2Trueskill.Mean = team2player2NewRating.Mean;
t2p2Trueskill.StandardDeviation = team2player2NewRating.StandardDeviation;
t2p2Trueskill.ConservativeRating = team2player2NewRating.ConservativeRating;
}
else
{
dbContext.Trueskill.Add(new Models.Trueskill()
{
Player = Team2.Player2,
Mean = team2player2NewRating.Mean,
StandardDeviation = team2player2NewRating.StandardDeviation,
ConservativeRating = team2player2NewRating.ConservativeRating
});
}
}
dbContext.SaveChanges();
}
}
public ContactsTeamRegisterPage(IRequestService requestService, Models.Team team)
{
InitializeComponent();
BindingContext = new ViewModels.ContactsTeamRegisterViewModel(Navigation, requestService, team);
}
public void UpdateMetrics(Models.Team Team1, Models.Team Team2, int Score1, int Score2)
{
using (var dbContext = new Foostats2.Models.FoostatsContext())
{
Team1 = dbContext.Teams.Include(x => x.Player1).Include(x => x.Player2).SingleOrDefault(x => x.Id == Team1.Id);
Team2 = dbContext.Teams.Include(x => x.Player1).Include(x => x.Player2).SingleOrDefault(x => x.Id == Team2.Id); // reload
var t1p1WinLoss = dbContext.WinLoss.Include(x => x.Player).FirstOrDefault(x => x.Player.Id == Team1.Player1.Id);
var t1p2WinLoss = Team1.Player2 == null ? null : dbContext.WinLoss.Include(x => x.Player).FirstOrDefault(x => x.Player.Id == Team1.Player2.Id);
var t2p1WinLoss = dbContext.WinLoss.Include(x => x.Player).FirstOrDefault(x => x.Player.Id == Team2.Player1.Id);
var t2p2WinLoss = Team2.Player2 == null ? null : dbContext.WinLoss.Include(x => x.Player).FirstOrDefault(x => x.Player.Id == Team2.Player2.Id);
var t1WinsToAdd = Score1 >= Score2 ? 1 : 0;
var t1LossToAdd = t1WinsToAdd == 1 ? 0 : 1;
var t2WinsToAdd = Score2 >= Score1 ? 1 : 0;
var t2LossToAdd = t2WinsToAdd == 1 ? 0 : 1;
#region Update Team 1
if (t1p1WinLoss != null)
{
t1p1WinLoss.Win += t1WinsToAdd;
t1p1WinLoss.Loss += t1LossToAdd;
}
else
{
dbContext.WinLoss.Add(new Models.WinLoss()
{
Player = Team1.Player1,
Win = t1WinsToAdd,
Loss = t1LossToAdd
});
}
if (Team1.Player2 != null)
{
if (t1p2WinLoss != null)
{
t1p2WinLoss.Win += t1WinsToAdd;
t1p2WinLoss.Loss += t1LossToAdd;
}
else
{
dbContext.WinLoss.Add(new Models.WinLoss()
{
Player = Team1.Player2,
Win = t1WinsToAdd,
Loss = t1LossToAdd
});
}
}
#endregion
#region Update Team 2
if (t2p1WinLoss != null)
{
t2p1WinLoss.Win += t2WinsToAdd;
t2p1WinLoss.Loss += t2LossToAdd;
}
else
{
dbContext.WinLoss.Add(new Models.WinLoss()
{
Player = Team2.Player1,
Win = t2WinsToAdd,
Loss = t2LossToAdd
});
}
if (Team2.Player2 != null)
{
if (t2p2WinLoss != null)
{
t2p2WinLoss.Win += t2WinsToAdd;
t2p2WinLoss.Loss += t2LossToAdd;
}
else
{
dbContext.WinLoss.Add(new Models.WinLoss()
{
Player = Team2.Player2,
Win = t2WinsToAdd,
Loss = t2LossToAdd
});
}
}
#endregion
dbContext.SaveChanges();
}
}
public Task <Models.Team> PostTeam(Models.Team team)
{
return(Task.FromResult(team));
}
public Models.Team UpdateTeam(Models.Team team)
{
return(_acc.UpdateTeam(team));
}
public Models.Team DeleteTeam(Models.Team team)
{
return(_acc.DeleteTeam(team));
}
public static DAL.Entities.Team Map(Models.Team team) => new DAL.Entities.Team(team.Id, team.Name, team.Player1Id, team.Player2Id);
public void OnGet(int?teamId)
{
Team = meProvider.GetManagedTeam(teamId);
Membership = repo.GetMembershipList(Team?.Id);
}
/**
* <summary>
* This event handler update or add record to DB
* </summary>
*
* @method btnsubmit_Click
* @param {object} sender
* @param {EventArgs} e
* @returns {void}
*/
protected void btnsubmit_Click(object sender, EventArgs e)
{
int rowCount;
// Use EF to connect to the server
using (DefaultConnectionGM db = new DefaultConnectionGM())
{
// use the Teams model to create a new team object and
// save a new record
Models.Team newTeam = new Models.Team();
int TID = 0;
if (Request.QueryString.Count > 0)
{
TID = Convert.ToInt32(Request.QueryString["TeamID"]);
//write query
newTeam = (from teamRecord in db.Teams
where teamRecord.TID == TID
select teamRecord).FirstOrDefault();
Session["TeamMsg"] = "Your Record Updated Succeessfully.";
}
//add data to DB
newTeam.Name = txtTeamName.Text.ToString().Trim();
newTeam.Description = txtshortdesc.Text.ToString().Trim();
newTeam.Gid = Convert.ToInt32(ddlGameName.SelectedValue);
//check operation insert or update
if (TID == 0)
{
//check record is already in DB
rowCount = checkAlready(newTeam);
if (rowCount == 0)
{
db.Teams.Add(newTeam);
Session["TeamMsg"] = "Your Record Added Succeessfully.";
//save our change
db.SaveChanges();
// Redirect back to the updated games page
Response.Redirect("~/AdminPanel/Team.aspx");
}
else
{
lblMsg.Text = "Record has been already added.";
alertMsg.Visible = true;
}
}
else
{
//save our change
db.SaveChanges();
// Redirect back to the updated games page
Response.Redirect("~/AdminPanel/Team.aspx");
}
}
}
