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 fillCourseList() { List <EDERSLER> dersler = new List <EDERSLER>(); dersler = BDERSLER.SelectList(); dataGridView1.DataSource = dersler; dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[5].Visible = false; dataGridView1.Columns[6].Visible = false; dataGridView1.Columns[7].Visible = false; comboBox6.DataSource = dersler; comboBox6.DisplayMember = "KODU1"; comboBox6.ValueMember = "ID1"; List <EKITAP> kitaplar = new List <EKITAP>(); kitaplar = BKITAP.SelectList(); comboBox5.DataSource = kitaplar; comboBox5.DisplayMember = "KITAPADI1"; comboBox5.ValueMember = "ID1"; List <EDERSTURU> dersTurleri = new List <EDERSTURU>(); dersTurleri = BDERSTURU.SelectList(); comboBox3.DataSource = dersTurleri; comboBox3.DisplayMember = "DERSTURU1"; comboBox3.ValueMember = "ID1"; }
private void fillEnterNote() { List <EDERSLER> dersler = new List <EDERSLER>(); dersler = BDERSLER.SelectList(); comboBox15.DataSource = dersler; comboBox15.DisplayMember = "DERS1"; comboBox15.ValueMember = "ID1"; List <EOGRENCI> ogrenciler = new List <EOGRENCI>(); ogrenciler = BOGRENCI.SelectList(); comboBox16.DataSource = ogrenciler; comboBox16.DisplayMember = "ADSOYAD1"; comboBox16.ValueMember = "ID1"; }
private void button2_Click(object sender, EventArgs e) { EDERSLER ders = new EDERSLER(); ders.DERS1 = textBox2.Text; ders.KODU1 = textBox3.Text; ders.YARIYILI1 = comboBox1.SelectedIndex + 1; ders.KREDI1 = comboBox2.SelectedIndex + 1; ders.TUR1 = Convert.ToInt32(comboBox3.SelectedValue); ders.DERSKITABI1 = Convert.ToInt32(comboBox5.SelectedValue); ders.ONSART1 = Convert.ToInt32(comboBox6.SelectedValue); int eklenen = BDERSLER.Insert(ders); if (eklenen == 1) { MessageBox.Show("Ders Oluşturuldu"); } fillCourseList(); }
private void fillOpenedCourseList() { List <EACILANDERSLERVIEW> acilanDersler = new List <EACILANDERSLERVIEW>(); acilanDersler = BACILANDERSLER.SelectList(); dataGridView2.DataSource = acilanDersler; dataGridView2.Columns[0].Visible = false; dataGridView2.Columns[10].Visible = false; List <EOGRETIMGOREVLISI> gorevliler = new List <EOGRETIMGOREVLISI>(); gorevliler = BOGRETIMGOREVLISI.SelectList(); comboBox7.DataSource = gorevliler; comboBox7.DisplayMember = "ADSOYAD1"; comboBox7.ValueMember = "ID1"; List <EBINALAR> binalar = new List <EBINALAR>(); binalar = BBINALAR.SelectList(); comboBox8.DataSource = binalar; comboBox8.DisplayMember = "KODU1"; comboBox8.ValueMember = "ID1"; List <EGUNLER> gunler = new List <EGUNLER>(); gunler = BGUNLER.SelectList(); comboBox9.DataSource = gunler; comboBox9.DisplayMember = "GUN1"; comboBox9.ValueMember = "ID1"; List <EDERSLIK> derslikler = new List <EDERSLIK>(); derslikler = BDERSLIK.SelectList(); comboBox10.DataSource = derslikler; comboBox10.DisplayMember = "KODU1"; comboBox10.ValueMember = "ID1"; List <EPROGRAM> programlar = new List <EPROGRAM>(); programlar = BPROGRAM.SelectList(); comboBox11.DataSource = programlar; comboBox11.DisplayMember = "PROGRAM1"; comboBox11.ValueMember = "ID1"; List <EEGITIMOGRETIMYILI> yillar = new List <EEGITIMOGRETIMYILI>(); yillar = BEGITIMOGRETIMYILI.SelectList(); comboBox13.DataSource = yillar; comboBox13.DisplayMember = "YIL1"; comboBox13.ValueMember = "ID1"; List <EDONEM> donemler = new List <EDONEM>(); donemler = BDONEM.SelectList(); comboBox14.DataSource = donemler; comboBox14.DisplayMember = "DONEM1"; comboBox14.ValueMember = "ID1"; List <EDERSDILI> diller = new List <EDERSDILI>(); diller = BDERSDILI.SelectList(); comboBox4.DataSource = diller; comboBox4.DisplayMember = "DIL1"; comboBox4.ValueMember = "ID1"; List <EDERSLER> dersler = new List <EDERSLER>(); dersler = BDERSLER.SelectList(); comboBox12.DataSource = dersler; comboBox12.DisplayMember = "DERS1"; comboBox12.ValueMember = "ID1"; }