protected void Page_Load(object sender, EventArgs e)
{
System.Diagnostics.Trace.WriteLine("Page_Load Start", "GroupListModuleControl");
base.Load(sender, e);
if (base.CheckAutorisation())
{
LabelMsg.Text = "";
this.ParentGroup = null;
if (DataCollectionID == null || DataCollectionID == Guid.Empty)
{
LabelMsg.Text = "Kies eerst een datacollectie";
}
else
{
if (!IsPostBack)
{
Guid dataId = Guid.Empty;
ShowDataEnum showDataBy = base.getSetting <ShowDataEnum>("ShowDataBy");
if (showDataBy == ShowDataEnum.UserSelect)
{
string dataIdQuery = Request.QueryString["dataid"];
Guid.TryParse(dataIdQuery, out dataId);
}
SelectAndShowData(dataId);
}
}
}
System.Diagnostics.Trace.WriteLine("Page_Load End", "GroupListModuleControl");
}
protected void Page_Load(object sender, EventArgs e)
{
System.Diagnostics.Trace.WriteLine("Page_Load Start", "ItemListModuleControl");
base.Load(sender, e);
if (base.CheckAutorisation())
{
LabelMsg.Text = "";
if (DataCollectionID == null || DataCollectionID == Guid.Empty)
{
LabelMsg.Text = "Kies eerst een datacollectie";
}
else
{
pageSize = base.getSetting <int>("MaxNumberOfRows");
placeHolderPaging = (PlaceHolder)FindControl("PlaceHolderPaging" + ModuleID.ToString("N"));
usePaging = ((pageSize > 0) && (placeHolderPaging != null));
if (!IsPostBack)
{
Guid dataId = Guid.Empty;
ShowDataEnum showDataBy = base.getSetting <ShowDataEnum>("ShowDataBy");
if (showDataBy == ShowDataEnum.UserSelect)
{
string dataIdQuery = Request.QueryString["dataid"];
Guid.TryParse(dataIdQuery, out dataId);
}
SelectAndShowData(dataId);
}
}
}
System.Diagnostics.Trace.WriteLine("Page_Load End", "ItemListModuleControl");
}
protected override string getWhere(string tableAlias)
{
string where = base.getWhere(tableAlias);
ShowDataEnum showDataBy = base.getSetting <ShowDataEnum>("ShowDataBy");
string selectGroupID = getSetting <string>("SelectGroupID");
if (reloadedFromFilterModule)
{
where += new FilterModule()
{
DataCollection = this.DataCollection
}.BuildWhere(tableAlias, Parameters);
}
else
{
if (showDataBy == ShowDataEnum.AllItems)
{
//als vaste groep is gekozen dan deze nemen
if (selectGroupID != null && selectGroupID != "")
{
where += String.Format(" AND {0}.FK_Parent_Group = '{1}'", tableAlias, selectGroupID);
}
else
{
//doe niks
}
}
else if (showDataBy == ShowDataEnum.UserSelect)
{
if (dataType == "I")
{
//Wordt op item geselecteerd: haal de groep op van dit item
string sql = "SELECT FK_Parent_Group FROM DataItem WHERE ID = '" + dataId.ToString() + "'";
object result = DataBase.Get().Execute(sql);
Guid.TryParse(result.ToString(), out dataId);
}
if (dataId == Guid.Empty)
{
//initiele waarde
//als vaste groep is gekozen dan deze nemen
if (selectGroupID != null && selectGroupID != "")
{
where += String.Format(" AND {0}.FK_Parent_Group = '{1}'", tableAlias, selectGroupID);
}
else
{
//alle uit root tonen
where += String.Format(" AND {0}.FK_Parent_Group is null", tableAlias);
}
}
else
{
where += String.Format(" AND {0}.FK_Parent_Group = '{1}'", tableAlias, dataId);
}
}
}
return(where);
}
//private BaseCollection<DataItem> getItems()
//{
// Guid dataId = Guid.Empty;
// string dataIdQuery = Request.QueryString["dataid"];
// Guid.TryParse(dataIdQuery, out dataId);
// return getItems(dataId);
//}
private BaseCollection <DataItem> getItems(Guid dataId, string extraWhere = "")
{
if (DataCollectionID == null)
{
return(new BaseCollection <DataItem>());
}
where = base.getWhere(extraWhere);
ShowDataEnum showDataBy = base.getSetting <ShowDataEnum>("ShowDataBy");
//als vaste groep is gekozen dan deze nemen
string selectGroupID = getSetting <string>("SelectGroupID");
if (selectGroupID != null && selectGroupID != "")
{
dataId = new Guid(selectGroupID);
}
if (showDataBy == ShowDataEnum.AllItems)
{
//doe niks
}
else if (showDataBy == ShowDataEnum.UserSelect && extraWhere == "")
{
if (dataId == Guid.Empty)
{
//als geen user select: alle items uit root
where += " AND FK_Parent_Group is null";
}
else
{
//dataid kan naar item verwijzen
DataItem item = BaseObject.GetById <DataItem>(dataId);
//dan group van item laden
if (item != null && item.ParentGroup != null)
{
dataId = item.ParentGroup.ID;
}
where += String.Format(" AND FK_Parent_Group = '{0}'", dataId);
}
}
string sort = getSort();
int maxNumberOfRows = getSetting <int>("MaxNumberOfRows");
int showFromRowNumber = getSetting <int>("ShowFromRowNumber");
BaseCollection <DataItem> items;
if (maxNumberOfRows > 0 || showFromRowNumber > 1)
{
items = BaseCollection <DataItem> .Get(where, sort, 0, maxNumberOfRows, showFromRowNumber);
}
else
{
items = BaseCollection <DataItem> .Get(where, sort, 0, 0, 0);
}
return(items);
}
//private BaseCollection<DataGroup> getGroups()
//{
// return getGroups(Guid.Empty);
//}
private BaseCollection <DataGroup> getGroups(Guid dataId)
{
if (DataCollectionID == null)
{
return(new BaseCollection <DataGroup>());
}
string where = base.getWhere();
ShowDataEnum showDataBy = base.getSetting <ShowDataEnum>("ShowDataBy");
string selectGroupID = getSetting <string>("SelectGroupID");
if (showDataBy == ShowDataEnum.MainGroups)
{
where += " AND FK_Parent_Group is null";
}
else if (showDataBy == ShowDataEnum.UserSelect)
{
//als vaste groep is gekozen dan deze nemen
if (selectGroupID != null && selectGroupID != "")
{
where += " AND FK_Parent_Group = '" + selectGroupID + "'";
}
else if (dataId == Guid.Empty)
{
where += " AND FK_Parent_Group is null";
}
else
{
where += String.Format(" AND FK_Parent_Group = '{0}'", dataId);
}
}
string sort = getSort();
int maxNumberOfRows = getSetting <int>("MaxNumberOfRows");
int showFromRowNumber = getSetting <int>("ShowFromRowNumber");
BaseCollection <DataGroup> groups;
if (maxNumberOfRows > 0 || showFromRowNumber > 1)
{
groups = BaseCollection <DataGroup> .Get(where, sort, 0, maxNumberOfRows, showFromRowNumber);
}
else
{
groups = BaseCollection <DataGroup> .Get(where, sort, 0, 0, 0);
}
return(groups);
}
protected override string getWhere(string tableAlias)
{
string where = base.getWhere(tableAlias);
ShowDataEnum showDataBy = base.getSetting <ShowDataEnum>("ShowDataBy");
string selectGroupID = getSetting <string>("SelectGroupID");
if (showDataBy == ShowDataEnum.AllGroups)
{
//als vaste groep is gekozen dan deze nemen
//if (selectGroupID != null && selectGroupID != "")
//{
// where += String.Format(" AND {0}.FK_Parent_Group = '{1}'", tableAlias, selectGroupID);
//}
//else {
////doe niks
//}
}
else if (showDataBy == ShowDataEnum.MainGroups)
{
where += String.Format(" AND {0}.FK_Parent_Group is null", tableAlias);
}
else if (showDataBy == ShowDataEnum.UserSelect || showDataBy == ShowDataEnum.UserSelectNoDefaultData)
{
if (dataId == Guid.Empty)
{
//initiele waarde
//als vaste groep is gekozen dan deze nemen
if (selectGroupID != null && selectGroupID != "")
{
where += String.Format(" AND {0}.FK_Parent_Group = '{1}'", tableAlias, selectGroupID);
}
else
{
//alle uit root tonen
where += String.Format(" AND {0}.FK_Parent_Group is null", tableAlias);
}
}
else
{
where += String.Format(" AND {0}.FK_Parent_Group = '{1}'", tableAlias, dataId);
}
}
return(where);
}
protected void Page_Load(object sender, EventArgs e)
{
System.Diagnostics.Trace.WriteLine("Page_Load Start", "GoogleMapsModuleControl");
base.Load(sender, e);
if (base.CheckAutorisation())
{
LabelMsg.Text = "";
this.ParentGroup = null;
if (DataCollectionID == null || DataCollectionID == Guid.Empty)
{
LabelMsg.Text = "Kies eerst een datacollectie";
}
else
{
if (!IsPostBack)
{
Guid dataId = Guid.Empty;
ShowDataEnum showDataBy = base.getSetting <ShowDataEnum>("ShowDataBy");
if (showDataBy == ShowDataEnum.UserSelect)
{
string dataIdQuery = Request.QueryString["dataid"];
Guid.TryParse(dataIdQuery, out dataId);
}
SelectAndShowData(dataId);
GPoint initPoint = GoogleGeocoder.GetLatLng(base.getSetting <string>("InitialAddress") + "," + base.getSetting <string>("InitialAddress"), SessionObject.CurrentSite.GoogleMapsKey);
string infoBalloonFormat = "";
string sideBarRowFormat = "";
Literal literalInfoBalloon = (Literal)FindControl("LiteralInfoBalloon" + ModuleID.ToString("N"));
if (literalInfoBalloon != null)
{
infoBalloonFormat = literalInfoBalloon.Text;
infoBalloonFormat = infoBalloonFormat.Replace("\r", "").Replace("\n", "").Replace("\t", "");
infoBalloonFormat = infoBalloonFormat.Replace("'", """);
}
Literal literalSideBar = (Literal)FindControl("LiteralSideBar" + ModuleID.ToString("N"));
if (literalSideBar != null)
{
sideBarRowFormat = literalSideBar.Text;
sideBarRowFormat = sideBarRowFormat.Replace("\r", "").Replace("\n", "").Replace("\t", "");
sideBarRowFormat = sideBarRowFormat.Replace("'", """);
}
string navigationUrl = Request.Url.LocalPath;
ModuleNavigationActionLite navigationAction = GetNavigationActionByTagName("{DrillDownLink}");
if (navigationAction != null)
{
navigationUrl = navigationAction.NavigationUrl;
if (navigationAction.NavigationType == NavigationTypeEnum.ShowDetailsInModules)
{
//blijven op dezelfde pagina
navigationUrl = Request.Url.LocalPath;
}
}
LabelMsg.Text = String.Format(@"
<script type=""text/javascript"">
BITGOOGLEMAP.key = '{0}';
BITGOOGLEMAP.initLatitude = {1};
BITGOOGLEMAP.initLongitude = {2};
BITGOOGLEMAP.initZoom = {3};
BITGOOGLEMAP.datacollectionID = '{4}';
BITGOOGLEMAP.infoBalloonFormat = '{5}';
BITGOOGLEMAP.sideBarRowFormat = '{6}';
BITGOOGLEMAP.navigationUrl = '{7}'
//BITGOOGLEMAP.mapType = '{0}';
</script>", SessionObject.CurrentSite.GoogleMapsKey, initPoint.Lat.ToString().Replace(",", "."), initPoint.Long.ToString().Replace(",", "."), base.getSetting <string>("InitialZoom"), this.DataCollectionID, infoBalloonFormat, sideBarRowFormat, navigationUrl);
}
}
}
System.Diagnostics.Trace.WriteLine("Page_Load End", "GoogleMapsModuleControl");
}
//public string ConvertHeaderFooterTags(string html)
//{
// //{Parent.Naam}
// string header = Regex.Match(html, "<HeaderTemplate>(.*?)</HeaderTemplate>", RegexOptions.Singleline).ToString();
// html = ConvertHtml(html, header);
// string footer = Regex.Match(html, "<FooterTemplate>(.*?)</FooterTemplate>", RegexOptions.Singleline).ToString();
// html = ConvertHtml(html, footer);
// return html;
//}
//public string ConvertHtml(string html, string source)
//{
// if (source != null)
// {
// string convertedHeader = source;
// MatchCollection tags = Regex.Matches(source, "{Parent(.*?)}");
// foreach (Match tagMatch in tags)
// {
// string field = tagMatch.ToString().Replace("{Parent.", "").Replace("}", "");
// Tag tag = this._tags.Where(c => c.Name == "{Parent." + field + "}").FirstOrDefault();
// if (tag != null)
// {
// string mappingColumn = tag.ReplaceValue.Replace("<%#DataBinder.Eval(Container.DataItem,\"", "").Replace("\")%>", "");
// convertedHeader = convertedHeader.Replace(tagMatch.ToString(), "<%# " + mappingColumn + " %>");
// }
// }
// html = html.Replace(source, convertedHeader);
// }
// return html;
//}
public override string Publish2(CmsPage page)
{
string html = "";
try
{
if (DataCollection != null)
{
PrepairTemplate(DataCollection.DataGroupFields, DataCollection.DataGroupFields);
}
html = base.Publish2(page);
if (DataCollection == null)
{
return(html);
}
ModuleNavigationAction navigationActionDrillDown = this.GetNavigationActionByTagName("{DrillDownLink}");
if (navigationActionDrillDown != null)
{
drillDownUrl = navigationActionDrillDown.GetNavigationUrl();
drillDownLink = navigationActionDrillDown.CreateNavigationHyperlink("G");
}
if (html.Contains("{DrillUpLink}"))
{
ModuleNavigationAction navigationActionDrillUp = this.GetNavigationActionByTagName("{DrillUpLink}");
if (navigationActionDrillUp != null)
{
drillUpUrl = navigationActionDrillUp.GetNavigationUrl();
drillUpLink = navigationActionDrillUp.CreateNavigationHyperlink("G");
}
}
//getDrillDownUrlAndLink(out drillDownUrl, out drillDownLink);
ShowDataEnum showdataBy = getSetting <ShowDataEnum>("ShowDataBy");
System.Data.DataTable groupsTable = new System.Data.DataTable();
if (showdataBy == ShowDataEnum.UserSelectNoDefaultData)
{
if (this.dataId != Guid.Empty && this.dataId != null)
{
groupsTable = getDataTable("DataGroup", "G", DataCollection.DataGroupFields);
}
}
else
{
groupsTable = getDataTable("DataGroup", "G", DataCollection.DataGroupFields);
}
string rowTemplate = base.GetSubTemplate("{List}");
string rowsHtml = "";
foreach (System.Data.DataRow dataRow in groupsTable.Rows)
{
string rowHtml = rowTemplate;
string rewriteUrlDrillDown = CreateRewriteUrl(page, drillDownUrl, "G", new Guid(dataRow["ID"].ToString()), dataRow["CompletePath"].ToString(), dataRow["Title"].ToString());
rowHtml = rowHtml.Replace("{DrillDownLink}", drillDownLink);
rowHtml = rowHtml.Replace("{/DrillDownLink}", "</a>");
rowHtml = rowHtml.Replace("{DrillDownUrl}", rewriteUrlDrillDown);
foreach (System.Data.DataColumn column in dataRow.Table.Columns)
{
rowHtml = ReplaceTag(rowHtml, dataRow, column);
//rowHtml = rowHtml.Replace("{" + column.ColumnName + "}", dataRow[column.ColumnName].ToString());
if (rowHtml.Contains("{FileList1}"))
{
rowHtml = fillExtraFilesSubTemplate(rowHtml, "", dataRow["ID"].ToString());
}
if (html.Contains("{ImageList1}"))
{
rowHtml = fillExtraImagesSubTemplate(rowHtml, "", dataRow["ID"].ToString());
}
}
rowsHtml += rowHtml;
}
html = html.Replace("<!--{List}-->" + rowTemplate + "<!--{/List}-->", rowsHtml);
html = html.Replace("{List}" + rowTemplate + "{/List}", rowsHtml);
//parent-tags kunnen ook buiten de list-template staan. dus buiten {List} en {/List}
//dan ook deze tags vervangen, ook als er geen rows zouden zijn. (parent kan er nog wel zijn)
if (html.Contains("{Parent") || html.Contains("{DrillUp"))
{
//dataId = dataId == Guid.Empty ? Guid.Parse(getSetting<string>("SelectGroupID")) : dataId;
System.Data.DataRow parentGroupRow = base.getDataParentGroupRow(dataId);
html = ReplaceDrillUpTag(page, html, parentGroupRow["FK_Parent_Group"].ToString());
foreach (System.Data.DataColumn column in parentGroupRow.Table.Columns)
{
html = html.Replace("{" + column.ColumnName + "}", parentGroupRow[column.ColumnName].ToString());
}
}
bool hideWhenNoData = getSetting <bool>("HideWhenNoData");
if (hideWhenNoData && groupsTable.Rows.Count == 0)
{
html = getModuleStartDiv() + getModuleEndDiv();
}
}
catch (Exception ex)
{
html = base.HandlePublishError(ex);
}
return(html);
}
