public List <DigerUrun> KategoriIleUrunGetir(int id) { ConnectionControl(); SqlCommand command = new SqlCommand("Select * from IlacDisiUrun where KategoriId like '%" + id + "%'", _connection); SqlDataReader reader = command.ExecuteReader(); List <DigerUrun> digerUrunler = new List <DigerUrun>(); while (reader.Read()) { DigerUrun digerUrun = new DigerUrun { DisId = Convert.ToInt32(reader["DisId"]), KategoriId = Convert.ToInt32(reader["KategoriId"]), Ad = reader["Ad"].ToString(), Firma = reader["Firma"].ToString(), Fiyat = Convert.ToDecimal(reader["Fiyat"]), BarkodNo = reader["BarkodNo"].ToString(), Stok = Convert.ToInt32(reader["Stok"]) }; digerUrunler.Add(digerUrun); } reader.Close(); _connection.Close(); return(digerUrunler); }
public void Add(DigerUrun digerUrun) { ConnectionControl(); SqlCommand command = new SqlCommand("insert into IlacDisiUrun values (@KategoriId ,@Ad,@Firma,@Fiyat,@BarkodNo, @Stok)", _connection); command.Parameters.AddWithValue("@KategoriId", digerUrun.KategoriId); command.Parameters.AddWithValue("@Ad", digerUrun.Ad); command.Parameters.AddWithValue("@Firma", digerUrun.Firma); command.Parameters.AddWithValue("@Fiyat", digerUrun.Fiyat); command.Parameters.AddWithValue("@BarkodNo", digerUrun.BarkodNo); command.Parameters.AddWithValue("@Stok", digerUrun.Stok); command.ExecuteNonQuery(); _connection.Close(); }
public void Update(DigerUrun digerUrun) { ConnectionControl(); SqlCommand command = new SqlCommand("Update IlacDisiUrun set KategoriId=@KategoriId, Ad=@Ad, Firma=@Firma, Fiyat=@Fiyat, BarkodNo=@BarkodNo , Stok=@Stok where DisId=@DisId ", _connection); command.Parameters.AddWithValue("@KategoriId", digerUrun.KategoriId); command.Parameters.AddWithValue("@Ad", digerUrun.Ad); command.Parameters.AddWithValue("@Firma", digerUrun.Firma); command.Parameters.AddWithValue("@Fiyat", digerUrun.Fiyat); command.Parameters.AddWithValue("@BarkodNo", digerUrun.BarkodNo); command.Parameters.AddWithValue("@DisId", digerUrun.DisId); command.Parameters.AddWithValue("@Stok", digerUrun.Stok); command.ExecuteNonQuery(); _connection.Close(); }