/// <summary> /// Saves a privacy setting as a new entry in the DB. /// </summary> /// <param name="privacySetting">Privacy setting object to add to the DB.</param> /// <returns>ID of the created privacy setting on success, 0 on failure.</returns> public static int CreateNewPrivacySetting(PrivacySetting privacySetting) { try { int id; using (SqlConnection connection = ConnectionManager.GetConnection()) { var data = new ActivEarthDataProvidersDataContext(connection); var privacySettingData = new PrivacySettingDataProvider { id = privacySetting.ID, email = privacySetting.Email, gender = privacySetting.Gender, age = privacySetting.Age, height = privacySetting.Height, weight = privacySetting.Weight, profile_visibility = (Byte)privacySetting.ProfileVisibility, user_id = privacySetting.UserID }; data.PrivacySettingDataProviders.InsertOnSubmit(privacySettingData); data.SubmitChanges(); id = privacySettingData.id; } return id; } catch (Exception) { return 0; } }
public User(string firstname, string lastname) { FirstName = firstname; LastName = lastname; _stats = new Dictionary<Statistic, UserStatistic>(); Wall = new Wall(); ActivityScore = new ActivityScore(); userPrivacySettings = new PrivacySetting(); }
/// <summary> /// Updates an existing PrivacySetting in the DB. /// </summary> /// <param name="privacySetting">PrivacySetting whose record needs updating.</param> /// <returns>True on success, false on failure.</returns> public static bool UpdatePrivacySetting(PrivacySetting privacySetting) { try { using (SqlConnection connection = ConnectionManager.GetConnection()) { var data = new ActivEarthDataProvidersDataContext(connection); PrivacySettingDataProvider dbPrivacySetting = (from p in data.PrivacySettingDataProviders where p.id == privacySetting.ID select p).FirstOrDefault(); if (dbPrivacySetting != null) { dbPrivacySetting.email = privacySetting.Email; dbPrivacySetting.gender = privacySetting.Gender; dbPrivacySetting.age = privacySetting.Age; dbPrivacySetting.height = privacySetting.Height; dbPrivacySetting.weight = privacySetting.Weight; dbPrivacySetting.profile_visibility = (Byte)privacySetting.ProfileVisibility; data.SubmitChanges(); } else { return false; } } return true; } catch (Exception) { return false; } }