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(); }