protected void imgBtn_Odberi_Click(object sender, ImageClickEventArgs e)
{
ImageButton imgBtnIzbrisiClicked = (ImageButton)sender;
DataListItem SelectedItem = (DataListItem)imgBtnIzbrisiClicked.NamingContainer;
Label Slika_Id = (Label)SelectedItem.FindControl("lbl_Slika_Id");
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConfigurationManager.ConnectionStrings["Konekcija"].ConnectionString;
SqlCommand komanda = new SqlCommand();
komanda.Connection = connection;
komanda.CommandText = @"UPDATE Pozadina SET Aktivna = 0 ; UPDATE Pozadina SET Aktivna = 1 WHERE Pozadina_Id = " + Slika_Id.Text;
try
{
connection.Open();
komanda.ExecuteNonQuery();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Успешна промена!');", true);
}
finally
{ connection.Close(); }
DS_SiteSliki.SelectCommand = "SELECT * FROM Pozadina";
DS_SiteSliki.DataBind();
DataList6.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
lblWidth.Text = "2000";
lblHeight.Text = "1000";
if ((Session["najaven"] != null))
{
if (Session["najaven"] == "ne")
{
pnlNajava.Visible = true;
pnlAdmin.Visible = false;
}
else if (Session["najaven"] == "da")
{
pnlNajava.Visible = false;
pnlAdmin.Visible = true;
DS_SiteSliki.SelectCommand = "SELECT * FROM Pozadina";
DS_SiteSliki.DataBind();
}
}
else
{
pnlNajava.Visible = true;
pnlAdmin.Visible = false;
}
}
protected void imgBtn_Izbrisi_Click(object sender, ImageClickEventArgs e)
{
if (Session["BrishiSliki"] == null)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Немате дозвола за бришење!');", true);
}
else
{
try
{
ImageButton imgBtnIzbrisiClicked = (ImageButton)sender;
DataListItem SelectedItem = (DataListItem)imgBtnIzbrisiClicked.NamingContainer;
Label Slika_Id = (Label)SelectedItem.FindControl("lbl_Slika_Id");
SqlConnection konekcija = new SqlConnection();
konekcija.ConnectionString = ConfigurationManager.ConnectionStrings["Konekcija"].ConnectionString;
string sqlString = @"SELECT COUNT(Vest_Id) AS Broj FROM dbo.Vest WHERE Sodrzina LIKE '%Handlers/Slika.ashx?Id=" + Slika_Id.Text + "%'";
SqlCommand komanda = new SqlCommand(sqlString, konekcija);
try
{
konekcija.Open();
SqlDataReader citac = komanda.ExecuteReader();
int BrojNaVesti = 0;
while (citac.Read())
{
BrojNaVesti = Convert.ToInt32(citac["Broj"]);
if (BrojNaVesti == 0)
{
String Sql = "DELETE FROM [Slika] WHERE Slika_Id=" + Slika_Id.Text;
DS_SiteSliki.DeleteCommand = Sql;
DS_SiteSliki.Delete();
DS_SiteSliki.SelectCommand = "SELECT * FROM [Slika] WHERE 1=2";
DS_SiteSliki.DataBind();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Сликата е избришана!');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Сликата неможе да се избриши! Има вести што ја користат оваа слика!');", true);
}
}
}
catch (Exception err)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Настана грешка! Бришењето не е извршено!');", true);
}
finally
{
konekcija.Close();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Настана грешка! Бришењето не е извршено!');", true);
}
}
}
protected void imgBtn_Izbrisi_Click(object sender, ImageClickEventArgs e)
{
try
{
ImageButton imgBtnIzbrisiClicked = (ImageButton)sender;
DataListItem SelectedItem = (DataListItem)imgBtnIzbrisiClicked.NamingContainer;
Label Slika_Id = (Label)SelectedItem.FindControl("lbl_Slika_Id");
Label Aktivna = (Label)SelectedItem.FindControl("lbl_Aktivna");
if (Aktivna.Text != "Активна")
{
try
{
String Sql = "DELETE FROM Pozadina WHERE Pozadina_Id=" + Slika_Id.Text;
DS_SiteSliki.DeleteCommand = Sql;
DS_SiteSliki.Delete();
DS_SiteSliki.SelectCommand = "SELECT * FROM Pozadina";
DS_SiteSliki.DataBind();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Сликата е избришана!');", true);
}
catch (Exception err)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Настана грешка! Бришењето не е извршено!');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Позадината се користи! Неможе да се избрише!');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Настана грешка! Бришењето не е извршено!');", true);
}
}
protected void InsertPozadina()
{
if (Upload.HasFile)
{
string FileName = System.IO.Path.GetFileName(Upload.PostedFile.FileName);
int len = Upload.PostedFile.ContentLength;
byte[] pic = new byte[len];
Upload.PostedFile.InputStream.Read(pic, 0, len);
String Url = tbPozadinaUrl.Text.Replace("'", "''");
if (Url.StartsWith("www"))
{
Url = "http://" + Url;
}
SqlConnection connection = new SqlConnection();
connection.ConnectionString = ConfigurationManager.ConnectionStrings["Konekcija"].ConnectionString;
SqlCommand komanda = new SqlCommand();
komanda.Connection = connection;
komanda.CommandText = @"INSERT INTO Pozadina (Pozadina, Aktivna, Url) Values (@Reklama, 0, '" + Url + "')";
komanda.Parameters.Add("@Reklama", pic);
try
{
connection.Open();
komanda.ExecuteNonQuery();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "AlertPopup", "alert('Позадината е прикачена!');", true);
}
finally
{ connection.Close(); }
DS_SiteSliki.SelectCommand = "SELECT * FROM Pozadina";
DS_SiteSliki.DataBind();
DataList6.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if ((Session["najaven"] != null))
{
if (Session["najaven"] == "ne")
{
pnlNajava.Visible = true;
pnlAdmin.Visible = false;
}
else if (Session["najaven"] == "da")
{
pnlNajava.Visible = false;
pnlAdmin.Visible = true;
DS_SiteSliki.SelectCommand = "SELECT * FROM [Slika] WHERE 1=2";
DS_SiteSliki.DataBind();
}
}
else
{
pnlNajava.Visible = true;
pnlAdmin.Visible = false;
}
}
protected void btnBaraj_Click(object sender, EventArgs e)
{
DS_SiteSliki.SelectCommand = "SELECT * FROM [Slika] WHERE Naziv LIKE '%" + tbBaraj.Text + "%'";
DS_SiteSliki.DataBind();
}
