/// <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); } }