void FillDatabase()
{
// db version
DatabaseInfo v = new DatabaseInfo();
v.Version = this.ActualDatabaseVersion;
Database.DatabaseInfo.InsertOnSubmit(v);
// languages
Language en = new Language("English", "en", true);
Language ru = new Language("Russian", "ru", false);
Database.Languages.InsertOnSubmit(en);
Database.Languages.InsertOnSubmit(ru);
// nations
Nation greekz = new Nation("Greek mythology", "gr", true, en);
Nation scands = new Nation("Scandinavian (norse) mythology", "sc", true, en);
Nation egipts = new Nation("Egyptian mythology", "eg", true, en);
greekz.I18nNations.Add(new I18nNation("Греческая мифология", "gr", ru));
scands.I18nNations.Add(new I18nNation("Скандинавская (северная) мифология", "sc", ru));
egipts.I18nNations.Add(new I18nNation("Древне-египетская религия", "eg", ru));
Database.Nations.InsertOnSubmit(greekz);
Database.Nations.InsertOnSubmit(scands);
Database.Nations.InsertOnSubmit(egipts);
Database.SubmitChanges();
// characters
List<Character> greekChars = ReadCharactersFromFile(@"Data/InitData/myth-gr-{0}.txt", greekz);
Database.Characters.InsertAllOnSubmit(greekChars);
List<Character> scandChars = ReadCharactersFromFile(@"Data/InitData/myth-sc-{0}.txt", scands);
Database.Characters.InsertAllOnSubmit(scandChars);
List<Character> egiptChars = ReadCharactersFromFile(@"Data/InitData/myth-eg-{0}.txt", egipts);
Database.Characters.InsertAllOnSubmit(egiptChars);
Database.SubmitChanges();
}
public Character(string name, string description, Nation nation, Language language)
: this()
{
I18nCharacters.Add(new I18nCharacter(name, description, language));
Nation = nation;
}
List<Character> ReadCharactersFromFile(string FileName, Nation nation)
{
List<Character> list = new List<Character>();
for (int LanguageIndex = 0; LanguageIndex < Database.Languages.Count(); LanguageIndex++)
{
Language language = Database.Languages.ToList()[LanguageIndex];
string LangFileName = FileName.Replace("{0}", language.ShortName);
var ResourceStream = Application.GetResourceStream(new Uri(LangFileName, UriKind.Relative));
if (ResourceStream == null)
return list;
using (Stream file = ResourceStream.Stream)
{
if (file.CanRead)
{
int LineIndex = 0;
StreamReader sr = new StreamReader(file);
while (!sr.EndOfStream)
{
string s = sr.ReadLine();
string[] f = s.Split('\t');
if (LanguageIndex == 0)
{
list.Add(new Character(f[2], f[3], nation, language));
}
else
{
list[LineIndex++].I18nCharacters.Add(new I18nCharacter(f[2], f[3], language));
}
}
sr.Close();
}
}
}
return list;
}