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

namespace Job1
{
    public partial class Form1 : Form
    {
        List<int> cityId = new List<int>();
        List<string> cityName = new List<string>();
        List<int> customerId = new List<int>();
        List<string> customerName = new List<string>();
        List<int> productId = new List<int>();
        List<string> productDes = new List<string>();

        public Form1()
        {
            InitializeComponent();
            //initilize pineValleyDB
            SqlConnection pineValleyDB = new SqlConnection("Data Source=(local);Initial Catalog=pineValleyDB;Integrated Security=True");
            pineValleyDB.Open();
            SqlCommand getIdCmd = new SqlCommand("SELECT ID from CITY_t", pineValleyDB);
            SqlCommand getCityNameCmd = new SqlCommand("SELECT CITY from CITY_t", pineValleyDB);
            SqlCommand getCustomerIdCmd = new SqlCommand("SELECT Customer_id from Customer_t", pineValleyDB);
            SqlCommand getCustomerNameCmd = new SqlCommand("SELECT Customer_Name from Customer_t", pineValleyDB);
            SqlCommand getProductIdCmd = new SqlCommand("SELECT Product_id from Product_t", pineValleyDB);
            SqlCommand getProductDesCmd = new SqlCommand("SELECT Product_Description from Product_t", pineValleyDB);

            SqlDataReader reader = getCityNameCmd.ExecuteReader();
            int i = 0;
            while (reader.Read())
            {
                int a = reader.GetOrdinal("CITY");
                cityName.Add(reader.GetString(a));
                listBox1.Items.Add(cityName[i]);
                i++;
            }
            reader.Close();

            reader = getIdCmd.ExecuteReader();
            i = 0;
            while (reader.Read())
            {
                int a = reader.GetOrdinal("ID");
                cityId.Add(reader.GetInt32(a));
                i++;
            }
            reader.Close();

            reader = getCustomerNameCmd.ExecuteReader();
            i = 0;
            while (reader.Read())
            {
                int a = reader.GetOrdinal("Customer_Name");
                customerName.Add(reader.GetString(a));
                listBox2.Items.Add(customerName[i]);
                i++;
            }
            reader.Close();

            reader = getCustomerIdCmd.ExecuteReader();
            i = 0;
            while (reader.Read())
            {
                int a = reader.GetOrdinal("Customer_id");
                customerId.Add((int)reader.GetDecimal(a));
                i++;
            }
            reader.Close();

            reader = getProductDesCmd.ExecuteReader();
            i = 0;
            while (reader.Read())
            {
                int a = reader.GetOrdinal("Product_Description");
                productDes.Add(reader.GetString(a));
                listBox3.Items.Add(productDes[i]);
                i++;
            }
            reader.Close();

            reader = getProductIdCmd.ExecuteReader();
            i = 0;
            while (reader.Read())
            {
                int a = reader.GetOrdinal("Product_id");
                productId.Add((int)reader.GetDecimal(a));
                i++;
            }
            reader.Close();
            pineValleyDB.Close();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            textBox2.Text = (int.Parse(textBox1.Text.ToString()) + cityId[listBox1.SelectedIndex]).ToString();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            textBox3.Text = (int.Parse(textBox2.Text.ToString()) * 3).ToString();
        }

        private void button22_Click(object sender, EventArgs e)
        {
            textBox22.Text = (int.Parse(textBox21.Text.ToString()) + customerId[listBox2.SelectedIndex]).ToString();
        }

        private void button23_Click(object sender, EventArgs e)
        {
            textBox23.Text = (int.Parse(textBox22.Text.ToString()) * 3).ToString();
        }

        private void button32_Click(object sender, EventArgs e)
        {
            textBox32.Text = (int.Parse(textBox31.Text.ToString()) + productId[listBox2.SelectedIndex]).ToString();
        }

        private void button33_Click(object sender, EventArgs e)
        {
            textBox33.Text = (int.Parse(textBox32.Text.ToString()) * 3).ToString();
        }

        public string pinGen()
        {
            return textBox3.Text.ToString() + "-" + textBox23.Text.ToString() + "-" + textBox33.Text.ToString();
        }

        private void button100_Click(object sender, EventArgs e)
        {
            textBox100.Text = pinGen();
        }

        private void generatePinToolStripMenuItem_Click(object sender, EventArgs e)
        {
            textBox100.Text = pinGen();
        }

    }
}