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; } }
// //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(); }
protected string GenerateCode() { string resultCode = ""; string pageName = ""; string pageId = ""; string sPath = Server.HtmlEncode(Request.Url.ToString()); Match match; try { match = Regex.Match(sPath, @"([A-Za-z0-9_\-]+)$", RegexOptions.IgnoreCase); pageName = match.Groups[1].Value; TR_AnagForDefaultPageTableAdapter adaptActualTranId = new TR_AnagForDefaultPageTableAdapter(); //Main.TR_AnagForDefaultPageDataTable tableTR_AnagOnyActiveTr = new Main.TR_AnagForDefaultPageDataTable(); pageId = adaptActualTranId.ScalarQueryGetTRAN_ID(pageName).ToString().ToUpper(); } catch (Exception) { Response.Redirect("error.aspx"); } string strCon = ConfigurationManager.ConnectionStrings["deepcavi_hdb1"].ConnectionString; try { using (SqlConnection con = new SqlConnection(strCon)) { con.Open(); TR_ArticTableAdapter adapt = new TR_ArticTableAdapter(); Main.TR_ArticDataTable table = new Main.TR_ArticDataTable(); table = adapt.GetDataByTRAN_NameReg(pageName); TR_AnagTableAdapter adaptTR_Anag = new TR_AnagTableAdapter(); Main.TR_AnagDataTable tableTR_Anag = new Main.TR_AnagDataTable(); tableTR_Anag = adaptTR_Anag.GetData(); //TR_ListPicTableAdapter adaptListPic = new TR_ListPicTableAdapter(); //Main.TR_ListPicDataTable tableListPic = new Main.TR_ListPicDataTable(); //tableListPic = adaptListPic.GetData(); TR_AnagOnlyEnabledTracksTableAdapter adaptTR_AnagOnlyActiveTr = new TR_AnagOnlyEnabledTracksTableAdapter(); Main.TR_AnagOnlyEnabledTracksDataTable tableTR_AnagOnyActiveTr = new Main.TR_AnagOnlyEnabledTracksDataTable(); tableTR_AnagOnyActiveTr = adaptTR_AnagOnlyActiveTr.GetData(); DataSet ds = new DataSet(); ds.Tables.Add(table); DataRow[] row1; row1 = table.Select("TRAR_PartNum = '1'"); DataRow[] rowTR_Anag; string tempSelect = "TRAN_Name = '" + pageName + "'"; rowTR_Anag = tableTR_Anag.Select(tempSelect); DataRow[] rowTR_AnagOnlyActiveTr; tempSelect = "TRAN_Name = '" + pageName + "'"; rowTR_AnagOnlyActiveTr = tableTR_AnagOnyActiveTr.Select(tempSelect); int nrOfVideos = 0; foreach (DataRow r in table) { nrOfVideos++; } /* + rowTR_Anag[0]["TRAN_Title"] + @"</h1><div id='Container'><div id='FlagBlock'><div id='FlagContent'></div></div><p>" + rowTR_Anag[0]["TRAN_Descr"] + @"</p></div></div><asp:Panel ID='Panel1' runat='server' style='position:absolute'>*/ if (row1[0]["TRAR_VideoHost"].ToString() == "v") { resultCode += @"<div class='myPadding'><h1>" + rowTR_Anag[0]["TRAN_Title"] + @"</h1> <table><tr><td> <div id='FlagContainer'> <div id='FlagBlock'> <img id='imgUserPicture' alt='' src='" + pStrUserImgPath + @"'width='100px' style='border: 1px solid grey'/><br /> By <label id='lblUploaderName'>" +pStrUserName+ @"</label> <div id='FlagContent'></div> </div><p>" + rowTR_Anag[0]["TRAN_Descr"] + @"</p></div> </td></tr></table> <asp:Panel ID='Panel1' runat='server' style='position:absolute'> <div id='FlagContainer'> <p style='padding-left:20px; padding-top:15px; width: 240px; position:absolute'>" + nrOfVideos + @" videos available</p> </div> </asp:Panel> <table border='0' cellpadding='0' cellspacing='0'> <tr> <td style='padding-right:4px; width:247px'> <div class='yoxview' id='videos'> <a href='" + "http://player.vimeo.com/video/" + row1[0]["TRAR_VideoID"] + "?wmode=opaque&byline=0&portrait=0' target='yoxview' style='border-style:none;'>" + "<img src='Images for html/Temp Images/go to videos clear.png' alt='' title='Part 1' width='241px' height='185' border-style:none; />"; } else { resultCode += @"<div class='myPadding'><h1>" + rowTR_Anag[0]["TRAN_Title"] + @"</h1> <table><tr><td> <div id='FlagContainer'> <div id='FlagBlock'> <img id='imgUserPicture' alt='' src='" + pStrUserImgPath + @"'width='100px' style='border: 1px solid grey'/><br /> By <label id='lblUploaderName'>" + pStrUserName + @"</label> <div id='FlagContent'></div> </div><p>" + rowTR_Anag[0]["TRAN_Descr"] + @"</p></div> </td></tr></table> <asp:Panel ID='Panel1' runat='server' style='position:absolute'> <div id='FlagContainer'> <p style='padding-left:20px; padding-top:15px; width: 240px; position:absolute'>" + nrOfVideos + @" videos available</p> </div> </asp:Panel> <table border='0' cellpadding='0' cellspacing='0'> <tr> <td style='padding-right:4px; width:247px'> <div class='yoxview' id='videos'> <a href='" + "http://www.youtube.com/embed/" + row1[0]["TRAR_VideoID"] + "?wmode=opaque&rel=0&showsearch=0&fs=1' target='yoxview' style='border-style:none;'>" + "<img src='Images for html/Temp Images/go to videos clear.png' alt='' title='Part 1' width='241px' height='185' style='border-style:none;' />"; } DataRow[] rowsFrom2; rowsFrom2 = table.Select("TRAR_PartNum > '1'"); int count = 0; foreach (DataRow row in rowsFrom2) { if (rowsFrom2[count]["TRAR_VideoHost"].ToString() == "v") { resultCode += @"<a href='" + "http://player.vimeo.com/video/" + rowsFrom2[count]["TRAR_VideoID"] + "?wmode=opaque&byline=0&portrait=0' target='yoxview' style='border-style:none; visibility: hidden; height:0px; width:0px'>" + "<img src='' alt='' title='Part " + (count + 1) + "' />"; } else if (rowsFrom2[count]["TRAR_VideoHost"].ToString() == "y") { resultCode += @"<a href='" + "http://www.youtube.com/embed/" + rowsFrom2[count]["TRAR_VideoID"] + "?wmode=opaque&rel=0&showsearch=0&fs=1' target='yoxview' style='border-style:none; visibility: hidden'; height:0px; width:0px>" + "<img src='' alt='' title='Part " + (count + 1) + "' />"; } count++; } resultCode += @"</a> </div> </td> <td valign='top'> <div class='yoxview'>"; string picName1 = ""; picName1 = Convert.ToInt16(rowTR_AnagOnlyActiveTr[0]["TRAN_Pic1"]) == 1 ? "1.bmp": ""; string picName2 = ""; picName2 = Convert.ToInt16(rowTR_AnagOnlyActiveTr[0]["TRAN_Pic2"]) == 1 ? "2.bmp" : ""; string picName3 = ""; picName3 = Convert.ToInt16(rowTR_AnagOnlyActiveTr[0]["TRAN_Pic3"]) == 1 ? "3.bmp" : ""; string picName4 = ""; picName4 = Convert.ToInt16(rowTR_AnagOnlyActiveTr[0]["TRAN_Pic4"]) == 1 ? "4.bmp" : ""; string picName5 = ""; picName5 = Convert.ToInt16(rowTR_AnagOnlyActiveTr[0]["TRAN_Pic5"]) == 1 ? "5.bmp" : ""; string picName6 = ""; picName6 = Convert.ToInt16(rowTR_AnagOnlyActiveTr[0]["TRAN_Pic6"]) == 1 ? "6.bmp" : ""; string picName7 = ""; picName7 = Convert.ToInt16(rowTR_AnagOnlyActiveTr[0]["TRAN_Pic7"]) == 1 ? "7.bmp" : ""; string picName8 = ""; picName8 = Convert.ToInt16(rowTR_AnagOnlyActiveTr[0]["TRAN_Pic8"]) == 1 ? "8.bmp" : ""; string picName9 = ""; picName9 = Convert.ToInt16(rowTR_AnagOnlyActiveTr[0]["TRAN_Pic9"]) == 1 ? "9.bmp" : ""; string picName10 = ""; picName10 = Convert.ToInt16(rowTR_AnagOnlyActiveTr[0]["TRAN_Pic10"]) == 1 ? "10.bmp" : ""; match = Regex.Match(picName1, @"([A-Za-z0-9_\-]+)\.bmp$", RegexOptions.IgnoreCase); picName1 = match.Groups[1].Value; match = Regex.Match(picName2, @"([A-Za-z0-9_\-]+)\.bmp$", RegexOptions.IgnoreCase); picName2 = match.Groups[1].Value; match = Regex.Match(picName3, @"([A-Za-z0-9_\-]+)\.bmp$", RegexOptions.IgnoreCase); picName3 = match.Groups[1].Value; match = Regex.Match(picName4, @"([A-Za-z0-9_\-]+)\.bmp$", RegexOptions.IgnoreCase); picName4 = match.Groups[1].Value; match = Regex.Match(picName5, @"([A-Za-z0-9_\-]+)\.bmp$", RegexOptions.IgnoreCase); picName5 = match.Groups[1].Value; match = Regex.Match(picName6, @"([A-Za-z0-9_\-]+)\.bmp$", RegexOptions.IgnoreCase); picName6 = match.Groups[1].Value; match = Regex.Match(picName7, @"([A-Za-z0-9_\-]+)\.bmp$", RegexOptions.IgnoreCase); picName7 = match.Groups[1].Value; match = Regex.Match(picName8, @"([A-Za-z0-9_\-]+)\.bmp$", RegexOptions.IgnoreCase); picName8 = match.Groups[1].Value; match = Regex.Match(picName9, @"([A-Za-z0-9_\-]+)\.bmp$", RegexOptions.IgnoreCase); picName9 = match.Groups[1].Value; match = Regex.Match(picName10, @"([A-Za-z0-9_\-]+)\.bmp$", RegexOptions.IgnoreCase); picName10 = match.Groups[1].Value; if (rowTR_AnagOnlyActiveTr[0]["TRAN_Pic5"].ToString() == "False") { resultCode += @"<a href='Images/" + pageId + "/Large/" + picName1 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName1 + @".bmp' alt='" + picName1 + @"' title='" + "Image " + picName1 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName2 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName2 + @".bmp' alt='" + picName2 + @"' title='" + "Image " + picName2 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a><br/>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName3 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName3 + @".bmp' alt='" + picName3 + @"' title='" + "Image " + picName3 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName4 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName4 + @".bmp' alt='" + picName4 + @"' title='" + "Image " + picName4 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; } else if (rowTR_AnagOnlyActiveTr[0]["TRAN_Pic7"].ToString() == "False") { resultCode += @"<a href='Images/" + pageId + "/Large/" + picName1 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName1 + @".bmp' alt='" + picName1 + @"' title='" + "Image " + picName1 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName2 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName2 + @".bmp' alt='" + picName2 + @"' title='" + "Image " + picName2 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName3 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName3 + @".bmp' alt='" + picName3 + @"' title='" + "Image " + picName3 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a><br/>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName4 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName4 + @".bmp' alt='" + picName4 + @"' title='" + "Image " + picName4 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName5 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName5 + @".bmp' alt='" + picName5 + @"' title='" + "Image " + picName5 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName6 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName6 + @".bmp' alt='" + picName6 + @"' title='" + "Image " + picName6 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; } else if (rowTR_AnagOnlyActiveTr[0]["TRAN_Pic9"].ToString() == "False") { resultCode += @"<a href='Images/" + pageId + "/Large/" + picName1 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName1 + @".bmp' alt='" + picName1 + @"' title='" + "Image " + picName1 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName2 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName2 + @".bmp' alt='" + picName2 + @"' title='" + "Image " + picName2 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName3 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName3 + @".bmp' alt='" + picName3 + @"' title='" + "Image " + picName3 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName4 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName4 + @".bmp' alt='" + picName4 + @"' title='" + "Image " + picName4 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a><br/>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName5 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName5 + @".bmp' alt='" + picName5 + @"' title='" + "Image " + picName5 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName6 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName6 + @".bmp' alt='" + picName6 + @"' title='" + "Image " + picName6 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName7 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName7 + @".bmp' alt='" + picName7 + @"' title='" + "Image " + picName7 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; resultCode += @"<a href='Images/" + pageId + "/Large/" + picName8 + @".jpg'><img src='Images/" + pageId + "/Thumb/" + picName8 + @".bmp' alt='" + picName8 + @"' title='" + "Image " + picName8 + @"' width='160' height='90' style='border-style:none; padding-right:5px'/></a>"; } // resultCode = @" // <a href='http://player.vimeo.com/video/27650420?byline=0&portrait=0' target='yoxview' style='border-style:none;'> // <img src='Images for html/Temp Images/go to videos.png' alt='' title='Part 1' /> // </a><a href='http://www.youtube.com/embed/HsM_EEmj7bw?wmode=opaque&rel=0&showsearch=0&fs=1' // target='yoxview' style='visibility: hidden'> // <img src='' alt='' title='Part 2' /> // </a><a href='http://www.youtube.com/embed/iA0ROdGxJDA?wmode=opaque&rel=0&showsearch=0&fs=1' // target='yoxview' style='visibility: hidden'> // <img src='' alt='' title='Part 3' /> // </a> // "; resultCode += @" </div> </td> </tr> </table>"; return resultCode; } } catch (SqlException err) { return err.ToString(); } }