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