protected void Page_Load(object sender, EventArgs e)
 {
     if (Page.IsPostBack == false)
     {
         if (Session["KoleksiyonerEmail"] != null)
         {
             string        kEmail     = Session["KoleksiyonerEmail"].ToString();
             SqlCommand    cmdSession = new SqlCommand("Select * from Koleksiyoner where KoleksiyonerEmail='" + kEmail + "'", bag.baglan());
             SqlDataReader drSession  = cmdSession.ExecuteReader();
             DatalistProfilBilgi.DataSource = drSession;
             DatalistProfilBilgi.DataBind();
             SqlCommand cmdForum = new SqlCommand("Select * from ForumKonu ", bag.baglan());
             DropdownForumKonu.DataSource     = cmdForum.ExecuteReader();;
             DropdownForumKonu.DataTextField  = "ForumKonuBaslik";
             DropdownForumKonu.DataValueField = "ForumKonuID";
             DropdownForumKonu.DataBind();
             SqlCommand    cmdForum1 = new SqlCommand("Select * from ForumKonu where KategoriAdi='" + DropdownForumKonu.SelectedItem.Text + "' ", bag.baglan());
             SqlDataReader drForum   = cmdForum1.ExecuteReader();
             DataListForumKonuGetir.DataSource = drForum;
             DataListForumKonuGetir.DataBind();
         }
         else
         {
             Response.Redirect("KullaniciGiris.aspx");
         }
     }
 }
Exemple #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            SQLBaglanti bag = new SQLBaglanti();

            if (!Page.IsPostBack)
            {
                if (Session["KoleksiyonerEmail"] != null)
                {
                    //kategori çek
                    SqlCommand    cmd = new SqlCommand("Select * from Kategori", bag.baglan());
                    SqlDataReader dr  = cmd.ExecuteReader();
                    DropDownListKategori.DataTextField  = "KategoriAdi";
                    DropDownListKategori.DataValueField = "KategoriID";
                    DropDownListKategori.DataSource     = dr;
                    DropDownListKategori.DataBind();

                    string        kEmail     = Session["KoleksiyonerEmail"].ToString();
                    SqlCommand    cmdSession = new SqlCommand("Select * from Koleksiyoner where KoleksiyonerEmail='" + kEmail + "'", bag.baglan());
                    SqlDataReader drSession  = cmdSession.ExecuteReader();
                    DatalistProfilBilgi.DataSource = drSession;
                    DatalistProfilBilgi.DataBind();
                }
                else
                {
                    Response.Redirect("KullaniciGiris.aspx");
                }
            }
        }
