public override BlokPaylasim IstekGetir(int id)
{
string commandText = "select * from BloklananPaylasimlar where BlokPaylasimId = @id";
BlokPaylasim blokEntry = new BlokPaylasim();
SqlConnection _sqlConnection = new SqlConnection(yol);
if (_sqlConnection.State == ConnectionState.Closed)
{
_sqlConnection.Open();
}
SqlCommand _sqlCommand = new SqlCommand(commandText, _sqlConnection);
_sqlCommand.Parameters.AddWithValue("@id", id);
SqlDataReader reader = _sqlCommand.ExecuteReader();
while (reader.Read())
{
blokEntry.BlokPaylasimId = Convert.ToInt32(reader["BlokPaylasimId"]);
blokEntry.PaylasimId = reader["PaylasimId"].ToString();
}
reader.Close();
_sqlConnection.Close();
return(blokEntry);
}
public override void Sil(BlokPaylasim veri)
{
string commandText =
"delete from BloklananPaylasimlar where PaylasimId = @id";
SqlConnection _sqlConnection = new SqlConnection(yol);
if (_sqlConnection.State == ConnectionState.Closed)
{
_sqlConnection.Open();
}
SqlCommand _sqlCommand = new SqlCommand(commandText, _sqlConnection);
_sqlCommand.Parameters.AddWithValue("@id", veri.PaylasimId);
_sqlCommand.ExecuteNonQuery();
_sqlConnection.Close();
}
public override void Ekle(BlokPaylasim veri)
{
string commandText =
"insert BloklananPaylasimlar values(@PaylasimId)";
SqlConnection _sqlConnection = new SqlConnection(yol);
if (_sqlConnection.State == ConnectionState.Closed)
{
_sqlConnection.Open();
}
SqlCommand _sqlCommand = new SqlCommand(commandText, _sqlConnection);
_sqlCommand.Parameters.AddWithValue("@PaylasimId", veri.PaylasimId);
_sqlCommand.ExecuteNonQuery();
_sqlConnection.Close();
}
public void Sil(BlokPaylasim veri)
{
_blokPaylasimDal.Sil(veri);
}
public void Ekle(BlokPaylasim veri)
{
_blokPaylasimDal.Ekle(veri);
}