private void btnSil_Click(object sender, EventArgs e)
{
Uye silicenekuye = new Uye();
silicenekuye = (Uye)dataGridView1.CurrentRow.DataBoundItem;
uye.uyesil(silicenekuye);
Listele();
TxtUyeAd.Clear();
TxtUyeSoyad.Clear();
TxtUyeTC.Clear();
MTxtUyeTelNo.Clear();
CBUyeCinsiyet.Text = " ";
}
private void btnGuncelle_Click(object sender, EventArgs e)
{
Uye eskiuye = new Uye();
eskiuye = (Uye)dataGridView1.CurrentRow.DataBoundItem;
Uye yeniuye = new Uye();
yeniuye.TCNO = Convert.ToDouble(TxtUyeTC.Text);
yeniuye.AD = TxtUyeAd.Text;
yeniuye.SOYAD = TxtUyeSoyad.Text;
yeniuye.TELEFON = MTxtUyeTelNo.Text;
yeniuye.CINSIYET = CBUyeCinsiyet.Text;
uye.uyeguncelle(eskiuye, yeniuye);
Listele();
TxtUyeAd.Clear();
TxtUyeSoyad.Clear();
TxtUyeTC.Clear();
MTxtUyeTelNo.Clear();
CBUyeCinsiyet.Text = " ";
}
public void uyesil(Uye K)
{
try
{
OleDbCommand cmd = new OleDbCommand("delete From UyeKayit Where TC='" + Convert.ToDouble(K.TCNO) + "'", con);
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public void uyeguncelle(Uye eskiuye, Uye yeniuye)
{
try
{
OleDbCommand cmd = new OleDbCommand("update UyeKayit SET Ad='" + yeniuye.AD.ToString() + "',Soyad='" + yeniuye.SOYAD.ToString() + "',Telefon='" + yeniuye.TELEFON.ToString() + "',Cinsiyet='" + yeniuye.CINSIYET.ToString() + "'Where TC= '" + eskiuye.TCNO.ToString() + "'", con);
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public void uyeekle(Uye K)
{
try
{
OleDbCommand cmd = new OleDbCommand("insert into UyeKayit (TC,Ad,Soyad,Telefon,Cinsiyet) Values ('" + Convert.ToDouble(K.TCNO) + "','" + K.AD.ToString() + "','" + K.SOYAD.ToString() + "','" + K.TELEFON.ToString() + "','" + K.CINSIYET.ToString() + "')", con);
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void btnEkle_Click(object sender, EventArgs e)
{
if (TxtUyeTC.TextLength < 11)
{
MessageBox.Show("Tc Kimlik No 11 Haneden Küçük!!!");
}
else
{
Uye yeniuye = new Uye();
yeniuye.TCNO = Convert.ToDouble(TxtUyeTC.Text);
yeniuye.AD = TxtUyeAd.Text;
yeniuye.SOYAD = TxtUyeSoyad.Text;
yeniuye.TELEFON = MTxtUyeTelNo.Text;
yeniuye.CINSIYET = CBUyeCinsiyet.Text;
uye.uyeekle(yeniuye);
Listele();
TxtUyeAd.Clear();
TxtUyeSoyad.Clear();
TxtUyeTC.Clear();
MTxtUyeTelNo.Clear();
CBUyeCinsiyet.Text = " ";
}
}
