private void fillScoreAndRecordedCourse()
{
List <ENOTLAR> notlar = new List <ENOTLAR>();
notlar = BNOTLAR.Select(Ogrenci.ID1);
List <EDERSLER> dersler = new List <EDERSLER>();
if (notlar != null)
{
foreach (ENOTLAR not in notlar)
{
not.DERSID1 = BACILANDERSLER.Select(not.ACILANDERS1).ID1;
EDERSLER ders = new EDERSLER();
ders = BDERSLER.Select(not.DERSID1);
not.DERSADI1 = ders.DERS1;
dersler.Add(ders);
}
dataGridView1.DataSource = notlar;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].Visible = false;
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns[8].Visible = false;
dataGridView2.DataSource = dersler;
dataGridView2.Columns[0].Visible = false;
dataGridView2.Columns[3].Visible = false;
dataGridView2.Columns[4].Visible = false;
dataGridView2.Columns[5].Visible = false;
dataGridView2.Columns[6].Visible = false;
dataGridView2.Columns[7].Visible = false;
}
}
private void button2_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dataGridView2.SelectedRows)
{
int dersID = Convert.ToInt32(row.Cells[0].Value);
EACILANDERSLER acilanDers = new EACILANDERSLER();
acilanDers = BACILANDERSLER.Select(dersID);
int durum = BNOTLAR.Delete(acilanDers.ID1);
if (durum == 0)
{
MessageBox.Show("Ders Bırakma Zamanı Geçmiştir!");
}
}
fillScoreAndRecordedCourse();
}
private void updateNote()
{
ENOTLAR not = new ENOTLAR();
not.OGRENCINO1 = Convert.ToInt32(comboBox16.SelectedValue);
not.ACILANDERS1 = Convert.ToInt32(comboBox15.SelectedValue);
not.VIZENOTU1 = Convert.ToInt32(textBox7.Text);
not.FINALNOTU1 = Convert.ToInt32(textBox8.Text);
not.PROJENOTU1 = Convert.ToInt32(textBox9.Text);
not.HARFNOTU1 = textBox10.Text.ToString();
int guncellenen = BNOTLAR.Update(not);
if (guncellenen == 1)
{
MessageBox.Show("Not Güncellendi");
fillNote();
}
}
private void fillNote()
{
ENOTLAR notlar = new ENOTLAR();
notlar = BNOTLAR.Select(Convert.ToInt32(comboBox16.SelectedValue), Convert.ToInt32(comboBox15.SelectedValue));
if (notlar != null)
{
textBox7.Text = notlar.VIZENOTU1.ToString();
textBox8.Text = notlar.FINALNOTU1.ToString();
textBox9.Text = notlar.PROJENOTU1.ToString();
textBox10.Text = notlar.HARFNOTU1.ToString();
}
else
{
textBox7.Clear();
textBox8.Clear();
textBox9.Clear();
textBox10.Clear();
}
}
