public static TournamentTeamParticipant ToTeamModel(this JoinTournamentRequest viewmodel) { TournamentTeamParticipant model = new TournamentTeamParticipant(); model.UserID = UserHelper.CurrentUserID; model.TournamentTeamID = viewmodel.TeamID ?? default(int); model.Registered = DateTime.Now; return(model); }
private void MigrateTournamentParticipant(DataContext db, MySqlConnection conn, DataSet set, MySqlDataAdapter adapter) { adapter.SelectCommand = new MySqlCommand("select * from tournaments_participants", conn); adapter.Fill(set, "tournaments_participants"); try { foreach (DataRow entry in set.Tables["tournaments_participants"].Rows) { if (Convert.ToInt32(entry["user_id"]) == 0 || new int[] { 12, 14, 20 }.Contains(Convert.ToInt32(entry["tournament_id"]))) { continue; } int tournamentTeamID = -1; int offsetID = 0; try { offsetID = TupleToId(db, Convert.ToInt32(entry["user_id"])); } catch (Exception ex) { Console.WriteLine("Skipping Participant : {0}", Convert.ToInt32(entry["user_id"])); continue; } if (Convert.ToInt32(entry["tournament_id"]) == 0) { continue; } int tid = Convert.ToInt32(entry["tournament_id"]) - 7; if (Convert.ToInt32(entry["tournament_id"]) > 20) { tid -= 4; } else if (Convert.ToInt32(entry["tournament_id"]) > 16) { tid -= 3; } else if (Convert.ToInt32(entry["tournament_id"]) > 11) { tid -= 1; } if (Convert.ToInt32(entry["team_id"]) != 0) { MySqlDataAdapter internalAdaper = new MySqlDataAdapter(); DataSet internalSet = new DataSet(); internalAdaper.SelectCommand = new MySqlCommand($"Select ID from tournaments_teams where ID={Convert.ToInt32(entry["team_id"])}", conn); internalAdaper.Fill(internalSet, "tournaments_teams"); var ID = Convert.ToInt32(internalSet.Tables["tournaments_teams"].Rows[0]["ID"]); tournamentTeamID = TournamentOldToNew[ID]; } TournamentParticipant part1 = null; TournamentTeamParticipant part2 = null; var tournament = db.Tournament.Find(tid); if (tournament.TeamSize > 1) { var participant = new TournamentTeamParticipant() { Registered = GetFromMySqlDate(new MySqlDateTime(entry["registered"].ToString())).Value, TournamentTeam = db.TournamentTeam.Find(tournamentTeamID), UserID = offsetID, }; part2 = participant; if (participant.TournamentTeam == null) { continue; } db.TournamentTeamParticipant.Add(participant); } else { var participant = new TournamentParticipant() { Registered = GetFromMySqlDate(new MySqlDateTime(entry["registered"].ToString())).Value, Tournament = db.Tournament.Find(tid), UserID = offsetID, }; part1 = participant; if (participant.Tournament == null) { continue; } db.TournamentParticipant.Add(participant); } try { db.SaveChanges(); } catch (Exception ex) { } } } catch (Exception ex) { } }
public static BackendUserViewModelItem FromModel(this BackendUserViewModelItem viewmodel, TournamentTeamParticipant model) { viewmodel.ID = model.ID; viewmodel.FirstName = model.User.FirstName; viewmodel.LastName = model.User.LastName; viewmodel.Nickname = model.User.Nickname; viewmodel.Image = "http://lan-netconnect.de/_api/images/team/no_image.png"; // TODO viewmodel.Email = model.User.Email; viewmodel.SteamID = model.User.SteamID; viewmodel.BattleTag = model.User.BattleTag; viewmodel.Newsletter = model.User.Newsletter; viewmodel.IsAdmin = model.User.IsAdmin; viewmodel.IsTeam = model.User.IsTeam; return(viewmodel); }
public static TournamentParticipantViewModelItem FromModel(this TournamentParticipantViewModelItem viewmodel, TournamentTeamParticipant model) { viewmodel.ID = model.ID; viewmodel.UserID = model.UserID; viewmodel.FirstName = model.User.FirstName; viewmodel.LastName = model.User.LastName; viewmodel.Nickname = model.User.Nickname; return(viewmodel); }