/// <summary>
/// Set Grid Data source
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>e
private void BindGrid()
{
if (pnlFileUpload.Visible)
{
GrdRouteCoordinates.DataSource = (DataTable)ViewState["EXCEL_DATA"];
GrdRouteCoordinates.DataBind();
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 1].Visible = false;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 2].Visible = false;
lnkMap.Visible = false;
}
else
{
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 1].Visible = true;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 2].Visible = true;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 3].Visible = false;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 4].Visible = false;
RouteCoordinatesBLL objRouteCoordinatesBLL = new RouteCoordinatesBLL();
GrdRouteCoordinates.DataSource = objRouteCoordinatesBLL.GetRouteCoordinates(ViewState["ROUTE_ID"].ToString());
GrdRouteCoordinates.DataBind();
GrdRouteCoordinates.Visible = true;
if (GrdRouteCoordinates.Rows.Count > 1)
{
lnkMap.Visible = true;
}
else
{
lnkMap.Visible = false;
}
}
}
/// <summary>
/// To generate map
/// </summary>
/// <param name="routeID"></param>
private void GenerateMap(int routeID)
{
RouteCoordinatesBLL objRouteCoordinatesBLL = new RouteCoordinatesBLL();
RouteCoordinatesList RouteCoordinates = objRouteCoordinatesBLL.GetRouteCoordinates(routeID.ToString());
System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach (RouteCoordinatesBO objRouteCoord in RouteCoordinates)
{
sb.Append(string.Format("'{0},{1},{2}'", objRouteCoord.Latitude, objRouteCoord.Longitude, objRouteCoord.Routename));
sb.Append(";");
}
if (sb.Length > 0)
{
sb.Remove(sb.Length - 1, 1);
}
//Response.Write(sb.ToString());
ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowMap", string.Format("initialize(\"{0}\")", sb.ToString()), true);
/*
* if (RouteCoordinates.Count > 0)
* {
* hdnStartingCoordinate.Value = string.Format("{0},{1}", RouteCoordinates[0].Latitude, RouteCoordinates[0].Longitude);
* hdnEndingCoordinate.Value = string.Format("{0},{1}", RouteCoordinates[RouteCoordinates.Count - 1].Latitude, RouteCoordinates[RouteCoordinates.Count - 1].Longitude); ;
* ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowMap", "calcRoute();", true);
* lblMessage.Visible = false;
* }
* else
* {
* lblMessage.Visible=true;
* }*/
}
/// <summary>
/// to fetch the count of route co ordinates
/// </summary>
/// <param name="RouteId"></param>
/// <returns></returns>
private int RouteCordinates(string RouteId)
{
RouteCoordinatesBLL objRouteCoordinatesBLL = new RouteCoordinatesBLL();
RouteCoordinatesList lstRouteCoordinates = objRouteCoordinatesBLL.GetRouteCoordinates(RouteId.ToString());
return(lstRouteCoordinates.Count);
}
/// <summary>
/// Set the Route coordinates to Map
/// </summary>
private void GenerateMap()
{
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
ProjectRouteList ProjectRouteList = new ProjectRouteList();
objProjectRoute.Project_Id = Convert.ToInt32(projectID);;
bool checck = true;
ProjectRouteList = objProjectRouteBLL.getFinalRouteApprovalDetial(objProjectRoute);
for (int i = 0; i < ProjectRouteList.Count; i++)
{
if (ProjectRouteList[i].IsFinal == "TRUE")
{
checck = false;
RouteCoordinatesBLL objRouteCoordinatesBLL = new RouteCoordinatesBLL();
RouteCoordinatesList RouteCoordinates = objRouteCoordinatesBLL.GetRouteCoordinates(ProjectRouteList[i].Route_ID.ToString());
System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach (RouteCoordinatesBO objRouteCoord in RouteCoordinates)
{
sb.Append(string.Format("'{0},{1},{2}'", objRouteCoord.Latitude, objRouteCoord.Longitude, objRouteCoord.Routename));
sb.Append(";");
}
if (sb.Length > 0)
{
sb.Remove(sb.Length - 1, 1);
}
//Response.Write(sb.ToString());
System.Text.StringBuilder sb1 = new System.Text.StringBuilder();
sb1.Append(string.Format("'{0},{1},{2}'", "0.469104", "33.164163", "E"));
sb1.Append(";");
sb1.Append(string.Format("'{0},{1},{2}'", "0.469145", "33.164285", "B"));
sb1.Append(";");
sb1.Append(string.Format("'{0},{1},{2}'", "0.468865", "33.164583", "C"));
sb1.Append(";");
sb1.Append(string.Format("'{0},{1},{2}'", "0.468782", "33.164507", "D"));
sb1.Append(";");
sb1.Append(string.Format("'{0},{1},{2}'", "0.469104", "33.164163", "E"));
sb1.Append(";");
if (sb1.Length > 0)
{
sb1.Remove(sb1.Length - 1, 1);
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowMap", string.Format("initialize(\"{0}\")", sb.ToString()), true);
//string paramView = string.Format("initialize('{0}','{1}');", sb.ToString(), sb1.ToString());
//ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowMap", paramView, true);
}
}
lblMessage.Visible = checck;
}