protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// string id = kod.getDataCell("select ogr_id from ogrenci WHERE ogr_no = " + Request.QueryString["no"]);
DataRow dr = kod.GetDataRow("Select * from ogrenci WHERE ogr_no =" + Request.QueryString["no"]);
txtAd.Text = dr[1].ToString();
txtSoyadi.Text = dr[4].ToString();
txtOgrNo.Text = dr[2].ToString();
txtOkul.Text = dr[3].ToString();
txtBolum.Text = dr[5].ToString();
txtFakulte.Text = dr[6].ToString();
txtNotOrt.Text = dr[7].ToString();
txtTel.Text = dr[8].ToString();
txtAdres.Text = dr[9].ToString();
txtEposta.Text = dr[10].ToString();
txtOgrSicil.Text = dr[11].ToString();
txtSifre.Text = dr[12].ToString();
DataTable pp = kod.GetDataTable("select ogr_resimi from ogrenci WHERE ogr_no =" + Request.QueryString["no"]);
RepeaterOgrResim.DataSource = pp;
RepeaterOgrResim.DataBind();
DataTable cv = kod.GetDataTable("select ogr_cv from ogrenci WHERE ogr_no =" + Request.QueryString["no"]);
RepeaterCV.DataSource = cv;
RepeaterCV.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
RepeaterSolMenu.DataSource = kod.GetDataTable("select * from makaleKategori");
RepeaterSolMenu.DataBind();
Repeatermakaleler.DataSource = kod.GetDataTable("select * from makaleler");
Repeatermakaleler.DataBind();
string urunlerSorgu = "";
if (Request.QueryString["kId"] != null)
{
urunlerSorgu = "SELECT makaleAltKategori.makaleAltKategori , makaleAltKategori.makaleKategoriId, makaleler.* FROM(makaleAltKategori INNER JOIN makaleler ON makaleAltKategori.makaleAltKategori = makaleler.makaleAltKategori)where (makaleDurum ='1' AND makaleKategoriId=" + Request.QueryString["kId"] + ") ORDER BY makaleId DESC";
}
else if (Request.QueryString["akId"] != null)
{
urunlerSorgu = "Select Top 20 * from makaleler where (makaleDurum='1' AND makaleAltKategori =" + Request.QueryString["akId"] + ") ORDER BY makaleId DESC";
}
else if (Request.QueryString["uId"] != null)
{
Response.Redirect("makaledetay.aspx?uId= " + Request.QueryString["uId"]);
}
else
{
urunlerSorgu = "Select Top 20 * from makaleler where makaleDurum = '1' ORDER BY makaleId DESC";
}
Repeatermakaleler.DataSource = kod.GetDataTable(urunlerSorgu);
Repeatermakaleler.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
RepeaterİletisimBilgileri.DataSource = kod.GetDataTable("SELECT * FROM [bilgi]");
RepeaterİletisimBilgileri.DataBind();
RepeaterSayflarİframae.DataSource = kod.GetDataTable("SELECT * FROM [sayfalar] WHERE [sayfaAd] = 'Benimle İletişime Geçin'");
RepeaterSayflarİframae.DataBind();
}
protected void GirisYap_Click(object sender, EventArgs e)
{
string kullanici = KullaniciAdi.Text, sifre = Sifre.Text;
try
{
if (RadioButtonList1.SelectedValue == "0") //ÖĞRENCİ
{
DataTable dt = kod.GetDataTable("Select * from ogrenci where (ogr_no=" + kullanici + " AND ogr_sifre='" + sifre + "' )"); /*AND uyeTuru='admin'*/
if (dt.Rows.Count == 0)
{
LabelHata.Visible = true;
}
else
{
Session["kullanici"] = kullanici;
Response.Redirect("Default.aspx?tur=ogrenci&no=" + kullanici);
}
}
else if (RadioButtonList1.SelectedValue == "1") //Öğretmen
{
DataTable dt = kod.GetDataTable("Select * from hoca where (sicil_no=" + kullanici + " AND hoca_sifre='" + sifre + "' )"); /*AND uyeTuru='admin'*/
if (dt.Rows.Count == 0)
{
LabelHata.Visible = true;
}
else
{
Session["kullanici"] = kullanici;
Response.Redirect("Default.aspx?tur=ogretmen&sicil=" + kullanici);
}
}
else if (RadioButtonList1.SelectedValue == "2") //Kurum
{
DataTable dt = kod.GetDataTable("Select * from kurum where (kurum_kodu= '" + kullanici + "' AND kurum_sifre='" + sifre + "' )");
if (dt.Rows.Count == 0)
{
LabelHata.Visible = true;
}
else
{
Session["kullanici"] = kullanici;
Response.Redirect("Default.aspx?tur=kurum&kurumkod=" + kullanici);
}
}
else
{
LabelHata.Text += " " + "VEYA Giriş Türünü Seçmediniz";
LabelHata.Visible = true;
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("Makale_Guncelle.aspx");
}
if (!Page.IsPostBack)
{
DataRow dr = kod.GetDataRow("Select * from makaleler WHERE makaleId=" + Request.QueryString["id"]);
txtMakaleAd.Text = dr[1].ToString();
txtMakaleOzet.Text = dr[2].ToString();
txtProjeBilgi.Text = dr[3].ToString();
DataRow drAna = kod.GetDataRow("Select * from makaleAltKategori where makaleAltKategori=" + dr[6].ToString());
txtalt.Text = drAna[1].ToString();
DataRow drust = kod.GetDataRow("Select * from makaleKategori where makaleKategoriId=" + drAna[2].ToString());
txtkat.Text = drust[1].ToString();
DataTable dt = kod.GetDataTable("Select * from makaleKategori");
ddlAna.DataSource = dt;
ddlAna.DataValueField = "makaleKategoriId";
ddlAna.DataTextField = "makalekategoriAd";
ddlAna.DataBind();
DataTable dt2 = kod.GetDataTable("Select * from makaleAltKategori WHERE makaleKategoriId=" + ddlAna.SelectedValue);
ddlAlt.DataSource = dt2;
ddlAlt.DataValueField = "makaleAltKategori";
ddlAlt.DataTextField = "makaleAltKategoriAd";
ddlAlt.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
RepeaterHakkimda.DataSource = kod.GetDataTable("SELECT * FROM [sayfalar] WHERE [sayfaId] = 1 ");
RepeaterHakkimda.DataBind();
RepeaterProje.DataSource = kod.GetDataTable("SELECT TOP 10 * FROM [proje] Order BY ProjeId DESC");
RepeaterProje.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
RepeaterKat.DataSource = kod.GetDataTable("SELECT [kategoriAd] ,[kategoriId] FROM [kategoriler]");
RepeaterKat.DataBind();
RepeaterFooter.DataSource = kod.GetDataTable("SELECT * FROM [footer]");
RepeaterFooter.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ddlAna.DataSource = kod.GetDataTable("Select * from kategoriler ");
ddlAna.DataValueField = "kategoriId";
ddlAna.DataTextField = "kategoriAd";
ddlAna.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string TP = kod.getDataCell("SELECT COUNT(projeId) FROM proje ");
Tp.InnerText = TP.ToString();
string MT = kod.getDataCell("SELECT COUNT(makaleAd) FROM makaleler");
Mt.InnerText = MT.ToString();
RepeaterProjeler.DataSource = kod.GetDataTable("SELECT Top 20 * FROM [proje] ORDER BY projeId DESC");
RepeaterProjeler.DataBind();
RepeaterMakaleler.DataSource = kod.GetDataTable("SELECT Top 20 * FROM [makaleler] ORDER BY makaleId DESC");
RepeaterMakaleler.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//RepeaterStajyerlerListele.DataSource = kod.GetDataTable("SELECT * FROM kurum WHERE kurum_kodu in (select kurum_kodu from stajyer where sicil_no = '" + labelSicilNo.Text + "')");
RepeaterStajyerlerListele.DataSource = kod.GetDataTable("SELECT * FROM stajyer where sicil_no = '" + Request.QueryString["sicil"].ToString() + "'");
RepeaterStajyerlerListele.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataTable dt = kod.GetDataTable("Select * from makaleKategori");
ddlAna.DataSource = dt;
ddlAna.DataValueField = "makaleKategoriId";
ddlAna.DataTextField = "makalekategoriAd";
ddlAna.DataBind();
DataTable dt2 = kod.GetDataTable("Select * from makaleAltKategori WHERE makaleKategoriId=" + ddlAna.SelectedValue);
ddlAlt.DataSource = dt2;
ddlAlt.DataValueField = "makaleAltKategori";
ddlAlt.DataTextField = "makaleAltKategoriAd";
ddlAlt.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
RepeaterStajyerDetay.DataSource = kod.GetDataTable("SELECT * FROM [stajyer] WHERE stajyer_id=" + Request.QueryString["stajyerId"]);
RepeaterStajyerDetay.DataBind();
DataTable pp = kod.GetDataTable("select ogr_resim from stajyer WHERE stajyer_id =" + Request.QueryString["stajyerId"]);
RepeaterOgrResim.DataSource = pp;
RepeaterOgrResim.DataBind();
DataTable cv = kod.GetDataTable("select ogr_cv from stajyer WHERE stajyer_id =" + Request.QueryString["stajyerId"]);
RepeaterCV.DataSource = cv;
RepeaterCV.DataBind();
}
protected void ddlEH_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlEH.SelectedValue == "1")
{
Panel3.Visible = true;
ddlAna.DataSource = kod.GetDataTable("Select * from kategoriler");
ddlAna.DataValueField = "kategoriId";
ddlAna.DataTextField = "kategoriAd";
ddlAna.DataBind();
}
else
{
Panel3.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
RepeaterOgrenciDetay.DataSource = kod.GetDataTable("SELECT * FROM [ogrenci] WHERE ogr_id=" + Request.QueryString["ogrId"]);
RepeaterOgrenciDetay.DataBind();
DataTable pp = kod.GetDataTable("select ogr_resimi from ogrenci WHERE ogr_id =" + Request.QueryString["ogrId"]);
RepeaterOgrResim.DataSource = pp;
RepeaterOgrResim.DataBind();
DataTable cv = kod.GetDataTable("select ogr_cv from ogrenci WHERE ogr_id =" + Request.QueryString["ogrId"]);
RepeaterCV.DataSource = cv;
RepeaterCV.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlAltKategori.DataSource = kod.GetDataTable("Select * from makaleKategori ");
ddlAltKategori.DataValueField = "makaleKategoriId";
ddlAltKategori.DataTextField = "makalekategoriAd";
ddlAltKategori.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["KurumId"] == null)
{
Response.Redirect("cik.aspx");
}
RepeaterKurumDetay.DataSource = kod.GetDataTable("SELECT * FROM kurum WHERE kurum_id = " + Request.QueryString["KurumId"].ToString());
RepeaterKurumDetay.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string urunlerSorgu = "";
if (Request.QueryString["uId"] != null)
{
urunlerSorgu = "Select Top 20 * from makaleler where (makaleDurum='1' AND makaleId=" + Request.QueryString["uId"] + ")";
}
else
{
Response.Redirect("makale.aspx");
}
RepeaterMakaleDetay.DataSource = kod.GetDataTable(urunlerSorgu);
RepeaterMakaleDetay.DataBind();
RepeaterProje.DataSource = kod.GetDataTable("SELECT TOP 10 * FROM [proje] Order BY ProjeId DESC");
RepeaterProje.DataBind();
}
protected void ddlEH_SelectedIndexChanged(object sender, EventArgs e)
{
Panel1.Visible = true;
DataTable dt = kod.GetDataTable("Select * from kategoriler");
ddlAna.DataSource = dt;
ddlAna.DataValueField = "kategoriId";
ddlAna.DataTextField = "kategoriAd";
ddlAna.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = kod.GetDataTable("select * from hizmetler");
listeleRepeater.DataSource = dt;
listeleRepeater.DataBind();
if (Request.QueryString["id"] != null && Request.QueryString["islem"] == "sil")
{
kod.komut("delete from hizmetler where id=" + Request.QueryString["id"].ToString());
Response.Redirect("Hizmetler_Duzenle.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = kod.GetDataTable("select * from altKategorininAltKategorisi");
listeleRepeater.DataSource = dt;
listeleRepeater.DataBind();
if (Request.QueryString["id"] != null && Request.QueryString["islem"] == "sil")
{
kod.komut("delete from altKategorininAltKategorisi where altKategorininAltKategori_Id=" + Request.QueryString["id"].ToString());
Response.Redirect("P_Alt_Kat_2_Duzenle.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
// RepeaterSlider.DataSource = kod.GetDataTable("SELECT * FROM [slider] WHERE sliderDurum = '1'");
DataTable dtSlider = kod.GetDataTable("SELECT TOP 10 * FROM [makaleler] WHERE makaleDurum = '1' Order BY MakaleId DESC");
int ogeSayisi = dtSlider.Rows.Count;
string ekle = "";
for (int i = 0; i < ogeSayisi; i++)
{
if (i == 0)
{
ekle += "<li data-target='#slider' data-slide-to='" + i + "' class='active'></li>";
}
else
{
ekle += "<li data-target='#slider' data-slide-to='" + i + "'></li>";
}
}
RepeaterSlider.DataSource = dtSlider;
sliderGosterge.InnerHtml = ekle;
RepeaterSlider.DataBind();
RepeaterBilgiler.DataSource = kod.GetDataTable("SELECT * FROM [bilgi]");
RepeaterBilgiler.DataBind();
Repeater1.DataSource = kod.GetDataTable("SELECT * FROM [yetenek] ORDER BY [yetenekYuzdesi] DESC");
Repeater1.DataBind();
//DataList1.DataSource = kod.GetDataTable("SELECT * FROM [hizmetler]");
//DataList1.DataBind();
RepeaterHizmetler.DataSource = kod.GetDataTable("SELECT * FROM [hizmetler] ");
RepeaterHizmetler.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
RepeaterSolMenu.DataSource = kod.GetDataTable("select kategoriId, kategoriAd from kategoriler");
RepeaterSolMenu.DataBind();
string urunlerSorgu = "";
if (Request.QueryString["kId"] != null)
{
urunlerSorgu = "SELECT proje.*, altkategori.altKategoriId , altkategori.kategoriId FROM(altkategori INNER JOIN proje ON altkategori.altKategoriId = proje.altKategoriId) where (projeDurum ='1' AND kategoriId=" + Request.QueryString["kId"] + ") Order BY ProjeId DESC";
}
else if (Request.QueryString["akId"] != null)
{
urunlerSorgu = "Select Top 20 * from proje where (projeDurum='1' AND altKategoriId =" + Request.QueryString["akId"] + ") Order BY ProjeId DESC ";
}
else if (Request.QueryString["uId"] != null)
{
urunlerSorgu = "Select Top 20 * from proje where projeDurum = '1' Order BY ProjeId DESC";
PanelUrunler.Visible = false;
PanelTekUrun.Visible = true;
tekUrunGoster(Request.QueryString["uId"]);
}
else if (Request.QueryString["ak_ak_Id"] != null)
{
urunlerSorgu = "Select Top 20 * from proje where (projeDurum='1' AND altKategorininAltKategori_Id =" + Request.QueryString["ak_ak_Id"] + ") Order BY ProjeId DESC";
}
else
{
urunlerSorgu = "Select Top 20 * from proje where projeDurum = '1' Order BY projeId DESC";
}
RepeaterUrunler.DataSource = kod.GetDataTable(urunlerSorgu);
RepeaterUrunler.DataBind();
}
protected void ddlAna_SelectedIndexChanged(object sender, EventArgs e)
{
ddlAlt.DataSource = kod.GetDataTable("Select * from altkategori WHERE kategoriId=" + ddlAna.SelectedItem.Value);
ddlAlt.DataValueField = "altKategoriId";
ddlAlt.DataTextField = "altKategoriAd";
ddlAlt.DataBind();
ddlEnAlt.DataSource = kod.GetDataTable("Select * from altKategorininAltKategorisi WHERE altKategoriId=" + ddlAlt.SelectedItem.Value);
ddlEnAlt.DataValueField = "altKategorininAltKategori_Id";
ddlEnAlt.DataTextField = "altKategorininAltKategoriAdi";
ddlEnAlt.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["uId"] == null)
{
Response.Redirect("Proje_Ekle.aspx");
}
DataTable dt = kod.GetDataTable("select * from projegorsel WHERE projeId=" + Request.QueryString["uId"]);
RepeaterUrunFoto.DataSource = dt;
RepeaterUrunFoto.DataBind();
if (Request.QueryString["id"] != null && Request.QueryString["islem"] == "sil")
{
kod.komut("delete from projegorsel where projeGorselId=" + Request.QueryString["id"].ToString());
Response.Redirect("urunFoto.aspx?uId=" + Request.QueryString["uId"].ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = kod.GetDataTable("select * from proje");
listeleRepeater.DataSource = dt;
listeleRepeater.DataBind();
if (!Page.IsPostBack)
{
}
if (Request.QueryString["id"] != null && Request.QueryString["islem"] == "sil")
{
kod.komut("delete from proje where projeId=" + Request.QueryString["id"].ToString());
Response.Redirect("Proje_Duzenle.aspx");
}
}
protected void btnGiris_Click(object sender, EventArgs e)
{
string kullanici = txtKullaniciAdi.Text, sifre = txtSifre.Text;
// kod.Sifrele(sifre);
string sifrem = FormsAuthentication.HashPasswordForStoringInConfigFile(sifre, "MD5");
DataTable dt = kod.GetDataTable("Select * from kullanici where (uyeAd='" + kullanici + "' AND uyeSifre='" + sifrem + "' )"); /*AND uyeTuru='admin'*/
if (dt.Rows.Count == 0)
{
lblHata.Visible = true;
}
else
{
Session["kullanici"] = kullanici;
Response.Redirect("Default.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataTable pp = kod.GetDataTable("select kurum_resim from kurum WHERE kurum_kodu = '" + Request.QueryString["kurumkod"] + "'");
RepeaterKurumLogo.DataSource = pp;
RepeaterKurumLogo.DataBind();
DataRow dr = kod.GetDataRow("Select * from kurum WHERE kurum_kodu = '" + Request.QueryString["kurumkod"] + "'");
txtAd.Text = dr[2].ToString();
txtTel.Text = dr[3].ToString();
txtAdres.Text = dr[5].ToString();
txtEposta.Text = dr[4].ToString();
txtSektor.Text = dr[6].ToString();
txtSifre.Text = dr[7].ToString();
txtKurumTur.Text = dr[8].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("Hizmetler_Duzenle.aspx");
}
if (!Page.IsPostBack)
{
DataRow dr = kod.GetDataRow("Select * from hizmetler where id=" + Request.QueryString["id"].ToString());
txtHizmetAdi.Text = dr[1].ToString();
txtHizmetBilgi.Text = dr[3].ToString();
ddlSayfa.SelectedValue = dr[4].ToString();
Repeater1.DataSource = kod.GetDataTable("select hizmetResimUrlsi from hizmetler WHERE id=" + Request.QueryString["id"].ToString());
Repeater1.DataBind();
fuDosya.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Panel1.Visible = false;
if (Request.QueryString["id"] == null)
{
Response.Redirect("P_Alt_Kat_guncelle.aspx");
}
if (!Page.IsPostBack)
{
DataRow dr = kod.GetDataRow("Select * from altkategori where altKategoriId=" + Request.QueryString["id"].ToString());
txtKategori.Text = dr[1].ToString();
KayitliKategori.Text = dr[3].ToString();
DataRow drAna = kod.GetDataRow("Select * from kategoriler where kategoriId=" + dr[3].ToString());
KayitliKategori.Text = drAna[1].ToString();
ddlAltKategori.DataSource = kod.GetDataTable("Select * from kategoriler");
ddlAltKategori.DataValueField = "kategoriId";
ddlAltKategori.DataTextField = "kategoriAd";
ddlAltKategori.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataTable pp = kod.GetDataTable("select hoca_resim from hoca WHERE sicil_no = " + Request.QueryString["sicil"] + "");
RepeaterPP.DataSource = pp;
RepeaterPP.DataBind();
DataRow dr = kod.GetDataRow("Select * from hoca WHERE sicil_no = " + Request.QueryString["sicil"] + "");
txtAd.Text = dr[2].ToString();
txtSoyad.Text = dr[3].ToString();
txtTel.Text = dr[4].ToString();
txtBolum.Text = dr[7].ToString();
txtAlan.Text = dr[8].ToString();
txtSifre.Text = dr[6].ToString();
txtEposta.Text = dr[5].ToString();
}
}
