public override void Sil(BlokBilgisi veri)
{
string commandText = "delete from BlokBilgileri where BlokBilgiId = @id";
SqlConnection _sqlConnection = new SqlConnection(yol);
if (_sqlConnection.State == ConnectionState.Closed)
{
_sqlConnection.Open();
}
SqlCommand _sqlCommand = new SqlCommand(commandText, _sqlConnection);
_sqlCommand.Parameters.AddWithValue("@BlokBilgiId", veri.BlokBilgiId);
_sqlCommand.ExecuteNonQuery();
_sqlConnection.Close();
}
public override void Ekle(BlokBilgisi veri)
{
string commandText = "insert BlokBilgileri values(@BlokPaylasimId,@KullaniciId)";
SqlConnection _sqlConnection = new SqlConnection(yol);
if (_sqlConnection.State == ConnectionState.Closed)
{
_sqlConnection.Open();
}
SqlCommand _sqlCommand = new SqlCommand(commandText, _sqlConnection);
_sqlCommand.Parameters.AddWithValue("@BlokPaylasimId", veri.BlokPaylasimId);
_sqlCommand.Parameters.AddWithValue("@KullaniciId", veri.KullaniciId);
_sqlCommand.ExecuteNonQuery();
_sqlConnection.Close();
}
public void Sil(BlokBilgisi veri)
{
_blokBilgisiDal.Ekle(veri);
}
