protected void CancellaFotoGallery(object sender, ImageClickEventArgs e)
{
string idNews = Request.QueryString["NewsID"];
DataSetVepAdminTableAdapters.AlbumsTableAdapter taAlbum = new DataSetVepAdminTableAdapters.AlbumsTableAdapter();
DataTable dtAlbID = taAlbum.GetIdAlbum(int.Parse(idNews));
if (dtAlbID.Rows.Count > 0)
{
string albumID = dtAlbID.Rows[0]["AlbumID"].ToString();
List <Photo> list = new List <Photo>();
list = PhotoManager.GetPhotos(int.Parse(albumID));
for (int i = 0; i < list.Count; i++)
{
PhotoManager.RemovePhoto(list[i].AlbumID);
}
taAlbum.Delete(int.Parse(albumID));
imgCancFotoG.Visible = false;
txtFotoGallery.Text = "Nessun FotoAlbum associato";
btnFotoAlbum.Text = "ASSOCIA FotoAlbum";
btnFotoAlbum.CssClass = "button green";
}
else
{
//messaggio notifica
}
}
protected void lnkBackNews_Click(object sender, EventArgs e)
{
int AlbumID = int.Parse((string)Request.QueryString["AlbumID"]);
int idNews = (int)Session["NewsIDInserita"];
DataSetVepAdminTableAdapters.AlbumsTableAdapter taAlb = new DataSetVepAdminTableAdapters.AlbumsTableAdapter();
DataTable dtAlbum = taAlb.GetInfoAlbumbyID(AlbumID);
string newsIDfromDB = "";
if (!string.IsNullOrEmpty(dtAlbum.Rows[0]["NewsEventoID"].ToString()))
{
newsIDfromDB = dtAlbum.Rows[0]["NewsEventoID"].ToString();
if (int.Parse(newsIDfromDB) == idNews)
{
Response.Redirect("AddModNews.aspx?NewsID=" + idNews.ToString());
}
else
{
Response.Redirect("AddModNews.aspx?NewsID=" + newsIDfromDB);
}
}
else
{
Response.Redirect("Albums.aspx");
}
}
public static string GetNomeAlbum(int AlbumID)
{
string nomeAlbume = "";
DataSetVepAdminTableAdapters.AlbumsTableAdapter taAlb = new DataSetVepAdminTableAdapters.AlbumsTableAdapter();
DataTable dtInfoAlb = taAlb.GetInfoAlbumbyID(AlbumID);
nomeAlbume = dtInfoAlb.Rows[0]["Caption"].ToString();
return(nomeAlbume);
}
public static bool isNewsLinked(int News_ID)
{
bool isLink = false;
DataSetVepAdminTableAdapters.AlbumsTableAdapter taAlb = new DataSetVepAdminTableAdapters.AlbumsTableAdapter();
DataTable dtAlb = taAlb.GetIdAlbum(News_ID);
if (dtAlb.Rows.Count != 0)
{
isLink = true;
}
return(isLink);
}
//GetPhotoSliderHome
public static DataTable GetPhotoSliderHome()
{
var taAlbum = new DataSetVepAdminTableAdapters.AlbumsTableAdapter();
DataTable dtAlbum = taAlbum.GetAlbumByCaption("HOME");
var taPhotos = new DataSetVepAdminTableAdapters.PhotosTableAdapter();
if (dtAlbum.Rows.Count == 0)
{
return(null);
}
DataTable dtPhotos = taPhotos.GetPhotosByPos(int.Parse(dtAlbum.Rows[0]["AlbumID"].ToString()));
return(dtPhotos);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) //check if the webpage is loaded for the first time.
{
ViewState["PreviousPage"] = Request.UrlReferrer; //Saves the Previous page url in ViewState
}
int AlbumID = int.Parse((string)Request.QueryString["AlbumID"]);
DataSetVepAdminTableAdapters.NewsTableAdapter taNews = new DataSetVepAdminTableAdapters.NewsTableAdapter();
DataSetVepAdminTableAdapters.AlbumsTableAdapter taAlb = new DataSetVepAdminTableAdapters.AlbumsTableAdapter();
DataTable dtAlb = taAlb.GetInfoAlbumbyID(AlbumID);
if (!string.IsNullOrEmpty(dtAlb.Rows[0]["NewsEventoID"].ToString()))
{
DataTable dtNews = taNews.GetDataByID(int.Parse(dtAlb.Rows[0]["NewsEventoID"].ToString()));
// lblArticolo.Text = dtNews.Rows[0]["Titolo"].ToString();
}
lblNomeAlb.Text = PhotoManager.GetNomeAlbum(AlbumID);
}
protected void BtnGalleryArt_Click(object sender, EventArgs e)
{
int idNews = (int)Session["NewsIDInserita"];
if (idNews != 0)
{
string caption = (string)Session["CaptionAlbumNews"];
DataSetVepAdminTableAdapters.AlbumsTableAdapter taAlbums = new DataSetVepAdminTableAdapters.AlbumsTableAdapter();
int albumID = 0;
string idScuola = (string)Session["ddlScuola"];
if (Request.QueryString["NewsID"] == null)
{
albumID = Convert.ToInt32(taAlbums.InsertAlbumRetID(caption, true, idNews));
//nuova news inserita faccio una redirect e nella sessione ho già l'id_news!
Response.Redirect("~/Admin/Photos.aspx?AlbumID=" + albumID.ToString());
}
else
{
DataTable dtAlbum = taAlbums.GetIdAlbum(idNews);
if (dtAlbum.Rows.Count == 0)
{
albumID = System.Convert.ToInt32(taAlbums.InsertAlbumRetID(txtTitoloNews.Text, true, idNews));
}
else
{
albumID = int.Parse(dtAlbum.Rows[0]["AlbumID"].ToString());
}
//si tratta di una modifica l'id_news la ottengo dalla querystring, quindi setto la var di sessione
Session["NewsIDInserita"] = int.Parse(Request.QueryString["NewsID"]);
Response.Redirect("~/Admin/Photos.aspx?AlbumID=" + albumID.ToString());
}
}
else
{
//errore devi prima inserire la news e poi puoi associare la fotogallery
LabelError.Text = "Attenzione: Devi prima inserire l'articolo.";
DivError.Visible = true;
DivSuccess.Visible = false;
}
}
protected void _OnItemCommand(object sender, ListViewCommandEventArgs e)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
string albumID = lvAlbums.DataKeys[dataItem.DisplayIndex].Value.ToString();
if (e.CommandName == "cancella")
{
DataSetVepAdminTableAdapters.AlbumsTableAdapter taAlbum = new DataSetVepAdminTableAdapters.AlbumsTableAdapter();
List <Photo> list = new List <Photo>();
list = PhotoManager.GetPhotos(int.Parse(albumID));
for (int i = 0; i < list.Count; i++)
{
PhotoManager.RemovePhoto(list[i].AlbumID);
}
taAlbum.Delete(int.Parse(albumID));
}
else if (e.CommandName == "modifica")
{
Response.Redirect("Photos.aspx?AlbumID=" + albumID);
}
lvAlbums.DataBind();
}
protected void _OnCreated(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType.ToString() != "EmptyItem")
{
DataSetVepAdminTableAdapters.AlbumsTableAdapter taAlbums = new DataSetVepAdminTableAdapters.AlbumsTableAdapter();
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
string albumID = lvAlbums.DataKeys[dataItem.DisplayIndex].Value.ToString();
DataTable dtAlbums = taAlbums.GetInfoAlbumbyID(int.Parse(albumID));
Label lblLinked = (Label)(e.Item.FindControl("lblLinkedtoNews"));
Image imgCount = (Image)(e.Item.FindControl("imgCount"));
Image imgLinked = (Image)(e.Item.FindControl("imgLinked"));
if (PhotoManager.GetFotoCount(int.Parse(albumID)) > 0)
{
imgCount.ImageUrl = "~/Admin/images/ball_blue_16.png";
}
if (dtAlbums.Rows[0]["NewsEventoID"].ToString() != "")
{
lblLinked.Text = "Si";
imgLinked.ImageUrl = "~/Admin/images/ball_blue_16.png";
}
}
}
protected void _OnItemCommand(object sender, ListViewCommandEventArgs e)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
string newsID = ListViewNews.DataKeys[dataItem.DisplayIndex].Value.ToString();
if (e.CommandName == "cancella")
{
DataSetMateraArredamentiTableAdapters.NewsTableAdapter taNews = new DataSetMateraArredamentiTableAdapters.NewsTableAdapter();
taNews.DeleteNewsEventi(int.Parse(newsID));
}
else if (e.CommandName == "modifica")
{
Response.Redirect("AddModNews.aspx?tipo=" + ddlTipo.SelectedValue + "&NewsID=" + newsID);
}
else if (e.CommandName == "fotoGallery")
{
DataSetVepAdminTableAdapters.NewsTableAdapter taNews = new DataSetVepAdminTableAdapters.NewsTableAdapter();
int idNews = int.Parse(newsID);
DataSetVepAdminTableAdapters.AlbumsTableAdapter taAlbums = new DataSetVepAdminTableAdapters.AlbumsTableAdapter();
int albumID = 0;
DataTable dtAlbum = taAlbums.GetIdAlbum(idNews);
DataTable dtNews = taNews.GetDataByID(idNews);
string idScuola = (string)Session["ddlScuola"];
if (dtAlbum.Rows.Count == 0)
{
albumID = Convert.ToInt32(taAlbums.InsertAlbumRetID(dtNews.Rows[0]["Descrizione"].ToString(), true, idNews));
//nuova news inserita faccio una redirect e nella sessione ho già l'id_news!
Response.Redirect("~/Admin/Photos.aspx?AlbumID=" + albumID.ToString());
}
else
{
Response.Redirect("~/Admin/Photos.aspx?AlbumID=" + dtAlbum.Rows[0]["AlbumID"].ToString());
}
}
ListViewNews.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var taNews = new DataSetVepAdminTableAdapters.AlbumsTableAdapter();
DataTable dtNews = taNews.GetInfoAlbums();
}