protected void LoadAccountInfo() { AccountData account = new AccountData("E3FB0351-32DC-4D4D-8902-181DD9666AB2"); SqlDataReader rdr = account.GetAccountData(); if (rdr.HasRows) { Response.Write("<div class='row'>"); Response.Write("<div class='col-md-2 product-table-hdr'><p class='active'>Product Name</p></div>"); Response.Write("<div class='col-md-2 product-table-hdr'><p>Start Date</p></div>"); Response.Write("<div class='col-md-2 product-table-hdr'><p>End Date</p></div>"); Response.Write("</div>"); while (rdr.Read()) { Response.Write("<div class='row'>"); Response.Write("<div class='col-md-2 product-table-row'>" + rdr.GetValue(1) + "</div>"); Response.Write("<div class='col-md-2 product-table-row'>" + rdr.GetDateTime(2).ToString("d") + "</div>"); Response.Write("<div class='col-md-2 product-table-row'>" + rdr.GetDateTime(3).ToString("d") + "</div>"); } Response.Write("</div>"); } else { Console.WriteLine("No rows found."); } rdr.Close(); }
public bool Execute(PlayerDetails playerDetails) { bool executed = false; DbAccountsData account = null; List <CharacterData> charsList = null; try { if (String.IsNullOrWhiteSpace(playerDetails.Login)) { CommandHandler.Send(new InfoCmdBuilder("You're not logged in!"), playerDetails); throw new Exception("player is not logged in!"); } if (playerDetails.CharId > -1) { playerDetails.CharId = -1; _logger.UpdateLog($"Player's char ID set to -1 by executing char list method for TCP client ID [{playerDetails.TcpClientId}]"); } account = _accountData.GetAccountData(playerDetails.Login); if (account == null) { CommandHandler.Send(new InfoCmdBuilder("An error occured on the server."), playerDetails); throw new Exception("cannot get db account data (NULL)!"); } charsList = _characterInfo.GetCharactersByAccId(account.AccId); foreach (CharacterData charData in charsList) { //LOBBY CHARACTER DETAILS CommandHandler.Send(new CharLobbyInfoCmdBuilder(false, charData), playerDetails); } //LIST CONFIRMATION CommandHandler.Send(new CharLobbyInfoCmdBuilder(true), playerDetails); executed = true; } catch (Exception exception) { _logger.UpdateLog($"Account characters getting error for TCP client ID [{playerDetails.TcpClientId}]: {exception.Message}"); } return(executed); }
public bool Execute(PlayerDetails playerDetails) { bool executed = false; DbAccountsData account = null; List <CharacterData> charsList = null; int charId = -1; try { if (String.IsNullOrWhiteSpace(playerDetails.Login)) { CommandHandler.Send(new InfoCmdBuilder("You're not logged in!"), playerDetails); throw new Exception("player is not logged in!"); } if (_cmdElements.Length != 2) { CommandHandler.Send(new InfoCmdBuilder("Character choosing - wrong command!"), playerDetails); throw new Exception($"wrong command element count [{_cmdElements.Length}]"); } if (String.IsNullOrWhiteSpace(_cmdElements[1]) || !Int32.TryParse(_cmdElements[1], out charId)) { CommandHandler.Send(new InfoCmdBuilder("Character choosing - wrong ID, must be numeric value!"), playerDetails); throw new Exception($"cannot convert character ID from element [{_cmdElements[1]}]"); } if (charId < 0) { CommandHandler.Send(new InfoCmdBuilder("Character choosing - wrong ID, cannot be less than 0!"), playerDetails); throw new Exception($"wrong character ID [{charId}] (less than 0)"); } account = _accountData.GetAccountData(playerDetails.Login); if (_playerHandler.GetPlayerCharacterId(account.Login) > -1) { CommandHandler.Send(new InfoCmdBuilder("You have already chosen your character (character in use)!"), playerDetails); throw new Exception("other character in use!"); } if (account == null) { CommandHandler.Send(new InfoCmdBuilder("An error occured on the server."), playerDetails); throw new Exception("cannot get db account data (NULL)!"); } charsList = _characterInfo.GetCharactersByAccId(account.AccId); foreach (CharacterData charData in charsList) { if (charData.CharId == charId) { _playerHandler.SetPlayerCharacter(charId, account.Login); _logger.UpdateLog($"Character set to char. ID [{charId}] for player [{account.Login}]"); executed = true; } } } catch (Exception exception) { _logger.UpdateLog($"Character choosing execution error for player with TCP client ID [{playerDetails.TcpClientId}]: {exception.Message}"); } finally { //CHARACTER CHOOSING RESULT CommandHandler.Send(new CharChoosingSuccessCmdBuilder(executed), playerDetails); } return(executed); }