//
//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;
}
}
