using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SQLite;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace CKUERA
{
    public partial class Objeto : Form
    {
        public Objeto()
        {
            InitializeComponent();
        }

        private void but_Aceptar_Click(object sender, EventArgs e)
        {
            if (Txt_objeto.Text.Length < 1) { Txt_objeto.Select(); return; }
            if (Txt_NumEScr.Text.Length < 1) { Txt_NumEScr.Select(); return; }
            if (Txt_Protocolo.Text.Length < 1) { Txt_Protocolo.Select(); return; }
            if (Txt_Secc.Text.Length < 1) { Txt_Secc.Select(); return; }
            if (Txt_Contri.Text.Length < 1) { Txt_Contri.Select(); return; }
            //if (Txt_reembolso.Text.Length < 1) { Txt_reembolso.Select(); return; }

            //try
            //{
            //    double d= double.Parse(Txt_reembolso.Text) * 1;
            //}
            //catch 
            //{
            //    MessageBox.Show("Escriba en número.");
            //    Txt_reembolso.SelectAll();
            //    return;
            //}

            Global.Objeto = Txt_objeto.Text.Trim().ToUpper();
            Global.NumEscri = Txt_NumEScr.Text.Trim();
            Global.Protocolo = Txt_Protocolo.Text.Trim().ToUpper();
            Global.SeccEscri = Txt_Secc.Text.Trim().ToUpper();
            Global.Contri = Txt_Contri.Text.Trim().ToUpper();
            //Global.Reembolso = Txt_reembolso.Text.Trim().ToUpper();

            //escri_objeto(id INTEGER PRIMARY KEY AUTOINCREMENT, objeto, num_escri, protocolo, secc, contri
            //GUARDAR DATOS DE OBJETO SI NO EXISTE
            {   //OBJETO
                SQLiteDataReader RS = null;//CONSULTA CONCEPTOS
                string SQL = "SELECT objeto FROM escri_objeto WHERE objeto='" + Global.Objeto + "';";
                SQLiteCommand CMD = new SQLiteCommand(SQL, Global.conexion);
                RS = CMD.ExecuteReader();

                if (RS.HasRows == false)//INSERTAR SI NO EXISTE CONCEPTO
                {
                    RS.Close();
                    string SQLin = "INSERT INTO escri_objeto (objeto, num_escri, protocolo, secc, contri) VALUES ('" + Global.Objeto + "','XX','XX','XX','XX');";
                    SQLiteCommand CMDin = new SQLiteCommand(SQLin, Global.conexion);
                    CMDin.ExecuteNonQuery();
                }
                RS.Close();
            }

            {   //num_escri
                SQLiteDataReader RS = null;//CONSULTA CONCEPTOS
                string SQL = "SELECT num_escri FROM escri_objeto WHERE num_escri='" + Global.NumEscri + "';";
                SQLiteCommand CMD = new SQLiteCommand(SQL, Global.conexion);
                RS = CMD.ExecuteReader();

                if (RS.HasRows == false)//INSERTAR SI NO EXISTE CONCEPTO
                {
                    RS.Close();
                    string SQLin = "INSERT INTO escri_objeto (objeto, num_escri, protocolo, secc, contri) VALUES ('XX','" + Global.NumEscri + "','XX','XX','XX');";
                    SQLiteCommand CMDin = new SQLiteCommand(SQLin, Global.conexion);
                    CMDin.ExecuteNonQuery();
                }
                RS.Close();
            }

            {   //protocolo
                SQLiteDataReader RS = null;//CONSULTA CONCEPTOS
                string SQL = "SELECT protocolo FROM escri_objeto WHERE protocolo='" + Global.Protocolo + "';";
                SQLiteCommand CMD = new SQLiteCommand(SQL, Global.conexion);
                RS = CMD.ExecuteReader();

                if (RS.HasRows == false)//INSERTAR SI NO EXISTE CONCEPTO
                {
                    RS.Close();
                    string SQLin = "INSERT INTO escri_objeto (objeto, num_escri, protocolo, secc, contri) VALUES ('XX','XX','" + Global.Protocolo + "','XX','XX');";
                    SQLiteCommand CMDin = new SQLiteCommand(SQLin, Global.conexion);
                    CMDin.ExecuteNonQuery();
                }
                RS.Close();
            }

            {   //secc
                SQLiteDataReader RS = null;//CONSULTA CONCEPTOS
                string SQL = "SELECT secc FROM escri_objeto WHERE secc='" + Global.SeccEscri + "';";
                SQLiteCommand CMD = new SQLiteCommand(SQL, Global.conexion);
                RS = CMD.ExecuteReader();

                if (RS.HasRows == false)//INSERTAR SI NO EXISTE CONCEPTO
                {
                    RS.Close();
                    string SQLin = "INSERT INTO escri_objeto (objeto, num_escri, protocolo, secc, contri) VALUES ('XX','XX','XX','" + Global.SeccEscri + "','XX');";
                    SQLiteCommand CMDin = new SQLiteCommand(SQLin, Global.conexion);
                    CMDin.ExecuteNonQuery();
                }
                RS.Close();
            }

            {   //contri
                SQLiteDataReader RS = null;//CONSULTA CONCEPTOS
                string SQL = "SELECT contri FROM escri_objeto WHERE contri='" + Global.Contri + "';";
                SQLiteCommand CMD = new SQLiteCommand(SQL, Global.conexion);
                RS = CMD.ExecuteReader();

                if (RS.HasRows == false)//INSERTAR SI NO EXISTE CONCEPTO
                {
                    RS.Close();
                    string SQLin = "INSERT INTO escri_objeto (objeto, num_escri, protocolo, secc, contri) VALUES ('XX','XX','XX','XX','" + Global.Contri + "');";
                    SQLiteCommand CMDin = new SQLiteCommand(SQLin, Global.conexion);
                    CMDin.ExecuteNonQuery();
                }
                RS.Close();
            }

            this.Close();
        }

        private void Objeto_Load(object sender, EventArgs e)
        {
            {//objeto
                SQLiteDataReader RS = null;
                string SQL = "SELECT DISTINCT (objeto) FROM escri_objeto;";
                SQLiteCommand CMD = new SQLiteCommand(SQL, Global.conexion);

                RS = CMD.ExecuteReader();

                if (RS.HasRows == true)
                {
                    while (RS.Read())
                    {
                        Txt_objeto.Items.Add(RS.GetString(0));
                    }

                }
                RS.Close();
            }

            {//num_escri
                SQLiteDataReader RS = null;
                string SQL = "SELECT DISTINCT (num_escri) FROM escri_objeto;";
                SQLiteCommand CMD = new SQLiteCommand(SQL, Global.conexion);

                RS = CMD.ExecuteReader();

                if (RS.HasRows == true)
                {
                    while (RS.Read())
                    {
                        Txt_NumEScr.Items.Add(RS.GetString(0));
                    }

                }
                RS.Close();
            }

            {//protocolo
                SQLiteDataReader RS = null;
                string SQL = "SELECT DISTINCT (protocolo) FROM escri_objeto;";
                SQLiteCommand CMD = new SQLiteCommand(SQL, Global.conexion);

                RS = CMD.ExecuteReader();

                if (RS.HasRows == true)
                {
                    while (RS.Read())
                    {
                        Txt_Protocolo.Items.Add(RS.GetString(0));
                    }

                }
                RS.Close();
            }

            {//secc
                SQLiteDataReader RS = null;
                string SQL = "SELECT DISTINCT (secc) FROM escri_objeto;";
                SQLiteCommand CMD = new SQLiteCommand(SQL, Global.conexion);

                RS = CMD.ExecuteReader();

                if (RS.HasRows == true)
                {
                    while (RS.Read())
                    {
                        Txt_Secc.Items.Add(RS.GetString(0));
                    }

                }
                RS.Close();
            }

            {//contri
                SQLiteDataReader RS = null;
                string SQL = "SELECT DISTINCT (contri) FROM escri_objeto;";
                SQLiteCommand CMD = new SQLiteCommand(SQL, Global.conexion);

                RS = CMD.ExecuteReader();

                if (RS.HasRows == true)
                {
                    while (RS.Read())
                    {
                        Txt_Contri.Items.Add(RS.GetString(0));
                    }

                }
                RS.Close();
            }
        }
    }
}