using System;
using System.Collections.Generic;
using System.Drawing;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data;
using System.ComponentModel;

namespace Cadastro
{
    /// <summary>
    /// Description of MainForm.
    /// </summary>
    public partial class MainForm : Form
    {

        private OleDbConnection Conn;
        private OleDbDataAdapter da;
        private DataSet ds;
        private string bd = "Cadastro.mdb";
        public MainForm()
        {
            //
            // The InitializeComponent() call is required for Windows Forms designer support.
            //
            InitializeComponent();

            //
            // TODO: Add constructor code after the InitializeComponent() call.
            //
        }

        void MainFormLoad(object sender, EventArgs e)
        {
            iniciaAcesso();
        }

        private void iniciaAcesso()
        {
            ds = new DataSet();
            Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\Dados\\" + bd);
            try
            {
                Conn.Open();
                if (Conn.State == ConnectionState.Open)
                {
                    da = new OleDbDataAdapter("SELECT * from Clientes", Conn);
                    da.Fill(ds, "Tabela");
                    dgvDados.DataSource = ds;
                    dgvDados.DataMember = "Tabela";
                    dgvDado.DataSource = ds;
                    dgvDado.DataMember = "Tabela";

                }
            }
            catch (System.Exception e)
            {
                MessageBox.Show(e.Message.ToString());
            }

        }

       private void Time_Tick(object sender, EventArgs e)
        {
            Clock.Text = DateTime.Now.ToString();
        }

        private void BtnSalvar_Click(object sender, EventArgs e)
        {
            if (validaDados())
            {
                SalvaDados();
            }
            else
            {
                MessageBox.Show("Dados Inválidos...");
                txtNome.Focus();
                return;
            }
        }

        private Boolean validaDados()
        {

            return true;
        }

        private void SalvaDados()
        {
            string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Users\\Dados\\Cadastro.mdb";
            string strSQL = "INSERT INTO Clientes(nome,sobrenome,funcao,paciente,endereco,bairro,cep,cidade,estado,pais,cpf,te
lefone,celular,email,rg,obs,nascimento,data)"
                            + " VALUES ('" + txtNome.Text + "','" + txtSobrenome.Text + "','" + txtFuncao.Text + "','" + txtPaciente.Text + "','" + txtEndereco.Text + "','" + txtBairro.Text + "','" + txtCep.Text + "','" + txtCidade.Text + "','" + txtEstado.Text + "','" + txtPais.Text + "','" + txtCpf.Text + "','" + txtTelefone.Text + "','" + txtCelular.Text + "','" + txtEmail.Text + "','" + txtRg.Text + "','" + tbObs.Text + "','" + txtNascimento.Text + "','" + txtData.Text + "')";
            
            //cria a conexão com o banco de dados
            OleDbConnection dbConnection = new OleDbConnection(strConnection);
            //Cria o comando que starta a query
            OleDbCommand cmdQry = new OleDbCommand(strSQL, dbConnection);
            try
            {
                // abre o banco
                dbConnection.Open();
                // executa a query
                cmdQry.ExecuteNonQuery();
                //
                MessageBox.Show("Dados Salvos com sucesso.");
            }
            //Trata a exceção
            catch (OleDbException ex)
            {
                MessageBox.Show("Error: " + ex.Message);
            }
            finally
            {
                //fecha a conexao
                dbConnection.Close();
            }
        }

        private void btnProcura_Click(object sender, EventArgs e)
        {
            Form5 f5 = new Form5();


            f5.ShowDialog();


            if (f5.sqlString != null && f5.sqlString != "")

                carregaGrid(f5.sqlString);
        }

        private void carregaGrid(string criterioSQL)
        {


            //define o dataset

            ds = new DataSet();


            //cria uma conexÆo usando a string de conexÆo

            Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\Dados\\" + bd);


            try
            {

                //abre a conexao

                Conn.Open();

            }

            catch (System.Exception e)
            {

                MessageBox.Show(e.Message.ToString());

            }


            if (Conn.State == ConnectionState.Open)
            {

                //se a conexÆo estiver aberta usa uma instru‡Æo SQL para selecionar os registros da tabela clientes

                //SELECT campos FROM tabela

                da = new OleDbDataAdapter(criterioSQL, Conn);

                da.Fill(ds, "Tabela");


                //exibe os dados no datagridview

                dgvDados.DataSource = ds;

                dgvDados.DataMember = "Tabela";
              

            }

        }

        private void button1_Click(object sender, EventArgs e)
        {
            Form8 f8 = new Form8();


            f8.ShowDialog();


            if (f8.sqlString != null && f8.sqlString != "")

                carregaGrid(f8.sqlString);
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Form7 f7 = new Form7();


            f7.ShowDialog();


            if (f7.sqlString != null && f7.sqlString != "")

                carregaGrid(f7.sqlString);
        }

        private void button3_Click(object sender, EventArgs e)
        {
            Form6 f6 = new Form6();


            f6.ShowDialog();


            if (f6.sqlString != null && f6.sqlString != "")

                carregaGrid(f6.sqlString);
        }

        private void sairToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Deseja realmente sair?", "Cadastro",
       MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                Application.Exit();
            }
        }

        private void LimpaCamposFormulario(Control.ControlCollection controles)
        {
            foreach (Control ctrl in controles)
            {
                if (ctrl is TextBox)
                {
                    ((TextBox)(ctrl)).Clear();
                }
                LimpaCamposFormulario(ctrl.Controls);
            }
        }



        private void button4_Click(object sender, EventArgs e)
        {
            LimpaCamposFormulario(this.Controls);

            tbObs.Clear();

        }

private void btnExcluir_Click(object sender, EventArgs e)
        {
            //solicita‡Æo confirma‡Æo para excluir

            if (MessageBox.Show("Confirma exclusao? ", "Excluir", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {

                ExcluirDados();

            }
        }
        public string Codigo;

        private void ExcluirDados()
        {

            //define string de conexÆo - Provedor + fonte de dados (caminho do banco de dados e seu nome)

            string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Users\\Dados\\Cadastro.mdb";



            //define instru‡Æo SQL para excluir dados da tabela Clientes - DELETE FROM tabela Where <criterio>

            string strSQL = "DELETE FROM clientes WHERE Codigo";



            //cria a conexÆo com o banco de dados

            OleDbConnection dbConnection = new OleDbConnection(strConnection);



            //Cria o comando que inicia a instru‡Æo SQL para exclusÆo

            OleDbCommand cmdExcluir = new OleDbCommand(strSQL, dbConnection);

            try
            {

                // abre o banco de dados

                dbConnection.Open();



                // executa a instru‡Æo SQL

                cmdExcluir.ExecuteNonQuery();

                //

                MessageBox.Show("Dados Exclu¡dos com sucesso.");

            }

            //Trata a exce‡Æo

            catch (OleDbException ex)
            {

                MessageBox.Show("Error: " + ex.Message);

            }

            finally
            {

                //fecha a conexao

                dbConnection.Close();

            }

        }