private void gvEkipe() { ek = new List <Ekipa>(); DB_connection.OpenConn(); ek = DB_GET.Ekipa_Get_All(); DB_connection.CloseConn(); var collection = new ObservableCollection <Ekipa>(ek); datasource = new BindingSource(collection, null); gv.ColumnCount = 1; gv.Columns[0].HeaderText = "Naziv"; gv.Columns[0].DataPropertyName = "Naziv"; gv.CellClick += (s, e) => { ekipa_id = (Ekipa)this.ek[e.RowIndex]; }; gv.DataSource = datasource; gv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; gv.AutoResizeColumns(); gv.AllowUserToAddRows = false; }
public Zapisnik_unos() { InitializeComponent(); var ek = new List <Ekipa>(); DB_connection.OpenConn(); ek = DB_GET.Ekipa_Get_All(); DB_connection.CloseConn(); cmbZapisnik01.Items.Clear(); cmbZapisnik01.DisplayMember = "Naziv"; foreach (var i in ek) { cmbZapisnik01.Items.Add(i); } }
public Trening_kreiranje() { InitializeComponent(); ek = new List <Ekipa>(); vj = new List <Vjezbe>(); try { DB_connection.OpenConn(); ek = DB_GET.Ekipa_Get_All(); vj = DB_GET.Vjezbe_Get_All(); DB_connection.CloseConn(); } catch (ArgumentException err) { lblTreningKreirajResult.ForeColor = Color.Red; Change_label("Greška kod učitavanja podataka: " + err.ToString()); } cmbTreningKreiraj01.Items.Clear(); cmbTreningKreiraj01.DisplayMember = "Naziv"; foreach (var i in ek) { cmbTreningKreiraj01.Items.Add(i); } var collection = new ObservableCollection <Vjezbe>(vj); collection.CollectionChanged += Collection_CollectionChanged; BindingSource datasource = new BindingSource(collection, null); dgvTreningKreiraj01.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvTreningKreiraj01.AutoResizeColumns(); dgvTreningKreiraj01.AllowUserToAddRows = false; dgvTreningKreiraj01.DataSource = datasource; dgvTreningKreiraj01.Columns["Id"].Visible = false; DataGridViewCheckBoxColumn chbCell = new DataGridViewCheckBoxColumn(); chbCell.ValueType = typeof(bool); chbCell.Name = "Koristi"; chbCell.HeaderText = "Koristi"; dgvTreningKreiraj01.Columns.Add(chbCell); }
private void btnUnosIgrac_Click(object sender, EventArgs e) { //za poziciju na ekranu, da se pojavi na sredini slike var x = (this.Width / 2) - (panelUnosIgr.Width / 2); var y = (this.Height / 2) - (panelUnosIgr.Height / 2); panelUnosIgr.Location = new Point(x, y); var ek = new List <Ekipa>(); try { DB_connection.OpenConn(); ek = DB_GET.Ekipa_Get_All(); DB_connection.CloseConn(); cmbUnosIgr01.Items.Clear(); cmbUnosIgr01.DisplayMember = "Naziv"; foreach (var i in ek) { cmbUnosIgr01.Items.Add(i); } } catch (ArgumentException err) { lblUnosResult.ForeColor = Color.Red; Change_label("Greška kod punjenja liste: " + err.ToString()); } //enable --> neme interakcije, visible --> ne vidi se panelUnosIgr.Visible = true; panelUnosIgr.Enabled = true; btnUnosIgrac.Visible = false; btnUnosIgrac.Enabled = false; btnUnosVjezba.Visible = false; btnUnosVjezba.Enabled = false; btnUnosEkipa.Visible = false; btnUnosEkipa.Enabled = false; btnUnosBrisi.Visible = false; btnUnosBrisi.Enabled = false; }
private void cmbBrisanjeOdabir_SelectedIndexChanged(object sender, EventArgs e) { int selected_idex = cmbBrisanjeOdabir.SelectedIndex; selected_item = cmbBrisanjeOdabir.SelectedItem.ToString(); try { DB_connection.OpenConn(); switch (selected_idex) { case 0: { ekipe = DB_GET.Ekipa_Get_All(); var collection = new ObservableCollection <Ekipa>(ekipe); datasource = new BindingSource(collection, null); selected_item = "EKIPA"; break; } case 1: { igrac = DB_GET.Igraci_Get_All(); var collection = new ObservableCollection <Igraci>(igrac); datasource = new BindingSource(collection, null); selected_item = "IGRAC"; break; } case 2: { prisutan = DB_GET.Prisutnost_Get_All(); var collection = new ObservableCollection <Prisutnost>(prisutan); datasource = new BindingSource(collection, null); selected_item = "PRISUTNOST"; break; } case 3: { trening = DB_GET.Trening_Get_All(); var collection = new ObservableCollection <Trening>(trening); datasource = new BindingSource(collection, null); selected_item = "TRENING"; break; } case 4: { statistike = DB_GET.Statistika_Get_All(); var collection = new ObservableCollection <Statistika>(statistike); datasource = new BindingSource(collection, null); selected_item = "STATISTIKA"; break; } case 5: { zapisnik = DB_GET.Zapisnik_Get_All(); var collection = new ObservableCollection <Zapisnik>(zapisnik); datasource = new BindingSource(collection, null); selected_item = "ZAPISNIK"; break; } case 6: { vjezba = DB_GET.Vjezbe_Get_All(); var collection = new ObservableCollection <Vjezbe>(vjezba); datasource = new BindingSource(collection, null); selected_item = "VJEZBE"; break; } case 7: { kosevi = DB_GET.Kosevi_Get_All(); var collection = new ObservableCollection <Kosevi>(kosevi); datasource = new BindingSource(collection, null); selected_item = "KOSEVI"; break; } } DB_connection.CloseConn(); } catch (ArgumentException err) { lblBrisanjeResult.ForeColor = Color.Red; Change_label("Greška kod brisanja: " + err.ToString()); } dgvBrisanje.DataSource = datasource; dgvBrisanje.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvBrisanje.AutoResizeColumns(); }