public List <PlayersVip> GetPlayersVipAll()
{
try
{
using (var con = new SQLiteConnection(_conStringDB))
{
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = string.Format("SELECT * FROM TB_COESERVER_PLAYERS_VIP;");
cmd.CommandType = System.Data.CommandType.Text;
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
return(PlayersVipTranslate.MapFromReaderList(reader));
}
else
{
return(null);
}
}
}
}
catch (Exception ex)
{
throw new Exception("Erro ao consultar os Players VIP's na base de dados: " + ex.Message);
}
}
public List <PlayersVip> GetPlayersVipByFilter(PlayersVipFilter playersVipFilter)
{
try
{
using (var con = new SQLiteConnection(_conStringDB))
{
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = string.Format("SELECT * FROM TB_COESERVER_PLAYERS_VIP WHERE 1 = 1 ");
// filtros
if (!string.IsNullOrEmpty(playersVipFilter.PlayerNome))
{
cmd.CommandText += string.Format("AND PLAYER_NOME LIKE '%{0}%' ", playersVipFilter.PlayerNome);
}
if (!string.IsNullOrEmpty(playersVipFilter.PlayerNick))
{
cmd.CommandText += string.Format("AND PLAYER_NICK LIKE '%{0}%' ", playersVipFilter.PlayerNick);
}
if (playersVipFilter.PlayerAtivo)
{
cmd.CommandText += string.Format("AND PLAYER_ATIVO = {0} ", playersVipFilter.PlayerAtivo);
}
if (playersVipFilter.PlayerEhAdmin)
{
cmd.CommandText += string.Format("AND PLAYER_EH_ADMIN = {0} ", playersVipFilter.PlayerEhAdmin);
}
if (playersVipFilter.PlayerDiasVIP != short.MinValue)
{
cmd.CommandText += string.Format("AND PLAYER_DIAS_VIP = {0} ", playersVipFilter.PlayerDiasVIP.Value);
}
if (playersVipFilter.PlayerDataInclusaoSLOTVipInicial != DateTime.MinValue || playersVipFilter.PlayerDataInclusaoSLOTVipFinal != DateTime.Now)
{
cmd.CommandText +=
string.Format("AND PLAYER_DT_INCLUSAO_SLOT_VIP BETWEEN '{0}' AND '{1}';",
playersVipFilter.PlayerDataInclusaoSLOTVipInicial.ToString("yyyy-MM-dd"),
playersVipFilter.PlayerDataInclusaoSLOTVipFinal.ToString("yyyy-MM-dd"));
}
cmd.CommandType = System.Data.CommandType.Text;
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
return(PlayersVipTranslate.MapFromReaderList(reader));
}
else
{
return(null);
}
}
}
}
catch (Exception ex)
{
throw new Exception("Erro ao consultar (por filtro) os Players VIP's na base de dados: " + ex.Message);
}
}
