public List <Product> GetUnitePrice(decimal price)
{
using (NorthWindContext context = new NorthWindContext())
{
return(context.Products.Where(x => x.UnitPrice >= price).ToList());
}
}
public List <Product> GetAll(Expression <Func <Product, bool> > filter = null)
{
using (NorthWindContext context = new NorthWindContext())
{
return(context.Products.ToList());
}
}
public List <Product> GetAll()
{
using (NorthWindContext context = new NorthWindContext())
{
return(context.Products.ToList());
}
}
public List <Product> GetUnitePrice(decimal max, decimal min)
{
using (NorthWindContext context = new NorthWindContext())
{
return(context.Products.Where(x => x.UnitPrice >= min && x.UnitPrice < max).ToList());
//where ile direkt tablodan koşul ile veri alabiliyoruz
}
}
public void Delete(Product products)
{
using (NorthWindContext context = new NorthWindContext())
{
var entity = context.Entry(products);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
}
public Product GetByID(int id)
{
using (NorthWindContext context = new NorthWindContext())
{
return(context.Products.FirstOrDefault(x => x.ProductId == id));
// return context.Products.SingleOrDefault(x => x.ID == id);
//tabloda eğer gönderilen id varsa veri çek yoksa default null gönder firstordefault
//tabloda eğer gönderilen id birden fazla ise sadece bir veriyi çek yoksa default null gönder singleordefault
}
}
public void Add(Product products)
{
using (NorthWindContext context = new NorthWindContext())
{
//context.Products.Add(products);
var entity = context.Entry(products);
entity.State = EntityState.Added;
context.SaveChanges();
}
}