This is a simple task to visualize a photo list associated to a feature: the task was developed integrating it in the map viewer (
) framework. In the code, you will have to point out the id layer and the field name on which the feature must be searched (variable LayerId and fieldName). Besides, in the static function LoadImages you will have to write your business logic in order to get back the photo list.
For instance, in this function I get back the photo list from a table (many) joined with the feature class passing to the function the value in fieldName in feature class (one). In this particular case the join is between ObjectId in feature class and the relevant value in a many table field, while the value searched in input in the user's floating panel is another one, in this case the fieldName string type field parameter key passed to the function. The last sentence highlights that, if the field is of numeric type, the apostrophes in the query must be removed.
The function returning the photo list could become more than one because it can be modified in runtime (through the property methodImages) as it is called via reflection.
namespace Studioat.ARCGIS.ADF.Tasks
{using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.ComponentModel;
using System.Configuration;
using System.Data.OleDb;
using System.Reflection;
using System.Text;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using ESRI.ArcGIS.ADF.Web;
using ESRI.ArcGIS.ADF.Web.DataSources;
using ESRI.ArcGIS.ADF.Web.UI.WebControls;
using ESRI.Solutions.NITK.Framework.Results;
using ESRI.Solutions.NITK.Framework.TaskResults;
//Author: Domenico Ciavarella
//www.studioat.it
[AjaxControlToolkit.ClientScriptResource("Studioat.ARCGIS.ADF.Tasks.PhotoGalleryTask", "Studioat.ARCGIS.ADF.Tasks.javascript.PhotoGalleryTask.js")][System.Web.UI.ToolboxData(@"<{0}:PhotoGalleryTask runat=""server"" BackColor=""White"" BorderColor=""LightSteelBlue"" BorderStyle=""Outset"" BorderWidth=""1px"" Font-Names=""Verdana""
Font-Size=""8pt"" ForeColor=""Black"" TitleBarColor=""WhiteSmoke"" TitleBarHeight=""20px""
TitleBarSeparatorLine=""True"" Transparency=""35"" Width=""130px"">
</{0}:PhotoGalleryTask>")]public class PhotoGalleryTask : ResultProducingTask
{static readonly log4net.ILog _log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
static readonly string taskFullName = System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName;
static readonly string taskNamespace = System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Namespace;
ITaskResultsContainer m_TaskResults;
//Change here your data
//*********************************************************
string LayerId = "1";
string fieldName = "YourNameFieldSearchUserFeature";
//*********************************************************
[Browsable(true)]
[Category("PhotoGalleryTask")][DefaultValue("LoadImages")][PersistenceMode(PersistenceMode.Attribute)]
[DisplayName("Method for list images")]public string MethodImages
{get
{object o = StateManager.GetProperty("methodImages");return (o == null) ? "LoadImages" : o as string;
}
set
{StateManager.SetProperty("methodImages", value);}
}
#region CreateChildControls, Render
HtmlGenericControl container = null;
HtmlGenericControl containerDivPG = null;
Image progressImage = null;
Image htmlPrevButton = null;
Image htmlNextButton = null;
HtmlGenericControl containerDiv = null;
Image photoImage = null;
public HtmlInputText txtValue = null;
public HtmlInputButton btnFind = null;
protected override void CreateChildControls()
{Controls.Clear();
base.CreateChildControls();
container = new HtmlGenericControl("div");container.ID = "photoGallery";
Controls.Add(container);
containerDivPG = new HtmlGenericControl("div");container.Controls.Add(containerDivPG);
htmlPrevButton = new Image();
htmlPrevButton.ID = "prevButton";
htmlPrevButton.ImageUrl = GetSource("backDisabled.png");containerDivPG.Controls.Add(htmlPrevButton);
htmlNextButton = new Image();
htmlNextButton.ID = "nextButton";
htmlNextButton.ImageUrl = GetSource("forwardDisabled.png");containerDivPG.Controls.Add(htmlNextButton);
progressImage = new Image();
progressImage.ID = "progress";
progressImage.ImageUrl = GetSource("activity_indicator.gif");containerDivPG.Controls.Add(progressImage);
containerDiv = new HtmlGenericControl("div");container.Controls.Add(containerDiv);
photoImage = new Image();
photoImage.ID = "image";
photoImage.ImageUrl = GetSource("gray_x_button.gif");containerDiv.Controls.Add(photoImage);
txtValue = new HtmlInputText();
txtValue.ID = "txtValue";
Controls.Add(txtValue);
btnFind = new HtmlInputButton();
btnFind.ID = "btnFind";
btnFind.Value = "Find";
Controls.Add(btnFind);
StringBuilder KeyValues = new StringBuilder();
KeyValues.Append(string.Format("'{0}=' + $get('{1}').value", "txtFindValue", txtValue.ClientID));string onClick = string.Format("executeTask({0},\"{1}\");", KeyValues.ToString(), CallbackFunctionString);btnFind.Attributes.Add("onclick", onClick);}
#endregion
private string GetSource(string image)
{return Page.ClientScript.GetWebResourceUrl(typeof(PhotoGalleryTask), string.Format("{0}.images.{1}", taskNamespace, image));}
protected override void OnPreRender(System.EventArgs e)
{base.OnPreRender(e);
if (!base.IsAsync)
{RegisterScriptControl();
}
}
protected string ControlClientID
{get
{EnsureChildControls();
return container.ClientID;
}
}
void RegisterScriptControl()
{StringBuilder script = new StringBuilder();
script.Append("Sys.Application.add_init(function() {");script.AppendFormat("$create({0},",taskFullName);script.Append("{");script.AppendFormat("'imageElement': $get('{0}'),", photoImage.ClientID);script.AppendFormat("'prevElement': $get('{0}'),", htmlPrevButton.ClientID);script.AppendFormat("'nextElement': $get('{0}'),", htmlNextButton.ClientID);script.AppendFormat("'progressElement': $get('{0}'),", progressImage.ClientID);script.AppendFormat("'forwardDisabledUrl': '{0}',", GetSource("forwardDisabled.png"));script.AppendFormat("'backwardDisabledUrl': '{0}',", GetSource("backDisabled.png"));script.AppendFormat("'forwardUrl': '{0}',", GetSource("forward.png"));script.AppendFormat("'backwardUrl': '{0}',", GetSource("back.png"));script.AppendFormat("'noPhotoUrl': '{0}',", GetSource("gray_x_button.gif"));script.Append("'images': []");script.AppendFormat("}}, {{}}, {{}}, $get('{0}'));", ControlClientID);script.AppendLine("});");System.Web.UI.ScriptManager.RegisterStartupScript(this, this.GetType(), this.ClientID + "_startup", script.ToString(), true);
}
/// <summary>
/// sample method used for list of images
/// </summary>
/// <param name="key">your key</param>
/// <returns>string: 'http://www.myphoto.com/01.jpg','http://www.myphoto.com/02.jpg' or string.Empty</returns>
static string LoadImages(string key)
{//********************************************************************************
//change with your code. This is an example.
//********************************************************************************
string connectionString = ConfigurationManager.AppSettings["ConnectionDB"];
string pathFoto = ConfigurationManager.AppSettings["PhysicalPathFoto"];
string queryString = "SELECT Photo from featureclassOne,tableMany "
+ "WHERE (featureclassOne.objectid = tableMany.foreignKey) and (YourFieldName = ?)";
using (OleDbConnection connection = new OleDbConnection(connectionString))
{OleDbCommand command = new OleDbCommand(queryString, connection);
command.Parameters.AddWithValue("@key", key);try
{string result=null;
connection.Open();
using (OleDbDataReader reader = command.ExecuteReader())
{while (reader.Read())
{result += string.Format("'{0}{1}{2}",pathFoto, reader[0].ToString().Replace("\\","/"),"',");}
}
result = result.Substring(0, result.Length - 1);
return result;
}
catch
{return string.Empty;
}
}
}
public override void ExecuteTask()
{Results = null;
if (Input == null) return;
NameValueCollection keyValColl = Input as NameValueCollection;
string stxtFindValue = keyValColl["txtFindValue"] as string;
string sWhere = string.Format("{0} = {2}{1}{2}", fieldName, stxtFindValue,"'");ESRI.ArcGIS.ADF.Web.DataSources.IGISResource gisresource = Map.PrimaryMapResourceInstance;
IQueryFunctionality queryFunctionality = (IQueryFunctionality)gisresource.CreateFunctionality(typeof(IQueryFunctionality), null);
SpatialFilter spatialfilter = new SpatialFilter();
spatialfilter.ReturnADFGeometries = true;
spatialfilter.MaxRecords = 1;
spatialfilter.WhereClause = sWhere;
System.Data.DataTable datatable = queryFunctionality.Query(null, LayerId, spatialfilter);
if ((datatable == null) (datatable.Rows.Count == 0))
{NoSelectionsTaskResult setResultsTaskResult = new NoSelectionsTaskResult((datatable == null) ? "Error!" : "No found value!");
Results = setResultsTaskResult;
return;
}
try
{SetResults(ref datatable, null, LayerId, true);
TaskResults.DisplayResults(null, null, null, this.Results);
TaskResults.Show();
MethodInfo dynMethod = GetType().GetMethod(MethodImages, BindingFlags.NonPublic BindingFlags.Static);
object o = dynMethod.Invoke(this, new object[] { stxtFindValue });CallbackResults.Add(CallbackResult.CreateJavaScript(string.Format("$find('{0}').set_images([{1}]);", ControlClientID, o)));}
catch (Exception ex)
{UnableToSetResultsTaskResult setResultsTaskResult = new UnableToSetResultsTaskResult(this.Title, ex.Message);
Results = setResultsTaskResult;
}
}
private ITaskResultsContainer TaskResults
{get
{if ((m_TaskResults == null) && (TaskResultsContainers[0] != null))
m_TaskResults = ESRI.ArcGIS.ADF.Web.UI.WebControls.Utility.FindControl(TaskResultsContainers[0].Name, Page) as ITaskResultsContainer;
return m_TaskResults;
}
}
public override string GetCallbackResult()
{NameValueCollection keyValColl = CallbackUtility.ParseStringIntoNameValueCollection(CallbackEventArgument);
Input = keyValColl;
return base.GetCallbackResult();
}
public override List<GISResourceItemDependency> GetGISResourceItemDependencies()
{throw new System.NotImplementedException();
}
}
}
