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

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

        private void mainBindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.MainBindingSource.EndEdit();
            this.TypeBindingSource.EndEdit();

            FilmDBDataSet.MainDataTable tabelChanges = FilmDBDataSet.Main.GetChanges(DataRowState.Added | DataRowState.Modified) as FilmDBDataSet.MainDataTable;
            if (tabelChanges != null)
            {
                MainTableAdapter.Update(tabelChanges);
            }

            TypeTableAdapter.Update(FilmDBDataSet.Type);
            StatusTableAdapter.Update(FilmDBDataSet.Status);

            FilmDBDataSet.MainDataTable tableDeletes = FilmDBDataSet.Main.GetChanges(DataRowState.Deleted) as FilmDBDataSet.MainDataTable;
            if (tabelChanges != tableDeletes)
            {
                MainTableAdapter.Update(tableDeletes);
            }

            FilmDBDataSet.AcceptChanges();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'FilmDBDataSet.Status' table. You can move, or remove it, as needed.
            this.StatusTableAdapter.Fill(this.FilmDBDataSet.Status);
            // TODO: This line of code loads data into the 'FilmDBDataSet.Type' table. You can move, or remove it, as needed.
            this.TypeTableAdapter.Fill(this.FilmDBDataSet.Type);
            // TODO: This line of code loads data into the 'filmDBDataSet.Main' table. You can move, or remove it, as needed.
            this.MainTableAdapter.Fill(this.FilmDBDataSet.Main);
        }
        private void MainBindingSource_AddingNew(object sender, AddingNewEventArgs e)
        {
            DataView dataTableView = MainBindingSource.List as DataView;
            DataRowView rowView = dataTableView.AddNew();

            rowView["ID"] = Guid.NewGuid();
            rowView["TypeID"] = (MainBindingSource.Current as DataRowView)["TypeID"];
            rowView["StatusID"] = (MainBindingSource.Current as DataRowView)["StatusID"];
            rowView["Name"] = "Name";
            rowView["Release"] = "0";

            e.NewObject = rowView;

            MainBindingSource.MoveLast();
        }

        private void statusBindingSource_AddingNew(object sender, AddingNewEventArgs e)
        {
            DataView dataTableView = StatusBindingSource.List as DataView;
            DataRowView rowView = dataTableView.AddNew();

            rowView["StatusID"] = Guid.NewGuid();
            rowView["Status"] = "";

            e.NewObject = rowView;

            StatusBindingSource.MoveLast();
        }

        private void mainDataGridView_DataError(object sender, DataGridViewDataErrorEventArgs e)
        {
            if (e.Exception is NoNullAllowedException)
            {
            }
            else
            {
                e.ThrowException = true;
            }
        }

        private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
        {

        }
    }
}