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