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;

namespace WindowsFormsApp6
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            FormLogin f = new FormLogin();
            if (f.ShowDialog() == DialogResult.OK)
            {
                InitializeComponent();
                tableTableAdapter.Fill(bazadedate5DataSet.Table); //pus pt ca sa ramana tot timpul de baza de date de aceea se pun
                calculatoareListBox.Items.Clear();
                foreach (DataRowView drv in tableBindingSource.List)
                {
                    calculatoareListBox.Items.Add("Producator:" + drv["Producator"].ToString() + " Model:" + drv["Model"].ToString() + " Garantie:" + drv["Garantie"].ToString() + " Cantitate:" + drv["Cantitate"].ToString() + " Pret:" + drv["Pret"].ToString());
                }
            }
        }

        private void tableBindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.tableBindingSource.EndEdit();
            this.tableAdapterManager.UpdateAll(this.bazadedate5DataSet);

        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'bazadedate5DataSet.Table' table. You can move, or remove it, as needed.
            this.tableTableAdapter.Fill(this.bazadedate5DataSet.Table);

        }

        private void adaugaButton_Click(object sender, EventArgs e)
        {
            errorProvider1.Clear();
            if (pretTextBox.Text.ToString() == "")
            {
                errorProvider1.SetError(pretTextBox, "Pretul trebuie completat");
            }
            else
            {
                tableTableAdapter.Insert(producatorTextBox.Text, modelTextBox.Text, Int32.Parse(garantieComboBox.Text), Int32.Parse(cantitateNumericUpDown.Text), double.Parse(pretTextBox.Text));
                // Salvarea datelor
                tableAdapterManager.UpdateAll(bazadedate5DataSet);
                // Reincarcarea datelor
                tableTableAdapter.Fill(bazadedate5DataSet.Table);
                //upDATE IN BAZA DE DATE
                calculatoareListBox.Items.Clear();
                foreach (DataRowView drv in tableBindingSource.List)
                {
                    calculatoareListBox.Items.Add("Producator:" + drv["Producator"].ToString() + " Model:" + drv["Model"].ToString() + " Garantie:" + drv["Garantie"].ToString() + " Cantitate:" + drv["Cantitate"].ToString() + " Pret:" + drv["Pret"].ToString());
                }
            }
        }

        private void ordonarePretButton_Click(object sender, EventArgs e)
        {
            List<Calculator> lista = new List<Calculator>();
            foreach (DataRowView drv in tableBindingSource.List)
            {
                Calculator c = new Calculator(drv["Producator"].ToString(), drv["Model"].ToString(), Int32.Parse(drv["Garantie"].ToString()), Int32.Parse(drv["Cantitate"].ToString()), float.Parse(drv["Pret"].ToString()));
                lista.Add(c);
            }
            calculatoareOrdonateListBox.Items.Clear();
            lista.Sort((x, y) => x.Pret.CompareTo(y.Pret));
            foreach (Calculator c in lista)
            {
                calculatoareOrdonateListBox.Items.Add("Producator:" + c.Producator + " Model:" + c.Model + " Garantie:" + c.Garantie + " Cantitate:" + c.Cantitate + " Pret:" + c.Pret);
            }
        }

        private void ordonareGarantieButton_Click(object sender, EventArgs e)
        {
            List<Calculator> lista = new List<Calculator>();
            foreach (DataRowView drv in tableBindingSource.List)
            {
                Calculator c = new Calculator(drv["Producator"].ToString(), drv["Model"].ToString(), Int32.Parse(drv["Garantie"].ToString()), Int32.Parse(drv["Cantitate"].ToString()), float.Parse(drv["Pret"].ToString()));
                lista.Add(c);
            }
            calculatoareOrdonateListBox.Items.Clear();
            lista.Sort((x, y) => x.Garantie.CompareTo(y.Garantie));
            foreach (Calculator c in lista)
            {
                calculatoareOrdonateListBox.Items.Add("Producator:" + c.Producator + " Model:" + c.Model + " Garantie:" + c.Garantie + " Cantitate:" + c.Cantitate + " Pret:" + c.Pret);
            }
        }

        private void afisareCantitateButton_Click(object sender, EventArgs e)
        {
            List<Calculator> lista = new List<Calculator>();
            foreach (DataRowView drv in tableBindingSource.List)
            {
                Calculator c = new Calculator(drv["Producator"].ToString(), drv["Model"].ToString(), Int32.Parse(drv["Garantie"].ToString()), Int32.Parse(drv["Cantitate"].ToString()), float.Parse(drv["Pret"].ToString()));
                lista.Add(c);
            }
            calculatoareOrdonateListBox.Items.Clear();
            foreach (Calculator c in lista)
            {
                if(c.Cantitate==Int32.Parse(afisareCantitateComboBox.Text.ToString()))
                     calculatoareOrdonateListBox.Items.Add("Producator:" + c.Producator + " Model:" + c.Model + " Garantie:" + c.Garantie + " Cantitate:" + c.Cantitate + " Pret:" + c.Pret);
            }
        }

        private void stergeButton_Click(object sender, EventArgs e)
        {
            string aux = calculatoareListBox.SelectedItem.ToString().Substring(11);
            string [] aux2 = aux.Split(' ');
            aux = aux2[0];
            foreach (DataRowView drv in tableBindingSource.List)
            {
                if (drv["Producator"].ToString() == aux)
                {
                    drv.Delete();
                    // Salvarea datelor
                    tableAdapterManager.UpdateAll(bazadedate5DataSet);
                    // Reincarcarea datelor
                    tableTableAdapter.Fill(bazadedate5DataSet.Table);
                }
            }
            calculatoareListBox.Items.Clear();
            foreach (DataRowView drv in tableBindingSource.List)
            {
                calculatoareListBox.Items.Add("Producator:" + drv["Producator"].ToString() + " Model:" + drv["Model"].ToString() + " Garantie:" + drv["Garantie"].ToString() + " Cantitate:" + drv["Cantitate"].ToString() + " Pret:" + drv["Pret"].ToString());
            }
        }
    }
}