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 FirebirdSql.Data.FirebirdClient;
using MFC_Statistica;

namespace Test
{
    public partial class Form1 : Form
    {
        
        FbDataAdapter fbDataAdapter = new FbDataAdapter();
        BindingSource bindingSource = new BindingSource();
        DataTable table = new DataTable();
        FbConnection fbConnect = new FbConnection(FireBird.fbConnectionString.ToString());

        public Form1()
        {
            InitializeComponent();

            fbDataAdapter.SelectCommand = new FbCommand("Select id, name, path From spr_mfc", fbConnect);
            fbDataAdapter.InsertCommand = new FbCommand("Insert Into spr_mfc (name, path) Values (@NAME, @PATH)", fbConnect);
            fbDataAdapter.UpdateCommand = new FbCommand("Update spr_mfc SET name = @NAME, path = @PATH where id = @ID", fbConnect);
            fbDataAdapter.DeleteCommand = new FbCommand("Delete From spr_mfc where id = @ID", fbConnect);

            fbDataAdapter.InsertCommand.Parameters.Add("@NAME", FbDbType.VarChar, 150, "name");
            fbDataAdapter.InsertCommand.Parameters.Add("@PATH", FbDbType.VarChar, 70, "path");

            fbDataAdapter.UpdateCommand.Parameters.Add("@NAME", FbDbType.VarChar, 150, "name");
            fbDataAdapter.UpdateCommand.Parameters.Add("@PATH", FbDbType.VarChar, 70, "path");
            fbDataAdapter.UpdateCommand.Parameters.Add("@ID", FbDbType.Integer, 5, "id");

            fbDataAdapter.DeleteCommand.Parameters.Add("@ID", FbDbType.Integer, 5, "id");

            fbDataAdapter.Update(table);
            table.AcceptChanges();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            fbDataAdapter = new FbDataAdapter("select id, name, path from spr_mfc", FireBird.fbConnectionString.ToString());
            FbCommandBuilder fbCommand = new FbCommandBuilder(fbDataAdapter);

            fbDataAdapter.Fill(table);
            bindingSource.DataSource = table;
            gridControl1.DataSource = bindingSource;
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            table.Rows[table.Rows.Count-1].SetField("name", "name1");
            table.Rows[table.Rows.Count-1].SetField("path", "path1");
            fbDataAdapter.Update((DataTable)bindingSource.DataSource);

        }
    }
}