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;
}
}