public static void LoadFromSystemDB(MieSystemDB systemDB, MieCharacterAttributeFile charAttr) { SQLiteCommand command = systemDB.Connection.CreateCommand(); command.CommandText = @"SELECT * FROM CharacterAttributes;"; using (SQLiteDataReader sdr = command.ExecuteReader()) { while (sdr.Read() == true) { var byteID = (byte[])sdr["ID"]; var name = (string)sdr["Name"]; var intGender = (long)sdr["Gender"]; var byteSpeakerID = (byte[])sdr["SpeakerID"]; var byteRaceID = (byte[])sdr["RaceID"]; Guid id = new Guid(byteID); Guid speakerID = new Guid(byteSpeakerID); Guid raceID = new Guid(byteRaceID); MieCharacterAttributeFile.NGender gender = (MieCharacterAttributeFile.NGender)Enum.ToObject(typeof(MieCharacterAttributeFile.NGender), intGender); MieCharacterAttributeEntry charEntry = new MieCharacterAttributeEntry(id, name, gender, speakerID, raceID); charAttr.AddCharacterAttributeEntry(charEntry); } } }
public MieCharacterAttributeEntry(Guid id, string name, MieCharacterAttributeFile.NGender gender, Guid speakerID, Guid race) { this.ID = id; this.Name = name; this.Gender = gender; this.SpeakerID = speakerID; this.RaceID = race; }
public MieSpeakerAttributeEntry(Guid id, string name, MieCharacterAttributeFile.NGender gender) { this.ID = id; this.Name = name; this.Gender = gender; }