using System;
using System.Windows.Forms;
using System.Xml.Linq;

namespace _25_Wiesinger
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();

            dataSet21.Clear();
            sqlDataAdapter2.Fill(dataSet21);
        }

        //INSERT INTO dbo.CD (ID, TITLE, ARTIST, COUNTRY, COMPANY, PRICE, YEAR) values (5, 'Eros', 'Eros Ramazzotti', 'EU', 'BMG', 9.90, 1997);
        private void RecreateButton_Click(object sender, EventArgs e)
        {
            using (OpenFileDialog openFileDialog = new OpenFileDialog())
            {
                    if (openFileDialog.ShowDialog() == DialogResult.OK)
                    {
                        string filePath = openFileDialog.FileName;
  
                        dataSet21.Clear();
                        sqlDataAdapter2.Update(dataSet21);
                       
                        sqlRecreate.Connection.Open();
                        sqlRecreate.ExecuteNonQuery();
                        sqlRecreate.Connection.Close();
                        dataSet21.ReadXml(filePath, System.Data.XmlReadMode.IgnoreSchema);
                        sqlDataAdapter2.Update(dataSet21);
                    
                }
            }
        }

        private void UpdateButton_Click(object sender, EventArgs e)
        {
            dataSet11.Clear();
            sqlDataAdapter2.Fill(dataSet21);
        }
        
        private void DeleteButton_Click(object sender, EventArgs e)
        {
                foreach (DataGridViewRow selectedRow in dataGridView1.SelectedRows)
                {
                    if (selectedRow.Index < dataSet21.CD.Rows.Count)
                        dataSet21.CD.Rows[selectedRow.Index].Delete();
                }

                sqlDataAdapter2.Update(dataSet21);
        }

        private void DataGridView1_RowLeave(object sender, EventArgs e)
        {
            sqlDataAdapter2.Update(dataSet21);
        }

    }
}