public void OgretmenEkle(string ogretmenAdi) { Ogretmen ogretmen = new Ogretmen(ogretmenAdi); Ogretmenler.Add(ogretmen); var connectionString = @"Server = DESKTOP-NCH3S9Q\SQLEXPRESS; Database = EgitimKayit; Integrated Security = true; "; var commandtext = "INSERT INTO Ogretmenler(Id,OgretmenAdi) VALUES ('" + ogretmen.Id + "','" + ogretmen.OgretmenAdi + "')"; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand command = new SqlCommand(commandtext, con); command.ExecuteNonQuery(); con.Close(); }
public List <Ogretmen> OgretmenGetir() { Ogretmenler.Clear(); var connectionString = @"Server = DESKTOP-NCH3S9Q\SQLEXPRESS; Database = EgitimKayit; Integrated Security = true; "; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand command = new SqlCommand("SELECT * FROM Ogretmenler", con); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Ogretmen ogretmen = new Ogretmen(reader.GetGuid(0).ToString(), reader.GetString(1)); Ogretmenler.Add(ogretmen); } con.Close(); return(Ogretmenler); }
public Egitim(Ders Ders, Ogretmen Ogretmen, Sube Sube) { if (Ders == null) { throw new ArgumentNullException(nameof(Ders)); } if (Ogretmen == null) { throw new ArgumentNullException(nameof(Ogretmen)); } if (Sube == null) { throw new ArgumentNullException(nameof(Sube)); } this.Ders = Ders; this.Ogretmen = Ogretmen; this.Sube = Sube; Ogrenciler = new List <Ogrenci>(); }