// //la tabella TR_ListPic viene creata e popolata dalla pagina Admin/ImgUpload.aspx // protected void Page_Load(object sender, EventArgs e) { Session["NewVideosAdded"] = "false"; //per pagina NewPageTemplate ApplicationId(); if (!IsPostBack) { Session["next10"] = 0; for (int i = 1; i <= 10; i++) { string playButton = "playButton" + i; string getSlides = "getSlides" + i; } CreateListDS(); /*TR_AnagForDefaultPageTableAdapter adapt = new TR_AnagForDefaultPageTableAdapter(); Main.TR_AnagForDefaultPageDataTable table = new Main.TR_AnagForDefaultPageDataTable();*/ TR_AnagForDefaultPageTableAdapter adapt = new TR_AnagForDefaultPageTableAdapter(); Main.TR_AnagForDefaultPageDataTable table = new Main.TR_AnagForDefaultPageDataTable(); table = adapt.GetData(); #region Elevation //prepare src for elevation img string bikemapNr1 = ""; string bikemapNr2 = ""; string bikemapNr3 = ""; string bikemapNr4 = ""; string bikemapNr5 = ""; string bikemapNr6 = ""; string bikemapNr7 = ""; string bikemapNr8 = ""; string bikemapNr9 = ""; string bikemapNr10 = ""; try { bikemapNr1 = table.Rows[0]["TRAN_BikemapNr"].ToString(); ViewState["strSrcBikemap1"] = "http://www.gpsies.com/" + bikemapNr1; ViewState["strTrackName1"] = table.Rows[0]["TRAN_Name"].ToString(); ViewState["strTrackRedirect1"] = @"VideoPages/" + ViewState["strTrackName1"].ToString() + ".aspx"; ViewState["strPicName1"] = @"Images/" + table.Rows[0]["TRAN_ID"].ToString() + @"/Thumb/"+ Convert.ToInt16(table.Rows[0]["TRAN_Pic1"]) + ".bmp"; ViewState["strTrackName1"] = ViewState["strTrackName1"].ToString().Replace("_", " "); ViewState["strDistanceKm1"] = table.Rows[0]["TRAN_DistanceKm"].ToString(); ViewState["strDistanceMiles1"] = table.Rows[0]["TRAN_DistanceMiles"].ToString(); ViewState["strVerticalClimbM1"] = table.Rows[0]["TRAN_VerticalClimbM"].ToString(); ViewState["strVerticalClimbFeet1"] = table.Rows[0]["TRAN_VerticalClimbFeet"].ToString(); ViewState["strCategory1"] = table.Rows[0]["TRAN_Category"].ToString(); } catch (Exception) { ViewState["strSrcBikemap1"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strTrackName1"] = ""; ViewState["strTrackRedirect1"] = Server.MapPath(@"~\Default.aspx"); ViewState["strPicName1"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strCategory1"] = ""; } try { bikemapNr2 = table.Rows[1]["TRAN_BikemapNr"].ToString(); ViewState["strSrcBikemap2"] = "http://www.gpsies.com/" + bikemapNr2; ViewState["strTrackName2"] = table.Rows[1]["TRAN_Name"].ToString(); ViewState["strTrackRedirect2"] = @"VideoPages/" + ViewState["strTrackName2"].ToString() + ".aspx"; ViewState["strPicName2"] = @"Images/" + ViewState["strTrackName2"].ToString() + @"/Thumb/" + table.Rows[1]["TRAN_Pic1"].ToString(); ViewState["strTrackName2"] = ViewState["strTrackName2"].ToString().Replace("_", " "); ViewState["strDistanceKm2"] = table.Rows[1]["TRAN_DistanceKm"].ToString(); ViewState["strDistanceMiles2"] = table.Rows[1]["TRAN_DistanceMiles"].ToString(); ViewState["strVerticalClimbM2"] = table.Rows[1]["TRAN_VerticalClimbM"].ToString(); ViewState["strVerticalClimbFeet2"] = table.Rows[1]["TRAN_VerticalClimbFeet"].ToString(); ViewState["strCategory2"] = table.Rows[1]["TRAN_Category"].ToString(); } catch (Exception) { ViewState["strSrcBikemap2"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strTrackName2"] = ""; ViewState["strTrackRedirect2"] = Server.MapPath(@"~\Default.aspx"); ViewState["strPicName2"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strCategory2"] = ""; } try { bikemapNr3 = table.Rows[2]["TRAN_BikemapNr"].ToString(); ViewState["strSrcBikemap3"] = "http://www.gpsies.com/" + bikemapNr3; ViewState["strTrackName3"] = table.Rows[2]["TRAN_Name"].ToString(); ViewState["strTrackRedirect3"] = @"VideoPages/" + ViewState["strTrackName3"].ToString() + ".aspx"; ViewState["strPicName3"] = @"Images/" + ViewState["strTrackName3"].ToString() + @"/Thumb/" + table.Rows[2]["TRAN_Pic1"].ToString(); ViewState["strTrackName3"] = ViewState["strTrackName3"].ToString().Replace("_", " "); ViewState["strDistanceKm3"] = table.Rows[2]["TRAN_DistanceKm"].ToString(); ViewState["strDistanceMiles3"] = table.Rows[2]["TRAN_DistanceMiles"].ToString(); ViewState["strVerticalClimbM3"] = table.Rows[2]["TRAN_VerticalClimbM"].ToString(); ViewState["strVerticalClimbFeet3"] = table.Rows[2]["TRAN_VerticalClimbFeet"].ToString(); ViewState["strCategory3"] = table.Rows[2]["TRAN_Category"].ToString(); } catch (Exception) { ViewState["strSrcBikemap3"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strTrackName3"] = ""; ViewState["strTrackRedirect3"] = Server.MapPath(@"~\Default.aspx"); ViewState["strPicName3"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strCategory3"] = ""; } try { bikemapNr4 = table.Rows[3]["TRAN_BikemapNr"].ToString(); ViewState["strSrcBikemap4"] = "http://www.gpsies.com/" + bikemapNr4; ViewState["strTrackName4"] = table.Rows[3]["TRAN_Name"].ToString(); ViewState["strTrackRedirect4"] = @"VideoPages/" + ViewState["strTrackName4"].ToString() + ".aspx"; ViewState["strPicName4"] = @"Images/" + ViewState["strTrackName4"].ToString() + @"/Thumb/" + table.Rows[3]["TRAN_Pic1"].ToString(); ViewState["strTrackName4"] = ViewState["strTrackName4"].ToString().Replace("_", " "); ViewState["strDistanceKm4"] = table.Rows[3]["TRAN_DistanceKm"].ToString(); ViewState["strDistanceMiles4"] = table.Rows[3]["TRAN_DistanceMiles"].ToString(); ViewState["strVerticalClimbM4"] = table.Rows[3]["TRAN_VerticalClimbM"].ToString(); ViewState["strVerticalClimbFeet4"] = table.Rows[3]["TRAN_VerticalClimbFeet"].ToString(); ViewState["strCategory4"] = table.Rows[3]["TRAN_Category"].ToString(); } catch (Exception) { ViewState["strSrcBikemap4"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strTrackName4"] = ""; ViewState["strTrackRedirect4"] = Server.MapPath(@"~\Default.aspx"); ViewState["strPicName4"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strCategory4"] = ""; } try { bikemapNr5 = table.Rows[4]["TRAN_BikemapNr"].ToString(); ViewState["strSrcBikemap5"] = "http://www.gpsies.com/" + bikemapNr5; ViewState["strTrackName5"] = table.Rows[4]["TRAN_Name"].ToString(); ViewState["strTrackRedirect5"] = @"VideoPages/" + ViewState["strTrackName5"].ToString() + ".aspx"; ViewState["strPicName5"] = @"Images/" + ViewState["strTrackName5"].ToString() + @"/Thumb/" + table.Rows[4]["TRAN_Pic1"].ToString(); ViewState["strTrackName5"] = ViewState["strTrackName5"].ToString().Replace("_", " "); ViewState["strDistanceKm5"] = table.Rows[4]["TRAN_DistanceKm"].ToString(); ViewState["strDistanceMiles5"] = table.Rows[4]["TRAN_DistanceMiles"].ToString(); ViewState["strVerticalClimbM5"] = table.Rows[4]["TRAN_VerticalClimbM"].ToString(); ViewState["strVerticalClimbFeet5"] = table.Rows[4]["TRAN_VerticalClimbFeet"].ToString(); ViewState["strCategory5"] = table.Rows[4]["TRAN_Category"].ToString(); } catch (Exception) { ViewState["strSrcBikemap5"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strTrackName5"] = ""; ViewState["strTrackRedirect5"] = Server.MapPath(@"~\Default.aspx"); ViewState["strPicName5"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strCategory5"] = ""; } try { bikemapNr6 = table.Rows[5]["TRAN_BikemapNr"].ToString(); ViewState["strSrcBikemap6"] = "http://www.gpsies.com/" + bikemapNr6; ViewState["strTrackName6"] = table.Rows[5]["TRAN_Name"].ToString(); ViewState["strTrackRedirect6"] = @"VideoPages/" + ViewState["strTrackName6"].ToString() + ".aspx"; ViewState["strPicName6"] = @"Images/" + ViewState["strTrackName6"].ToString() + @"/Thumb/" + table.Rows[5]["TRAN_Pic1"].ToString(); ViewState["strTrackName6"] = ViewState["strTrackName6"].ToString().Replace("_", " "); ViewState["strDistanceKm6"] = table.Rows[5]["TRAN_DistanceKm"].ToString(); ViewState["strDistanceMiles6"] = table.Rows[5]["TRAN_DistanceMiles"].ToString(); ViewState["strVerticalClimbM6"] = table.Rows[5]["TRAN_VerticalClimbM"].ToString(); ViewState["strVerticalClimbFeet6"] = table.Rows[5]["TRAN_VerticalClimbFeet"].ToString(); ViewState["strCategory6"] = table.Rows[5]["TRAN_Category"].ToString(); } catch (Exception) { ViewState["strSrcBikemap6"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strTrackName6"] = ""; ViewState["strTrackRedirect6"] = Server.MapPath(@"~\Default.aspx"); ViewState["strPicName6"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strCategory6"] = ""; } try { bikemapNr7 = table.Rows[6]["TRAN_BikemapNr"].ToString(); ViewState["strSrcBikemap7"] = "http://www.gpsies.com/" + bikemapNr7; ViewState["strTrackName7"] = table.Rows[6]["TRAN_Name"].ToString(); ViewState["strTrackRedirect7"] = @"VideoPages/" + ViewState["strTrackName7"].ToString() + ".aspx"; ViewState["strPicName7"] = @"Images/" + ViewState["strTrackName7"].ToString() + @"/Thumb/" + table.Rows[6]["TRAN_Pic1"].ToString(); ViewState["strTrackName7"] = ViewState["strTrackName7"].ToString().Replace("_", " "); ViewState["strDistanceKm7"] = table.Rows[6]["TRAN_DistanceKm"].ToString(); ViewState["strDistanceMiles7"] = table.Rows[6]["TRAN_DistanceMiles"].ToString(); ViewState["strVerticalClimbM7"] = table.Rows[6]["TRAN_VerticalClimbM"].ToString(); ViewState["strVerticalClimbFeet7"] = table.Rows[6]["TRAN_VerticalClimbFeet"].ToString(); ViewState["strCategory7"] = table.Rows[6]["TRAN_Category"].ToString(); } catch (Exception) { ViewState["strSrcBikemap7"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strTrackName7"] = ""; ViewState["strTrackRedirect7"] = Server.MapPath(@"~\Default.aspx"); ViewState["strPicName7"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strCategory7"] = ""; } try { bikemapNr8 = table.Rows[7]["TRAN_BikemapNr"].ToString(); ViewState["strSrcBikemap8"] = "http://www.gpsies.com/" + bikemapNr8; ViewState["strTrackName8"] = table.Rows[7]["TRAN_Name"].ToString(); ViewState["strTrackRedirect8"] = @"VideoPages/" + ViewState["strTrackName8"].ToString() + ".aspx"; ViewState["strPicName8"] = @"Images/" + ViewState["strTrackName8"].ToString() + @"/Thumb/" + table.Rows[7]["TRAN_Pic1"].ToString(); ViewState["strTrackName8"] = ViewState["strTrackName8"].ToString().Replace("_", " "); ViewState["strDistanceKm8"] = table.Rows[7]["TRAN_DistanceKm"].ToString(); ViewState["strDistanceMiles8"] = table.Rows[7]["TRAN_DistanceMiles"].ToString(); ViewState["strVerticalClimbM8"] = table.Rows[7]["TRAN_VerticalClimbM"].ToString(); ViewState["strVerticalClimbFeet8"] = table.Rows[7]["TRAN_VerticalClimbFeet"].ToString(); ViewState["strCategory8"] = table.Rows[7]["TRAN_Category"].ToString(); } catch (Exception) { ViewState["strSrcBikemap8"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strTrackName8"] = ""; ViewState["strTrackRedirect8"] = Server.MapPath(@"~\Default.aspx"); ViewState["strPicName8"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strCategory8"] = ""; } try { bikemapNr9 = table.Rows[8]["TRAN_BikemapNr"].ToString(); ViewState["strSrcBikemap9"] = "http://www.gpsies.com/" + bikemapNr9; ViewState["strTrackName9"] = table.Rows[8]["TRAN_Name"].ToString(); ViewState["strTrackRedirect9"] = @"VideoPages/" + ViewState["strTrackName9"].ToString() + ".aspx"; ViewState["strPicName9"] = @"Images/" + ViewState["strTrackName9"].ToString() + @"/Thumb/" + table.Rows[8]["TRAN_Pic1"].ToString(); ViewState["strTrackName9"] = ViewState["strTrackName9"].ToString().Replace("_", " "); ViewState["strDistanceKm9"] = table.Rows[8]["TRAN_DistanceKm"].ToString(); ViewState["strDistanceMiles9"] = table.Rows[8]["TRAN_DistanceMiles"].ToString(); ViewState["strVerticalClimbM9"] = table.Rows[8]["TRAN_VerticalClimbM"].ToString(); ViewState["strVerticalClimbFeet9"] = table.Rows[8]["TRAN_VerticalClimbFeet"].ToString(); ViewState["strCategory9"] = table.Rows[8]["TRAN_Category"].ToString(); } catch (Exception) { ViewState["strSrcBikemap9"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strTrackName9"] = ""; ViewState["strTrackRedirect9"] = Server.MapPath(@"~\Default.aspx"); ViewState["strPicName9"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strCategory9"] = ""; } try { bikemapNr10 = table.Rows[9]["TRAN_BikemapNr"].ToString(); ViewState["strSrcBikemap10"] = "http://www.gpsies.com/" + bikemapNr10; ViewState["strTrackName10"] = table.Rows[9]["TRAN_Name"].ToString(); ViewState["strPicName10"] = @"Images/" + ViewState["strTrackName10"].ToString() + @"/Thumb/" + table.Rows[9]["TRAN_Pic1"].ToString(); ViewState["strTrackRedirect10"] = @"VideoPages/" + ViewState["strTrackName10"].ToString() + ".aspx"; ViewState["strPicName10"] = @"Images/" + ViewState["strTrackName10"].ToString() + @"/Thumb/" + table.Rows[9]["TRAN_Pic1"].ToString(); ViewState["strTrackName10"] = ViewState["strTrackName10"].ToString().Replace("_", " "); ViewState["strDistanceKm10"] = table.Rows[9]["TRAN_DistanceKm"].ToString(); ViewState["strDistanceMiles10"] = table.Rows[9]["TRAN_DistanceMiles"].ToString(); ViewState["strVerticalClimbM10"] = table.Rows[9]["TRAN_VerticalClimbM"].ToString(); ViewState["strVerticalClimbFeet10"] = table.Rows[9]["TRAN_VerticalClimbFeet"].ToString(); ViewState["strCategory10"] = table.Rows[9]["TRAN_Category"].ToString(); } catch (Exception) { ViewState["strSrcBikemap10"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strTrackName10"] = ""; ViewState["strTrackRedirect10"] = Server.MapPath(@"~\Default.aspx"); ViewState["strPicName10"] = Server.MapPath(@"~\Images\white background.bmp"); ViewState["strCategory10"] = ""; } #endregion } //#region WhenWhiteBackground TR_AnagForDefaultPageTableAdapter adaptPicRow = new TR_AnagForDefaultPageTableAdapter(); Main.TR_AnagForDefaultPageDataTable tablePicRow = new Main.TR_AnagForDefaultPageDataTable(); tablePicRow = adaptPicRow.GetData(); }
public static AjaxControlToolkit.Slide[] GetSlides9(/*string contextKey*/) { TR_AnagForDefaultPageTableAdapter adapt = new TR_AnagForDefaultPageTableAdapter(); Main.TR_AnagForDefaultPageDataTable table = new Main.TR_AnagForDefaultPageDataTable(); table = adapt.GetData(); AjaxControlToolkit.Slide[] photos9 = new AjaxControlToolkit.Slide[10]; string trackId = ""; try { trackId = table.Rows[8].ItemArray[0].ToString(); string[] fileNames = new string[8];//string[] fileNames = System.IO.Directory.GetFiles(HttpContext.Current.Server.MapPath("~/Images/" +/*contextKey*/trackId + "/Thumb/")); for (int i = 0; i < fileNames.Length; i++) { fileNames[i] = Convert.ToInt16(table.Rows[8].ItemArray[18 + i]).ToString(); photos9[i] = new AjaxControlToolkit.Slide("Images/" + trackId + "/Thumb/" + Convert.ToInt16(fileNames[i]) + ".bmp", "", ""); } return photos9; } catch (Exception) { } if (trackId != "") return photos9; else { AjaxControlToolkit.Slide[] whiteArr = new AjaxControlToolkit.Slide[1]; whiteArr[0] = new AjaxControlToolkit.Slide("Images/" + "white background.bmp", "", ""); return whiteArr; } }