Exemple #1
0
        /// <summary>
        /// Gets the account data via I.
        /// </summary>
        /// <returns>The account data via ID.</returns>
        /// <param name="id">Identifier for DB access.</param>
        public TableData GetAccountDataViaID(int id)
        {
            SQLiteConnection con = new SQLiteConnection(ServerConstants.DB_PATH);

               TableData tb = new TableData();

               tb.Units = con.Query<TableUnit>("SELECT * FROM Unit WHERE Id = ?", id);
               tb.Buildings = con.Query<TableBuilding>("SELECT * FROM Building WHERE Id = ?", id);
               tb.Resources = con.Query<TableResource>("SELECT * FROM Ressources WHERE Id = ?", id);

               return tb;
        }
Exemple #2
0
        /// <summary>
        /// Gets the account data via DB login.
        /// </summary>
        /// <returns>The account data via DB login.</returns>
        /// <param name="account">Account for DB data.</param>
        /// <param name="password">Password for DB data.</param>
        public TableData GetAccountDataViaDBLogin(Account account, string password)
        {
            SQLiteConnection con = new SQLiteConnection(ServerConstants.DB_PATH);

               DBAccount dbacc = new DBAccount(con);
               TableData tb = new TableData();

               if (dbacc.Login(account.UserName, password))
               {
               var data = con.Query<TableAccount>("SELECT Id FROM Account WHERE UserName = ? LIMIT 1", account.UserName);
               tb.Id = data[0].Id;
               tb.Units = con.Query<TableUnit>("SELECT * FROM Unit WHERE Id = ?", tb.Id);
               tb.Buildings = con.Query<TableBuilding>("SELECT * FROM Building WHERE Id = ?", tb.Id);
               tb.Resources = con.Query<TableResource>("SELECT * FROM Ressources WHERE Id = ?", tb.Id);
               }

               return tb;
        }