protected void btnKaydet_Click(object sender, EventArgs e) { string ID = hdnID.Value; string KategoriAdi = txtKategoriAdi.Text; projeEntities entities = new projeEntities(); UrunKategorileri kategori; if (ID == "0") { kategori = new UrunKategorileri(); } else { kategori = entities.UrunKategorileris.FirstOrDefault(x => x.ID == int.Parse(ID)); } kategori.KategoriAdi = KategoriAdi; if (ID == "0") { entities.UrunKategorileris.Add(kategori); } entities.SaveChanges(); hdnID.Value = "0"; txtKategoriAdi.Text = ""; Goster(); }
protected void btnDuzenle_Click(object sender, EventArgs e) { projeEntities entities = new projeEntities(); LinkButton b = sender as LinkButton; ID = b.CommandArgument.ToString(); hdnID.Value = ID.ToString(); var banner = entities.KampanyaBanners.FirstOrDefault(x => x.bannerID == int.Parse(ID)); if (banner != null) { txtBannerAciklama.Text = banner.bannerAciklama; txtTarihi.Text = Convert.ToDateTime(banner.bannerTarih).ToString("yyyy-MM-dd"); bool aktif = banner.aktiflik.HasValue ? banner.aktiflik.Value : false; if (aktif) { rblAktiflik.Items[0].Selected = true; } else { rblAktiflik.Items[1].Selected = true; } } }
protected void btnKaydet_Click(object sender, EventArgs e) { projeEntities entities = new projeEntities(); string ID = hdnID.Value; ETicaret.Kullanicilar kullanici; if (ID == "0") { kullanici = new ETicaret.Kullanicilar(); } else { kullanici = entities.Kullanicilars.FirstOrDefault(x => x.ID == int.Parse(ID)); } kullanici.Ad = txtAd.Text; kullanici.Soyad = txtSoyad.Text; kullanici.Email = txtEmail.Text; kullanici.sifre = txtSifre.Text; kullanici.Yetki = int.Parse(txtYetki.SelectedValue); if (ID == "0") { entities.Kullanicilars.Add(kullanici); } entities.SaveChanges(); hdnID.Value = "0"; txtAd.Text = ""; txtSoyad.Text = ""; txtSifre.Text = ""; txtEmail.Text = ""; txtYetki.SelectedValue = "1"; Goster(); }
protected void Button2_Click(object sender, EventArgs e) { projeEntities entities = new projeEntities(); if (entities.Kullanicilars.Any(x => x.Email == TextBox1.Text && x.sifre == TextBox2.Text) == true) { var res = (from kullanici in entities.Kullanicilars where kullanici.Email == TextBox1.Text && kullanici.sifre == TextBox2.Text select new { kullanici.ID, kullanici.Ad, kullanici.Soyad, kullanici.Email, }).FirstOrDefault(); UserType u = new UserType(); u.ID = res.ID; u.Email = res.Email; u.Ad = res.Ad; u.Soyad = res.Soyad; Session["USER"] = u; Response.Redirect("default.aspx"); } }
void UrunResimleri() { projeEntities entities = new projeEntities(); var data = entities.UrunResimleris.Where(x => x.UrunID == int.Parse(hdnID.Value)).ToList(); rptResimler.DataSource = data; rptResimler.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { projeEntities entities = new projeEntities(); var data = entities.Urunlers.ToList(); Repeater1.DataSource = data; Repeater1.DataBind(); }
void Goster() { projeEntities entities = new projeEntities(); var Urunkategori = entities.UrunKategorileris.OrderBy(x => x.KategoriAdi).ToList(); GridView1.DataSource = Urunkategori; GridView1.DataBind(); }
void Goster() { projeEntities entities = new projeEntities(); var kullanıcılar = entities.Kullanicilars.OrderBy(x => x.Ad).ThenBy(x => x.Soyad).ToList(); GridView1.DataSource = kullanıcılar; GridView1.DataBind(); }
void Goster() { projeEntities entities = new projeEntities(); var data = entities.KampanyaBanners.OrderBy(x => x.bannerID).ToList(); GridView1.DataSource = data; GridView1.DataBind(); }
void Goster() { projeEntities entities = new projeEntities(); var uyeler = entities.Uyelers.OrderBy(x => x.ID).ToList(); GridView1.DataSource = uyeler; GridView1.DataBind(); }
protected void btnSil_Click(object sender, EventArgs e) { projeEntities entities = new projeEntities(); var urun = entities.Urunlers.FirstOrDefault(x => x.ID == int.Parse(hdnID.ID)); entities.Urunlers.Remove(urun); entities.SaveChanges(); goster(); }
protected void btnOnay_Click(object sender, EventArgs e) { LinkButton btn = sender as LinkButton; string ID = btn.CommandArgument; projeEntities entities = new projeEntities(); entities.UrunYorumlaris.FirstOrDefault(x => x.ID == int.Parse(ID)).YorumDurum = 1; entities.SaveChanges(); Goster(); }
protected void btnSil_Click(object sender, EventArgs e) { LinkButton btn = sender as LinkButton; string ID = btn.CommandArgument; projeEntities entities = new projeEntities(); entities.KampanyaBanners.Remove(entities.KampanyaBanners.FirstOrDefault(x => x.bannerID == int.Parse(ID))); entities.SaveChanges(); Goster(); }
protected void btnDuzenle_Click(object sender, EventArgs e) { LinkButton btn = sender as LinkButton; string ID = btn.CommandArgument; projeEntities entities = new projeEntities(); string kategori = entities.UrunKategorileris.FirstOrDefault(x => x.ID == int.Parse(ID)).KategoriAdi; txtKategoriAdi.Text = kategori; hdnID.Value = ID; }
protected void btnKaydet_Click(object sender, EventArgs e) { //hdnId ile düzenle butonundan gelen ID yi tutabildik string ID = hdnID.Value; string Sdurum = ddlSiparisDurumu.SelectedValue; projeEntities entities = new projeEntities(); entities.Siparislerims.FirstOrDefault(x => x.ID == int.Parse(ID)).SiparisDurumu = int.Parse(Sdurum); entities.SaveChanges(); goster(); }
protected void LinkButton2_Click(object sender, EventArgs e) { LinkButton btn = sender as LinkButton; string ID = btn.CommandArgument; hdnResimID.Value = ID; projeEntities entities = new projeEntities(); var data = entities.UrunResimleris.FirstOrDefault(x => x.ID == int.Parse(hdnResimID.Value)); chkVitrin.Checked = data.Vitrin.HasValue ? data.Vitrin.Value : false; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { projeEntities entities = new projeEntities(); var data = entities.SiparisDurumlaris.ToList(); ddlSiparisDurumu.DataSource = data; ddlSiparisDurumu.DataValueField = "ID"; ddlSiparisDurumu.DataTextField = "SiparisDurumu"; ddlSiparisDurumu.DataBind(); } goster(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { projeEntities entities = new projeEntities(); goster(); var data = entities.UrunKategorileris.ToList(); Kategori.DataValueField = "ID"; Kategori.DataTextField = "KategoriAdi"; Kategori.DataSource = data; Kategori.DataBind(); } }
protected void btnSil_Click(object sender, EventArgs e) { LinkButton btn = sender as LinkButton; string ID = btn.CommandArgument; projeEntities entities = new projeEntities(); UrunKategorileri kategori = entities.UrunKategorileris.FirstOrDefault(x => x.ID == int.Parse(ID)); if (kategori != null) { entities.UrunKategorileris.Remove(kategori); entities.SaveChanges(); } Goster(); }
void goster() { projeEntities entities = new projeEntities(); var data = (from urun in entities.Urunlers join urunkategori in entities.UrunKategorileris on urun.UrunKategorisi equals urunkategori.ID select new { urun.ID, urun.UrunAdi, urun.UrunKategorisi, urunkategori.KategoriAdi, urun.StokMiktari }).ToList(); GridView1.DataSource = data; GridView1.DataBind(); }
protected void btnSil_Click(object sender, EventArgs e) { LinkButton btn = sender as LinkButton; string ID = btn.CommandArgument; projeEntities entities = new projeEntities(); if (ID == "1") { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('ADMIN Kullanıcı silinemez!');", true); } else { entities.Kullanicilars.Remove(entities.Kullanicilars.FirstOrDefault(x => x.ID == int.Parse(ID))); entities.SaveChanges(); } Goster(); }
protected void btnResimUpload_Click(object sender, EventArgs e) { string path = Server.MapPath("/UrunResimleri/"); //string dosyaadi = FileUpload1.FileName; string dosyaadi = Guid.NewGuid().ToString().Replace("-", "") + ".jpg"; FileUpload1.SaveAs(path + dosyaadi); projeEntities entities = new projeEntities(); ETicaret.UrunResimleri resim = new UrunResimleri() { UrunID = int.Parse(hdnID.Value), Resim = dosyaadi, Vitrin = chkVitrin.Checked }; entities.UrunResimleris.Add(resim); entities.SaveChanges(); }
protected void btnDuzenle_Click(object sender, EventArgs e) { LinkButton btn = sender as LinkButton; string ID = btn.CommandArgument; projeEntities entities = new projeEntities(); var kullanici = entities.Kullanicilars.FirstOrDefault(x => x.ID == int.Parse(ID)); if (kullanici != null) { txtAd.Text = kullanici.Ad; txtSoyad.Text = kullanici.Soyad; txtEmail.Text = kullanici.Email; txtSifre.Text = kullanici.sifre; txtYetki.SelectedValue = kullanici.Yetki.ToString(); hdnID.Value = ID; } }
void Goster() { projeEntities entities = new projeEntities(); var yorumSonucu = (from urun in entities.Urunlers join yorum in entities.UrunYorumlaris on urun.ID equals yorum.UrunID join uye in entities.Uyelers on yorum.UyeID equals uye.ID select new { uye.ID, uye.Ad, urun.UrunAdi, yorum.Yorum, yorum.YorumDurum }).ToList(); GridView1.DataSource = yorumSonucu; GridView1.DataBind(); }
protected void LinkButton1_Click(object sender, EventArgs e) { LinkButton b = sender as LinkButton; ID = Convert.ToInt32(b.CommandArgument); hdnID.Value = ID.ToString(); projeEntities entities = new projeEntities(); var urun = entities.Urunlers.FirstOrDefault(x => x.ID == int.Parse(hdnID.ID)); if (urun != null) { UrunAdi.Text = urun.UrunAdi; Marka.Text = urun.UrunMarkasi; Fiyat.Text = urun.UrunOrijinalFiyati.ToString(); Indirim.Text = urun.IndirimOrani.ToString(); Kategori.SelectedValue = urun.UrunKategorisi.ToString(); } }
public void goster() { projeEntities entities = new projeEntities(); var data = (from siparis in entities.Siparislerims join urun in entities.Urunlers on siparis.UrunID equals urun.ID join siparisdurum in entities.SiparisDurumlaris on siparis.SiparisDurumu equals siparisdurum.ID join uye in entities.Uyelers on siparis.UyeID equals uye.ID select new { siparis.ID, uye.Ad, urun.UrunAdi, siparis.Tarih, siparisdurum.SiparisDurumu }).ToList(); GridView1.DataSource = data; GridView1.DataBind(); }
protected void Kaydet_Click(object sender, EventArgs e) { double orjfiyat = Convert.ToDouble(Fiyat.Text); double indirim = Indirim.Text == string.Empty ? Convert.ToDouble(Indirim.Text) : (double)0; double fiyat = orjfiyat - (orjfiyat * indirim / 100); int puan = 0; projeEntities entities = new projeEntities(); ETicaret.Urunler urun; if (hdnID.Value == "0") { urun = new ETicaret.Urunler(); } else { urun = entities.Urunlers.FirstOrDefault(x => x.ID == int.Parse(hdnID.ID)); } urun.UrunAdi = UrunAdi.Text; urun.UrunKategorisi = int.Parse(Kategori.SelectedValue); urun.UrunMarkasi = Marka.Text; urun.UrunFiyati = fiyat; urun.IndirimOrani = indirim; urun.UrunOrijinalFiyati = orjfiyat; urun.StokMiktari = Convert.ToDouble(StokMiktari.Text); urun.UrunAciklamasi = Aciklama.Text; urun.DegerlendirmePuani = Convert.ToDouble(puan); urun.Aktif = true; if (hdnID.Value == "0") { urun = entities.Urunlers.Add(urun); } if (entities.SaveChanges() > 0) { goster(); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Bir sorun oluştu ürün güncellenemedi!');", true); } }
protected void btnDuzenle_Click(object sender, EventArgs e) { LinkButton b = sender as LinkButton; ID = b.CommandArgument.ToString(); hdnID.Value = ID.ToString(); projeEntities entities = new projeEntities(); var sip = ( from siparis in entities.Siparislerims join urun in entities.Urunlers on siparis.UrunID equals urun.ID join siparisdurum in entities.SiparisDurumlaris on siparis.SiparisDurumu equals siparisdurum.ID select new { siparisdurum.SiparisDurumu, } ).FirstOrDefault().SiparisDurumu; if (sip != null) { ddlSiparisDurumu.DataTextField = sip.ToString(); } }
protected void btnKaydet_Click(object sender, EventArgs e) { projeEntities entities = new projeEntities(); string ID = hdnID.Value; string BannerAciklama = txtBannerAciklama.Text; DateTime Tarih = Convert.ToDateTime(txtTarihi.Text); bool aktiflik = Convert.ToBoolean(rblAktiflik.SelectedValue); string path = Server.MapPath("/KampanyaResimleri/"); //string dosyaadi = FileUpload1.FileName; string dosyaadi = Guid.NewGuid().ToString().Replace("-", "") + ".jpg"; FileUpload1.SaveAs(path + dosyaadi); KampanyaBanner banner; if (ID == "0") { banner = new KampanyaBanner(); } else { banner = entities.KampanyaBanners.FirstOrDefault(x => x.bannerID == int.Parse(ID)); } banner.aktiflik = aktiflik; banner.bannerResim = dosyaadi; banner.bannerTarih = Tarih; banner.bannerAciklama = BannerAciklama; banner.bannerResim = FileUpload1.HasFile ? dosyaadi : string.Empty; if (ID == "0") { entities.KampanyaBanners.Add(banner); } entities.SaveChanges(); hdnID.Value = "0"; Goster(); }