public void sepeteekle(int URUNID, int quantity, string urunadi, string urunresimyol, int urunfiyat)
        {
            List <C_SEPET> d  = db.C_SEPET.ToList();
            C_SEPET        cs = new C_SEPET();


            if (d.Any(x => x.S_URUNID == URUNID))
            {
                db.C_SEPET.First(x => x.S_URUNID == URUNID).S_URUNADET++;
            }
            else
            {
                cs.S_URUNADET = quantity;


                cs.S_URUNID    = URUNID;
                cs.S_URUNADI   = urunadi;
                cs.S_URUNFIYAT = urunfiyat;

                cs.S_URUNRESIM = urunresimyol;
                db.C_SEPET.Add(cs);
            }

            db.SaveChanges();

            sepetbilgileri();
        }
        public void sepeturunsil(int id)
        {
            List <C_SEPET> d = db.C_SEPET.ToList();

            if (d.Any(x => x.S_URUNID == id) && d.Any(x => x.S_URUNADET > 1))
            {
                db.C_SEPET.First(x => x.S_URUNID == id).S_URUNADET--;
                db.SaveChanges();
            }
            else
            {
                C_SEPET u = db.C_SEPET.FirstOrDefault(x => x.S_URUNID == id);
                db.C_SEPET.Remove(u);
            }
            db.SaveChanges();
        }