public OgrenciDersleriForm(Ogrenci ogrenci)
{
InitializeComponent();
_ogrenci = ogrenci;
UIDegerleriniVer();
DersGetir();
SecilenDersiGetir();
}
public static List<OgrenciDersleri> OgrenciDersGetir(Ogrenci ogrenci)
{
List<OgrenciDersleri> ogrenciDersleri = new List<OgrenciDersleri>();
MySqlConnection connection=null;
try
{
string connectionString="SERVER=localhost;DATABASE=OgrenciYonetimSistemi; UID=root;PASSWORD=hy050491;";
connection = new MySqlConnection(connectionString);
connection.Open();
string query = "SELECT * FROM OgrenciDersleri";
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader reader= cmd.ExecuteReader();
while (reader.Read())
{
OgrenciDersleri ogreciDers = new OgrenciDersleri();
ogreciDers.Id = Convert.ToInt32(reader["Id"]);
ogreciDers.Ogrenci = new Ogrenci();
ogreciDers.Ogrenci.Id = Convert.ToInt32(reader["Ogrenci"]);
ogreciDers.Ders = new Ders();
ogreciDers.Ders.Id = Convert.ToInt32(reader["Ders"]);
string studentQuery = "SELECT * FROM Ogrenci WHERE Id = '" + ogreciDers.Ogrenci.Id + "'";
MySqlCommand cmdStudent = new MySqlCommand(query, connection);
MySqlDataReader readerStudent = cmd.ExecuteReader();
while (readerStudent.Read())
{
ogreciDers.Ogrenci.Adi = readerStudent["Adi"].ToString();
ogreciDers.Ogrenci.Soyadi = readerStudent["Soyadi"].ToString();
}
ogrenciDersleri.Add(ogreciDers);
}
connection.Close();
DataTable table = new DataTable();
table.Load(reader);
for (int i = 0; i < table.Rows.Count; i++)
{
string adi = table.Rows[i]["Id"].ToString();
}
//DersBilgileriDoldur(ogrenciDersleri);
}
catch (Exception ex)
{
}
finally
{
connection.Close();
}
return ogrenciDersleri;
}
private void button1_Click_2(object sender, EventArgs e)
{
secilenOgrenci = dgvOgrenciler.SelectedRows[0].DataBoundItem as Ogrenci;
if (secilenOgrenci != null)
{
OgrenciDersleriForm ogrencidersleri = new OgrenciDersleriForm(secilenOgrenci);
ogrencidersleri.ShowDialog();
}
}
public void Ekle()
{
Ogrenci ogrenci = new Ogrenci();
ogrenci.Adi = txtAdi.Text.Trim();
ogrenci.Soyadi = txtSoyadi.Text.Trim();
OgrenciBL.OgrenciEkle(ogrenci);
OgrencileriGetir();
}
public static bool OgrenciSil(Ogrenci ogrenci)
{
bool eklendi = false;
MySqlConnection connection = null;
try
{
string connectionString = "SERVER=localhost;DATABASE=OgrenciYonetimSistemi; UID=root;PASSWORD=hy050491;";
connection = new MySqlConnection(connectionString);
connection.Open();
string query = "DELETE FROM Ogrenci WHERE Id='" + ogrenci.Id + "'";
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, connection);
int sonucDeger = cmd.ExecuteNonQuery();
if (sonucDeger > 0)
eklendi = true;
}
catch (Exception ex)
{
eklendi = false;
}
finally
{
connection.Close();
}
return eklendi;
}
public static List<Ogrenci> OgrencileriGetir()
{
List<Ogrenci> ogrenciler = new List<Ogrenci>();
MySqlConnection connection=null;
try
{
string connectionString="SERVER=localhost;DATABASE=OgrenciYonetimSistemi; UID=root;PASSWORD=hy050491;";
connection = new MySqlConnection(connectionString);
connection.Open();
string query = "SELECT * FROM Ogrenci";
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader reader= cmd.ExecuteReader();
while (reader.Read())
{
Ogrenci ogrenci = new Ogrenci();
ogrenci.Id=Convert.ToInt32(reader["Id"]);
ogrenci.Adi=reader["Adi"].ToString();
ogrenci.Soyadi = reader["Soyadi"].ToString();
ogrenciler.Add(ogrenci);
}
}
catch (Exception ex)
{
}
finally
{
connection.Close();
}
return ogrenciler;
}
private void dgvOgrenciler_MouseDoubleClick(object sender, MouseEventArgs e)
{
secilenOgrenci = dgvOgrenciler.SelectedRows[0].DataBoundItem as Ogrenci;
if (secilenOgrenci != null)
{
txtAdi.Text = secilenOgrenci.Adi;
txtSoyadi.Text = secilenOgrenci.Soyadi;
}
}
private void dgvOgrenciler_MouseClick(object sender, MouseEventArgs e)
{
secilenOgrenci = dgvOgrenciler.SelectedRows[0].DataBoundItem as Ogrenci;
}