Esempio n. 1
0
        public int InserirUsuarioSistema(AdministracaoPlayersVip administracaoPlayersVip)
        {
            try
            {
                using (var con = new SQLiteConnection(_conStringDB))
                {
                    using (var cmd = new SQLiteCommand(con))
                    {
                        cmd.CommandText = "INSERT INTO TB_COESERVER_ADMIN(LEVEL_ADMIN_ID, ADMIN_NOME, ADMIN_LOGIN, ADMIN_PASSWORD, ADMIN_DATA_CADASTRO) " +
                                          "VALUES(@LEVEL_ADMIN_ID, @ADMIN_NOME, @ADMIN_LOGIN, @ADMIN_PASSWORD, @ADMIN_DATA_CADASTRO)";

                        cmd.Parameters.AddWithValue("LEVEL_ADMIN_ID", administracaoPlayersVip.LvlAdminID);
                        cmd.Parameters.AddWithValue("ADMIN_NOME", administracaoPlayersVip.AdminNome);
                        cmd.Parameters.AddWithValue("ADMIN_LOGIN", administracaoPlayersVip.AdminLogin);
                        cmd.Parameters.AddWithValue("ADMIN_PASSWORD", administracaoPlayersVip.AdminPassword);
                        cmd.Parameters.AddWithValue("ADMIN_DATA_CADASTRO", administracaoPlayersVip.AdminDataCadastro);

                        cmd.CommandType = System.Data.CommandType.Text;

                        if (con.State == System.Data.ConnectionState.Closed)
                        {
                            con.Open();
                        }

                        return(cmd.ExecuteNonQuery());
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception("Erro ao inserir o Usuário de Sistema na base de dados: " + ex.Message);
            }
        }
        private void btnLogin_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(txtLogin.Text) || string.IsNullOrEmpty(txtSenha.Text))
            {
                MessageBox.Show("Os campos de login e senha não deverão estar vazios", "Aviso!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;
            }

            string _msgErro = "Login e/ou senha inválido(s)";

            BusinessOperations businessOperations = new BusinessOperations();

            AdministracaoPlayersVip administracaoPlayersVip = businessOperations.BusinessAdministracaoPlayersVip(new AdministracaoPlayersVip
            {
                AdminLogin    = txtLogin.Text,
                AdminPassword = txtSenha.Text
            });

            if (administracaoPlayersVip == null)
            {
                MessageBox.Show(_msgErro, "Aviso!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                lblMsgSistema.ForeColor = Color.Red;
                lblMsgSistema.Visible   = true;
                lblMsgSistema.Text      = _msgErro + ". Tente novamente!";
                return;
            }
            else
            {
                FrmMain frmMain = new FrmMain(administracaoPlayersVip);
                Hide();
                frmMain.Show();
            }
        }
Esempio n. 3
0
        public bool BusinessInserirUsuarioSistema(AdministracaoPlayersVip administracaoPlayersVip)
        {
            _operationsDataBase = new OperationsDataBase();

            administracaoPlayersVip.AdminPassword = MD5Hash(administracaoPlayersVip.AdminPassword);

            return(_operationsDataBase.InserirUsuarioSistema(administracaoPlayersVip) > 0 ? true : false);
        }
Esempio n. 4
0
        public AdministracaoPlayersVip BusinessAdministracaoPlayersVip(AdministracaoPlayersVip administracaoPlayersVip)
        {
            _operationsDataBase = new OperationsDataBase();

            administracaoPlayersVip.AdminPassword = MD5Hash(administracaoPlayersVip.AdminPassword);

            return(_operationsDataBase.LoginAdministracao(administracaoPlayersVip));
        }
Esempio n. 5
0
        // 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);
            }
        }
Esempio n. 6
0
        public static AdministracaoPlayersVip MapFromReader(IDataReader reader)
        {
            AdministracaoPlayersVip administracaoPlayersVip = new AdministracaoPlayersVip();

            while (reader.Read())
            {
                administracaoPlayersVip = new AdministracaoPlayersVip
                {
                    AdminID    = Convert.ToInt32(reader["ADMIN_ID"]),
                    LvlAdminID = Convert.ToInt32(reader["LEVEL_ADMIN_ID"]),
                    AdminNome  = reader["ADMIN_NOME"].ToString(),
                    AdminLogin = reader["ADMIN_LOGIN"].ToString(),
                    LevelAdministracaoPlayersVip = new LevelAdministracaoPlayersVip
                    {
                        LevelAdministracaoPlayersVipID        = Convert.ToInt32(reader["LEVEL_ADMIN_ID"]),
                        LevelAdministracaoPlayersVipDescricao = reader["LEVEL_ADMIN_DESCRICAO"].ToString()
                    }
                };
            }

            return(administracaoPlayersVip);
        }
Esempio n. 7
0
        // FORMULÁRIO

        public FrmMain(AdministracaoPlayersVip administracaoPlayersVip)
        {
            InitializeComponent();
            // Seta neste tipo os dados do usuário logado
            _administracaoPlayersVip = administracaoPlayersVip;

            lblUsuarioLogado.Text = string.Format("({0}) {1}", administracaoPlayersVip.LevelAdministracaoPlayersVip.LevelAdministracaoPlayersVipDescricao,
                                                  administracaoPlayersVip.AdminNome);

            // esconde os botões de cancelar e gravar novo Player vip
            btnCancelarGravarNovoPlayerVip.Visible = false;
            btnSalvarNovoPlayerVip.Visible         = false;

            ResetarControlesDoFormulario();

            // Desabilita as ações de usuários diferente de Administrador (ID 1)
            if (_administracaoPlayersVip.LevelAdministracaoPlayersVip.LevelAdministracaoPlayersVipID != 1)
            {
                foreach (TabPage item in tabMain.TabPages)
                {
                    if (item.Name == "tabCadastroUsuarioSistema")
                    {
                        item.Controls.Clear();
                        item.Controls.Add(lblAvisoNaoAdministrador);
                        lblAvisoNaoAdministrador.Visible = true;
                    }
                }

                grpAdminAcoes.Controls.Clear();
                grpAdminAcoes.Controls.Add(lblAvisoNaoAdministradorAcoesPlayersVip);
                lblAvisoNaoAdministradorAcoesPlayersVip.Visible = true;
            }

            // Habilita os radiobuttons da tab "Consulta de Players Vip"
            rdbBuscaPlayerVipAtivoSim.Checked   = true;
            rdbBuscaPlayerVipEhAdminNao.Checked = true;
        }