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