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