/// <summary>
/// Search for a player
/// Returns if a player is found
/// </summary>
/// <param name="username">Username of the player</param>
/// <returns>Returns if a player is found with the usernames</returns>
static bool PlayerExist(string username)
{
string sql = String.Format("SELECT * FROM [dbo].[{0}] WHERE Username = '******'"
, tableName
, username);
Dictionary <string, object> results = new Dictionary <string, object>();
if (DBEndPoint.GetSingleRowSqlSearch(sql, results))
{
return(true);
}
return(false);
}
/// <summary>
/// Search for a player
/// Returns null if no player is found
/// </summary>
/// <param name="username">Username of the player</param>
/// <param name="hashedPassword">Hashed password of the player </param>
/// <returns>The player profile, null if none were found</returns>
public static DBProfile_Login GetPlayer(string username, string hashedPassword)
{
string sql = String.Format("SELECT * FROM [dbo].[{0}] WHERE Username = '******' and Password = '******'"
, tableName
, username
, hashedPassword);
Dictionary <string, object> results = new Dictionary <string, object>();
if (DBEndPoint.GetSingleRowSqlSearch(sql, results))
{
DBProfile_Login profile;
profile = new DBProfile_Login((int)results["Id"], (string)results["Username"]);
return(profile);
}
return(null);
}
/// <summary>
/// Returns the profile of a player
/// </summary>
/// <param name="username"></param>
/// <param name="hashedPassword"></param>
/// <returns>Returns the profile of a player, returns null if none were found</returns>
public static DBProfile_Stats GetPlayer(string username, string hashedPassword)
{
var player = DBLogin.GetPlayer(username, hashedPassword);
if (player == null)
{
return(null);
}
string sql = String.Format("SELECT * FROM [dbo].[{0}] WHERE Id = {1}"
, tableName
, player.id);
Dictionary <string, object> results = new Dictionary <string, object>();
if (DBEndPoint.GetSingleRowSqlSearch(sql, results))
{
DBProfile_Stats profile;
profile = new DBProfile_Stats((int)results["Wins"], (int)results["Losses"], (int)results["Kills"], (int)results["Deaths"]);
return(profile);
}
return(null);
}