protected void btn_satınal_Click(object sender, EventArgs e) { UrunID = Convert.ToInt32(Request.QueryString["urunid"]); pcompone_1453Entities3 db = new pcompone_1453Entities3(); Urunler urun = (from i in db.Urunler where (i.urun_id == UrunID) select i).FirstOrDefault <Urunler>(); urun.urun_adet = Convert.ToInt32(sayii); int adet = Convert.ToInt32(sayii); int sayı = Convert.ToInt32(urun.fiyat); int sonuc; sonuc = adet * sayı; urun.toplamfiyat = sonuc; int satıs = Convert.ToInt32(urun.urunsatissayisi); int deger = satıs + 1; urun.urunsatissayisi = deger; db.SaveChanges(); Session["adet"] = sayii; Session["fiyat"] = urun.fiyat; Response.Redirect("satınal.aspx?urunid=" + UrunID + ""); }
protected void btn_guncel_Click(object sender, EventArgs e) { pcompone_1453Entities3 bd = new pcompone_1453Entities3(); kullaniciid = Convert.ToInt16(Session["ID"]); Kullanici kullanici = (from i in bd.Kullanici where (i.kullanici_id == kullaniciid) select i).FirstOrDefault <Kullanici>(); kullanici.adi = txtad.Text; kullanici.soyadi = txtsoyad.Text; kullanici.kullaniciadi = txt_kadi.Text; kullanici.sifre = txtsifre.Text; kullanici.email = txtemail.Text; kullanici.dogumtarihi = txtdogumtarihi.Text; kullanici.dogumyeri = txtdogumyeri.Text; kullanici.adres = txtadres.Text; kullanici.ceptelefonu = txtceptelefonu.Text; kullanici.sehir = txtsehir.Text; bd.SaveChanges(); Label2.Text = " Güncelleme Başarılı"; }
protected void Button2_Click(object sender, EventArgs e) { pcompone_1453Entities3 bd = new pcompone_1453Entities3(); kullaniciid = Convert.ToInt16(Session["ID"]); Kullanici kullanici = (from i in bd.Kullanici where (i.kullanici_id == kullaniciid) select i).FirstOrDefault <Kullanici>(); kullanici.adi = txtad.Text; kullanici.soyadi = txtsoyad.Text; kullanici.kullaniciadi = txt_kadi.Text; kullanici.sifre = txtsifre.Text; kullanici.email = txtemail.Text; kullanici.dogumtarihi = txtdogumtarihi.Text; kullanici.dogumyeri = txtdogumyeri.Text; kullanici.adres = txtadres.Text; kullanici.ceptelefonu = txtceptelefonu.Text; kullanici.sehir = txtsehir.Text; bd.SaveChanges(); Response.Write("<script lang='JavaScript'> alert ('Güncelleme Başarılı');</script>"); }
protected void btn_ekle_Click(object sender, EventArgs e) { Urunler urun = new Urunler(); urun.urunismi = txturunismi.Text; urun.fiyat = int.Parse(txturunfiyati.Text); urun.resim = txturunresmi.Text.ToString(); urun.durum = txturundurum.Text; urun.ozellikler = txturununozellikleri.Text; urun.garantisuresi = txtsure.Text; urun.urunturu = DropDownList1.SelectedItem.ToString(); urun.urunKategoriID = int.Parse(DropDownList1.SelectedValue); urun.eklenmetarihi = DateTime.Now; urun.urun_markaid = int.Parse(DropDownList2.SelectedValue); urun.urun_markaismi = DropDownList2.SelectedItem.ToString(); pcompone_1453Entities3 db = new pcompone_1453Entities3(); db.Urunler.AddObject(urun); db.SaveChanges(); Response.Write("<script lang='JavaScript'> alert ('Ürün Eklendi!');</script>"); Response.Redirect("urunekleme.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { string kisiadi = Session["uye_adim"].ToString(); pcompone_1453Entities3 db = new pcompone_1453Entities3(); Kullanici urun = (from i in db.Kullanici where (i.kullaniciadi == kisiadi) select i).FirstOrDefault <Kullanici>(); urun.sifre = TextBox1.Text; db.SaveChanges(); Response.Write("<script lang='JavaScript'> alert ('Şifre Değiştirldi');</script>"); }
protected void btnekle_Click(object sender, EventArgs e) { pcompone_1453Entities3 db = new pcompone_1453Entities3(); db.Kategori.AddObject(new Kategori() { kategoriismi = TextBox1.Text, MainKategori = int.Parse(maink.Text), AnaKategorisi = int.Parse(anak.Text), urun_markaid = int.Parse(urunmk.Text), }); db.SaveChanges(); }
protected void btn_odeme_Click(object sender, EventArgs e) { kullaniciid = Convert.ToInt16(Session["ID"]); UrunID = Convert.ToInt32(Request.QueryString["urunid"]); pcompone_1453Entities3 bd = new pcompone_1453Entities3(); pcompone_1453Entities3 hhh = new pcompone_1453Entities3(); var sorgu = from i in bd.Kullanici where (i.kullanici_id == kullaniciid) select i; if (sorgu.Count() != 0) { pcompone_1453Entities3 aa = new pcompone_1453Entities3(); SatilanUrunler saturun = new SatilanUrunler(); saturun.urunID = UrunID; saturun.kullaniciID = kullaniciid; saturun.datetime = DateTime.Now; saturun.urunadedi = Convert.ToInt16(Session["adet"]); saturun.toplamfiyat = Convert.ToInt16(Session["adet"]) * Convert.ToInt16(Session["fiyat"]); aa.SatilanUrunler.AddObject(saturun); aa.SaveChanges(); pcompone_1453Entities3 x = new pcompone_1453Entities3(); Urunler urun = (from i in x.Urunler where (i.urun_id == UrunID) select i).FirstOrDefault <Urunler>(); int adet = Convert.ToInt16(urun.StokAdedi); int adetsayisi = adet - Convert.ToInt16(Session["adet"]); urun.StokAdedi = adetsayisi; x.SaveChanges(); Response.Redirect("odeme.aspx?urunid=" + UrunID + ""); } else if (sorgu.Count() == 0) { pcompone_1453Entities3 db = new pcompone_1453Entities3(); Repeater1.DataSource = (from i in db.Urunler where (i.urun_id == UrunID) select i).ToList <Urunler>(); Repeater1.DataBind(); Response.Write("<script lang='JavaScript'> alert ('Ürünü Satın Alabilmeniz İçin Giriş Yapın veya Üye Olun');</script>"); } }
protected void btn_yorum_Click(object sender, EventArgs e) { UrunID = Convert.ToInt32(Request.QueryString["urunid"]); pcompone_1453Entities3 bdd = new pcompone_1453Entities3(); Urunler urun = (from i in bdd.Urunler where (i.urun_id == UrunID) select i).FirstOrDefault <Urunler>(); pcompone_1453Entities3 db = new pcompone_1453Entities3(); Kullanici kullanici = new Kullanici(); kullaniciid = Convert.ToInt16(Session["ID"]); Yorumlar yorum = new Yorumlar(); var sorgu = from i in db.Kullanici where (i.kullanici_id == kullaniciid) select i; if (sorgu.Count() != 0) { var query = from jjj in db.Kullanici where jjj.kullanici_id == kullaniciid select jjj.kullaniciadi; string kullaniciadiii = query.Single(); yorum.kisi_adi = kullaniciadiii; yorum.urun_id = UrunID; yorum.yorum = txt_yorum.Text; yorum.tarih = DateTime.Now; db.Yorumlar.AddObject(yorum); db.SaveChanges(); Response.Write("<script lang='JavaScript'> alert ('Yorumunuz onay verildikten sonra yayınlanacaktır.');</script>"); txt_yorum.Text = ""; } else { Response.Write("<script lang='JavaScript'> alert ('Lütfen giriş yapın veya üye olun');</script>"); } }
protected void btn_sil_Click(object sender, EventArgs e) { if (Request.QueryString["kategori_id"] != null) { int kategori_id = int.Parse(Request.QueryString["kategori_id"].ToString()); pcompone_1453Entities3 db = new pcompone_1453Entities3(); Kategori kategori = (from i in db.Kategori where (i.kategori_id == kategori_id) select i).FirstOrDefault <Kategori>(); kategori.kategoriismi = TextBox1.Text; db.Kategori.DeleteObject(kategori); db.SaveChanges(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { pcompone_1453Entities3 z = new pcompone_1453Entities3(); pcompone_1453Entities3 b = new pcompone_1453Entities3(); var abcc = from sa in z.Ziyaretci where (sa.Ipadress == ip) select ip; if (abcc.Count() == 0) { Ziyaretci ziyaretci = new Ziyaretci(); ziyaretci.Ipadress = ip; k.Ziyaretci.AddObject(ziyaretci); k.SaveChanges(); Hit hit = (from i in b.Hit where (i.hit_id == 1) select i).FirstOrDefault <Hit>(); int sayı = Convert.ToInt32(hit.site_hit); int deger = sayı + 1; hit.site_hit = deger; b.SaveChanges(); } else { Hit git = (from i in k.Hit select i).FirstOrDefault <Hit>(); } } pcompone_1453Entities3 db = new pcompone_1453Entities3(); Repeater1.DataSource = (from i in db.Urunler select i).Take(12); Repeater1.DataBind(); }
protected void btn_sil_Click(object sender, EventArgs e) { int urun_id = int.Parse(Request.QueryString["urun_id"].ToString()); pcompone_1453Entities3 db = new pcompone_1453Entities3(); Urunler urun = (from i in db.Urunler where (i.urun_id == urun_id) select i).FirstOrDefault <Urunler>(); urun.urunismi = urunismi.Text; urun.fiyat = int.Parse(urunfiyati.Text); urun.resim = urunresmi.Text; urun.durum = urunundurumu.Text; urun.ozellikler = urununozellikleri.Text; urun.garantisuresi = urunungarantisuresi.Text; urun.urunturu = DropDownList1.SelectedItem.ToString(); urun.urunKategoriID = int.Parse(DropDownList1.SelectedValue); db.Urunler.DeleteObject(urun); db.SaveChanges(); }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { kullaniciid = Convert.ToInt16(Session["ID"]); int urunid = Convert.ToInt16(e.CommandArgument); pcompone_1453Entities3 db = new pcompone_1453Entities3(); //int urunid = Convert.ToInt32(((LinkButton)e.Item.FindControl("lnkislem")).CommandName); if (e.CommandName.ToString() == "btnislem") { FavoriUrunler fav = (from i in db.FavoriUrunler where (i.urunID == urunid) && (i.kullaniciID == kullaniciid) select i).FirstOrDefault <FavoriUrunler>(); db.FavoriUrunler.DeleteObject(fav); db.SaveChanges(); doldur(); //Response.Write("satinalinan.aspx?kullaniciid=" + kullaniciid + ""); } }
protected void btn_begen_Click(object sender, EventArgs e) { kullaniciid = Convert.ToInt16(Session["ID"]); UrunID = Convert.ToInt32(Request.QueryString["urunid"]); pcompone_1453Entities3 db = new pcompone_1453Entities3(); Urunler urun = (from i in db.Urunler where (i.urun_id == UrunID) select i).FirstOrDefault <Urunler>(); var sorgu = from a in db.Kullanici where (a.kullanici_id == kullaniciid) select a; if (sorgu.Count() != 0) { int ht = Convert.ToInt32(urun.hit); int sonuc = ht + 1; urun.hit = sonuc; db.SaveChanges(); pcompone_1453Entities3 aa = new pcompone_1453Entities3(); FavoriUrunler favurun = new FavoriUrunler(); favurun.urunID = UrunID; favurun.kullaniciID = kullaniciid; favurun.datetime = DateTime.Now; aa.FavoriUrunler.AddObject(favurun); aa.SaveChanges(); Response.Redirect("urundetay.aspx?urunid=" + urun.urun_id + ""); } else if (sorgu.Count() == 0) { Response.Write("<script lang='JavaScript'> alert ('Lütfen giriş yapın veya üye olun');</script>"); } }
protected void Page_Load(object sender, EventArgs e) { txt_adet.Text = "1"; txt_adet.Enabled = false; if (!IsPostBack) { sayii = 1; kullaniciid = Convert.ToInt16(Session["ID"]); pcompone_1453Entities3 u = new pcompone_1453Entities3(); var abc = from sa in u.Ziyaretci where (sa.Ipadress != ip) select ip; if (abc.Count() != 0) { UrunID = Convert.ToInt32(Request.QueryString["urunid"]); pcompone_1453Entities3 bd = new pcompone_1453Entities3(); Urunler urun = (from i in bd.Urunler where (i.urun_id == UrunID) select i).FirstOrDefault <Urunler>(); int sayı = Convert.ToInt32(urun.urungoruntulenmesayisi); int deger = sayı + 1; urun.urungoruntulenmesayisi = deger; bd.SaveChanges(); } else { } } pcompone_1453Entities3 q = new pcompone_1453Entities3(); var getirme = (from f in q.FavoriUrunler where (f.urunID == UrunID) && (f.kullaniciID == kullaniciid) select f); if (getirme.Count() == 1) { btn_begen.BackColor = System.Drawing.Color.Yellow; btn_begen.Text = "FAVORİLERE EKLENDİ"; btn_begen.Enabled = false; btn_begen.ToolTip = "Kullanıcı Panelinizden Ürünü Favoriden Çıkartabilirsiniz"; } UrunID = Convert.ToInt32(Request.QueryString["urunid"]); pcompone_1453Entities3 db = new pcompone_1453Entities3(); Repeater1.DataSource = (from i in db.Urunler where (i.urun_id == UrunID) select i).ToList <Urunler>(); Repeater1.DataBind(); pcompone_1453Entities3 a = new pcompone_1453Entities3(); UrunID = Convert.ToInt32(Request.QueryString["urunid"]); kullaniciid = Convert.ToInt16(Session["ID"]); Repeater2.DataSource = (from i in a.Yorumlar where (i.urun_id == UrunID) where (i.onay == 1) orderby i.tarih descending select i).Take(3); Repeater2.DataBind(); pcompone_1453Entities3 klm = new pcompone_1453Entities3(); Repeater3.DataSource = (from i in db.Urunler where (i.urun_id == UrunID) select i).ToList <Urunler>(); Repeater3.DataBind(); }