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); } }