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