/// <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;
}
}
private void detach_privacy_settings(PrivacySettingDataProvider entity)
{
this.SendPropertyChanging();
entity.UserDataProvider = null;
}
partial void DeletePrivacySettingDataProvider(PrivacySettingDataProvider instance);
partial void InsertPrivacySettingDataProvider(PrivacySettingDataProvider instance);