public SealsOfHellVisual() { mData = new DataHandler(); InitializeComponent(); this.openDatabase.ShowDialog(); }
public static bool SetData(DataHandler pDataHandler) { pDataHandler.mActions.Clear(); pDataHandler.mGamePlayData.Clear(); pDataHandler.mPickables.Clear(); pDataHandler.mInit = false; DataTable aData = ReadData("SELECT * FROM ActionData;"); if (aData == null) { return(false); } foreach (DataRow aRow in aData.Rows) { ActionData aAData = new ActionData(); if (!int.TryParse(aRow[0].ToString(), out aAData.mActionId)) { continue; } if (!int.TryParse(aRow[2].ToString(), out aAData.mCount)) { continue; } aAData.mCommandName = aRow[1].ToString(); pDataHandler.mActions.Add(aAData); } pDataHandler.mActions.Sort((a1, a2) => a1.mCommandName.CompareTo(a2.mCommandName)); aData = ReadData("SELECT * FROM PickableData;"); if (aData == null) { return(false); } foreach (DataRow aRow in aData.Rows) { PickableData aPData = new PickableData(); if (!int.TryParse(aRow[0].ToString(), out aPData.mPickableId)) { continue; } if (!int.TryParse(aRow[2].ToString(), out aPData.mPickCount)) { continue; } if (!int.TryParse(aRow[3].ToString(), out aPData.mDropCount)) { continue; } aPData.mPickableName = aRow[1].ToString(); pDataHandler.mPickables.Add(aPData); } pDataHandler.mPickables.Sort((p1, p2) => p1.mPickableName.CompareTo(p2.mPickableName)); aData = ReadData("SELECT * FROM GameData;"); if (aData == null) { return(false); } foreach (DataRow aRow in aData.Rows) { GameData aGData = new GameData(); if (!int.TryParse(aRow[0].ToString(), out aGData.mGameId)) { continue; } if (!double.TryParse(aRow[1].ToString(), out aGData.mPlayTime)) { continue; } if (!int.TryParse(aRow[2].ToString(), out aGData.mInventoryCount)) { continue; } pDataHandler.mGamePlayData.Add(aGData); } pDataHandler.mGamePlayData.Sort((g1, g2) => g1.mPlayTime.CompareTo(g2.mPlayTime)); pDataHandler.mInit = true; return(true); }