using System;
using System.Windows.Forms;

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

			//Загружаем список таблиц в comboBox
			comboBox1.Items.Clear();
			foreach(String[] line in Database.getTablesList().data){
				comboBox1.Items.Add(line[0]);
			}
			comboBox1.SelectionChangeCommitted += (object sender, EventArgs e) => loadTable(comboBox1.Text);

			//Кнопка запроса
			queryBtn.Click += (object sender, EventArgs e) => {
				try{
					comboBox1.SelectedIndex = -1;
					clearTable();
					setTableData(Database.query(textBox1.Text));
				}catch(Exception ex){
					MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly, false);
				}
			};

			//Кнопка редактирования
			editBtn.Click += (object sender, EventArgs e) => {
				if(dataGridView1.CurrentRow == null){
					MessageBox.Show("Сначала выберите строку для редактирования", "Ошибка");
					return;
				}
				Form2 form = new Form2(currentTable.columns);

				foreach(DataGridViewCell cell in dataGridView1.CurrentRow.Cells){
					TextBox field = form.getElementForField(cell.OwningColumn.HeaderText);
					if(field != null){
						field.Text = cell.Value as String;
					}
				}

				form.button.Text = "Сохранить изменения";
				form.button.Click += (object sndr, EventArgs ea) => {
					try{
					Database.updateData(comboBox1.Text, currentTable.columns, dataGridView1.CurrentRow, form.getValues());
					}catch(Exception ex){
						MessageBox.Show(ex.Message, "Ошибка");
					}
					form.Hide();
					loadTable(comboBox1.Text);
				};

				form.Show();
			};

			//Кнопка добавления
			addBtn.Click += (object sender, EventArgs e) => {
				Form2 form = new Form2(currentTable.columns);

				form.button.Text = "Добавить запись";
				form.button.Click += (object sndr, EventArgs ea) => {
					try{
						Database.insertData(comboBox1.Text, currentTable.columns, form.getValues());
					}catch(Exception ex){
						MessageBox.Show(ex.Message, "Ошибка");
					}
					form.Hide();
					loadTable(comboBox1.Text);
				};

				form.Show();
			};

			//Кнопка удаления
			delBtn.Click += (object sender, EventArgs e) => {
				if(dataGridView1.CurrentRow == null){
					MessageBox.Show("Сначала выберите строку для удаления", "Ошибка");
					return;
				}
				try{
					Database.deleteData(comboBox1.Text, currentTable.columns, dataGridView1.CurrentRow);
				}catch(Exception ex){
					MessageBox.Show(ex.Message, "Ошибка");
				}
			};

		}

		public void loadTable(String tableName){
			textBox1.Text = "SELECT * FROM `"+tableName+"`";

			clearTable();
			setTableData(Database.query(textBox1.Text));

			addBtn.Enabled = true;
			editBtn.Enabled = true;
			delBtn.Enabled = true;
		}

		private QueryResult currentTable = null;

		public void clearTable(){
			dataGridView1.Columns.Clear();
			dataGridView1.Rows.Clear();
			currentTable = null;

			addBtn.Enabled = false;
			editBtn.Enabled = false;
			delBtn.Enabled = false;
		}

		public void setTableData(QueryResult table){

			clearTable();

			foreach(String columnName in table.columns.Keys){
				DataGridViewColumn column = new DataGridViewTextBoxColumn();
				column.HeaderText = columnName;
				dataGridView1.Columns.Add(column);
			}

			foreach(String[] line in table.data){
				dataGridView1.Rows.Add(line);
			}

			currentTable = table;
		}

	}