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;
}
