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;
}
}