public Fatura Getir(int id)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
return(context.Fatura.AsNoTracking().SingleOrDefault(x => x.FaturaID == id));
}
}
public Kullanici KullaniciGiris(string kullaniciAdi, string kullaniciSifre)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
return(context.Kullanici.Where(x => x.KullaniciKodu == kullaniciAdi && x.Sifre == kullaniciSifre).SingleOrDefault());
}
}
public Kullanici Getir(int id)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
return(context.Kullanici.AsNoTracking().SingleOrDefault(x => x.KullaniciID == id));
}
}
public Stok Getir(int id)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
return(context.Stok.AsNoTracking().SingleOrDefault(x => x.StokID == id));
}
}
public List <Fatura> Listele(Expression <Func <Fatura, bool> > predicateExpression)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
return(context.Fatura.AsNoTracking().Where(predicateExpression).ToList());
}
}
public List <Fatura> Listele()
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
return(context.Fatura.AsNoTracking().ToList());
}
}
public List <Kullanici> Listele()
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
return(context.Kullanici.AsNoTracking().ToList());
}
}
public bool Sil(Kullanici entity)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
context.Kullanici.Remove(entity);
return(context.SaveChanges() > 0);
}
}
public bool Sil(int id)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
Kullanici silinecek = Getir(id);
return(Sil(silinecek));
}
}
public int Guncelle(Kullanici entity)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
context.Kullanici.AddOrUpdate(entity);
return(context.SaveChanges());
}
}
public List <Kullanici> Listele(Expression <Func <Kullanici, bool> > predicateExpression)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
return(context.Kullanici.AsNoTracking().Where(predicateExpression).ToList());
}
throw new NotImplementedException();
}
public bool Sil(Fatura entity)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
context.Fatura.Remove(entity);
return(context.SaveChanges() > 0);
}
}
public Kullanici Kaydet(Kullanici entity)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
context.Kullanici.Add(entity);
context.SaveChanges();
return(entity);
}
}
public Fatura Kaydet(Fatura entity)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
context.Fatura.Add(entity);
context.SaveChanges();
return(entity);
}
}
public Stok Kaydet(Stok entity)
{
using (var aaa = new SiparisTakipContext())
{
aaa.Stok.Add(entity);
SiparisTakipContext.SaveChanges();
return(entity);
}
}
public Stok Kaydet(Stok entity)
{
using (SiparisTakipContext context = new SiparisTakipContext())
{
context.Stok.Add(entity);
context.SaveChanges();
return(entity);
}
}
public EfGenericRepository()
{
context = new SiparisTakipContext();
}
