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