Exemple #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            UrunID = Request.QueryString["UrunID"];


            SqlCommand    cmuGetir = new SqlCommand("Select * from Urun where UrunID='" + UrunID + "'", baglan.baglan());
            SqlDataReader druGetir = cmuGetir.ExecuteReader();

            Datalist1.DataSource = druGetir;
            Datalist1.DataBind();
            if (Session["KoleksiyonerEmail"] != null)
            {
                string        kEmail     = Session["KoleksiyonerEmail"].ToString();
                SqlCommand    cmdSession = new SqlCommand("Select * from Koleksiyoner where KoleksiyonerEmail='" + kEmail + "'", baglan.baglan());
                SqlDataReader drSession  = cmdSession.ExecuteReader();
                DatalistProfilBilgi.DataSource = drSession;
                DatalistProfilBilgi.DataBind();
                Panel1.Visible = false;
                //SqlCommand cmYorumGetir = new SqlCommand("Select * from ForumKonuYorum where ForumKonuID=" + ForumKonuID + "", baglan.baglan());
                //SqlDataReader drYorumGetir = cmYorumGetir.ExecuteReader();
                //DatalistMesajGetir.DataSource = drYorumGetir;
                //DatalistMesajGetir.DataBind();
            }
            else
            {
                Panel2.Visible = false;
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            ForumKonuID = Request.QueryString["ForumKonuID"];
            islem       = Request.QueryString["islem"];

            if (islem == "sil")
            {
                SqlCommand cmuSil = new SqlCommand("Delete from ForumKonu where ForumKonuID='" + ForumKonuID + "'", baglan.baglan());
                cmuSil.ExecuteNonQuery();
            }
            if (Session["KoleksiyonerEmail"] != null)
            {
                string        kEmail     = Session["KoleksiyonerEmail"].ToString();
                SqlCommand    cmdSession = new SqlCommand("Select * from Koleksiyoner where KoleksiyonerEmail='" + kEmail + "'", baglan.baglan());
                SqlDataReader drSession  = cmdSession.ExecuteReader();
                DatalistProfilBilgi.DataSource = drSession;
                DatalistProfilBilgi.DataBind();
                SqlCommand    cmForumKonuGetir = new SqlCommand("Select * from ForumKonu", baglan.baglan());
                SqlDataReader drForumKonuGetir = cmForumKonuGetir.ExecuteReader();

                DataListKonuGetir.DataSource = drForumKonuGetir;
                DataListKonuGetir.DataBind();
            }
            else
            {
                Response.Redirect("KullaniciGiris.aspx");
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Page.IsPostBack == false)
            {
                if (Session["KoleksiyonerEmail"] != null)
                {
                    string        kEmail     = Session["KoleksiyonerEmail"].ToString();
                    SqlCommand    cmdSession = new SqlCommand("Select * from Koleksiyoner where KoleksiyonerEmail='" + kEmail + "'", bag.baglan());
                    SqlDataReader drSession  = cmdSession.ExecuteReader();
                    DatalistProfilBilgi.DataSource = drSession;
                    DatalistProfilBilgi.DataBind();
                    SqlCommand cmdKoleksiyoner = new SqlCommand("Select * from Koleksiyoner where KoleksiyonerEmail='" + kEmail + "'", bag.baglan());
                    cmdKoleksiyoner.ExecuteNonQuery();
                    SqlDataReader drKoleksiyoner = cmdKoleksiyoner.ExecuteReader();

                    DataTable dtKGuncelle = new DataTable("tablo");
                    dtKGuncelle.Load(drKoleksiyoner);
                    DataRow row = dtKGuncelle.Rows[0];
                    txtAd.Text    = row["KoleksiyonerAdi"].ToString();
                    txtEmail.Text = row["KoleksiyonerEmail"].ToString();
                    txtSifre.Text = row["KoleksiyonerSifre"].ToString();
                    txtTel.Text   = row["KoleksiyonerTelefon"].ToString();
                    txtAdres.Text = row["KoleksiyonerAdres"].ToString();
                }
                else
                {
                    Response.Redirect("KullaniciGiris.aspx");
                }
            }
        }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Session["KoleksiyonerEmail"] != null)
     {
         string        kEmail     = Session["KoleksiyonerEmail"].ToString();
         SqlCommand    cmdSession = new SqlCommand("Select * from Koleksiyoner where KoleksiyonerEmail='" + kEmail + "'", baglan.baglan());
         SqlDataReader drSession  = cmdSession.ExecuteReader();
         DatalistProfilBilgi.DataSource = drSession;
         DatalistProfilBilgi.DataBind();
         Panel1.Visible = false;
     }
     else
     {
         DatalistProfilBilgi.Visible = false;
         Panel2.Visible = false;
     }
 }
