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

namespace Hopprenn
{
    public partial class Form1 : Form
    {
        public DBConnection dbAPI = new DBConnection();

        public List<JUMPER> listHopper = new List<JUMPER>();
        public SortedList<Int32, TEST1> listTEST1 = new SortedList<Int32, TEST1>();

        public Form1()
        {
            InitializeComponent();


            DataTable datatableResultat = dbAPI.DBGetResultat("FIGMSSQL01", "hermes", "hermes", "Whydfml2010");

            DataTable datatableHopp = dbAPI.DBGetHopprenn("FIGMSSQL01", "hermes", "hermes", "Whydfml2010");

            buildlistTEST1(datatableResultat);
            buildlistHopper(datatableHopp);

            buildlistListviewMain(listTEST1);
        }

        private void buildlistTEST1(DataTable datatable)
        {
            if (datatable != null && datatable.Rows.Count > 0)
            {
                foreach (DataRow dr in datatable.Rows)
                {
                    TEST1 record = new TEST1(dr);
                    if (!listTEST1.ContainsKey(record.plassering))
                        listTEST1.Add(record.plassering, record);
                }
            }
        }

        private void buildlistHopper(DataTable datatable)
        {
            if (datatable != null && datatable.Rows.Count > 0)
            {
                foreach (DataRow dr in datatable.Rows)
                {
                    JUMPER record = new JUMPER(dr);
                    listHopper.Add(record);
                }
            }
        }

        private void buildlistListviewMain(SortedList<Int32, TEST1> sortedlist)
        {
            listView1.Items.Clear();

            for (int i = 1; i <= sortedlist.Count; i++)
            {
                String[] ColumnArray = new String[] { sortedlist[i].startnummer.ToString(),
                                                      sortedlist[i].etternavn.ToString(),
                                                      sortedlist[i].fornavn.ToString(),
                                                      sortedlist[i].land.ToString(),
                                                      sortedlist[i].poengsum.ToString(),
                                                      sortedlist[i].plassering.ToString()
                                                    };
                ListViewItem lvItem = new ListViewItem(ColumnArray);
                listView1.Items.Add(lvItem);
            }
        }

   /*     private void buildlistListviewDetail(Int32 startnr)
        {
            listView2.Items.Clear();

            for (int i = 0; i < listHopper.Count; i++)
            {
                if (Convert.ToInt32(listHopper[i].startnummer) == startnr)
                {
                    String[] ColumnData = new String[listView2.Columns.Count];

                    ColumnData[0] = listHopper[i].hopplengde.ToString();
                    ColumnData[1] = listHopper[i].dommerA.ToString();
                    ColumnData[2] = listHopper[i].dommerB.ToString();
                    ColumnData[3] = listHopper[i].dommerC.ToString();
                    ColumnData[4] = listHopper[i].dommerD.ToString();
                    ColumnData[5] = listHopper[i].dommerE.ToString();
                    ColumnData[6] = listHopper[i].poengsum.ToString();

                    ListViewItem lvItem = new ListViewItem(ColumnData);
                    listView2.Items.Add(lvItem);

                }
            }
        }
*/
        private void button1_Click(object sender, EventArgs e)
        {

            listView2.Items.Clear();
            panel2.Visible = false;


        }



        private void informasjonToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (panel1.Visible == false)
                panel1.Visible = true;
            else
                panel1.Visible = false;
        }

        private void avsluttToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            Close();
        }
    }
}