public int SetSetting(int userId, string key, string value)
{
using (var db = new LogistoDb())
{
int id = db.UserSettings.Where(w => w.UserId == userId && w.Key == key).Select(s => s.ID).FirstOrDefault();
if (id > 0)
{
var setting = db.UserSettings.First(w => w.ID == id);
setting.Value = value;
db.Update(setting);
return(id);
}
else
{
var setting = new UserSetting {
UserId = userId, Key = key, Value = value
};
return(Convert.ToInt32(db.InsertWithIdentity(setting)));
}
}
}