protected void Page_Load(object sender, EventArgs e) { sqlbaglantisi baglan = new sqlbaglantisi(); baglan.baglan.Open(); if (Session["kullaniciadii"] == null) { Response.Redirect("admingiris.aspx"); } urunID = Request.QueryString["urunID"]; islem = Request.QueryString["islem"]; if (islem == "sil") { SqlCommand cmdsil = new SqlCommand("delete from urun where id='" + urunID + "'", baglan.baglan); cmdsil.ExecuteNonQuery(); } SqlCommand cmdugetir = new SqlCommand("select * from urun", baglan.baglan); SqlDataReader drugetir = cmdugetir.ExecuteReader(); dl_urungunleme.DataSource = drugetir; dl_urungunleme.DataBind(); baglan.baglan.Close(); }
protected void ddl_il_SelectedIndexChanged(object sender, EventArgs e) { sqlbaglantisi baglan = new sqlbaglantisi(); baglan.baglan.Open(); SqlCommand comm = new SqlCommand("Select id,ad from ilce where il_id=" + ddl_il.SelectedItem.Value, baglan.baglan); try { SqlDataReader reader = comm.ExecuteReader(); ddl_ilce.DataSource = reader; ddl_ilce.DataValueField = "id"; ddl_ilce.DataTextField = "ad"; ddl_ilce.DataBind(); reader.Close(); baglan.baglan.Close(); } catch { Response.Write("Bir hata oluştu"); } }
protected void Page_Load(object sender, EventArgs e) { sqlbaglantisi baglan = new sqlbaglantisi(); baglan.baglan.Open(); if (!IsPostBack) { SqlCommand com = new SqlCommand("Select id, ad from il", baglan.baglan); try { SqlDataReader reader = com.ExecuteReader(); ddl_il.DataSource = reader; ddl_il.DataValueField = "id"; ddl_il.DataTextField = "ad"; ddl_il.DataBind(); reader.Close(); baglan.baglan.Close(); } catch { Response.Write("Bir hata oluştu"); } } }
protected void Button1_Click(object sender, EventArgs e) { sqlbaglantisi baglan = new sqlbaglantisi(); baglan.baglan.Open(); if (fu_urunresim.HasFile) { fu_urunresim.SaveAs(Server.MapPath("/admin/img/" + fu_urunresim.FileName)); SqlCommand yeni = new SqlCommand("select id from kategori where ad='" + ddl_kategoriadi.Text + "'", baglan.baglan); SqlCommand yeni1 = new SqlCommand("select id from marka where ad='" + ddl_markaadi.Text + "'", baglan.baglan); Object a = yeni.ExecuteScalar(); Object b = yeni1.ExecuteScalar(); SqlCommand cmdekle = new SqlCommand("insert into urun (kategori_id,marka_id,ad,birim_fiyat,aciklama,kodu,resim) Values('" + a + "','" + b + "','" + txt_urunadi.Text + "','" + txt_birimfiyat.Text + "','" + txt_urunaciklama.Text + "','" + txt_urunkodu.Text + "','/admin/img/" + fu_urunresim.FileName + "')", baglan.baglan); cmdekle.ExecuteNonQuery(); Response.Redirect("adminpanel.aspx"); } else { Response.Write("<script>alert('Lütfen bir resim ekleyiniz!')</script>"); } baglan.baglan.Close(); }
protected void btn_kaydet_Click(object sender, EventArgs e) { sqlbaglantisi baglan = new sqlbaglantisi(); baglan.baglan.Open(); SqlCommand cmdekle = new SqlCommand("insert into musteri_hesap (kullanici_adi,sifre,email) Values('" + txt_kkullaniciadi.Text + "','" + txt_ksifre.Text + "','" + txt_email.Text + "')", baglan.baglan); cmdekle.ExecuteNonQuery(); Response.Redirect("/default.aspx"); baglan.baglan.Close(); }
protected void Page_Load(object sender, EventArgs e) { sqlbaglantisi baglan = new sqlbaglantisi(); baglan.baglan.Open(); if (Session["kullaniciadii"] == null) { Response.Redirect("admingiris.aspx"); } urunID = Request.QueryString["urunID"]; if (Page.IsPostBack == false) { SqlCommand cmduduzenle = new SqlCommand("select * from urun where id='" + urunID + "'", baglan.baglan); SqlDataReader druduzenle = cmduduzenle.ExecuteReader(); SqlCommand cmdkategoriid = new SqlCommand("select kategori_id from urun where id='" + urunID + "'", baglan.baglan); Object a = cmdkategoriid.ExecuteScalar(); SqlCommand cmdmarkaid = new SqlCommand("select marka_id from urun where id='" + urunID + "'", baglan.baglan); Object b = cmdmarkaid.ExecuteScalar(); SqlCommand cmdgetir = new SqlCommand("select k.ad from kategori k,urun u where u.id='" + urunID + "' and k.id='" + a + "'", baglan.baglan); Object kategoriadi = cmdgetir.ExecuteScalar(); ddl_kategoriadi.Text = kategoriadi.ToString(); SqlCommand cmdgetir1 = new SqlCommand("select m.ad from marka m,urun u where u.id='" + urunID + "' and m.id='" + b + "'", baglan.baglan); Object markaadi = cmdgetir1.ExecuteScalar(); ddl_markaadi.Text = markaadi.ToString(); DataTable dtuduzenle1 = new DataTable("tablo"); dtuduzenle1.Load(druduzenle); foreach (DataRow item in dtuduzenle1.Rows) { txt_birimfiyat.Text = item["birim_fiyat"].ToString(); txt_urunadi.Text = item["ad"].ToString(); txt_urunkodu.Text = item["kodu"].ToString(); txt_urunaciklama.Text = item["aciklama"].ToString(); } } baglan.baglan.Close(); }
protected void btn_kaydet_Click1(object sender, EventArgs e) { sqlbaglantisi baglan = new sqlbaglantisi(); baglan.baglan.Open(); SqlCommand cmdkontrol = new SqlCommand("select kullanici_adi from musteri_hesap where kullanici_adi='" + txt_kkullaniciadi.Text + "'", baglan.baglan); Object kontrol = cmdkontrol.ExecuteScalar(); if (kontrol == null) { SqlCommand cmdekle = new SqlCommand("insert into musteri_hesap (kullanici_adi,sifre,email) Values('" + txt_kkullaniciadi.Text + "','" + txt_ksifre.Text + "','" + txt_email.Text + "')", baglan.baglan); cmdekle.ExecuteNonQuery(); SqlCommand cmdmhid = new SqlCommand("select id from musteri_hesap where kullanici_adi='" + txt_kkullaniciadi.Text + "'", baglan.baglan); Object b = cmdmhid.ExecuteScalar(); SqlCommand cmdiid = new SqlCommand("select id from il where ad='" + ddl_il.SelectedItem + "'", baglan.baglan); Object c = cmdiid.ExecuteScalar(); SqlCommand cmdilceid = new SqlCommand("select id from ilce where ad='" + ddl_ilce.SelectedItem + "'", baglan.baglan); Object d = cmdilceid.ExecuteScalar(); if (rbtn_erkek.Checked) { cinsiyet = "E"; } else { cinsiyet = "K"; } SqlCommand cmdekle1 = new SqlCommand("insert into musteri (ad,soyad,telefon,cinsiyet,il_id,ilce_id,musteri_hesap_id) Values('" + txt_ad.Text + "','" + txt_soyad.Text + "','" + txt_telefon.Text + "','" + cinsiyet + "','" + c + "','" + d + "','" + b + "')", baglan.baglan); cmdekle1.ExecuteNonQuery(); Response.Redirect("/default.aspx"); } else { Response.Write("<script>alert('Kullanıcı adınız önceden kullanılmıştır!')</script>"); } baglan.baglan.Close(); }
protected void btn_kaydet_Click(object sender, EventArgs e) { sqlbaglantisi baglan = new sqlbaglantisi(); baglan.baglan.Open(); SqlCommand cmdilid = new SqlCommand("select id from il where ad='" + ddl_il.Text + "'", baglan.baglan); Object a = cmdilid.ExecuteScalar(); SqlCommand cmdilceid = new SqlCommand("select id from ilce where ad='" + ddl_ilce.Text + "'", baglan.baglan); Object b = cmdilceid.ExecuteScalar(); SqlCommand cmdmhi = new SqlCommand("select id from musteri_hesap where kullanici_adi='" + Session["kullaniciadi"] + "'", baglan.baglan); Object mhid = cmdmhi.ExecuteScalar(); SqlCommand cmd = new SqlCommand("update musteri_hesap set kullanici_adi='" + txt_kullaniciadi.Text + "',sifre='" + txt_sifre.Text + "',email='" + txt_email.Text + "' where id='" + mhid + "'", baglan.baglan); cmd.ExecuteNonQuery(); if (rbtn_erkek.Checked) { cinsiyet = "E"; } else { cinsiyet = "K"; } SqlCommand cmd1 = new SqlCommand("update musteri set ad='" + txt_ad.Text + "',soyad='" + txt_soyad.Text + "',telefon='" + txt_telefon.Text + "',cinsiyet='" + cinsiyet + "',il_id='" + a + "',ilce_id='" + b + "' where musteri_hesap_id='" + mhid + "'", baglan.baglan); cmd1.ExecuteNonQuery(); Session["kullaniciadi"] = txt_kullaniciadi.Text; Response.Redirect("profil.aspx"); baglan.baglan.Close(); }
protected void btn_giris_Click1(object sender, EventArgs e) { sqlbaglantisi baglan = new sqlbaglantisi(); baglan.baglan.Open(); SqlCommand cmd = new SqlCommand("Select * from musteri_hesap where kullanici_adi='" + txt_kullaniciadi.Text + "' and sifre='" + txt_sifre.Text + "'", baglan.baglan); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { Session["kullaniciadi"] = dr["kullanici_adi"]; Response.Redirect("/default.aspx"); } else { Response.Write("<script>alert('Kullanıcı adı veya şifre hatalı!')</script>"); } baglan.baglan.Close(); }
protected void btn_kaydet_Click(object sender, EventArgs e) { sqlbaglantisi baglan = new sqlbaglantisi(); baglan.baglan.Open(); SqlCommand cmdkategoriid = new SqlCommand("select id from kategori where ad='" + ddl_kategoriadi.Text + "'", baglan.baglan); Object a = cmdkategoriid.ExecuteScalar(); SqlCommand cmdmarkaid = new SqlCommand("select id from marka where ad='" + ddl_markaadi.Text + "'", baglan.baglan); Object b = cmdmarkaid.ExecuteScalar(); SqlCommand cmd = new SqlCommand("update urun set kategori_id='" + a + "',marka_id='" + b + "',ad='" + txt_urunadi.Text + "',birim_fiyat='" + txt_birimfiyat.Text + "',aciklama='" + txt_urunaciklama.Text + "',kodu='" + txt_urunkodu.Text + "' where id='" + urunID + "'", baglan.baglan); cmd.ExecuteNonQuery(); Response.Redirect("urungunleme.aspx"); baglan.baglan.Close(); }
protected void btn_giris_Click(object sender, EventArgs e) { sqlbaglantisi baglan = new sqlbaglantisi(); baglan.baglan.Open(); SqlCommand cmd = new SqlCommand("Select * from admin where kullanici_adi='" + txt_kullaniciadi.Text + "' and sifre='" + txt_sifre.Text + "'", baglan.baglan); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { Session["kullaniciadii"] = dr["kullanici_adi"]; Response.Redirect("urunekle.aspx"); } else { lbl_hata.Visible = true; lbl_hata.Text = "Hatalı giriş Yaptınız!"; } baglan.baglan.Close(); }
protected void Page_Load(object sender, EventArgs e) { sqlbaglantisi baglan = new sqlbaglantisi(); baglan.baglan.Open(); //if (!IsPostBack) //{ // SqlCommand com = new SqlCommand("Select id, ad from il", baglan.baglan); // try // { // SqlDataReader reader = com.ExecuteReader(); // ddl_il.DataSource = reader; // ddl_il.DataValueField = "id"; // ddl_il.DataTextField = "ad"; // ddl_il.DataBind(); // //ddl_il.Items.Insert(0, new ListItem(iladi.ToString(), b.ToString())); // reader.Close(); // } // catch // { // Response.Write("Bir hata oluştu"); // } //} //SqlCommand comm = new SqlCommand("Select id,ad from ilce", baglan.baglan); //try //{ // SqlDataReader reader = comm.ExecuteReader(); // ddl_ilce.DataSource = reader; // ddl_ilce.DataValueField = "id"; // ddl_ilce.DataTextField = "ad"; // ddl_ilce.DataBind(); // //ddl_ilce.Items.Insert(0, new ListItem(ilceadi.ToString(), c.ToString())); // reader.Close(); //} //catch //{ // Response.Write("Bir hata oluştu"); //} SqlCommand cmdmhi = new SqlCommand("select id from musteri_hesap where kullanici_adi='" + Session["kullaniciadi"] + "'", baglan.baglan); Object mhid = cmdmhi.ExecuteScalar(); if (Page.IsPostBack == false) { SqlCommand cmduduzenle = new SqlCommand("select * from musteri where musteri_hesap_id='" + mhid + "'", baglan.baglan); SqlDataReader druduzenle = cmduduzenle.ExecuteReader(); SqlCommand cmdilid = new SqlCommand("select il_id from musteri where musteri_hesap_id='" + mhid + "'", baglan.baglan); Object b = cmdilid.ExecuteScalar(); SqlCommand cmdilceid = new SqlCommand("select ilce_id from musteri where musteri_hesap_id='" + mhid + "'", baglan.baglan); Object c = cmdilceid.ExecuteScalar(); SqlCommand cmdgetiril = new SqlCommand("select i.ad from il i,musteri m where m.musteri_hesap_id='" + mhid + "' and i.id='" + b + "'", baglan.baglan); Object iladi = cmdgetiril.ExecuteScalar(); ddl_il.Text = iladi.ToString(); SqlCommand cmdgetirilce = new SqlCommand("select i.ad from ilce i,musteri m where m.musteri_hesap_id='" + mhid + "' and i.id='" + c + "'", baglan.baglan); Object ilceadi = cmdgetirilce.ExecuteScalar(); ddl_ilce.Text = ilceadi.ToString(); SqlCommand cmdgetirka = new SqlCommand("select kullanici_adi from musteri_hesap where id='" + mhid + "'", baglan.baglan); Object ka = cmdgetirka.ExecuteScalar(); txt_kullaniciadi.Text = ka.ToString(); SqlCommand cmdgetirsifre = new SqlCommand("select sifre from musteri_hesap where id='" + mhid + "'", baglan.baglan); Object sifre = cmdgetirsifre.ExecuteScalar(); txt_sifre.Text = sifre.ToString(); SqlCommand cmdgetiremail = new SqlCommand("select email from musteri_hesap where id='" + mhid + "'", baglan.baglan); Object email = cmdgetiremail.ExecuteScalar(); txt_email.Text = email.ToString(); DataTable dtuduzenle1 = new DataTable("tablo"); dtuduzenle1.Load(druduzenle); foreach (DataRow item in dtuduzenle1.Rows) { txt_ad.Text = item["ad"].ToString(); txt_soyad.Text = item["soyad"].ToString(); txt_telefon.Text = item["telefon"].ToString(); if (item["cinsiyet"].ToString() == "E") { rbtn_erkek.Checked = true; } else { rbtn_kadın.Checked = true; } } } baglan.baglan.Close(); }