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