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"); } }