/// <summary>
/// Saves a contest as a new entry in the DB.
/// </summary>
/// <param name="contest">Contest object to add to the DB.</param>
/// <returns>ID of the created contest on success, 0 on failure.</returns>
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,
points = contest.Points,
end_mode = (byte)contest.Mode,
end_goal = contest.EndCondition.EndValue,
end_time = contest.EndCondition.EndTime,
start = contest.StartTime,
type = (byte)contest.Type,
statistic = (byte)contest.StatisticBinding,
};
data.ContestDataProviders.InsertOnSubmit(contestData);
data.SubmitChanges();
id = contestData.id;
}
foreach (Team team in contest.Teams)
{
//TeamDAO.CreateNewTeam(team, contest.ID);
}
return id;
}
catch (Exception)
{
return 0;
}
}
private void detach_ContestDataProviders(ContestDataProvider entity)
{
this.SendPropertyChanging();
entity.UserDataProvider = null;
}
partial void DeleteContestDataProvider(ContestDataProvider instance);
partial void UpdateContestDataProvider(ContestDataProvider instance);
partial void InsertContestDataProvider(ContestDataProvider instance);
/// <summary>
/// Saves a contest as a new entry in the DB.
/// </summary>
/// <param name="contest">Contest object to add to the DB.</param>
/// <returns>ID of the created contest on success, 0 on failure.</returns>
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;
}
}