private void btnSave_Click(object sender, EventArgs e) { // gather all user selected keys and look up in dictionary to get the int value // add int to list to make a user list saved as a string // put string and name of string into preset object and save to db try { List <int> usersSelectedKeys = new List <int>(); foreach (CheckBox cb in pnCheckBoxes.Controls.OfType <CheckBox>()) { if (cb.Checked == true) { string cbParse = cb.Name; cbParse = cbParse.Remove(0, 2); int cbNumber = Convert.ToInt16(cbParse); usersSelectedKeys.Add(cbNumber); } } string myPresetList = ""; string name = cbPreset.Text; foreach (int keyNum in usersSelectedKeys) { myPresetList += keyNum.ToString() + " "; } if (string.IsNullOrEmpty(name) || (string.IsNullOrEmpty(myPresetList))) { throw new ApplicationException(); // to ensure that blank presets are not saved } Preset newPreset = new Preset(name, myPresetList); PresetDBHelper.ConnectToDatabase(); PresetDBHelper.InsertPreset(newPreset); RefreshPresetComboBox(); MessageBox.Show("New Preset Created "); } catch (Exception exception) { MessageBox.Show("Saving preset requires a name and keys selected "); } }
private void LoadPresetComboBox() { if (File.Exists("NoterizePresets.sqlite")) { PresetDBHelper.ConnectToDatabase(); PresetDBHelper.PrintPresetsComboBox(cbPreset); cbPreset.Text = "Default"; } else { PresetDBHelper.CreateNewDatabase(); PresetDBHelper.ConnectToDatabase(); PresetDBHelper.CreateTable(); PresetDBHelper.InsertDefault(); PresetDBHelper.PrintPresetsComboBox(cbPreset); cbPreset.Text = "Default"; } }
private void cbPreset_SelectedIndexChanged(object sender, EventArgs e) { PresetDBHelper.ConnectToDatabase(); string preset = ""; preset = PresetDBHelper.GetPresetList(cbPreset.Text); preset = preset.TrimEnd(); string[] presetStrings = preset.Split(); List <int> presetInts = new List <int>(); foreach (string str in presetStrings) { presetInts.Add(Convert.ToInt32(str)); } foreach (CheckBox cb in pnCheckBoxes.Controls.OfType <CheckBox>()) { cb.Checked = false; } Dictionary <int, CheckBox> NumberedCheckBoxNames = LookUpCheckBoxes(); foreach (int cbInt in presetInts) { foreach (KeyValuePair <int, CheckBox> keyString in NumberedCheckBoxNames) { // look up checkbox name in Dictionary and add number to list if (cbInt == keyString.Key) { keyString.Value.Checked = true; } } } }
private void RefreshPresetComboBox() { cbPreset.Items.Clear(); PresetDBHelper.ConnectToDatabase(); PresetDBHelper.PrintPresetsComboBox(cbPreset); }