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 RRCAG.Business;
using RRCAG.Data;
using System.Data.OleDb;

namespace Assignment8
{
    public partial class frmVehicleData : Form
    {
        private OleDbDataAdapter _dataAdapter;
        private DataSet _dataSet;
        private BindingSource _bind;
        private OleDbCommandBuilder _commandBuilder;

        public frmVehicleData()
        {
            InitializeComponent();
            LoadData();


            this.Load += FrmVehicleData_Load;
            dgvVehicleData.SelectionChanged += DgvVehicleData_SelectionChanged;
            dgvVehicleData.CellValueChanged += DgvVehicleData_CellValueChanged;
            mnuDelete.Click += MnuDelete_Click;
            mnuSave.Click += MnuSave_Click;
            mnuClose.Click += MnuClose_Click;
            this.FormClosing += FrmVehicleData_FormClosing;

        }

        private void MnuClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void MnuSave_Click(object sender, EventArgs e)
        {
            try
            {
                dgvVehicleData.EndEdit();
                _bind.EndEdit();
                _dataAdapter.Update(_dataSet, "VehicleStock");
                this.Text = "Vehicle Data";
                mnuSave.Enabled = false;
            }
            catch (Exception ex)
            {
                MessageBox.Show("An error occured while saving the changes to the vehicle data", "Save Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

                //MessageBox.Show(ex.Message);

            }
        }

        private void FrmVehicleData_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (mnuSave.Enabled)
            {
                DialogResult dialog = MessageBox.Show("Do you wish to save the changes?", "Save", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button3);

                if (dialog == DialogResult.Cancel)
                {
                    e.Cancel = true;
                }

                else if (dialog == DialogResult.Yes)
                {
                    try
                    {
                        dgvVehicleData.EndEdit();
                        _bind.EndEdit();
                        _dataAdapter.Update(_dataSet, "VehicleStock");
                    }
                    catch
                    {
                        DialogResult result = MessageBox.Show("An error occured while saving the changes. Do you still wish to close this window?", "Save Error", MessageBoxButtons.YesNo, MessageBoxIcon.Error, MessageBoxDefaultButton.Button2);
                    }
                }
            }
        }

        private void MnuDelete_Click(object sender, EventArgs e)
        {
            DialogResult dialog = MessageBox.Show("Are you sure you want to permanently delete stock item " + dgvVehicleData.Rows[dgvVehicleData.SelectedCells[0].RowIndex].Cells[1].Value.ToString() , "Delete Stock Item", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2);

            try
            {
                if (dialog == DialogResult.Yes)
                {
                    dgvVehicleData.Rows.RemoveAt(dgvVehicleData.CurrentRow.Index);
                    _dataAdapter.Update(_dataSet, "VehicleStock");
                    mnuDelete.Enabled = false;
                }
            }
            catch
            {
                DialogResult result = MessageBox.Show("An error occured while deleting the the selected vehicle", "Deletion Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }


        }

        private void DgvVehicleData_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            this.Text = "* Vehicle Data";
            mnuSave.Enabled = true;
        }

        private void DgvVehicleData_SelectionChanged(object sender, EventArgs e)
        {
            if (dgvVehicleData.CurrentRow.Selected && !dgvVehicleData.CurrentRow.IsNewRow)
            {
                mnuDelete.Enabled = true;
            }
        }

        private void FrmVehicleData_Load(object sender, EventArgs e)
        {
            _bind.DataSource = _dataSet.Tables["VehicleStock"];
            dgvVehicleData.DataSource = bind;
            dgvVehicleData.Columns["ID"].Visible = false;


        }

        private void LoadData()
        {
            OleDbConnection _myConnection = new OleDbConnection();
            _myConnection.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = AMDatabase.mdb";
            _myConnection.Open();
            OleDbCommand _myCommand = new OleDbCommand();
            _myCommand.CommandText = "SELECT * FROM VehicleStock";
            _myCommand.Connection = _myConnection;
            _dataAdapter = new OleDbDataAdapter();
            _dataAdapter.SelectCommand = _myCommand;
            _dataSet = new DataSet();
            dataAdapter.Fill(_dataSet, "VehicleStock");
            _bind = new BindingSource();
            _commandBuilder = new OleDbCommandBuilder();
            _commandBuilder.DataAdapter = _dataAdapter;
        }
    }
}