public bool UlkeEkle(Ulke u)
{
bool Sonuc = false;
SqlCommand comm = new SqlCommand("insert into Ulkeler (UlkeAdi, UlkeTelCod, Aciklama) values (@Adi, @TelCod, @Aciklama)", conn);
comm.Parameters.Add("@Adi", SqlDbType.VarChar).Value = u._ulkeAdi;
comm.Parameters.Add("@TelCod", SqlDbType.VarChar).Value = u._ulkeTelCode;
comm.Parameters.Add("@Aciklama", SqlDbType.VarChar).Value = u._aciklama;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
try
{
Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery());
}
catch (SqlException ex)
{
string hata = ex.Message;
}
finally { conn.Close(); }
return(Sonuc);
}
public bool UlkeGuncelle(Ulke u)
{
bool Sonuc = false;
SqlCommand comm = new SqlCommand("update Ulkeler set UlkeAdi=@Adi, UlkeTelCod=@TelCod, aciklama=@Aciklama where ulkeID=@ulkeID", conn);
comm.Parameters.Add("@Adi", SqlDbType.VarChar).Value = u._ulkeAdi;
comm.Parameters.Add("@ulkeID", SqlDbType.Int).Value = u._ulkeID;
comm.Parameters.Add("@TelCod", SqlDbType.VarChar).Value = u._ulkeTelCode;
comm.Parameters.Add("@Aciklama", SqlDbType.VarChar).Value = u._aciklama;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
try
{
Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery());
}
catch (SqlException ex)
{
string hata = ex.Message;
}
finally { conn.Close(); }
return(Sonuc);
}