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