public static int CreateNewBadge(Badge badge)
{
try
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
var badgeData = new BadgeDataProvider
{
user_id = badge.UserID,
badge_level = (byte)badge.Level,
progress = (byte)badge.Progress,
statistic = (byte)badge.StatisticBinding
};
data.BadgeDataProviders.InsertOnSubmit(badgeData);
data.SubmitChanges();
return badgeData.id;
}
}
catch (Exception)
{
return 0;
}
}