private static void AddRemoveSubscription(int subTypeId, string username, bool add)
{
string settingKey = EMAIL_SUB_SETTING_KEY_PREFIX + subTypeId;
var data = LibCommon.DBModel();
// first remove any existing
var existingSubs = data.userSettings
.Where(x => x.active_flag && x.settingKey == settingKey && x.username == username);
foreach (var sub in existingSubs)
{
sub.active_flag = false;
sub.update_dt = DateTime.Now;
}
// if add, then add it
if (add)
{
db.userSetting sub = new db.userSetting();
sub.settingKey = settingKey;
sub.settingValue = string.Empty;
sub.username = username;
sub.insert_dt = DateTime.Now;
sub.update_dt = DateTime.Now;
sub.active_flag = true;
data.userSettings.InsertOnSubmit(sub);
}
data.SubmitChanges();
}
private static void AddUserSetting(string key, string value, bool distinct)
{
string username = Authentication.GetAuthenticatedUserName();
if (string.IsNullOrEmpty(username))
{
return;
}
var data = DBModel();
if (distinct)
{
foreach (var item in data.userSettings.Where(x => x.settingKey == key && x.active_flag == true && x.username == username))
{
item.active_flag = false;
}
}
db.userSetting newSetting = new db.userSetting();
newSetting.username = username;
newSetting.settingKey = key;
newSetting.settingValue = value;
newSetting.insert_dt = DateTime.Now;
newSetting.update_dt = DateTime.Now;
newSetting.active_flag = true;
data.userSettings.InsertOnSubmit(newSetting);
data.SubmitChanges();
}
public void AddExpandedTopicToUserSetting(string id, string username)
{
var data = Common.DBModel();
db.userSetting newSetting = new db.userSetting();
newSetting.username = username;
newSetting.settingKey = "expandedTopic";
newSetting.settingValue = id;
newSetting.insert_dt = DateTime.Now;
newSetting.update_dt = DateTime.Now;
newSetting.active_flag = true;
data.userSettings.InsertOnSubmit(newSetting);
data.SubmitChanges();
}
public static void ChangeAppMode(bool modeOn, string modeText = "testmode")
{
var data = DBModel();
if (modeOn)
{
db.userSetting setting = new db.userSetting();
setting.active_flag = true;
setting.settingKey = modeText;
setting.settingValue = modeText;
setting.update_dt = DateTime.Now;
setting.insert_dt = DateTime.Now;
setting.username = "******";
data.userSettings.InsertOnSubmit(setting);
data.SubmitChanges();
}
else
{
data.userSettings.DeleteAllOnSubmit(data.userSettings.Where(x => x.settingKey == modeText));
data.SubmitChanges();
}
}
