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