Esempio n. 1
0
        public void SaveSettings()
        {
            using (var context = new Settings(ConnectionString))
            {
                if (!context.DatabaseExists())
                {
                    // create database if it does not exist
                    context.CreateDatabase();
                }
                var    query = context.SettingsTable.Where(setting => setting.Id == 0);
                string s     = null;
                s = UserPreference.PreferredAssociations.Aggregate(s, (current, preferredAssociation) => current + (preferredAssociation.In + ';'));
                var formatted = s != null?s.Substring(0, s.Length - 1) : "";

                SettingsTable settingUpdate = null;
                if (query.Any())
                {
                    settingUpdate = query.First();
                }
                if (!query.Any())
                {
                    var sett = new SettingsTable {
                        Associations = formatted, Filtering = Convert.ToString(UserPreference.IsFiltering), Id = 0, CacheDate = _cacheTime.ToString(new CultureInfo("nl-BE")), AccessKey = UserPreference.AccessKey, FbUserId = UserPreference.FbUserId, Name = UserPreference.Name
                    };
                    context.SettingsTable.InsertOnSubmit(sett);
                }
                else
                {
                    if (settingUpdate != null)
                    {
                        settingUpdate.Filtering    = Convert.ToString(UserPreference.IsFiltering);
                        settingUpdate.Associations = formatted;
                        settingUpdate.CacheDate    = _cacheTime.ToString(new CultureInfo("nl-BE"));
                        settingUpdate.AccessKey    = UserPreference.AccessKey;
                        settingUpdate.FbUserId     = UserPreference.FbUserId;
                        settingUpdate.Name         = UserPreference.Name;
                    }
                }
                context.SubmitChanges();
            }
        }
Esempio n. 2
0
        public void SaveSettings()
        {
            using (var context = new Settings(ConnectionString))
            {

                if (!context.DatabaseExists())
                {
                    // create database if it does not exist
                    context.CreateDatabase();
                }
                var query = context.SettingsTable.Where(setting => setting.Id == 0);
                string s = null;
                s = UserPreference.PreferredAssociations.Aggregate(s, (current, preferredAssociation) => current + (preferredAssociation.In + ';'));
                var formatted = s != null ? s.Substring(0, s.Length - 1) : "";
                SettingsTable settingUpdate = null;
                if (query.Any())
                {
                    settingUpdate = query.First();
                }
                if (!query.Any())
                {
                    var sett = new SettingsTable { Associations = formatted, Filtering = Convert.ToString(UserPreference.IsFiltering), Id = 0, CacheDate = _cacheTime.ToString(new CultureInfo("nl-BE")), AccessKey = UserPreference.AccessKey, FbUserId = UserPreference.FbUserId, Name = UserPreference.Name };
                    context.SettingsTable.InsertOnSubmit(sett);

                }
                else
                {

                    if (settingUpdate != null)
                    {
                        settingUpdate.Filtering = Convert.ToString(UserPreference.IsFiltering);
                        settingUpdate.Associations = formatted;
                        settingUpdate.CacheDate = _cacheTime.ToString(new CultureInfo("nl-BE"));
                        settingUpdate.AccessKey = UserPreference.AccessKey;
                        settingUpdate.FbUserId = UserPreference.FbUserId;
                        settingUpdate.Name = UserPreference.Name;
                    }
                }
                context.SubmitChanges();
            }
        }