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 Form2_Load(object sender, EventArgs e) { Ogrenci = this.mainForm.Ogrenci; label12.Text = Ogrenci.AD1; label13.Text = Ogrenci.SOYAD1; label14.Text = Ogrenci.OKULNO1; label15.Text = Ogrenci.TCKIMLIKNO1; label16.Text = BIL.Select(Ogrenci.DOGUMYERI1).IL1.ToString(); label17.Text = Ogrenci.DOGUMTARIHI1.ToString(); label18.Text = Ogrenci.KAYITTARIHI1.ToString(); label19.Text = BOGRENCITURU.Select(Ogrenci.OGRENCITURU1).TUR1.ToString(); label20.Text = BPROGRAM.Select(Ogrenci.BOLUM1).PROGRAM1.ToString(); textBox1.Text = Ogrenci.MAIL1; textBox2.Text = Ogrenci.SIFRE1; fillScoreAndRecordedCourse(); List <EACILANDERSLERVIEW> acilanDersler = new List <EACILANDERSLERVIEW>(); acilanDersler = BACILANDERSLER.SelectList(); dataGridView3.DataSource = acilanDersler; dataGridView3.Columns[0].Visible = false; //dataGridView3.Columns[10].Visible = false; }
private void button3_Click(object sender, EventArgs e) { EACILANDERSLER acilanDers = new EACILANDERSLER(); acilanDers.DERS1 = Convert.ToInt32(comboBox12.SelectedValue); acilanDers.CRN1 = Convert.ToInt32(textBox4.Text); acilanDers.OGRETIMUYESI1 = Convert.ToInt32(comboBox7.SelectedValue); acilanDers.BINA1 = Convert.ToInt32(comboBox8.SelectedValue); acilanDers.GUN1 = Convert.ToInt32(comboBox9.SelectedValue); acilanDers.BASLANGICSAATI1 = textBox5.Text; acilanDers.DERSLIK1 = Convert.ToInt32(comboBox10.SelectedValue); acilanDers.KONTENJAN1 = Convert.ToInt32(textBox6.Text); acilanDers.DERSIALABILENPROGRAM1 = Convert.ToInt32(comboBox11.SelectedValue); acilanDers.YIL1 = Convert.ToInt32(comboBox13.SelectedValue); acilanDers.DONEM1 = Convert.ToInt32(comboBox14.SelectedValue); acilanDers.DILI1 = Convert.ToInt32(comboBox4.SelectedValue); int eklenen = BACILANDERSLER.Insert(acilanDers); if (eklenen == 1) { MessageBox.Show("Ders Açıldı"); } fillOpenedCourseList(); }
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"; }