public UrunSiparis UrunSiparisEkle(UrunSiparis mahmut) { var result = _context.UrunSiparis.Add(mahmut); _context.SaveChanges(); return(result.Entity); }
public ActionResult SiparisKayit(SiparisVM vm) { try { var user = SesionHelper.Get <Users>("Kullanici"); long userID = 0; if (user != null && user.ID != 0) { userID = user.ID; } ContextDB db = new ContextDB(); Siparis siparis = new Siparis { Adi = vm.Adi, Email = vm.Email, Adres = vm.Adres, IlceIl = vm.IlceIl, PostaKodu = vm.PostaKodu, Soyadi = vm.Soyadi, TelefonNo = vm.TelefonNo, ÜlkeAdi = vm.ÜlkeAdi, UserID = userID }; db.Siparis.Add(siparis); db.SaveChanges(); var sepettekiUrunler = new List <SepetVM>(); List <long> rerer = new List <long>(); sepettekiUrunler = (List <SepetVM>)Session["SepettekiUrunler"]; List <UrunSiparis> urunSiparis = new List <UrunSiparis>(); List <Urun> dbUrunler = new List <Urun>();//stoktan düşürülecekleri tutacağımız liste if (sepettekiUrunler != null && sepettekiUrunler.Count > 0) { rerer = sepettekiUrunler.Select(x => x.ID).ToList(); dbUrunler = db.Urun.Where(x => rerer.Contains(x.ID) && x.Aktif).ToList(); foreach (var item in dbUrunler) { item.StokMiktari = item.StokMiktari - sepettekiUrunler.FirstOrDefault(x => x.ID == item.ID).SepettekiUrunAdedi; } db.SaveChanges(); } foreach (var item in sepettekiUrunler) { UrunSiparis urun = new UrunSiparis(); urun.SiparisID = siparis.ID; urun.UrunID = item.ID; urun.SiparisEdilenUrunAdedi = item.SepettekiUrunAdedi; urunSiparis.Add(urun); } if (urunSiparis.Count > 0) { db.UrunSiparis.AddRange(urunSiparis); db.SaveChanges(); } if (dbUrunler != null && dbUrunler.Count > 0) { foreach (var item in dbUrunler) { var result = db.Urun.FirstOrDefault(x => x.ID == item.ID && x.Aktif); if (result != null) { result.StokMiktari = item.StokMiktari; db.SaveChanges(); } } } return(RedirectToAction("Siparisler")); } catch (Exception ex) { return(View()); } }