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