public static void Load()
 {
     LastTab = Convert.ToInt16(GetSetting("LastTab", "0"));
     DatagridLastSelectedRow = Convert.ToInt16(GetSetting("DatagridLastSelectedRow", "1"));
     IsRandom         = Convert.ToBoolean(GetSetting("IsRandom", "False"));
     Volume           = Convert.ToInt32(GetSetting("Volume", "0"));
     LastAlbum        = Convert.ToString(GetSetting("LastAlbum", "Alle"));
     LastCatalog      = Convert.ToString(GetSetting("LastCatalog", "Alle"));
     LastGenre        = Convert.ToString(GetSetting("LastGenre", "Alle"));
     LastArtist       = Convert.ToString(GetSetting("LastArtist", "Alle"));
     FormTop          = Convert.ToInt16(GetSetting("FormTop", "100"));
     FormLeft         = Convert.ToInt16(GetSetting("FormLeft", "100"));
     FormWidth        = Convert.ToInt16(GetSetting("FormWidth", "836"));
     FormHeight       = Convert.ToInt16(GetSetting("FormHeight", "580"));
     FormSplitterLeft = Convert.ToInt16(GetSetting("FormSplitterLeft", "200"));
     FormState        = Convert.ToString(GetSetting("FormState", "Normal"));
     RootImagePath    = Convert.ToString(GetSetting("RootImagePath", "C:\\"));
     QueryList        = DataGetSet.GetQueryList();
 }
        public static void Save()
        {
            var context = new MyJukeboxEntities();

            foreach (KeyValuePair <string, object> item in Settings)
            {
                var update = context.tSettings.SingleOrDefault(n => n.Name == item.Key);
                update.Value = item.Value.ToString();
            }

            context.SaveChanges();

            var result = DataGetSet.TruncateTableQueries();

            foreach (string query in QueryList)
            {
                context.tQueries.Add(new tQuery {
                    Query = query
                });
            }

            context.SaveChanges();
        }