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