/// <summary> /// Saves a badge as a new entry in the DB. /// </summary> /// <param name="badge">Badge object to add to the DB.</param> /// <returns>ID of the created badge on success, 0 on failure.</returns> 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; } }
private void detach_BadgeDataProviders(BadgeDataProvider entity) { this.SendPropertyChanging(); entity.UserDataProvider = null; }
partial void DeleteBadgeDataProvider(BadgeDataProvider instance);
partial void UpdateBadgeDataProvider(BadgeDataProvider instance);
partial void InsertBadgeDataProvider(BadgeDataProvider instance);