public List <AdministracaoPlayersVip> GetUsuariosSistemaAll()
{
try
{
using (var con = new SQLiteConnection(_conStringDB))
{
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = "SELECT * FROM TB_COESERVER_ADMIN AS ADM " +
"INNER JOIN TB_LEVEL_ADMIN AS LVL_ADM ON ADM.LEVEL_ADMIN_ID = LVL_ADM.LEVEL_ADMIN_ID;";
cmd.CommandType = System.Data.CommandType.Text;
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
return(AdministracaoPlayersVipTranslate.MapFromReaderList(reader));
}
else
{
return(null);
}
}
}
}
catch (Exception ex)
{
throw new Exception("Erro ao consultar os Players VIP's na base de dados: " + ex.Message);
}
}
// ACESSOS ADMINISTRAÇÃO SISTEMA
public AdministracaoPlayersVip LoginAdministracao(AdministracaoPlayersVip administracaoPlayersVip)
{
try
{
using (var con = new SQLiteConnection(_conStringDB))
{
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = "SELECT ADM.ADMIN_ID, ADM.LEVEL_ADMIN_ID, ADM.ADMIN_NOME, ADM.ADMIN_LOGIN, LVL_ADM.LEVEL_ADMIN_ID, LVL_ADM.LEVEL_ADMIN_DESCRICAO " +
"FROM TB_COESERVER_ADMIN AS ADM " +
"INNER JOIN TB_LEVEL_ADMIN AS LVL_ADM ON ADM.LEVEL_ADMIN_ID = LVL_ADM.LEVEL_ADMIN_ID " +
"WHERE ADM.ADMIN_LOGIN = @ADMIN_LOGIN AND ADM.ADMIN_PASSWORD = @ADMIN_PASSWORD;";
cmd.Parameters.AddWithValue("ADMIN_LOGIN", administracaoPlayersVip.AdminLogin);
cmd.Parameters.AddWithValue("ADMIN_PASSWORD", administracaoPlayersVip.AdminPassword);
cmd.CommandType = System.Data.CommandType.Text;
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
return(AdministracaoPlayersVipTranslate.MapFromReader(reader));
}
else
{
return(null);
}
}
}
}
catch (Exception ex)
{
throw new Exception("Erro ao consultar usuário de administracão de Players VIP na base de dados: " + ex.Message);
}
}
