public List <PortList> Get_NearByPorts(string Longitude, string Latitude, string LongDir, string LatDir) { List <PortList> Pt = new List <PortList>(); try { //longitude += ".00"; //latitude += ".00"; DataTable dtport = JiBeDAL.Get_Ports_NearVessel_DL(Longitude, Latitude, LongDir, LatDir); foreach (DataRow dr in dtport.Rows) { if (!string.IsNullOrEmpty(Convert.ToString(dr["PORT_LON"])) && !string.IsNullOrEmpty(Convert.ToString(dr["PORT_LAT"]))) { PortList pt = new PortList(); pt.PORT_ID = Convert.ToInt32(dr["PORT_ID"]); pt.PORT_NAME = Convert.ToString(dr["PORT_NAME"]); pt.BP_CODE = Convert.ToString(dr["BP_CODE"]); double Lon = JiBeGeneral.ConvertLatLon(Convert.ToString(dr["PORT_LON"])); pt.PORT_LON = Lon; double Lat = JiBeGeneral.ConvertLatLon(Convert.ToString(dr["PORT_LAT"])); pt.PORT_LAT = Lat; pt.OCEAN = Convert.ToString(dr["OCEAN"]); pt.UTC = Convert.ToString(dr["UTC"]); pt.Country_ID = Convert.ToInt32(dr["Country_ID"]); pt.Country_Name = Convert.ToString(dr["PORT_COUNTRY"]); DataTable dtLastPortCall = JiBeDAL.Get_LastPortCallDetails(Convert.ToInt32(dr["PORT_ID"])); if (dtLastPortCall != null && dtLastPortCall.Rows.Count > 0) { pt.ToolTipContent = "<div style=\"text-align:left;\"><span style=\"color: #66777C;font-weight:bold;\">" + Convert.ToString(dr["PORT_NAME"]) + "</span><br/><table width=\"300px\">"; pt.ToolTipContent += "<tr><td width=\"120px\">Country:</td><td width=\"180px\">" + Convert.ToString(dr["PORT_COUNTRY"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td width=\"120px\">Latitude:</td><td width=\"180px\">" + Convert.ToString(dr["PORT_LAT"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td width=\"120px\">Longitude:</td><td width=\"180px\">" + Convert.ToString(dr["PORT_LON"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td colspan=\"2\"><fieldset><legend>Last port call made by vessel- " + Convert.ToString(dtLastPortCall.Rows[0]["Vessel_Name"]) + "</legend>"; pt.ToolTipContent += "<table><tr><td>Arrival:</td><td>" + Convert.ToString(dtLastPortCall.Rows[0]["Arrival"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td>Departure:</td><td>" + Convert.ToString(dtLastPortCall.Rows[0]["Departure"]) + "</td></tr>"; pt.ToolTipContent += "</table></fieldset></td></tr></table></div>"; } else { pt.ToolTipContent = "<div style=\"text-align:left;\"><span style=\"color: #66777C;font-weight:bold;\">" + Convert.ToString(dr["PORT_NAME"]) + "</span><br/><table width=\"300px\">"; pt.ToolTipContent += "<tr><td width=\"120px\">Country:</td><td width=\"180px\">" + Convert.ToString(dr["PORT_COUNTRY"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td width=\"120px\">Latitude:</td><td width=\"180px\">" + Convert.ToString(dr["PORT_LAT"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td width=\"120px\">Longitude:</td><td width=\"180px\">" + Convert.ToString(dr["PORT_LON"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td colspan=\"2\"><fieldset><legend>Last port call details</legend>"; pt.ToolTipContent += "<table><tr><td colspan=\"2\">No Port Calls Details available.</td></tr>"; pt.ToolTipContent += "</table></fieldset></td></tr></table></div>"; } Pt.Add(pt); } } } catch (Exception ex) { string s = ex.Message; } return(Pt); }
public List <PortList> Get_SelectedPort(string PortID) { List <PortList> Pt = new List <PortList>(); try { DataTable dtport = JiBeDAL.Get_PortDetailsByID_DL(int.Parse(PortID)); foreach (DataRow dr in dtport.Rows) { if (!string.IsNullOrEmpty(Convert.ToString(dr["PORT_LON"])) && !string.IsNullOrEmpty(Convert.ToString(dr["PORT_LAT"]))) { string ConversionValue = Convert.ToString(dr["PORT_LON"]); string LatConversionValue = Convert.ToString(dr["PORT_LAT"]); if (ConversionValue.Contains("'") && LatConversionValue.Contains("'")) { PortList pt = new PortList(); //JiBeGeneral.Conv_Deg2Decimal_new(Convert.ToDouble(dr["Longitude_Degrees"]), Convert.ToDouble(dr["Longitude_Minutes"]), Convert.ToDouble(dr["Longitude_Seconds"]), Convert.ToString(dr["Longitude_E_W"])); double longDegrees = 0; double longminutes = 0; string longdirections = ""; double latDegrees = 0; double latminutes = 0; string latdirections = ""; pt.PORT_ID = Convert.ToInt32(dr["PORT_ID"]); pt.PORT_NAME = Convert.ToString(dr["PORT_NAME"]); pt.BP_CODE = Convert.ToString(dr["BP_CODE"]); //Getting Longitude if (ConversionValue.Contains("'")) { ConversionValue = ConversionValue.Replace("'", "-"); } string[] words = ConversionValue.Split('-'); for (int i = 0; i < words.Length; i++) { if (i == 0) { longDegrees = Convert.ToDouble(words[i]); } if (i == 1) { longminutes = Convert.ToDouble(words[i]); } if (i == 2) { longdirections = words[i]; } } string Longitude = JiBeGeneral.Conv_Deg2Decimal_new(longDegrees, longminutes, 0, longdirections); pt.PORT_LON = Convert.ToDouble(Longitude); //Getting Longitude //Getting Latitude if (LatConversionValue.Contains("'")) { LatConversionValue = LatConversionValue.Replace("'", "-"); } string[] latwords = LatConversionValue.Split('-'); for (int i = 0; i < latwords.Length; i++) { if (i == 0) { latDegrees = Convert.ToDouble(latwords[i]); } if (i == 1) { latminutes = Convert.ToDouble(latwords[i]); } if (i == 2) { latdirections = latwords[i]; } } string Latitude = JiBeGeneral.Conv_Deg2Decimal_new(latDegrees, latminutes, 0, latdirections); pt.PORT_LAT = Convert.ToDouble(Latitude); //Getting Latitude pt.OCEAN = Convert.ToString(dr["OCEAN"]); pt.UTC = Convert.ToString(dr["UTC"]); pt.Country_ID = Convert.ToInt32(dr["Country_ID"]); pt.Country_Name = Convert.ToString(dr["PORT_COUNTRY"]); DataTable dtLastPortCall = JiBeDAL.Get_LastPortCallDetails(Convert.ToInt32(dr["PORT_ID"])); if (dtLastPortCall != null && dtLastPortCall.Rows.Count > 0) { pt.ToolTipContent = "<div style=\"text-align:left;\"><span style=\"color: #66777C;font-weight:bold;\">" + Convert.ToString(dr["PORT_NAME"]) + "</span><br/><table width=\"300px\">"; pt.ToolTipContent += "<tr><td width=\"120px\">Country:</td><td width=\"180px\">" + Convert.ToString(dr["PORT_COUNTRY"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td width=\"120px\">Latitude:</td><td width=\"180px\">" + Convert.ToString(dr["PORT_LAT"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td width=\"120px\">Longitude:</td><td width=\"180px\">" + Convert.ToString(dr["PORT_LON"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td colspan=\"2\"><fieldset><legend>Last port call made by vessel- " + Convert.ToString(dtLastPortCall.Rows[0]["Vessel_Name"]) + "</legend>"; pt.ToolTipContent += "<table><tr><td>Arrival:</td><td>" + Convert.ToString(dtLastPortCall.Rows[0]["Arrival"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td>Departure:</td><td>" + Convert.ToString(dtLastPortCall.Rows[0]["Departure"]) + "</td></tr>"; pt.ToolTipContent += "</table></fieldset></td></tr></table></div>"; } else { pt.ToolTipContent = "<div style=\"text-align:left;\"><span style=\"color: #66777C;font-weight:bold;\">" + Convert.ToString(dr["PORT_NAME"]) + "</span><br/><table width=\"300px\">"; pt.ToolTipContent += "<tr><td width=\"120px\">Country:</td><td width=\"180px\">" + Convert.ToString(dr["PORT_COUNTRY"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td width=\"120px\">Latitude:</td><td width=\"180px\">" + Convert.ToString(dr["PORT_LAT"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td width=\"120px\">Longitude:</td><td width=\"180px\">" + Convert.ToString(dr["PORT_LON"]) + "</td></tr>"; pt.ToolTipContent += "<tr><td colspan=\"2\"><fieldset><legend>Last port call details</legend>"; pt.ToolTipContent += "<table><tr><td colspan=\"2\">No Port Calls Details available.</td></tr>"; pt.ToolTipContent += "</table></fieldset></td></tr></table></div>"; } Pt.Add(pt); } } } } catch (Exception ex) { string s = ex.Message; } return(Pt); }