public static int CreateNewContest(Contest contest)
{
try
{
int id;
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
var contestData = new ContestDataProvider
{
name = contest.Name,
description = contest.Description,
reward = contest.Reward,
end_mode = (byte)contest.Mode,
end_goal = contest.EndValue,
end_time = contest.EndTime,
start = contest.StartTime,
type = (byte)contest.Type,
statistic = (byte)contest.StatisticBinding,
searchable = contest.IsSearchable,
active = contest.IsActive,
deactivated = contest.DeactivatedTime,
creator_id = contest.CreatorId
};
data.ContestDataProviders.InsertOnSubmit(contestData);
data.SubmitChanges();
id = contestData.id;
}
foreach (ContestTeam team in contest.Teams)
{
TeamDAO.CreateNewTeam(team);
}
return id;
}
catch (Exception)
{
return 0;
}
}