public void Sil(Hemsire silineceKisi)
{
try
{
cmd.CommandText = "Delete From Hemsire Where hemsire_TC = '" + silineceKisi.Hemsire_TC + "'";
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public void sGuncelleme(Hemsire yenisifre, Hemsire tc)
{
try
{
cmd.CommandText = "Update Hemsire SET hemsire_Sifre='" + yenisifre.Hemsire_Sifre.ToString() + "' Where hemsire_TC='" + tc.Hemsire_TC.ToString() + "'";
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public void Guncelle(Hemsire tc, Hemsire yeniKisi)
{
try
{
cmd.CommandText = "Update Hemsire SET hemsire_Ad='" + yeniKisi.Hemsire_Ad + "',hemsire_Soyad='" + yeniKisi.Hemsire_Soyad + "',hemsire_TC='" + yeniKisi.Hemsire_TC + "',hemsire_Sifre='" + yeniKisi.Hemsire_Sifre + "' Where hemsire_TC='" + tc.Hemsire_TC + "'";
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public void Ekle(Hemsire h)
{
try
{
cmd.CommandText = "Insert Into Hemsire (hemsire_Ad, hemsire_Soyad, hemsire_TC, hemsire_Sifre) Values ('" + h.Hemsire_Ad.ToString() + "','" + h.Hemsire_Soyad.ToString() + "','" + h.Hemsire_TC.ToString() + "','" + h.Hemsire_Sifre.ToString() + "')";
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}