protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("Proje_Duzenle.aspx");
}
if (!Page.IsPostBack)
{
Panel1.Visible = false;
getir();
DataRow drana = kod.GetDataRow("Select * from proje WHERE projeId=" + Request.QueryString["id"].ToString());
txtProjeAd.Text = drana[1].ToString();
txtProjeFiyat.Text = drana[2].ToString();
txtProjeBilgi.Text = drana[3].ToString();
DataRow dr = kod.GetDataRow("Select * from altKategorininAltKategorisi where altKategorininAltKategori_Id=" + drana[6].ToString());
txtEnALt.Text = dr[1].ToString();
txtAlt.Text = dr[2].ToString();
DataRow drAna = kod.GetDataRow("Select * from altkategori where altKategoriId=" + dr[2].ToString());
txtAlt.Text = drAna[1].ToString();
DataRow drust = kod.GetDataRow("Select * from kategoriler where kategoriId=" + drAna[3].ToString());
txtAna.Text = drust[1].ToString();
}
}
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)
{
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)
{
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 (Request.QueryString["id"] == null)
{
Response.Redirect("P_Alt_Kat_2_guncelle.aspx");
}
if (!Page.IsPostBack)
{
Panel3.Visible = false;
DataRow dr = kod.GetDataRow("Select * from altKategorininAltKategorisi where altKategorininAltKategori_Id=" + Request.QueryString["id"].ToString());
txtKategori.Text = dr[1].ToString();
txtUst.Text = dr[2].ToString();
DataRow drAna = kod.GetDataRow("Select * from altkategori where altKategoriId=" + dr[2].ToString());
txtUst.Text = drAna[1].ToString();
DataRow drust = kod.GetDataRow("Select * from kategoriler where kategoriId=" + drAna[3].ToString());
txtAna.Text = drust[1].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("Makale_Kat_Duzenle.aspx");
}
if (!Page.IsPostBack)
{
DataRow dr = kod.GetDataRow("Select * from MakaleKategori where makaleKategoriId=" + Request.QueryString["id"].ToString());
txtKategori.Text = dr[1].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("Yetenek_Duzenle.aspx");
}
if (!Page.IsPostBack)
{
DataRow dr = kod.GetDataRow("Select * from yetenek where yetenekId=" + Request.QueryString["id"].ToString());
txtYetenekAdi.Text = dr[1].ToString();
txtYetenekOrani.Text = dr[2].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("uyeDuzenle.aspx");
}
if (!Page.IsPostBack)
{
DataRow dr = kod.GetDataRow("Select * from kullanici where uyeId=" + Request.QueryString["id"].ToString());
txtUyeAdi.Text = dr[1].ToString();
ddlUyeTuru.SelectedValue = dr[3].ToString();
ddlDurum.SelectedValue = dr[5].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataRow dr = kod.GetDataRow("Select * from footer");
txtFooterHakkimda.Text = dr[1].ToString();
txtTwitterUrl.Text = dr[2].ToString();
txtFacebook.Text = dr[3].ToString();
txtInstagram.Text = dr[4].ToString();
txtLinkedin.Text = dr[5].ToString();
txtAdres.Text = dr[6].ToString();
txtEPosta1.Text = dr[7].ToString();
txtEPosta2.Text = dr[8].ToString();
txtTel.Text = dr[9].ToString();
txtYazi.Text = dr[10].ToString();
txtCop.Text = dr[11].ToString();
}
}
protected void btnEkle_Click(object sender, EventArgs e)
{
//string projeId = Request.QueryString["uId"];
try
{
DataRow dr = kod.GetDataRow("Select projeAd from proje WHERE projeId=" + Request.QueryString["uId"]);
if (fuDosya.HasFile)
{
string url = kod.KodOlustur(dr[0].ToString());
kod.komut("Insert Into projegorsel (projeGorselUrl, projeGorselUrlKucuk, projeId) VALUES ('" + kod.FotoKaydetOptimize(fuDosya, 1024, "/img/projeler/buyuk/", url) + "', '" + kod.FotoKaydetOptimize(fuDosya, 256, "/img/projeler/kucuk/", url) + "'," + Request.QueryString["uId"].ToString() + ")");
Response.Redirect("urunFoto.aspx?uId=" + Request.QueryString["uId"].ToString());
}
}
catch
{
LblHata.Visible = true;
}
}
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)
{
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();
}
}
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();
}
if (Request.QueryString["id"] == null)
{
Response.Redirect("Sayfalar_Duzenle.aspx");
}
if (!Page.IsPostBack)
{
DataRow dr = kod.GetDataRow("Select * from makaleAltKategori where makaleAltKategori=" + Request.QueryString["id"].ToString());
txtKategori.Text = dr[1].ToString();
ddlAltKategori.SelectedValue = dr[2].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataRow dr = kod.GetDataRow("Select * from bilgi");
txtIsimSoyisim.Text = dr[1].ToString();
txtMeslek.Text = dr[2].ToString();
txtuni.Text = dr[3].ToString();
txtFakulte.Text = dr[4].ToString();
txtTel.Text = dr[5].ToString();
txtEPosta1.Text = dr[6].ToString();
txtEPosta2.Text = dr[7].ToString();
txtHitap.Text = dr[9].ToString();
Repeater1.DataSource = kod.GetDataTable("select foto from bilgi");
Repeater1.DataBind();
fuDosya.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == "2")
{
Panel1.Visible = false;
}
if (Request.QueryString["id"] == null)
{
Response.Redirect("Sayfalar_Duzenle.aspx");
}
if (!Page.IsPostBack)
{
DataRow dr = kod.GetDataRow("Select * from sayfalar where sayfaId=" + Request.QueryString["id"].ToString());
txtSayfaAdi.Text = dr[1].ToString();
txtSayfaMetin.Text = dr[2].ToString();
Repeater1.DataSource = kod.GetDataTable("select sayfaResim from sayfalar WHERE sayfaId=" + Request.QueryString["id"].ToString());
Repeater1.DataBind();
fuDosya.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//try
//{
string StajKayitlimi = kod.getDataCell("select kurum_adi from stajyer WHERE ogr_no =" + Request.QueryString["no"]);
Label1.Text = StajKayitlimi;
if (Label1.Text == "")
{
PanelStajKaydet.Visible = true;
Label1.Text = "Staj Yeri Seçmediniz";
ButtonStajİptal.Visible = false;
}
else
{
PanelStajKaydet.Visible = false;
Label1.Text = StajKayitlimi;
}
//}
//catch (Exception)
//{
// //Label1.Text = "Kayıt Yok";
//}
if (!Page.IsPostBack)
{
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();
txtNotOrt.Text = dr[7].ToString();
txtTel.Text = dr[8].ToString();
txtEposta.Text = dr[11].ToString();
txtOgrSicil.Text = dr[11].ToString();
string danismanAd = kod.getDataCell("select hoca_adi from hoca WHERE sicil_no = '" + dr[11].ToString() + "'");
string danismanSoyad = kod.getDataCell("select hoca_soyadi from hoca WHERE hoca_adi = '" + danismanAd + "'");
txtDanısman.Text = danismanAd + " " + danismanSoyad;
DataTable dt = kod.GetDataTable("SELECT * from kurum");
DropDownListKurumlar.DataSource = dt;
DropDownListKurumlar.DataValueField = "kurum_kodu";
DropDownListKurumlar.DataTextField = "kurum_adi";
DropDownListKurumlar.DataBind();
LabelKurumKodunuz.Text = DropDownListKurumlar.SelectedItem.Value;
DataRow kurum = kod.GetDataRow("Select * from kurum WHERE kurum_kodu = '" + LabelKurumKodunuz.Text + "' ");
LabelKurumTel.Text = kurum[3].ToString();
LabelKurumEPosta.Text = kurum[4].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();
}
}
