private void btnSvi_Click(object sender, EventArgs e) { autiGrid.Columns[0].Visible = false; cbMarka.SelectedIndex = 0; Automobil automobil = new Automobil(); DataTable dtAutomobili = automobil.DohvatiAutomobile(); dtAutomobili.Columns["naziv"].ColumnName = "Marka"; dtAutomobili.Columns["automobilID"].ColumnName = "ID automobila"; dtAutomobili.Columns["naziv1"].ColumnName = "Model"; dtAutomobili.Columns["tip"].ColumnName = "Tip"; dtAutomobili.Columns["cijena"].ColumnName = "Cijena"; autiGrid.AutoGenerateColumns = true; autiGrid.DataSource = dtAutomobili; autiGrid.Columns[1].Width = 150; autiGrid.Columns[2].Width = 150; autiGrid.Columns[3].Width = 150; autiGrid.Columns[0].Visible = false; autiGrid.Sort(autiGrid.Columns[1], ListSortDirection.Ascending); }
private void btnObrisiAutomobil_Click(object sender, EventArgs e) { DataGridViewRow selectedRow = autiGrid.SelectedRows[0]; int id = Convert.ToInt32(selectedRow.Cells[0].Value); //provjerava ima li automobil trenutne rezervacije Rezervacija rez = new Rezervacija(); bool imaRezervacije = rez.AutoImaRezervacije(id); if (imaRezervacije == true) { MessageBox.Show("Auto je rezerviran. Ne možete izbrisati rezervirani automobil."); } else { //brisanje automobila Automobil auto = new Automobil(); auto.ObrisiAutomobil(id); //ponovno se dohvacaju automobili za grid Automobil automobil = new Automobil(); DataTable dtAutomobili = automobil.DohvatiAutomobile(); dtAutomobili.Columns["naziv"].ColumnName = "Marka"; dtAutomobili.Columns["automobilID"].ColumnName = "ID automobila"; dtAutomobili.Columns["naziv1"].ColumnName = "Model"; dtAutomobili.Columns["tip"].ColumnName = "Tip"; dtAutomobili.Columns["cijena"].ColumnName = "Cijena (kn)"; autiGrid.AutoGenerateColumns = true; autiGrid.DataSource = dtAutomobili; //ovdje postavljamo datasource za auti grid, datatable dtAutomobili autiGrid.Columns[1].Width = 150; autiGrid.Columns[2].Width = 150; autiGrid.Columns[3].Width = 150; autiGrid.Columns[4].Width = 150; autiGrid.Sort(autiGrid.Columns[1], ListSortDirection.Ascending); //sortiranje grid-a autiGrid.Columns[0].Visible = false; //skrivam prvi stupac koji sadrži automobilID } }
/// <summary> /// DGV se popunjava karakteristima automobila, za dohvat podataka koristi se metoda DohvatiAutomobile koja je /// definirana u RentACar.BL /// </summary> public void PopuniGridAutomobili() { Automobil automobil = new Automobil(); DataTable dtAutomobili = automobil.DohvatiAutomobile(); dtAutomobili.Columns[0].ColumnName = "AutomobilID"; dtAutomobili.Columns[1].ColumnName = "Marka"; dtAutomobili.Columns[2].ColumnName = "Model"; dtAutomobili.Columns[3].ColumnName = "Tip"; dtAutomobili.Columns[4].ColumnName = "Snaga"; dtAutomobili.Columns[5].ColumnName = "Opis"; dtAutomobili.Columns[6].ColumnName = "Cijena (kn/dan)"; autiGrid.AutoGenerateColumns = true; autiGrid.DataSource = dtAutomobili; autiGrid.Columns[1].Width = 150; autiGrid.Columns[2].Width = 150; autiGrid.Columns[3].Width = 150; autiGrid.Columns[4].Width = 150; autiGrid.Columns[4].Visible = false; autiGrid.Columns[5].Visible = false; autiGrid.Sort(autiGrid.Columns[1], ListSortDirection.Ascending); List <string> listaMarki = new List <string>(); List <string> listaTipova = new List <string>(); Automobil auto = new Automobil(); listaMarki = auto.DohvatiMarke(); cbMarka.DataSource = listaMarki; autiGrid.Columns[0].Visible = false; }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox1.SelectedItem.ToString() == "") { Automobil auto = new Automobil(); DataTable dt = auto.DohvatiAutomobile(); dt.Columns[1].ColumnName = "Marka"; dt.Columns[2].ColumnName = "Model"; dt.Columns[3].ColumnName = "Tip"; AutiGrid.DataSource = dt; AutiGrid.Columns[0].Visible = false; AutiGrid.Columns[4].Visible = false; AutiGrid.Columns[1].Width = 170; AutiGrid.Columns[2].Width = 170; AutiGrid.Columns[3].Width = 170; } else { Automobil auto = new Automobil(); DataTable dt = auto.DohvatiAutomobilPremaMarki(comboBox1.SelectedValue.ToString()); AutiGrid.DataSource = dt; AutiGrid.Columns[0].Visible = false; AutiGrid.Columns[4].Visible = false; AutiGrid.Columns[5].Visible = false; AutiGrid.Columns[6].Visible = false; AutiGrid.Columns[7].Visible = false; AutiGrid.Columns[8].Visible = false; } }