public PlayersVip GetPlayersVipById(int id)
{
try
{
using (var con = new SQLiteConnection(_conStringDB))
{
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = string.Format("SELECT * FROM TB_COESERVER_PLAYERS_VIP WHERE PLAYER_ID = {0}", id);
cmd.CommandType = System.Data.CommandType.Text;
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
return(PlayersVipTranslate.MapFromReader(reader));
}
else
{
return(null);
}
}
}
}
catch (Exception ex)
{
throw new Exception("Erro ao consultar o Player VIP na base de dados: " + ex.Message);
}
}
