public static siparisler SiparisBul(int ID)
{
using (SuDBEntities s = new SuDBEntities())
{
return(s.siparisler.Find(ID));
}
}
public static List <MusteriModel> SiparisDepends()
{
List <MusteriModel> mList = new List <MusteriModel>();
using (SuDBEntities s = new SuDBEntities())
{
var sList = s.siparisler.ToList();
foreach (var item in sList)
{
if (item.Durum == "Hazirlaniyor" || item.Durum == "Yolda")
{
MusteriModel mm = new MusteriModel();
mm.siparis.siparisID = item.siparisID;
mm.siparis.musAdi = item.musAdi;
mm.siparis.musSoyadi = item.musSoyadi;
mm.siparis.musAdres = item.musAdres;
mm.siparis.Tutar = item.Tutar;
mm.siparis.Durum = item.Durum;
mList.Add(mm);
}
}
return(mList);
}
}
public static List <int> SiparisIDListele()
{
using (SuDBEntities s = new SuDBEntities())
{
List <int> sm = new List <int>();
var sList = s.siparisler.ToList();
foreach (var item in sList)
{
sm.Add(item.siparisID);
}
return(sm);
}
}
public static bool TumSiparisTablosunuSil(List <int> l)
{
using (SuDBEntities s = new SuDBEntities())
{
foreach (var item in l)
{
var bulunan = s.siparisler.Find(item);
s.siparisler.Remove(bulunan);
if (s.SaveChanges() < 0)
{
return(false);
}
}
return(true);
}
}
public static bool SiparisSil(int ID)
{
using (SuDBEntities s = new SuDBEntities())
{
var bulunan = s.siparisler.Find(ID);
s.siparisler.Remove(bulunan);
if (s.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public static bool DurumDegistir(MusteriModel mm)
{
using (SuDBEntities s = new SuDBEntities())
{
siparisler sip = ConvertToSiparis(mm);
s.Entry(sip).State = EntityState.Modified;
if (s.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public static bool SiparisEkle(MusteriModel mm)
{
using (SuDBEntities s = new SuDBEntities())
{
siparisler sip = ConvertToSiparis(mm);
s.siparisler.Add(sip);
if (s.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public static bool UpdateMusteri(MusteriModel mm)
{
using (SuDBEntities s = new SuDBEntities())
{
musteriler m = ConvertMusteri(mm);
s.Entry(m).State = EntityState.Modified;
if (s.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public static bool AddMusteri(MusteriModel mm)
{
using (SuDBEntities s = new SuDBEntities())
{
musteriler m = ConvertMusteri(mm);
s.musteriler.Add(m);
if (s.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public static bool RemoveMusteri(int ID)
{
using (SuDBEntities s = new SuDBEntities())
{
var bul = s.musteriler.Find(ID);
s.musteriler.Remove(bul);
if (s.SaveChanges() > 0)
{
return(true);
}
else
{
return(true);
}
}
}
public static List <MusteriModel> SiparisAsList()
{
using (SuDBEntities s = new SuDBEntities())
{
var list = s.siparisler.ToList();
List <MusteriModel> mList = new List <MusteriModel>();
foreach (var item in list)
{
MusteriModel mm = new MusteriModel();
mm.siparis.siparisID = item.siparisID;
mm.siparis.musAdi = item.musAdi;
mm.siparis.musSoyadi = item.musSoyadi;
mm.siparis.musAdres = item.musAdres;
mm.siparis.Tutar = item.Tutar;
mm.siparis.Durum = item.Durum;
mList.Add(mm);
}
return(mList);
}
}
public static List <MusteriModel> ReturnMusteri(string ad, string soyad)
{
using (SuDBEntities s = new SuDBEntities())
{
List <MusteriModel> mList = new List <MusteriModel>();
MusteriModel mm = new MusteriModel();
var list = MusteriAsList();
foreach (var item in list)
{
if (item.musteriAdi.Equals(ad) && item.musteriSoyadi.Equals(soyad))
{
mm.musteriID = item.musteriID;
mm.musteriAdi = item.musteriAdi;
mm.musteriSoyadi = item.musteriSoyadi;
mm.Adres = item.Adres;
mm.Telefon = item.Telefon;
mList.Add(mm);
}
}
return(mList);
}
}
public static List <MusteriModel> MusteriAsList() //Geri dönüş tipi MusteriModel , müşteri listesini döndür
{
List <MusteriModel> mList = new List <MusteriModel>();
using (SuDBEntities s = new SuDBEntities())
{
var list = s.musteriler.ToList();
foreach (var item in list)
{
MusteriModel mm = new MusteriModel();
mm.musteriID = item.musteriID;
mm.musteriAdi = item.musteriAdi;
mm.musteriSoyadi = item.musteriSoyadi;
mm.Adres = item.Adres;
mm.Telefon = item.Telefon;
mList.Add(mm);
}
return(mList);
}
}
