public static int Insert(EACILANDERSLER item)
{
if (item.DERS1 != null)
{
return(FACILANDERSLER.Insert(item));
}
else
{
return(-1);
}
}
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();
}
public static int Insert(EACILANDERSLER item)
{
SqlCommand cmd = null;
int etkilenen = 0;
try
{
cmd = new SqlCommand("ACILANDERSLER_INSERT", BAGLAN.conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
cmd.Parameters.AddWithValue("CRN", item.CRN1);
cmd.Parameters.AddWithValue("DERS", item.DERS1);
cmd.Parameters.AddWithValue("OGRETIMUYESI", item.OGRETIMUYESI1);
cmd.Parameters.AddWithValue("BINA", item.BINA1);
cmd.Parameters.AddWithValue("GUN", item.GUN1);
cmd.Parameters.AddWithValue("BASLANGICSAATI", item.BASLANGICSAATI1);
cmd.Parameters.AddWithValue("DERSLIK", item.DERSLIK1);
cmd.Parameters.AddWithValue("KONTENJAN", item.KONTENJAN1);
cmd.Parameters.AddWithValue("YAZILAN", item.YAZILAN1);
cmd.Parameters.AddWithValue("PROGRAM", item.DERSIALABILENPROGRAM1);
cmd.Parameters.AddWithValue("YIL", item.YIL1);
cmd.Parameters.AddWithValue("DONEM", item.DONEM1);
cmd.Parameters.AddWithValue("DILI", item.DILI1);
etkilenen = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
etkilenen = -1;
}
finally
{
cmd.Connection.Close();
}
return(etkilenen);
}
public static EACILANDERSLER Select(int id)
{
EACILANDERSLER dersler = null;
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("ACILANDERSLER_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 EACILANDERSLER();
dersler.ID1 = Convert.ToInt32(rdr["ID"]);
dersler.DERS1 = Convert.ToInt32(rdr["DERS"]);
}
}
rdr.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
dersler = null;
}
finally
{
cmd.Connection.Close();
}
return(dersler);
}
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();
}