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