/// <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 Import To Grid
/// </summary>
/// <param name="pFileName"></param>
/// <param name="fileExtension"></param>
private void Import_To_Grid(string pFileName, string fileExtension)
{
RouteCoordinatesBLL objRouteCoordinatesBLL = new RouteCoordinatesBLL();
DataTable dtCoordinates = objRouteCoordinatesBLL.ExcelDataImportintoGrid(pFileName, fileExtension, Convert.ToInt32(ViewState["ROUTE_ID"]), Convert.ToInt32(Session["USER_ID"]));
dtCoordinates.Columns.Add("LATITUDE", typeof(string));
dtCoordinates.Columns.Add("LONGITUDE", typeof(string));
dtCoordinates.Columns.Add("ROUTE_COORDINATEID", typeof(string));
if (dtCoordinates.Columns.Contains("X_axis") && dtCoordinates.Columns.Contains("Y_axis") && dtCoordinates.Columns.Contains("Z_axis"))
{
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 1].Visible = false;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 2].Visible = false;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 3].Visible = true;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 4].Visible = true;
GrdRouteCoordinates.DataSource = dtCoordinates;
GrdRouteCoordinates.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "CalcLatLongForGrid", "CalcLatLongForGrid()", true);
pnlRouteCoordinatesDetails.Visible = false;
pnlFileUpload.Visible = true;
DataTable dt = (DataTable)GrdRouteCoordinates.DataSource;
ViewState["EXCEL_DATA"] = dtCoordinates;
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Invalid Excel File.Please Upload valid Excel File');", true);
}
}
/// <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;
}
/// <summary>
/// To load co ordiante data
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnLoadCordinate_Click(object sender, EventArgs e)
{
RouteCoordinatesList list1 = new RouteCoordinatesList();
RouteCoordinatesBO objBo;
for (int i = 0; i < GrdRouteCoordinates.Rows.Count; i++)
{
objBo = new RouteCoordinatesBO();
if (GrdRouteCoordinates.Rows[i].Cells[1].Text.Trim() != " ")
{
objBo.X_axis = GrdRouteCoordinates.Rows[i].Cells[1].Text;
}
if (GrdRouteCoordinates.Rows[i].Cells[2].Text.Trim() != " ")
{
objBo.Y_axis = GrdRouteCoordinates.Rows[i].Cells[2].Text;
}
if (GrdRouteCoordinates.Rows[i].Cells[3].Text.Trim() != " ")
{
objBo.Z_axis = GrdRouteCoordinates.Rows[i].Cells[3].Text;
}
//TextBox txtlat = (TextBox)GrdRouteCoordinates.Rows[i].Cells[0].FindControl("txtLATITUDE");
//TextBox txtlon = (TextBox)GrdRouteCoordinates.Rows[i].Cells[0].FindControl("txtLONGITUDE");
TextBox txtlat = (TextBox)GrdRouteCoordinates.Rows[i].FindControl("txtLATITUDE");
TextBox txtlon = (TextBox)GrdRouteCoordinates.Rows[i].FindControl("txtLONGITUDE");
objBo.Latitude = txtlat.Text;
objBo.Longitude = txtlon.Text;
list1.Add(objBo);
}
RouteCoordinatesBLL objRouteCoordinatesBLL = new RouteCoordinatesBLL();
string message = "";
string uID = Session["USER_ID"].ToString();
string Count = objRouteCoordinatesBLL.SaveExcelData(list1, Convert.ToInt32(ViewState["ROUTE_ID"]), Session["USER_ID"].ToString());
if (!string.IsNullOrEmpty(Count))
{
if (Count == "0")
{
message = "Coordinates already exist in the system.";
}
else
{
message = Count + " - Coordinates(s) were added successfully";
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
pnlRouteCoordinatesDetails.Visible = true;
pnlFileUpload.Visible = false;
EnableSaveCancel(false);
BindGrid();
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Save_Click(object sender, EventArgs e)
{
string message = "";
if (!IsDuplicateRoute(btn_Save.Text))
{
RouteCoordinatesBO objRouteCoordinates = new RouteCoordinatesBO();
objRouteCoordinates.Route_CoordinateID = Convert.ToInt32(ViewState["ROUTE_COORDINATEID"]);
objRouteCoordinates.X_axis = txtX.Text.Trim();
objRouteCoordinates.Y_axis = txtY.Text.Trim();
objRouteCoordinates.Z_axis = txtZ.Text.Trim();
objRouteCoordinates.Latitude = txtLatitude.Text;
objRouteCoordinates.Longitude = txtLongitude.Text;
objRouteCoordinates.Route_ID = Convert.ToInt32(ViewState["ROUTE_ID"]);
RouteCoordinatesBLL objRouteCoordinatesBLL = new RouteCoordinatesBLL();
if (objRouteCoordinates.Route_CoordinateID == 0)
{
objRouteCoordinates.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
objRouteCoordinatesBLL.AddRouteCoordinates(objRouteCoordinates);
message = "Data saved successfully";
}
else
{
objRouteCoordinates.UpdatedBy = Convert.ToInt32(Session["USER_ID"]);
objRouteCoordinatesBLL.UpdateRouteCoordinates(objRouteCoordinates);
message = "Data updated successfully";
}
ClearDetails();
BindGrid();
SetUpdateMode(false);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
else
{
message = "Route Coordinates already exist in the system";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
