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