/// <summary>
/// Saves a Team as a new entry in the DB.
/// </summary>
/// <param name="team">Team object to add to the DB.</param>
/// <returns>ID of the created team on success, 0 on failure.</returns>
public static int CreateNewTeam(ContestTeam team)
{
try
{
int id;
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
var teamData = new TeamDataProvider
{
name = team.Name,
score = team.Score,
contest_id = team.ContestId,
locked = team.IsLocked,
group_id = team.GroupId,
bracket = team.Bracket
};
data.TeamDataProviders.InsertOnSubmit(teamData);
data.SubmitChanges();
id = teamData.id;
}
TeamDAO.UpdateTeamMembers(team);
return id;
}
catch (Exception)
{
return 0;
}
}
/// <summary>
/// Saves a Team as a new entry in the DB.
/// </summary>
/// <param name="team">Team object to add to the DB.</param>
/// <returns>ID of the created team on success, 0 on failure.</returns>
public static int CreateNewTeam(Team team, int contestId)
{
try
{
int id;
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
var teamData = new TeamDataProvider
{
name = team.Name,
score = team.Score,
contest_id = contestId
};
data.TeamDataProviders.InsertOnSubmit(teamData);
data.SubmitChanges();
id = teamData.id;
}
UpdateTeamMembers(team);
return id;
}
catch (Exception)
{
return 0;
}
}
partial void DeleteTeamDataProvider(TeamDataProvider instance);
partial void UpdateTeamDataProvider(TeamDataProvider instance);
partial void InsertTeamDataProvider(TeamDataProvider instance);
private void detach_TeamDataProviders(TeamDataProvider entity)
{
this.SendPropertyChanging();
entity.ContestDataProvider = null;
}
private void attach_TeamDataProviders(TeamDataProvider entity)
{
this.SendPropertyChanging();
entity.GroupDataProvider = this;
}
