[HaBo]

using System;
using System.Windows.Forms;
using SoundConductor.Common.Helper;
using System.Data;
using System.Data.SQLite ;

namespace SoundConductor.forms
{
    public partial class frmTableEditor : Form
    {
        DataHelper db = new DataHelper();
        SQLiteDataAdapter daTable = new SQLiteDataAdapter();
        DataSet dsTables = new DataSet();
        DataSet dsTableContent = new DataSet();

        private string tableName = "";
        private bool showID = false;
        private bool showTables = false;

        public bool ShowTables
        {
            get { return showTables; }
            set { showTables = value; }
        }

        public bool ShowID
        {
            get { return showID; }
            set { showID = value; }
        }

        public string TableName
        {
            set { tableName = value; }
        }

        public frmTableEditor()
        {
            InitializeComponent();
        }

        private void frmTableEditor_Load(object sender, EventArgs e)
        {
            try
            {
                if (showTables == false)
                {
                    dgvTableContent.Dock = DockStyle.Fill;
                    this.Text = string.Format(this.Text, tableName);

                    daTable = db.GetTable(this.tableName);
                    daTable.Fill(dsTables);

                    //set the DataGridView DataSource
                    dgvTableContent.DataSource = dsTables.Tables[0];
                    dgvTableContent.Columns["ID"].Visible = this.showID;
                }
                else
                {
                    dgvTableContent.Dock = DockStyle.None;
                    DataSet Tables = db.GetTables();
                    if (Tables.Tables.Count > 0)
                    {
                        cboTables.DataSource = Tables.Tables[0];
                        cboTables.DisplayMember = "name";
                        cboTables.Refresh();
                    }
                }

                lblAttention.Visible = showTables;
                lblTables.Visible = showTables;
                cboTables.Visible = showTables;
                //btnGo.Visible = showTables;
                
                
            }
            catch (Exception ex)
            {
                DebugHelper.WriteToLog(ex.Message);
            }
        }

        private void btnSaveData_Click(object sender, EventArgs e)
        {

        }
      
        private void dgvTableContent_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                //dgvTableContent.EndEdit();
                daTable.Update(dsTableContent); 
            }
            catch (Exception ex)
            {
                DebugHelper.WriteToLog(ex.Message);
            }
        }

        private void btnDeleteRow_Click(object sender, EventArgs e)
        {
            try
            {
                dgvTableContent.Rows.RemoveAt(dgvTableContent.SelectedRows[0].Index);
                daTable.Update(dsTableContent);
            }
            catch (Exception ex)
            {
                DebugHelper.WriteToLog(ex.Message.ToString());
            }
        }

        private void cboTables_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                this.Text = string.Format(this.Text, cboTables.Text);

                dsTableContent.Clear();
                dsTableContent.Dispose();
                dsTableContent = new DataSet();

                daTable = db.GetTable(cboTables.Text);
                daTable.Fill(dsTableContent);

                dgvTableContent.AutoGenerateColumns = true;
                dgvTableContent.DataSource = dsTableContent.Tables[0];

                dgvTableContent.Columns["ID"].Visible = this.showID;
                dgvTableContent.Refresh();
                dgvTableContent.Update();
            }
            catch (Exception ex)
            {
                DebugHelper.WriteToLog(ex.Message.ToString());
            }
        }
    }
}