private void ShowNewsList()
{
try
{
conn.Open();
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
//set the commandText to the name of our stored procedure
command.CommandText = "[dbo].[ListNewsItems]";
//command.CommandText = string.Format("select * from NewsTbl");
queryResults = command.ExecuteReader();
if (!queryResults.Read())
{ //used emptydata template in News.aspx instead
// lblError.Text = "No News Items recorded ";
}
ListViewNews.DataSource = queryResults;
ListViewNews.DataBind();
command.Connection.Close();
}
catch (Exception ex)
{
lblError.Visible = true;
lblError.Text = ex.Message;
}
finally
{
conn.Close();
}
}
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();
}
