public Form1() { InitializeComponent(); DBCommunation.refreshComboBoxSubject(ref comboBox3); List <String> combo = DBCommunation.refreshComboBox(); comboBox4.Items.Clear(); foreach (String element in combo) { comboBox4.Items.Add(element); } for (int i = 1; i <= Constants.noOfSemester; i++) { comboBox2.Items.Add(Convert.ToString(i) + ". semestar"); } for (int i = 1; i <= Constants.ocjena; i++) { comboBox5.Items.Add(Convert.ToString(i)); } DBCommunation.refreshComboBoxSemester(ref semestri); foreach (string sem in semestri) { comboBox1.Items.Add(sem + ". semestar"); } }
//padajuca lista semestara private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = DBCommunation.getContent((string)comboBox1.SelectedItem); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.Refresh(); }
private void comboBox4_SelectedIndexChanged(object sender, EventArgs e) { int tempECTS = 0, tempOcjena = 0; DateTime datum = new DateTime(); DBCommunation.printProperty((string)comboBox4.SelectedItem, ref tempECTS, ref tempOcjena, ref datum); textBox8.Text = (string)comboBox4.SelectedItem; textBox9.Text = Convert.ToString(tempECTS); textBox10.Text = Convert.ToString(tempOcjena); textBox11.Text = Convert.ToString(date); }
//dodaj private void button1_Click(object sender, EventArgs e) { string temp = (string)comboBox2.SelectedItem; temp = temp.Remove(1); if (DBCommunation.checkExistence((string)comboBox3.SelectedItem) == 1) { DBCommunation.insertData((string)comboBox3.SelectedItem, Convert.ToInt16(comboBox5.SelectedItem), date, Convert.ToInt16(temp)); } else { MessageBox.Show("Predmet je već upisan"); } }
//izracunaj prosjek private void button3_Click_1(object sender, EventArgs e) { prosjek = Math.Round(prosjek, 2); prosjek = DBCommunation.calculate(); textBox7.Text = String.Format("{0:0.0000}", prosjek); }
//izracunaj tezinski prosjek private void button2_Click_1(object sender, EventArgs e) { tezinskiProsjek = Math.Round(tezinskiProsjek, 2); tezinskiProsjek = DBCommunation.calculateHeavy(); textBox6.Text = String.Format("{0:0.0000}", tezinskiProsjek); }