/// <summary>
/// Sets up the UI inputs based on the player stat record selected
/// </summary>
/// <param name="playerId"></param>
public void Edit(int playerId)
{
ResetGUI();
_playerId = playerId;
// determine if the record exists
bool recordExists;
var firstRecord = dbManager.QueryFirstRecord <PlayerStats>(out recordExists, "SELECT * FROM PlayerStats WHERE PlayerID = ?", _playerId);
if (recordExists)
{
// show the edit panel;
editPanel.SetActive(true);
// set the player id label
playerIdLabel.text = "PlayerId: " + _playerId.ToString();
// populate the edit fields with the record if it exists
playerNameInput.text = firstRecord.PlayerName;
totalKillsInput.text = firstRecord.TotalKills.ToString();
pointsInput.text = firstRecord.Points.ToString();
}
else
{
// hide the edit panel
editPanel.SetActive(false);
}
}
void Start()
{
// Gather a list of weapons and their type names pulled from the weapontype table
List <Weapon> weaponList = dbManager.Query <Weapon>(
"SELECT " +
"W.WeaponID, " +
"W.WeaponName, " +
"W.Damage, " +
"W.Cost, " +
"W.Weight, " +
"W.WeaponTypeID, " +
"T.Description AS WeaponTypeDescription " +
"FROM " +
"Weapon W " +
"JOIN WeaponType T " +
"ON W.WeaponTypeID = T.WeaponTypeID " +
"ORDER BY " +
"W.WeaponID "
);
// output the list of weapons
outputText.text = "Weapons\n\n";
foreach (Weapon weaponRecord in weaponList)
{
outputText.text += "<color=#1abc9c>Name</color>: '" + weaponRecord.WeaponName + "' " +
"<color=#1abc9c>Damage</color>:" + weaponRecord.Damage.ToString() + " " +
"<color=#1abc9c>Cost</color>:" + weaponRecord.Cost.ToString() + " " +
"<color=#1abc9c>Weight</color>:" + weaponRecord.Weight.ToString() + " " +
"<color=#1abc9c>Type</color>:" + weaponRecord.WeaponTypeDescription + "\n";
}
// get the first weapon record that has a WeaponID > 4
outputText.text += "\nFirst weapon record where the WeaponID > 4: ";
bool recordExists;
Weapon firstWeaponRecord = dbManager.QueryFirstRecord <Weapon>(out recordExists, "SELECT WeaponName FROM Weapon WHERE WeaponID > 4");
if (recordExists)
{
outputText.text += firstWeaponRecord.WeaponName + "\n";
}
else
{
outputText.text += "No record found\n";
}
}