public static int Insert(EDERSLER item)
{
SqlCommand cmd = null;
int etkilenen = 0;
try
{
cmd = new SqlCommand("DERSLER_INSERT", BAGLAN.conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
cmd.Parameters.AddWithValue("DERS", item.DERS1);
cmd.Parameters.AddWithValue("KODU", item.KODU1);
cmd.Parameters.AddWithValue("YARIYIL", item.YARIYILI1);
cmd.Parameters.AddWithValue("KREDI", item.KREDI1);
cmd.Parameters.AddWithValue("TUR", item.TUR1);
cmd.Parameters.AddWithValue("DERSKITABI", item.DERSKITABI1);
cmd.Parameters.AddWithValue("ONSART", item.ONSART1);
etkilenen = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
etkilenen = -1;
}
finally
{
cmd.Connection.Close();
}
return(etkilenen);
}
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;
}
}
public static int Insert(EDERSLER item)
{
if (item.DERS1 != null)
{
return(FDERSLER.Insert(item));
}
else
{
return(-1);
}
}
public static List <EDERSLER> SelectList()
{
List <EDERSLER> dersler = null;
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("DERSLER_SELECTLIST", BAGLAN.conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
dersler = new List <EDERSLER>();
while (rdr.Read())
{
EDERSLER ders = new EDERSLER();
ders.ID1 = Convert.ToInt32(rdr["ID"]);
ders.DERS1 = rdr["DERS"].ToString();
ders.KODU1 = rdr["KODU"].ToString();
ders.YARIYILI1 = Convert.ToInt32(rdr["YARIYILI"]);
ders.KREDI1 = Convert.ToInt32(rdr["KREDI"]);
ders.DERSTURU1 = rdr["TUR"].ToString();
ders.KITAPADI1 = rdr["KITAPADI"].ToString();
dersler.Add(ders);
}
}
rdr.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
dersler = null;
}
finally
{
cmd.Connection.Close();
}
return(dersler);
}
public static EDERSLER Select(int id)
{
EDERSLER dersler = null;
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("DERSLER_SELECT", BAGLAN.conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
cmd.Parameters.AddWithValue("DERS_ID", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
dersler = new EDERSLER();
dersler.ID1 = Convert.ToInt32(rdr["ID"]);
dersler.DERS1 = rdr["DERS"].ToString();
dersler.KODU1 = rdr["KODU"].ToString();
dersler.YARIYILI1 = Convert.ToInt32(rdr["YARIYILI"]);
dersler.KREDI1 = Convert.ToInt32(rdr["KREDI"]);
dersler.TUR1 = Convert.ToInt32(rdr["TUR"]);
dersler.DERSKITABI1 = Convert.ToInt32(rdr["DERSKITABI"]);
}
}
rdr.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
dersler = null;
}
finally
{
cmd.Connection.Close();
}
return(dersler);
}
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();
}
