public override void Ekle(Paylasim veri)
{
string commandText =
"insert Paylasimlar values(@PaylasimId, @KategoriId, @KullaniciId,@PaylasimTipi,@GirilmeZamani)";
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.Parameters.AddWithValue("@KategoriId", veri.KategoriId);
_sqlCommand.Parameters.AddWithValue("@KullaniciId", veri.KullaniciId);
_sqlCommand.Parameters.AddWithValue("@PaylasimTipi", veri.PaylasimTipi);
_sqlCommand.Parameters.AddWithValue("@GirilmeZamani", veri.GirilmeZamani);
_sqlCommand.ExecuteNonQuery();
_sqlConnection.Close();
}
public void Ekle(Paylasim veri)
{
if (String.IsNullOrEmpty(veri.PaylasimId))
{
veri.PaylasimId = Guid.NewGuid().ToString();
}
_paylasimDal.Ekle(veri);
}
public IActionResult PaylasimYap(Paylasim model)
{
var user = userManager.FindByNameAsync(User.Identity.Name).Result;
var Paylasim = new Paylasim()
{
Baslik = model.Baslik,
Icerik = model.Icerik,
VLink = model.VLink,
GLink = model.GLink,
KullaniciAd = user.UserName
};
context.Paylasimlar.Add(Paylasim);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public override void Sil(Paylasim veri)
{
string commandText =
"delete from Paylasimlar 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 void Sil(Paylasim veri)
{
_paylasimDal.Sil(veri);
}
