private void AddChildren(FleetViewTreeViewNode node, RadTreeNode treeNode)
{
if (node.NodeType == FleetViewTreeViewNode.DataNodeType.Vehicle)
{
allVehicles.Add(node);
}
if (node.NodeType == FleetViewTreeViewNode.DataNodeType.OrgUnit)
{
if (treeNode == null)
{
treeNode = new Telerik.Web.UI.RadTreeNode(node.Description, node.Id.ToString());
treeNode.Attributes.Add("GPSUnitID", node.GpsUnitId);
treeNode.Attributes.Add("ParentId", node.ParentId.ToString());
treeNode.Attributes.Add("Id", node.Id.ToString());
rtvGrouping.Nodes.Add(treeNode);
if (node.Children != null && node.Children.Count > 0)
{
node.Children.ForEach(x => AddChildren(x, treeNode));
}
}
else
{
var tn = new RadTreeNode(node.Description, node.Id.ToString());
tn.Attributes.Add("GPSUnitID", node.GpsUnitId);
tn.Attributes.Add("ParentId", node.ParentId.ToString());
tn.Attributes.Add("Id", node.Id.ToString());
treeNode.Nodes.Add(tn);
if (node.Children != null && node.Children.Count > 0)
{
node.Children.ForEach(x => AddChildren(x, tn));
}
}
}
}
private RadTreeNode GetTreeNode(string title, string value)
{
RadTreeNode treeNode = new Telerik.Web.UI.RadTreeNode();
treeNode.Text = title;
treeNode.Value = value;
return(treeNode);
}
public void InstantiateIn(Control container)
{
if (container is Telerik.Web.UI.RadTreeNode)
{
Telerik.Web.UI.RadTreeNode nodo = (Telerik.Web.UI.RadTreeNode)container;
Label lblNombre = new Label();
lblNombre.Text = nodo.Text;
nodo.Controls.Add(lblNombre);
if (nodo.Category != "SISTEMA")
{
LinkButton lnkEditar = new LinkButton();
LinkButton lnkEliminar = new LinkButton();
LinkButton lnkDetalle = new LinkButton();
LinkButton lnkAddItem = new LinkButton();
lnkEditar.ToolTip = "Editar";
lnkEditar.Text = "<i class='fa fa-pencil' aria-hidden='true'></i>";
lnkEliminar.Text = "<i class='fa fa-times' aria-hidden='true'></i>";
lnkEliminar.ToolTip = "Eliminar";
lnkDetalle.Text = "<i class='fa fa-eye' aria-hidden='true'></i>";
lnkDetalle.ToolTip = "Detalles";
lnkAddItem.Text = "<i class='fa fa-plus-circle' aria-hidden='true'></i>";
lnkAddItem.ToolTip = "Agregar página";
lnkDetalle.Click += new EventHandler(eventoDetalles);
lnkDetalle.DataBinding += new EventHandler(lkn_DataBinding);
lnkEditar.Click += new EventHandler(eventoEditar);
lnkEditar.DataBinding += new EventHandler(lkn_DataBinding);
lnkEliminar.Click += new EventHandler(eventoEliminar);
lnkEliminar.DataBinding += new EventHandler(lkn_DataBinding);
lnkAddItem.Click += new EventHandler(eventoAgregar);
lnkAddItem.DataBinding += new EventHandler(lkn_DataBinding);
nodo.Controls.Add(lnkAddItem);
nodo.Controls.Add(lnkDetalle);
nodo.Controls.Add(lnkEditar);
nodo.Controls.Add(lnkEliminar);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
BOLClass = new BOLAccessGroups();
hplSysName.Text = BOLClass.PageLable;
hplSysName.NavigateUrl = "~/" + BaseID;
if (Code == null)
{
if (!NewMode)
{
return;
}
}
if (!Page.IsPostBack)
{
string InstanceName = Request["InstanceName"];
ViewState["InstanceName"] = InstanceName;
if (!NewMode)
{
LoadData((int)Code);
IBaseBOL BOL = new BOLResources();
DataTable dt = BOL.GetDataSource(null, string.Empty, int.MaxValue, 0);
foreach (DataRow row in dt.Rows)
{
Telerik.Web.UI.RadTreeNode node = new Telerik.Web.UI.RadTreeNode();
node.Text = (string)row["Name"];
node.Value = ((int)row["Code"]).ToString();
node.Category = "Some Category";
node.ExpandMode = TreeNodeExpandMode.ServerSideCallBack;
RadTree1.Nodes.Add(node);
}
RadTree1.LoadingMessage = "( در حال بارگذاری ... )";
}
}
}
private void AddChildNodes(Telerik.Web.UI.RadTreeNode node)
{
BOLResources ReourseBOL = new BOLResources();
DataTable dt = ReourseBOL.GetNodeData(Convert.ToInt32(node.Value));
foreach (DataRow row in dt.Rows)
{
Telerik.Web.UI.RadTreeNode childNode = new Telerik.Web.UI.RadTreeNode();
childNode.Text = (string)row["Name"];
childNode.Value = ((int)row["Code"]).ToString();
DataTable dtChild = ReourseBOL.GetNodeData(Convert.ToInt32(childNode.Value));
if (dtChild.Rows.Count > 0)
{
childNode.ExpandMode = TreeNodeExpandMode.ServerSideCallBack;
}
node.Nodes.Add(childNode);
}
}
private void BindGmapData()
{
var user = _userBL.GetUser(HttpContext.Current.User.Identity.Name);
List <t_Sites> sites;
if (user.Role == "consumer")
{
sites = _siteBL.GetSitesForMapByConsumerID(user.ConsumerId).ToList();
}
else if (user.Role == "staff")
{
sites = _siteBL.GetSitesForMapByStaffId(user.StaffId).ToList();
}
else
{
sites = null;
}
//var sites = _siteBL.GetSitesForMap().ToList();
if (sites.Count == 0)
{
GMap1.setCenter(new GLatLng(16.109833, 107.201294), 6);
return;
}
List <string> groups = (from s in sites
select s.DisplayGroup).Distinct().ToList();
if (!IsPostBack)
{
GMap1.GZoom = (int)sites.Select(s => s.Zoom).Min();
int i = 0;
foreach (string g in groups)
{
Telerik.Web.UI.RadTreeNode parent = new Telerik.Web.UI.RadTreeNode(g);
trvSites.Nodes.Add(parent);
var gSites = (from s1 in sites
where s1.DisplayGroup == g
select s1).ToList();
foreach (t_Sites gS in gSites)
{
Telerik.Web.UI.RadTreeNode child = new Telerik.Web.UI.RadTreeNode(gS.Location, gS.SiteAliasName);
child.NavigateUrl = String.Format("javascript:open_Window({0});", i.ToString());
parent.Nodes.Add(child);
i++;
}
}
trvSites.ExpandAllNodes();
}
GLatLngBounds gLatLngBounds = new GLatLngBounds();
double forwardIndex = 0;
double reveseIndex = 0;
DateTime?lastForwardIndexTimeStamp = null;
DateTime?lastReverseIndexTimeStamp = null;
double? index = 0;
DateTime?indexTimeStamp = null;
GIcon icon = new GIcon();
icon.image = System.Configuration.ConfigurationManager.AppSettings["gMarkerIcon"];
icon.iconSize = new GSize(20, 20);
icon.shadowSize = new GSize(20, 20);
icon.iconAnchor = new GPoint(6, 20);
icon.infoWindowAnchor = new GPoint(5, 1);
GIcon icon_alrm = new GIcon();
icon_alrm.image = System.Configuration.ConfigurationManager.AppSettings["gMarkerIconError"];
icon_alrm.iconSize = new GSize(20, 20);
icon_alrm.shadowSize = new GSize(20, 20);
icon_alrm.iconAnchor = new GPoint(6, 20);
icon_alrm.infoWindowAnchor = new GPoint(5, 1);
GMap1.resetCustomInsideJS();
GMap1.resetCustomJS();
GMap1.resetInfoWindows();
GMap1.resetMarkers();
//Alarm display
List <string> listSiteAlarm = new List <string>();
OleDbConnection aCnn = new OleDbConnection("");
aCnn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\PMAC\PMACSITE.MDB";
try
{
aCnn.Open();
OleDbCommand aCmd = new OleDbCommand("SELECT [Id] FROM [ALARMLOG] WHERE Priority LIKE 'H' OR Priority LIKE 'L' GROUP BY [Id]", aCnn);
OleDbDataReader aRdr = aCmd.ExecuteReader();
while (aRdr.Read())
{
listSiteAlarm.Add(aRdr[0].ToString());
}
aCnn.Close();
aCnn.Dispose();
}
catch (Exception ex)
{
throw ex;
}
StringBuilder sb = new StringBuilder();
sb.Append("markers = [];");
sb.Append("lablelMarkers = [];");
sb.Append("function add_Window()");
sb.Append("{");
string formatedAliasName;
bool flag = false;
foreach (string g in groups)
{
var gSites = (from s1 in sites
where s1.DisplayGroup == g
select s1).ToList();
foreach (var s in gSites)
{
formatedAliasName = Clean(s.SiteAliasName);
//formatedAliasName = s.SiteAliasName.Replace(' ', '_').Replace('.', '_').Replace('-','_').Replace('+','_');
var channels = _channelConfigurationBL.GetChannelConfigurationsByLoggerID(s.LoggerId);
forwardIndex = 0;
reveseIndex = 0;
foreach (var c in channels)
{
if (c.ForwardFlow == true)
{
forwardIndex = c.LastIndex ?? 0;
lastForwardIndexTimeStamp = c.IndexTimeStamp;
}
else if (c.ReverseFlow == true)
{
reveseIndex = c.LastIndex ?? 0;
lastReverseIndexTimeStamp = c.IndexTimeStamp;
}
}
index = forwardIndex - reveseIndex;
indexTimeStamp = lastForwardIndexTimeStamp ?? lastReverseIndexTimeStamp;
string label = "";
label += "<div id='l_" + formatedAliasName + "' >";
label += "<div class='lblSiteName'>" + formatedAliasName + "</div>";
label += "<table border='0' cellpadding='3' cellspacing='0'>";
string html = "";
html += "<div class=\"text\">"
+ "Alias name"
+ ": "
+ s.SiteAliasName
+ "</div>";
html += "<div class=\"text\">"
+ "Vị trí"
+ ": "
+ s.Location
+ "</div>";
html += "<div class=\"text\">"
+ "Cỡ ống"
+ ": "
+ s.PipeSize
+ "</div>";
html += "<div class=\"text\">"
+ "Chỉ số"
+ ": "
+ string.Format("{0:0.0}", index) + " (" + (indexTimeStamp != null ? ((DateTime)indexTimeStamp).ToString("dd/MM/yyyy HH:mm") : "") + ")"
+ "</div>";
html += "<table border=\"0\" cellpadding=\"3\" cellspacing=\"0\" style=\"width:auto;height:auto;\">";
html += "<tr><td class=\"tblHeader\">"
+ "Kênh"
+ "</td><td class=\"tblHeader\">"
+ "Mô tả"
+ "</td><td class=\"tblHeader\">"
+ "Ngày giờ"
+ "</td><td class=\"tblHeader\">"
+ "Giá trị"
+ "</td><td class=\"tblHeader\">"
+ "Đơn vị"
+ "</td></tr>";
flag = false;
foreach (var c in channels)
{
html += "<tr><td class=\"cellCenter\">"
+ c.ChannelId
+ "</td><td class=\"cellCenter\">"
+ c.ChannelName
+ "</td><td class=\"cellCenter imp\">"
+ (c.TimeStamp == null ? "NO DATA" : ((DateTime)c.TimeStamp).ToString("dd/MM/yyyy HH:mm"))
+ "</td><td class=\"cellRight imp\">"
+ string.Format(culture, "{0:0.0}", c.LastValue)
+ "</td><td class=\"cellLeft\">"
+ c.Unit
+ "</td></tr>";
if ((c.Pressure2 == true && c.Pressure1 == false && flag == false) || (c.Pressure2 == false && c.Pressure1 == true && flag == false))
{
label += "<tr><td class='cellCenterLbl'>"
+ (c.LastValue == null ? "NO DATA" : string.Format(culture, "{0:0.0}", c.LastValue))
//+ "</td><td class='cellCenterLbl'>"
//+ c.Unit
+ "</td></tr>";
flag = true;
}
}
html += "</table>";
label += "</table></div>";
GMarkerOptions markerOptions = new GMarkerOptions();
if (listSiteAlarm.Contains(s.LoggerId) || s.t_Logger_Configurations.Alarm == true)
{
markerOptions.icon = icon_alrm;
}
else
{
markerOptions.icon = icon;
}
markerOptions.Animation = GMarkerOptions.AnimationType.Bounce;
GLatLng loc = new GLatLng((double)s.Latitude, (double)s.Longitude);
GMarker marker = new GMarker(loc, markerOptions);
marker.ID = "m_" + formatedAliasName;
GInfoWindow infoWindow = new GInfoWindow(marker, html);
sb.Append(infoWindow.ToString(GMap1.GMap_Id));
sb.AppendFormat("var {0} = new MarkerWithLabel(", "l_m_" + formatedAliasName);
sb.Append("{");
sb.AppendFormat(culture, "position: new google.maps.LatLng({0}, {1}),", (double)s.Latitude, (double)s.Longitude);
sb.Append("draggable: false,");
sb.Append("raiseOnDrag: false,");
sb.AppendFormat("map: {0},", GMap1.GMap_Id);
sb.AppendFormat("labelContent: \"{0}\",", label);
sb.Append("labelAnchor: new google.maps.Point(15, 0),");
sb.Append("icon: {}");
sb.Append("});");
sb.AppendFormat("{0}.setVisible(display);", "l_m_" + formatedAliasName);
sb.AppendFormat("google.maps.event.addListener({0}, 'click', function (e) ", "l_m_" + formatedAliasName);
sb.Append("{");
sb.AppendFormat("google.maps.event.trigger({0}, 'click')", marker.ID);
sb.Append("});");
sb.AppendFormat("markers.push({0});", marker.ID);
sb.AppendFormat("lablelMarkers.push({0});", "l_m_" + formatedAliasName);
gLatLngBounds.extend(loc);
}
}
if (!IsPostBack)
{
//fitBounds
sb.Append("var myBounds = new google.maps.LatLngBounds(); ");
sb.AppendFormat("var ne = new google.maps.LatLng({0},{1});", gLatLngBounds.ne.lat.ToString(), gLatLngBounds.ne.lng.ToString());
sb.AppendFormat("var sw = new google.maps.LatLng({0},{1});", gLatLngBounds.sw.lat.ToString(), gLatLngBounds.sw.lng.ToString());
sb.Append("myBounds.extend(ne);myBounds.extend(sw);");
sb.AppendFormat("{0}.fitBounds(myBounds);", GMap1.GMap_Id);
}
//Center on page reload event
sb.AppendFormat("google.maps.event.addListener({0}, 'center_changed', function()", GMap1.GMap_Id);
sb.Append("{");
sb.AppendFormat("center={0}.getCenter();", GMap1.GMap_Id);
sb.Append("});");
sb.AppendFormat("{0}.setCenter(center);", GMap1.GMap_Id);
// create the ContextMenu object
sb.AppendFormat("var contextMenu = new ContextMenu({0}, contextMenuOptions);", GMap1.GMap_Id);
// display the ContextMenu on a Map right click
sb.AppendFormat("google.maps.event.addListener({0}, 'rightclick', function (mouseEvent)", GMap1.GMap_Id);
sb.Append("{contextMenu.show(mouseEvent.latLng);});");
sb.Append("google.maps.event.addListener(contextMenu, 'menu_item_selected', function (latLng, eventName) {");
sb.Append("switch (eventName) {");
sb.Append("case 'hide_click':");
sb.Append("for (var i = 0; i < lablelMarkers.length; i++) {");
sb.Append("lablelMarkers[i].setVisible(false);");
sb.Append("display=false;");
sb.Append("}");
sb.Append("break;");
sb.Append("case 'show_click':");
sb.Append("for (var i = 0; i < lablelMarkers.length; i++) {");
sb.Append("lablelMarkers[i].setVisible(true);");
sb.Append("display=true;");
sb.Append("}");
sb.Append("break;");
sb.Append("}");
sb.Append("});");
sb.Append("}");
GMap1.Add(sb.ToString());
GMap1.Add("add_Window();", true);
}
private void LoadMainCats()
{
RadTreeViewAcc.Nodes.Clear();
Telerik.Web.UI.RadTreeNode MainNodI = new Telerik.Web.UI.RadTreeNode("شجرة الحسابات", "-1");
MainNodI.ImageUrl = "~/Images/Folders.png";
MainNodI.Category = "0";
MainNodI.LongDesc = "0";
RadTreeViewAcc.Nodes.Add(MainNodI);
DataTable GeneralItems = MC.LoadDataTable(@"Select AccountId, AccountName, AccountTreeId From TblAccounts Where BasicAccountId = 0", "");
foreach (DataRow R in GeneralItems.Rows)
{
Telerik.Web.UI.RadTreeNode NodI = new Telerik.Web.UI.RadTreeNode(R["AccountName"].ToString(), R["AccountId"].ToString());
NodI.ImageUrl = "~/Images/Folders.png";
NodI.Category = R["AccountTreeId"].ToString();
MainNodI.Nodes.Add(NodI);
LoadChildCats(NodI);
}
}
private void LoadChildCats(Telerik.Web.UI.RadTreeNode Node)
{
DataTable ItemChilds = MC.LoadDataTable("Select AccountId, AccountName, AccountTreeId, BasicAccountId From TblAccounts Where BasicAccountId = " + Node.Value, "");
foreach (DataRow R in ItemChilds.Rows)
{
Telerik.Web.UI.RadTreeNode NodI = new Telerik.Web.UI.RadTreeNode(R["AccountName"].ToString(), R["AccountId"].ToString());
NodI.ImageUrl = "~/Images/Folders.png";
NodI.Category = R["AccountTreeId"].ToString();
NodI.LongDesc = R["BasicAccountId"].ToString();
Node.Nodes.Add(NodI);
LoadChildCats(NodI);
}
}