/// <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 Excel Data /// </summary> /// <param name="list1"></param> /// <param name="RouteID"></param> /// <param name="uID"></param> /// <returns></returns> public string SaveExcelData(RouteCoordinatesList list1, int RouteID, string uID) { Int32 result = 0; OracleConnection myConnection; OracleCommand myCommand; myConnection = new OracleConnection(AppConfiguration.ConnectionString); myCommand = new OracleCommand("USP_TRN_INS_COORDINATES", myConnection); myCommand.Connection = myConnection; myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.Add("@RouteIdIN", ""); myCommand.Parameters.Add("@X_AxiesIN", ""); myCommand.Parameters.Add("@Y_AxiesIN", ""); myCommand.Parameters.Add("@Z_AxiesIN", ""); myCommand.Parameters.Add("@LATITUDEIN", ""); myCommand.Parameters.Add("@LONGITUDEIN", ""); myCommand.Parameters.Add("@ISDELETEDIN", ""); myCommand.Parameters.Add("@USERIDIN", ""); myCommand.Parameters.Add("rows_Affected", OracleDbType.Int32).Direction = ParameterDirection.Output; myConnection.Open(); for (int i = 0; i < list1.Count; i++) { myCommand.Parameters["@RouteIdIN"].Value = RouteID; myCommand.Parameters["@X_AxiesIN"].Value = list1[i].X_axis; myCommand.Parameters["@Y_AxiesIN"].Value = list1[i].Y_axis; myCommand.Parameters["@Z_AxiesIN"].Value = list1[i].Z_axis; myCommand.Parameters["@LATITUDEIN"].Value = list1[i].Latitude; myCommand.Parameters["@LONGITUDEIN"].Value = list1[i].Longitude; myCommand.Parameters["@ISDELETEDIN"].Value = "false"; myCommand.Parameters["@USERIDIN"].Value = uID; myCommand.ExecuteNonQuery(); if (myCommand.Parameters["rows_Affected"].Value != null) { result += Convert.ToInt32(myCommand.Parameters["rows_Affected"].Value.ToString()); } } myConnection.Close(); return(result.ToString()); }
/// <summary> /// To Save Excel Data /// </summary> /// <param name="list1"></param> /// <param name="ProjectID"></param> /// <param name="uID"></param> /// <returns></returns> public string SaveExcelData(RouteCoordinatesList list1, int ProjectID, string uID) { RouteCoordinatesDAL objRouteCoordinatesDAL = new RouteCoordinatesDAL(); return(objRouteCoordinatesDAL.SaveExcelData(list1, ProjectID, uID)); }
/// <summary> /// To Get Route Coordinates /// </summary> /// <param name="RouteId"></param> /// <returns></returns> public RouteCoordinatesList GetRouteCoordinates(string RouteId) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GETCOORDINATES"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; if (RouteId.ToString() == "") { cmd.Parameters.Add("@Route_IdIN", DBNull.Value); } else { cmd.Parameters.Add("@Route_IdIN", RouteId.ToString()); } cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); RouteCoordinatesBO objRouteCoordinates = null; RouteCoordinatesList RouteCoordinates = new RouteCoordinatesList(); while (dr.Read()) { objRouteCoordinates = new RouteCoordinatesBO(); if (!dr.IsDBNull(dr.GetOrdinal("ROUTE_COORDINATEID"))) { objRouteCoordinates.Route_CoordinateID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ROUTE_COORDINATEID"))); } if (!dr.IsDBNull(dr.GetOrdinal("ROUTEID"))) { objRouteCoordinates.Route_ID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ROUTEID"))); } if (!dr.IsDBNull(dr.GetOrdinal("ROUTENAME"))) { objRouteCoordinates.Routename = dr.GetString(dr.GetOrdinal("ROUTENAME")); } if (!dr.IsDBNull(dr.GetOrdinal("X_LONGITUDE"))) { objRouteCoordinates.X_axis = dr.GetString(dr.GetOrdinal("X_LONGITUDE")); } if (!dr.IsDBNull(dr.GetOrdinal("Y_LATITUDE"))) { objRouteCoordinates.Y_axis = dr.GetString(dr.GetOrdinal("Y_LATITUDE")); } if (!dr.IsDBNull(dr.GetOrdinal("Z_HEIGHT"))) { objRouteCoordinates.Z_axis = dr.GetString(dr.GetOrdinal("Z_HEIGHT")); } if (!dr.IsDBNull(dr.GetOrdinal("latitude"))) { objRouteCoordinates.Latitude = dr.GetString(dr.GetOrdinal("latitude")); } if (!dr.IsDBNull(dr.GetOrdinal("LONGITUDE"))) { objRouteCoordinates.Longitude = dr.GetString(dr.GetOrdinal("LONGITUDE")); } RouteCoordinates.Add(objRouteCoordinates); } dr.Close(); return(RouteCoordinates); }