private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { var sdm = new SqlDataManager(); var alphabet = this.listBox1.SelectedItem as Alphabet; var charWhere = String.Format("AlphabetId = '{0}'", alphabet.AlphabetId); this.listBox2.DataSource = sdm.GetAllCharacters <Character>(charWhere).OrderBy(orderBy => orderBy.Name).ToList(); }
/// <summary> /// Check to see if there are any related Characters, and load them if requested /// </summary> public static void CheckExpandCharacters(SqlDataManager sdm, IEnumerable <Alphabet> alphabets, string expandString) { var alphabetsWhere = CreateAlphabetWhere(alphabets); expandString = expandString.SafeToString(); if (String.Equals(expandString, "all", StringComparison.OrdinalIgnoreCase) || expandString.IndexOf("characters", StringComparison.OrdinalIgnoreCase) >= 0) { var childCharacters = sdm.GetAllCharacters <Character>(alphabetsWhere); alphabets.ToList() .ForEach(feAlphabet => feAlphabet.LoadCharacters(childCharacters)); } }
private void EnsureLoaded() { var sdm = new SqlDataManager(); var charWhere = String.Format("AlphabetId = '{0}'", this.AlphabetId); var chars = sdm.GetAllCharacters <Character>(charWhere); this.Characters.Clear(); chars.ForEach(feChar => this.Characters.Add(feChar)); var charSequenceWhere = String.Format("CharacterId IN (SELECT CharacterId from Character where AlphabetId = '{0}')", this.AlphabetId); var charSequences = sdm.GetAllCharacterSquences <CharacterSquence>(charSequenceWhere); foreach (var charToCheck in this.Characters) { charToCheck.LoadCharacterSquences(charSequences); } }
public static void SaveNow() { var sdm = new SqlDataManager(); var mcms = new MorseCodeMetaSnapshot(); var allCharacters = sdm.GetAllCharacters <Character>(); var allSignals = sdm.GetAllSignals <Signal>(); mcms.Alphabets = sdm.GetAllAlphabets <Alphabet>(); foreach (var alphabet in mcms.Alphabets) { alphabet.LoadCharacters(allCharacters); alphabet.ParseCharacters(sdm, allSignals); } mcms.Signals = sdm.GetAllSignals <Signal>(); mcms.Save("../../../SSoT/MorseCodeMetaSnapshot.json"); }