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 <VesselLocation> PGET_VesselCurrentLocation(VesselCurrentLocation rVesselCurrentLocation) { List <VesselLocation> VL = new List <VesselLocation>(); try { DataSet dsData = JiBeDAL.Get_VesselCurrentLocation(Convert.ToInt32(rVesselCurrentLocation.VesselID), Convert.ToInt32(rVesselCurrentLocation.FleetID), rVesselCurrentLocation.TelegramType, Convert.ToInt32(rVesselCurrentLocation.UserID)); DataTable dtvessellocation = dsData.Tables[0]; foreach (DataRow dr in dtvessellocation.Rows) { if (!string.IsNullOrEmpty(Convert.ToString(dr["Vessel_ID"]))) { VesselLocation vl = new VesselLocation(); vl.Vessel_ID = Convert.ToInt32(dr["Vessel_ID"]); vl.Vessel_Name = Convert.ToString(dr["Vessel_Name"]); vl.Vessel_Short_Name = Convert.ToString(dr["Vessel_Short_Name"]); string Latitude = JiBeGeneral.Conv_Deg2Decimal_new(Convert.ToDouble(dr["Latitude_Degrees"]), Convert.ToDouble(dr["Latitude_Minutes"]), Convert.ToDouble(dr["Latitude_Seconds"]), Convert.ToString(dr["LATITUDE_N_S"])); vl.Latitude = Convert.ToDouble(Latitude); string Longitude = 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"])); vl.Longitude = Convert.ToDouble(Longitude); vl.LonDir = Convert.ToString(dr["Longitude_E_W"]); vl.LatDir = Convert.ToString(dr["LATITUDE_N_S"]); string strVesselCourse = "0"; if (!string.IsNullOrEmpty(Convert.ToString(dr["Vessel_Course"]))) { strVesselCourse = Convert.ToString(dr["Vessel_Course"]); int index = strVesselCourse.IndexOf("."); if (index > 0) { strVesselCourse = strVesselCourse.Substring(0, index); } } vl.VesselCourse = strVesselCourse; string content = "<div style=\"text-align:left;\"><span style=\"color: #66777C;font-weight:bold;\">" + Convert.ToString(dr["Vessel_Name"]) + "</span><br/><table width=\"300px\">"; content += "<tr><td width=\"120px\">ReportDate:</td><td width=\"180px\"><span style=\"color: blue;font-weight:bold;\">" + Convert.ToString(dr["infodate"]) + "</span></td></tr>"; content += "<tr><td>Location:</td><td>" + Convert.ToString(dr["Location_Name"]) + "</td></tr>"; content += "<tr><td>Latitude:</td><td>" + Convert.ToString(dr["Latitude_Degrees"]) + " " + Convert.ToString(dr["Latitude_Minutes"]) + " " + Convert.ToString(dr["Latitude_Seconds"]) + " " + Convert.ToString(dr["LATITUDE_N_S"]) + "</td></tr>"; content += "<tr><td>Longitude:</td><td>" + Convert.ToString(dr["Longitude_Degrees"]) + " " + Convert.ToString(dr["Longitude_Minutes"]) + " " + Convert.ToString(dr["Longitude_Seconds"]) + " " + Convert.ToString(dr["Longitude_E_W"]) + "</td></tr>"; content += "<tr><td>Course:</td><td>" + Convert.ToString(dr["Vessel_Course"]) + "</td></tr>"; content += "<tr><td>Wind Direction/Force:</td><td>" + Convert.ToString(dr["Wind_Direction"]) + "/" + Convert.ToString(dr["Wind_Force"]) + "</td></tr>"; content += "<tr><td>Average speed:</td><td>" + Convert.ToString(dr["AVERAGE_SPEED"]) + "</td></tr>"; string PName = Convert.ToString(dr["PORT_NAME"]); if (string.IsNullOrEmpty(PName)) { PName = "Not avialble"; } string ETADate = "-"; string ETATime = "-"; if (!string.IsNullOrEmpty(Convert.ToString(dr["ETA_Next_Port"]))) { ETADate = (Convert.ToDateTime(dr["ETA_Next_Port"])).ToString("dd MMM yyyy"); ETATime = (Convert.ToDateTime(dr["ETA_Next_Port"])).ToString("HH:mm"); } content += "<tr><td><span font-size: x-small;\">Next Port/ETA:</td><td>" + PName + "/" + ETADate + " " + ETATime + "</span></td></tr>"; content += "<tr><td><a href='" + rVesselCurrentLocation.BaseUrl + "Crew/CrewList_PhotoView.aspx?vcode=" + dr["Vessel_Short_Name"].ToString() + "' target='_blank'>Crew List</a></td>"; content += "<td><a href='" + rVesselCurrentLocation.BaseUrl + "Operations/NoonReport.aspx?LastNoon=" + dr["Vessel_Short_Name"].ToString() + "&ID=" + dr["PKID"].ToString() + "' target='_blank'>Last Noon</a></td></tr>"; content += "</table></div>"; vl.ToolTipContent = content; vl.SLat = Convert.ToInt32(vl.Latitude).ToString(); vl.SLon = Convert.ToInt32(vl.Longitude).ToString(); vl.PKID = Convert.ToInt32(dr["PKID"]); VL.Add(vl); } } } catch (Exception ex) { string s = ex.Message; } return(VL); }
public List <VesselArrivalDepartureByPort> Get_PortArrivalDepatureByVesselRoute(string VesselID, string FleetID, string FromDate, string ToDate, string PortID, string TelegramType) { List <VesselArrivalDepartureByPort> Pt = new List <VesselArrivalDepartureByPort>(); try { DateTime?dtFromDate = null; DateTime?dtToDate = null; string Day = ""; string Month = ""; string Year = ""; string[] DateArray; if (!string.IsNullOrEmpty(FromDate)) { DateArray = FromDate.Split('_'); int i = 0; foreach (string word in DateArray) { if (i == 0) { Day = word; } if (i == 1) { Month = word; } if (i == 2) { Year = word; } i++; } FromDate = Year + "/" + Month + "/" + Day; Day = ""; Month = ""; Year = ""; DateArray = null; dtFromDate = Convert.ToDateTime(FromDate); } if (!string.IsNullOrEmpty(ToDate)) { DateArray = ToDate.Split('_'); int i = 0; foreach (string word in DateArray) { if (i == 0) { Day = word; } if (i == 1) { Month = word; } if (i == 2) { Year = word; } i++; } ToDate = Year + "/" + Month + "/" + Day; Day = ""; Month = ""; Year = ""; DateArray = null; dtToDate = Convert.ToDateTime(ToDate); } //DataTable dtport = JiBeDAL.Get_PortDetailsByID_DL(int.Parse(PortID)); DataTable dtportcalls = JiBeDAL.Get_PortArrivalDepatureByVesselRoute(int.Parse(VesselID), int.Parse(FleetID), dtFromDate, dtToDate, int.Parse(PortID), TelegramType); double latdegrees = 0; double latminutes = 0; string latdirections = ""; double londegrees = 0; double lonminutes = 0; string londirections = ""; string[] parts = null; if (dtportcalls.Rows.Count > 0) { for (int i = 0; i < dtportcalls.Rows.Count; i++) { string content = ""; VesselArrivalDepartureByPort pt = new VesselArrivalDepartureByPort(); if (!string.IsNullOrEmpty(Convert.ToString(dtportcalls.Rows[i]["PORT_ID"])) && !string.IsNullOrEmpty(Convert.ToString(dtportcalls.Rows[i]["PORT_NAME"]))) { string portlat = Convert.ToString(dtportcalls.Rows[i]["PORT_LAT"]); string portlon = Convert.ToString(dtportcalls.Rows[i]["PORT_LON"]); if (!string.IsNullOrEmpty(portlat) && !string.IsNullOrEmpty(portlon)) { pt.PORT_ID = Convert.ToInt32(dtportcalls.Rows[i]["PORT_ID"]); parts = portlat.Split('-'); for (int v = 0; v < parts.Length; v++) { if (v == 0) { latdegrees = Convert.ToDouble(parts[v]); } else { latdirections = parts[v]; } } parts = latdirections.Split('\''); for (int t = 0; t < parts.Length; t++) { if (t == 0) { latminutes = Convert.ToDouble(parts[t]); } else { latdirections = parts[t]; } } parts = portlon.Split('-'); for (int v = 0; v < parts.Length; v++) { if (v == 0) { londegrees = Convert.ToDouble(parts[v]); } else { londirections = parts[v]; } } parts = londirections.Split('\''); for (int t = 0; t < parts.Length; t++) { if (t == 0) { lonminutes = Convert.ToDouble(parts[t]); } else { londirections = parts[t]; } } string Latitude = JiBeGeneral.Conv_Deg2Decimal_new(latdegrees, latminutes, 0, latdirections); pt.PORT_LAT = Latitude; string Longitude = JiBeGeneral.Conv_Deg2Decimal_new(londegrees, lonminutes, 0, londirections); pt.PORT_LON = Longitude; pt.PORT_NAME = Convert.ToString(dtportcalls.Rows[i]["PORT_NAME"]); content = "<div style=\"text-align:left;\"><span style=\"color: #66777C;font-weight:bold;\">" + Convert.ToString(dtportcalls.Rows[i]["PORT_NAME"]) + "</span><br/><table width=\"300px\">"; content += "<tr><td width=\"120px\">Country:</td><td width=\"180px\">" + Convert.ToString(dtportcalls.Rows[i]["PORT_COUNTRY"]) + "</td></tr>"; content += "<tr><td width=\"120px\">Longitude:</td><td width=\"180px\">" + Convert.ToString(dtportcalls.Rows[i]["PORT_LON"]) + "</td></tr>"; content += "<tr><td width=\"120px\">Latitude:</td><td width=\"180px\">" + Convert.ToString(dtportcalls.Rows[i]["PORT_LAT"]) + "</td></tr>"; content += "<tr><td width=\"120px\" colspan=\"2\"><fieldset><legend>Port Call Details</legend><br/>"; content += "<table><tr><td width=\"120px\">Arrival:</td><td>" + Convert.ToString(dtportcalls.Rows[i]["Arrival"]) + "</td></tr>"; content += "<tr><td width=\"120px\">Depature:</td><td>" + Convert.ToString(dtportcalls.Rows[i]["Departure"]) + "</td></tr>"; content += "</table></fieldset></td></tr></table></div>"; pt.Content = content; if (!string.IsNullOrEmpty(Convert.ToString(dtportcalls.Rows[i]["Arrival"]))) { pt.Arrival = Convert.ToString(dtportcalls.Rows[i]["Arrival"]); } else { pt.Arrival = ""; } if (!string.IsNullOrEmpty(Convert.ToString(dtportcalls.Rows[i]["Departure"]))) { pt.Departure = Convert.ToString(dtportcalls.Rows[i]["Departure"]); } else { pt.Departure = ""; } } Pt.Add(pt); } } } } catch (Exception ex) { string s = ex.Message; } return(Pt); }
public List <Route> Get_VesselRoute(string VesselID, string FleetID, string FromDate, string ToDate, string TelegramType) { List <Route> Pt = new List <Route>(); try { DateTime?dtFromDate = null; DateTime?dtToDate = null; string Day = ""; string Month = ""; string Year = ""; string[] DateArray; if (!string.IsNullOrEmpty(FromDate)) { DateArray = FromDate.Split('_'); int i = 0; foreach (string word in DateArray) { if (i == 0) { Day = word; } if (i == 1) { Month = word; } if (i == 2) { Year = word; } i++; } FromDate = Year + "/" + Month + "/" + Day; Day = ""; Month = ""; Year = ""; DateArray = null; dtFromDate = Convert.ToDateTime(FromDate); } if (!string.IsNullOrEmpty(ToDate)) { DateArray = ToDate.Split('_'); int i = 0; foreach (string word in DateArray) { if (i == 0) { Day = word; } if (i == 1) { Month = word; } if (i == 2) { Year = word; } i++; } ToDate = Year + "/" + Month + "/" + Day; Day = ""; Month = ""; Year = ""; DateArray = null; dtToDate = Convert.ToDateTime(ToDate); } DataTable dtport = JiBeDAL.Get_TelegramData_Route_DL(int.Parse(VesselID), int.Parse(FleetID), dtFromDate, dtToDate, TelegramType); foreach (DataRow dr in dtport.Rows) { Route pt = new Route(); pt.Vessel_ID = Convert.ToInt32(dr["Vessel_ID"]); string Latitude = JiBeGeneral.Conv_Deg2Decimal_new(Convert.ToDouble(dr["Latitude_Degrees"]), Convert.ToDouble(dr["Latitude_Minutes"]), Convert.ToDouble(dr["Latitude_Seconds"]), Convert.ToString(dr["LATITUDE_N_S"])); pt.Latitude = Latitude.Remove(6); //pt.Latitude = Latitude; string Longitude = 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"])); pt.Longitude = Longitude.Remove(6); pt.Next_Port = Convert.ToInt32(dr["Next_Port"]); pt.PORT_NAME = Convert.ToString(dr["PORT_NAME"]); //pt.Longitude = Longitude; 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); }