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); }