/// <summary>
/// Sets players game data to default values
/// </summary>
/// <param name="prEmail">email address used to identify the player</param>
#region New Game
public void NewGame(string prEmail)
{
//remove existing entries for player
_connection.Query <TableAreaItem>(
"delete from TableAreaItem"
+ " where TableAreaItem.Email = ?",
dataBetweenScenesManager.dataBetweenScenesInstance.Email);
_connection.Query <TableInventory>(
"delete from TableInventory"
+ " where TableInventory.Email = ?",
dataBetweenScenesManager.dataBetweenScenesInstance.Email);
_connection.Query <TableNPC>(
"delete from TableNPC"
+ " where TableNPC.Email = ?",
dataBetweenScenesManager.dataBetweenScenesInstance.Email);
_connection.Query <TableVisited>(
"delete from TableVisited"
+ " where TableVisited.Email = ?",
dataBetweenScenesManager.dataBetweenScenesInstance.Email);
//pull player out
TablePlayer lcPlayer = _connection.Table <TablePlayer>().Where(x => x.Email == prEmail).FirstOrDefault();
//update to default values
lcPlayer.CurrentArea = "christChurchSteps";
lcPlayer.Health = 10;
//put back in
_connection.Update(lcPlayer);
//insert new entires for area item as default values
TableAreaItem lcNewAreaItem1 = new TableAreaItem
{
ItemID = 1,
AreaName = "starbucks",
Email = prEmail
};
TableAreaItem lcNewAreaItem2 = new TableAreaItem
{
ItemID = 2,
AreaName = "newWorld",
Email = prEmail
};
TableNPC lcNPC = new TableNPC
{
Name = "spookyboi",
Health = 20,
Email = prEmail,
CurrentArea = "stateCinemas"
};
_connection.Insert(lcNewAreaItem1);
_connection.Insert(lcNewAreaItem2);
_connection.Insert(lcNPC);
}
/// <summary>
/// gets current npc table for the area the player is in
/// </summary>
/// <param name="prPlayer">used to get the correct npc table for the player</param>
/// <returns>returns the npc table</returns>
public bool GetNPC(Player prPlayer)
{
TablePlayer lcPlayer = _connection.Table <TablePlayer>().Where(x => x.Email == prPlayer._email).FirstOrDefault();
TableNPC lcNPC = _connection.Table <TableNPC>().Where(x => x.CurrentArea == lcPlayer.CurrentArea && x.Email == prPlayer._email).FirstOrDefault();
if (lcNPC == null)
{
return(false);
}
else
{
return(true);
}
}
