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

namespace WindowsFormsApplication1
{
    public partial class form2 : Form
    {
        int m_selectedIndex;

        //string[] queries = { "NumeReclama", "CategReclama" };
        //Implementarea Queriurilor se face aici!
        string[][] m_tables = {
                                  new string[]{"NumeReclama"},
                                  new
private   int p1;
private   int p2;

public    form2(int p1,int p2)
    {
        // TODO: Complete member initialization
this.p1 = p1;
this.p2 = p2;
    }                             new string[]{"CategReclama"}
                                  new string[]{"NumeReclama", "NrPagina" }
                                  new string[]{"NumeRevista","CategRevista","Editie"}
                                  new string[]{"NumeReclama","VarstaAudienta"}
                                  new string[]{"NumeReclama","MarimeReclama"}

                                  new string[]{"NumeRevista", "NrReviste"},
                                  new string[]{"NumeReclama","IDPagina"},
                                  new string[]{"NumeRevista"},
                                  new string[]{"VarstaAudienta","SexAudienta"}
                              };
        string[] m_queries = {
                                  "SELECT NumeReclama FROM Reclama",
                                  "SELECT CategReclama FROM Reclama",
                                  "SELECT r.NumeReclama,p.NrPagina FROM Pagina p JOIN PaginaReclama rp ON p.IDPagina=rp.IDPagina JOIN Reclama r ON r.IDReclama=rp.IDReclama",
                                  "SELECT NumeRevista,CategRevista,Editie FROM Revista ORDER BY Editie",
                                  "SELECT NumeReclama,VarstaAudienta FROM Reclama r JOIN Audienta a ON r.IDReclama=a.IDReclama",
                                  "SELECT NumeReclama,MarimeReclama FROM Reclama ORDER BY MarimeReclama",
                                    //Interogari simple
                                  "SELECT r.NumeRevista,(SELECT COUNT (*) FROM PaginaReclama pr ,Reclama r,Pagina p,Revista re WHERE r.IDReclama=pr.IDReclama AND p.IDPagina=pr.IDPagina AND re.IDRevista=p.IDRevista)AS NrReviste  FROM Revista r WHERE r.NumeRevista='Forbes'",
                                  "SELECT r.NumeReclama,p.IDPagina FROM Pagina p,Reclama r,PaginaReclama rp WHERE p.IDPagina=rp.IDPagina AND r.IDReclama=rp.IDReclama AND p.IDPagina='4'",
                                  "SELECT NumeRevista FROM Revista WHERE IDRedactie=(SELECT IDRedactie FROM Redactie WHERE NumeRedactie='Antena')",
                                  "SELECT VarstaAudienta,SexAudienta FROM Audienta WHERE IDAudienta=(SELECT IDAudienta FROM Reclama WHERE CategReclama='IT' GROUP BY CategReclama ) "
                                    //Interogari complexe
                             };

        public form2(int i_comboNumber, int i_selectedIndex)
        {
            InitializeComponent();

            m_selectedIndex = i_selectedIndex + (i_comboNumber - 1) * 6;
                //Conexiunea cu baza de date
            string connString = "Data Source=.;Initial Catalog=Gestionare;Integrated Security=True";
            using (SqlConnection con = new SqlConnection(connString))
            {
                con.Open();
                string query = m_queries[m_selectedIndex];
                using(SqlCommand cmd= new SqlCommand(query, con)){
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            string result = String.Empty;

                            for (int i = 0; i < m_tables[m_selectedIndex].Length; i++)
                            {
                                result += reader[m_tables[m_selectedIndex][i]];
                                result += " ";
                            }

                            listBoxData.Items.Add(result);
                        }
                    }
                }
            }
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            this.Close();
        }


    }
}