Exemple #7
0
        protected void Page_Load(object sender, EventArgs e)
        {
            ForumKonuID = Request.QueryString["ForumKonuID"];
            if (Page.IsPostBack == false)
            {
                if (Session["KoleksiyonerEmail"] != null)
                {
                    //kategori çek
                    SqlCommand    cmd = new SqlCommand("Select * from Kategori ", baglan.baglan());
                    SqlDataReader dr  = cmd.ExecuteReader();
                    DropDownListKonu.DataTextField  = "KategoriAdi";
                    DropDownListKonu.DataValueField = "KategoriID";
                    DropDownListKonu.DataSource     = dr;
                    DropDownListKonu.DataBind();

                    SqlCommand    cmdKonuGetir   = new SqlCommand("Select * from ForumKonu where ForumKonuID='" + ForumKonuID + "'", baglan.baglan());
                    SqlDataReader drKonuGuncelle = cmdKonuGetir.ExecuteReader();
                    DataTable     dtKonuGuncelle = new DataTable("tablo");
                    dtKonuGuncelle.Load(drKonuGuncelle);
                    DataRow row = dtKonuGuncelle.Rows[0];

                    txtKonuAdi.Text = row["ForumKonuBaslik"].ToString();
                    txtIcerik.Text  = row["ForumKonuIcerik"].ToString();
                    SqlCommand    cmd2 = new SqlCommand("Select * from Kategori where KategoriAdi='" + row["KategoriAdi"].ToString() + "'", baglan.baglan());
                    SqlDataReader dr2  = cmd2.ExecuteReader();
                    DataTable     dt2  = new DataTable("tablo");
                    dt2.Load(dr2);
                    DataRow row2 = dt2.Rows[0];

                    DropDownListKonu.SelectedIndex = (Convert.ToInt32(row2["KategoriID"]) - 1);


                    string        kEmail     = Session["KoleksiyonerEmail"].ToString();
                    SqlCommand    cmdSession = new SqlCommand("Select * from Koleksiyoner where KoleksiyonerEmail='" + kEmail + "'", baglan.baglan());
                    SqlDataReader drSession  = cmdSession.ExecuteReader();
                    DatalistProfilBilgi.DataSource = drSession;
                    DatalistProfilBilgi.DataBind();
                }
                else
                {
                    Response.Redirect("KullaniciGiris.aspx");
                }
            }
        }
Exemple #8
0
        protected void Page_Load(object sender, EventArgs e)
        {
            UrunID = Request.QueryString["UrunID"];
            if (Page.IsPostBack == false)
            {
                if (Session["KoleksiyonerEmail"] != null)
                {
                    //kategori çek
                    SqlCommand    cmd = new SqlCommand("Select * from Kategori ", baglan.baglan());
                    SqlDataReader dr  = cmd.ExecuteReader();
                    DropDownListKategori.DataTextField  = "KategoriAdi";
                    DropDownListKategori.DataValueField = "KategoriID";
                    DropDownListKategori.DataSource     = dr;
                    DropDownListKategori.DataBind();

                    SqlCommand    cmdUrunGetir = new SqlCommand("Select * from Urun where UrunID='" + UrunID + "'", baglan.baglan());
                    SqlDataReader druGuncelle  = cmdUrunGetir.ExecuteReader();

                    DataTable dtuGuncelle = new DataTable("tablo");
                    dtuGuncelle.Load(druGuncelle);
                    DataRow row = dtuGuncelle.Rows[0];
                    txtUrunAdi.Text    = row["UrunAdi"].ToString();
                    txtFiyat.Text      = row["UrunFiyat"].ToString();
                    txtAciklama.Text   = row["Aciklama"].ToString();
                    txtIlanSuresi.Text = row["IhaleSuresi"].ToString();
                    DropDownListKategori.SelectedItem.Text = row["KategoriAdi"].ToString();

                    string        kEmail     = Session["KoleksiyonerEmail"].ToString();
                    SqlCommand    cmdSession = new SqlCommand("Select * from Koleksiyoner where KoleksiyonerEmail='" + kEmail + "'", baglan.baglan());
                    SqlDataReader drSession  = cmdSession.ExecuteReader();
                    DatalistProfilBilgi.DataSource = drSession;
                    DatalistProfilBilgi.DataBind();
                }
                else
                {
                    Response.Redirect("KullaniciGiris.aspx");
                }
            }
        }