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