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");
}
