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