TSP

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace PROBKONTROL
{
    class Conn
    {

        OleDbConnection connection;
        OleDbCommand command;
        private void ConnectTo()
        {
            connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\student\Documents\Database4.accdb");
            command = connection.CreateCommand();
        }
        public Conn()
        {
            ConnectTo();
        }

        public void Insert(Kniga k)
        {

            try
            {

                command.CommandText = "INSERT INTO Knigi(IDKniga, [zaglavie], [avtor], godinaizdavane, [zhanr]) VALUES (" + k.IDKniga + "," + "'" + k.zaglavie + "'" + "," + "'" + k.Avtor + "'" + "," + k.GodinaIzdavane + "," + "'" + k.Janr + "'" + ")";
                command.CommandType = CommandType.Text;
                connection.Open();
                command.ExecuteNonQuery();
            }

            catch (Exception)
            {

                MessageBox.Show("Nekorektni danni!!!");
            }
            finally
            {
                if (connection != null)
                {
                    connection.Close();
                }

            }

        }



        public void Update(Kniga k)
        {

            try
            {

                command.CommandText = "UPDATE Knigi SET [zaglavie] = " + "'" + k.zaglavie + "'" + ", [avtor] = " + "'" + k.avtor + "'" + ", godinaizdavane=" + k.godinaizdavane + ", [zhanr] =" + "'" + k.zhanr + "'" + " WHERE IDKniga= " + k.IDKniga;
                command.CommandType = CommandType.Text;
                connection.Open();
                command.ExecuteNonQuery();
            }

            catch (Exception)
            {

                MessageBox.Show("Nekorektni danni!!!");
            }
            finally
            {
                if (connection != null)
                {
                    connection.Close();
                }

            }

        }



        public void Delete(Kniga k)
        {

            try
            {

                command.CommandText = "DELETE FROM Knigi WHERE IDKniga =" + k.IDKniga;
                command.CommandType = CommandType.Text;
                connection.Open();
                command.ExecuteNonQuery();
            }

            catch (Exception)
            {

                MessageBox.Show("Nekorektni danni!!!");
            }
            finally
            {
                if (connection != null)
                {
                    connection.Close();
                }

            }

        }






    }

}