private static KitapciDBContext GetContext()
{
if (context == null)
{
context = new KitapciDBContext();
}
return(context);
}
public static object MusteriGetir(int mid)
{
context = GetContext();
if (mid % 2 == 1)
{
return(context.onlineMusteris.Where(m => m.mid == mid).FirstOrDefault());
}
else
{
return(context.magazaMusteris.Where(m => m.mid == mid).FirstOrDefault());
}
}
public static string FaturaEkle(fatura f)
{
try
{
context = GetContext();
context.faturas.Add(f);
context.SaveChanges();
return("Fature eklendi");
}
catch
{
return("Fatura eklenemedi");
}
}
public static string SiparisEkle(siparisler s, kitap k)
{
context = GetContext();
if (MusteriKontrol(s.musteriNo))
{
context.siparislers.Add(s);
context.kitaps.Add(k);
context.SaveChanges();
return("Sipariş eklendi.");
}
else
{
return("Bu ID'de müşteri yok.");
}
}
public static List <fatura> FaturaGetirByMusteri(int mid)
{
context = GetContext();
decimal borc = context.kitaps.Where(k => k.siparisler.musteriNo == mid).Sum(a => a.miktar * a.birimFiyat);
//context.faturas.Where(x => x.odemelers.Where(y => y.odemeMiktari < borc) && x.siparisler.musteriNo == mid).ToList();
List <fatura> faturas = context.faturas.Where(x => x.siparisler.musteriNo == mid).ToList();
List <odemeler> odemee = context.odemelers.Where(x => x.fatura.siparisler.musteriNo == mid && x.odemeMiktari < borc).ToList();
List <fatura> faturalar = new List <fatura>();
foreach (fatura item in faturas)
{
if (item.odemelers.Count == 0 || item.odemelers.Where(y => y.odemeMiktari < borc).Count() > 0)
{
faturalar.Add(item);
}
}
return(faturalar);
}
public static void MusteriEkle(magazaMusteri m)
{
context = GetContext();
context.magazaMusteris.Add(m);
context.SaveChanges();
}
public static void MusteriEkle(onlineMusteri m)
{
context = GetContext();
context.onlineMusteris.Add(m);
context.SaveChanges();
}
public static bool MusteriKontrol(int mid)
{
context = GetContext();
return(context.musteris.Where(m => m.mid == mid).Count() > 0);
}
public static kitap KitapGetir(int sid)
{
context = GetContext();
return(context.kitaps.Where(m => m.sipNo == sid).First());
}
public static siparisler SiparisGetir(int sid)
{
context = GetContext();
return(context.siparislers.Where(m => m.siparisNo == sid).FirstOrDefault());
}
