private void button22_Click(object sender, EventArgs e)
        {
            VehicleRepositoryDB cltdb = new VehicleRepositoryDB();
            List <VehicleRep>   cltrp = cltdb.GetAllVehicle();

            this.dataGridView3.DataSource = cltrp;
        }
        private void vecView(object sender, EventArgs e)
        {
            groupBox5.Hide();

            dateTimePicker3.Text = DateTime.Now.ToString("dd/MM/yyyy");
            VehicleRepositoryDB cltdb = new VehicleRepositoryDB();
            List <VehicleRep>   cltrp = cltdb.GetAllVehicle();

            this.dataGridView3.DataSource = cltrp;

            vehicleShow.Dock = DockStyle.Fill;
            vehicleShow.Show();

            viewClientPanel.Hide();
            clientPanel.Hide();
            salesPanel.Hide();
            panelTrans.Hide();
        }
        private void inseertVecclick(object sender, EventArgs e)
        {
            if (costBox.Text.Length != 0 && modelBox.Text.Length != 0)
            {
                rand          = r.Next(111111, 999999);
                carIdBox.Text = "vehicle" + rand;

                VehicleRep vr = new VehicleRep();

                vr.CarID     = this.carIdBox.Text;
                vr.Category  = this.catBox.Text;
                vr.ModelName = this.modelBox.Text;
                vr.Date      = this.dateTimePicker1.Text;
                //vr.CarClass = this.modelBox.Text;
                //vr.Fuel = this.engineBox.Text;
                vr.Engine = this.engineBox.Text;
                //Console.WriteLine(cr.Status + " " + cr.Id);
                //vr.Release = this.reBox.Text;
                vr.Color = this.colorBox.Text;
                vr.Cost  = this.costBox.Text;
                vr.Seat  = this.seatBox.Text;

                VehicleRepositoryDB vrdb = new VehicleRepositoryDB();

                if (vrdb.Insert(vr))
                {
                    MessageBox.Show("Insert Completed!", "Succeed");
                    //button45.Visible = true;
                }

                else
                {
                    MessageBox.Show("Insert Not Complete", "Error");
                }
            }

            else
            {
                MessageBox.Show("Invalid!", "Error");
            }
        }