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