protected void SdsIcerik_Inserting(object sender, SqlDataSourceCommandEventArgs e) { if (!YetkiKontrol(pageName + "-Insert")) { e.Cancel = true; return; } try { if (e.Command.Parameters["@Icerik"].Value != null && e.Command.Parameters["@Icerik"].Value.ToString().Length > Snlg_ConfigValues.maxCharacterLimit) { e.Cancel = true; Snlg_Hata.ziyaretci.HataGosterHatali("Bilgiler kaydedilmedi! İçerik 100.000 karakterden daha uzun olamaz. Girmiş olduğunuz içeriğin uzunluğu : " + e.Command.Parameters["@Icerik"].Value.ToString().Length.ToString() + " karakter.", false); return; } DropDownList DDLCont = (DropDownList)FVIcerik.FindControl("DDLCont"); ListBox list1 = (ListBox)FVIcerik.FindControl("List1"); string sorgu = ""; if (!string.IsNullOrEmpty(DDLCont.SelectedValue)) { foreach (ListItem li in list1.Items) { if (li.Selected && !string.IsNullOrEmpty(li.Value)) { sorgu += "INSERT INTO snlg_V1.TblDesignSablonIcerik (SablonId,ContainerId,UCId,Sira)"; sorgu += string.Format("VALUES ({0}, @ContainerId, @UCId, @Sira); ", li.Value); } } e.Command.Parameters["@GosterilecekSablonlarSql"].Value = sorgu; } } catch { } }
protected void FVIcerik_DataBound(object sender, EventArgs e) { if (FVIcerik.CurrentMode == FormViewMode.Insert) { ((RadioButtonList)FVIcerik.FindControl("RBL1")).SelectedIndex = 0; } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["ucid"] == null && !Page.IsPostBack) { FVIcerik.ChangeMode(FormViewMode.Insert); } }
protected void FVIcerik_DataBound(object sender, EventArgs e) { if (FVIcerik.CurrentMode == FormViewMode.ReadOnly) { return; } ListBox lb = (ListBox)FVIcerik.FindControl("ListKtg"); lb.Items.Clear(); ListDoldur(DTMakKtgler.Select("UstId IS NULL"), null, lb); if (FVIcerik.CurrentMode == FormViewMode.Edit) { Snlg_DBConnect vt = new Snlg_DBConnect(true); SqlDataReader SDRKtgler = vt.DBReaderOlustur("SELECT ProjeId, KtgId FROM snlg_V1.TblProje_Kategori WHERE ProjeId = " + Request.QueryString["projeid"], CommandType.Text); while (SDRKtgler.Read()) { try { lb.Items.FindByValue(SDRKtgler["KtgId"].ToString()).Selected = true; } catch { } } SDRKtgler.Close(); vt.Kapat(); DropDownList DDLLinks = (DropDownList)FVIcerik.FindControl("DDLLinks"); foreach (ListItem item in DDLLinks.Items) { item.Text += Snlg_ConfigValues.urlExtension; } } }
protected void FVIcerik_DataBound(object sender, EventArgs e) { try { if (FVIcerik.CurrentMode == FormViewMode.Insert) { ((RadioButtonList)FVIcerik.FindControl("RBL1")).SelectedIndex = 0; } //ListBox list1 = (ListBox)FVIcerik.FindControl("List1"); //Snlg_DBConnect vt = new Snlg_DBConnect(true); //SqlDataReader SDRKtgler = vt.DBReaderOlustur(@"SELECT TBDS.SablonId, TBDS.SablonAd FROM snlg_V1.TblDesignSablonlar AS TBDS // INNER JOIN snlg_V1.TblDesignSablonIcerik AS TBDSI ON // TBDS.SablonId=TBDSI.SablonId WHERE TBDSI.UCId= " + Request.QueryString["ucid"], CommandType.Text); //while (SDRKtgler.Read()) // try { list1.Items.FindByValue(SDRKtgler["SablonId"].ToString()).Selected = true; } // catch { } //SDRKtgler.Close(); //vt.Kapat(); } catch (Exception) { } }
protected void SDSMak_Updating(object sender, SqlDataSourceCommandEventArgs e) { if (!YetkiKontrol(pageName + "-Update")) { e.Cancel = true; return; } if (e.Command.Parameters["@Icerik"].Value != null && e.Command.Parameters["@Icerik"].Value.ToString().Length > Snlg_ConfigValues.maxCharacterLimit) { e.Cancel = true; Snlg_Hata.ziyaretci.HataGosterHatali("Makale içeriği " + Snlg_ConfigValues.maxCharacterLimit + " karakterden daha uzun olamaz. Girmiş olduğunuz içeriğin uzunluğu : " + e.Command.Parameters["@Icerik"].Value.ToString().Length.ToString() + " karakterdir.", false); return; } //seçilen kategorilerr için sql hazrılanıyor string ktgSql = ""; ListBox lb = (ListBox)FVIcerik.FindControl("ListKtg"); foreach (ListItem item in lb.Items) { if (item.Selected) { ktgSql += string.Format("INSERT INTO snlg_V1.TblMakale_Kategori (MakId, KtgId) VALUES (@MakId, {0}); ", item.Value); } } e.Command.Parameters["@KtgSql"].Value = ktgSql; }
protected void FVIcerik_DataBound(object sender, EventArgs e) { if (FVIcerik.CurrentMode == FormViewMode.ReadOnly) { return; } ListBox lb = (ListBox)FVIcerik.FindControl("ListKtg"); lb.Items.Clear(); ListDoldur(DTMakKtgler.Select("UstId IS NULL"), null, lb); if (FVIcerik.CurrentMode == FormViewMode.Insert) { ((TextBox)FVIcerik.FindControl("TbTarih")).Text = DateTime.Today.ToShortDateString(); } else if (FVIcerik.CurrentMode == FormViewMode.Edit) { Snlg_DBConnect vt = new Snlg_DBConnect(true); SqlDataReader SDRKtgler = vt.DBReaderOlustur("SELECT MakId, KtgId FROM snlg_V1.TblMakale_Kategori WHERE MakId = " + Request.QueryString["makid"], CommandType.Text); while (SDRKtgler.Read()) { try { lb.Items.FindByValue(SDRKtgler["KtgId"].ToString()).Selected = true; } catch { } } SDRKtgler.Close(); vt.Kapat(); } }
protected void SdsIcerik_Selected(object sender, SqlDataSourceStatusEventArgs e) { if (e.AffectedRows < 1) { FVIcerik.ChangeMode(FormViewMode.Insert); } else { FVIcerik.ChangeMode(FormViewMode.Edit); } }
protected void LinkRSil_Click(object sender, EventArgs e) {//resim silniyor. if (!YetkiKontrol(pageName + "-Delete")) { return; } Snlg_DBConnect vt = new Snlg_DBConnect(true); int silinen = vt.SorguCalistir("UPDATE snlg_V1.TblProjeApp SET Resim = NULL WHERE ProjeId = @ProjeId ", System.Data.CommandType.Text, new Snlg_DBParameter[] { new Snlg_DBParameter("@ProjeId", SqlDbType.Int, Request.QueryString["projeid"]) }); vt.Kapat(); Snlg_Hata.ziyaretci.HataGosterBasarili("Resim silindi.", false); FVIcerik.DataBind(); }
protected void SdsIcerik_Updating(object sender, SqlDataSourceCommandEventArgs e) { if (!YetkiKontrol(pageName + "-Update")) { e.Cancel = true; return; } try { if (Request.QueryString["bt"] == "1") {//eğer custom kontrol ise içeriği kontrol et if (e.Command.Parameters["@Icerik"].Value != null && e.Command.Parameters["@Icerik"].Value.ToString().Length > Snlg_ConfigValues.maxCharacterLimit) { e.Cancel = true; Snlg_Hata.ziyaretci.HataGosterHatali("Bilgiler kaydedilmedi! İçerik 100.000 karakterden daha uzun olamaz. Girmiş olduğunuz içeriğin uzunluğu : " + e.Command.Parameters["@Icerik"].Value.ToString().Length.ToString() + " karakter.", false); return; } } else { e.Command.Parameters["@Icerik"].Value = DBNull.Value; } DropDownList DDLCont = (DropDownList)FVIcerik.FindControl("DDLCont"); ListBox list1 = (ListBox)FVIcerik.FindControl("List1"); string sorgu = ""; if (!string.IsNullOrEmpty(DDLCont.SelectedValue)) { foreach (ListItem li in list1.Items) { if (li.Selected && !string.IsNullOrEmpty(li.Value)) { sorgu += "IF (NOT EXISTS(SELECT * FROM snlg_V1.TblDesignSablonIcerik WHERE (UCId = @UCId) AND SablonID = " + li.Value + ")) " + Environment.NewLine; sorgu += string.Format("INSERT INTO snlg_V1.TblDesignSablonIcerik (SablonId,ContainerId,UCId,Sira) VALUES ({0}, @ContainerId, @UCId, @Sira); ", li.Value) + Environment.NewLine; sorgu += "ELSE" + Environment.NewLine; sorgu += string.Format("UPDATE snlg_V1.TblDesignSablonIcerik SET ContainerId=@ContainerId, Sira=@Sira WHERE (UCId = @UCId) AND SablonID = {0} ", li.Value) + Environment.NewLine; sorgu += Environment.NewLine; } } e.Command.Parameters["@ContainerId"].Value = DDLCont.SelectedValue; e.Command.Parameters["@GosterilecekSablonlarSql"].Value = sorgu; } } catch { } }
protected void SDSPrj_Updating(object sender, SqlDataSourceCommandEventArgs e) { if (!YetkiKontrol(pageName + "-Insert")) { e.Cancel = true; } //seçilen kategorilerr için sql hazrılanıyor string ktgSql = ""; ListBox lb = (ListBox)FVIcerik.FindControl("ListKtg"); foreach (ListItem item in lb.Items) { if (item.Selected) { ktgSql += string.Format("INSERT INTO snlg_V1.TblProje_Kategori (ProjeId, KtgId) VALUES (@ProjeId, {0}); ", item.Value); } } e.Command.Parameters["@KtgSql"].Value = ktgSql; }