connection

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.OleDb;

namespace repairs
{
    internal class Connection
    {
        OleDbConnection connect;
        OleDbCommand command;
        List<String> id = new List<String>();
        List<String> reg = new List<String>();
        List<String> make = new List<String>();
        List<String> color = new List<String>();
        List<String> year = new List<String>();
        List<String> seats = new List<String>();
        List<String> price = new List<String>();
        List<String> model = new List<String>();
        private void connectionTo()
        {
            //connect = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\TCP PROJECT\repairs.accdb");
            connect = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\TCP PROJECT\repairs\repairs\repairs.accdb");
            command = connect.CreateCommand();
        }
        public Connection()
        {
           connectionTo();
            //('1', '1', '1', 1, 1, 1, '1')";;
        }
        public void insert(Car car)
        {
            try
            {
                command.CommandText = "Insert into Car([Reg_number], [Car_make], [Car_color], Car_year, Car_seats, Repair_price, [Car_model]) Values('"+
                    car.Reg_number + "','" + car.Car_make + "','" + car.Car_color + "'," + car.Car_year + "," + car.Car_seats + "," + car.Repair_price + ",'" + car.Car_model +
                  "')";
                command.CommandType = System.Data.CommandType.Text;
                connect.Open();
                command.ExecuteNonQuery();
            }
            catch (Exception)
            {
                System.Windows.Forms.MessageBox.Show("Incorrect data.");
            }
            finally {
                if (connect != null){
                    connect.Close();
                }
            }
        }
        public void updateCar(Car car)
        {
            try
            {
                 command.CommandText = "UPDATE Car SET Reg_number = '" + car.Reg_number + "', Car_make = '" + car.Car_make + "', Car_color = '" + car.Car_color +
                   "', Car_year = '" + car.Car_year + "', Car_seats = '" + car.Car_seats + "', Repair_price = '" + car.Repair_price + "', Car_model = '" + car.Car_model + "' Where Car_id=" +car.Car_id;
                // command.CommandText =  "UPDATE Car SET Reg_number = '" + car.Reg_number + "' WHERE Car_id = " + car.Car_id;
                command.CommandType = System.Data.CommandType.Text;
                connect.Open();
                command.ExecuteNonQuery();
            }
            catch (Exception)
            {
                System.Windows.Forms.MessageBox.Show("Incorrect data.");
            }
            finally
            {
                if (connect != null)
                {
                    connect.Close();
                }
            }

        }
        public void deleteCar(Car car)
        {

            try
            {
                command.CommandText = "Delete  From Car WHERE  Car_id=" + car.Car_id;
                // command.CommandText =  "UPDATE Car SET Reg_number = '" + car.Reg_number + "' WHERE Car_id = " + car.Car_id;
                command.CommandType = System.Data.CommandType.Text;
                connect.Open();
                command.ExecuteNonQuery();
            }
            catch (Exception)
            {
                System.Windows.Forms.MessageBox.Show("Incorrect data.");
            }
            finally
            {
                if (connect != null)
                {
                    connect.Close();
                }
            }

        }


    }
}