public static async Task <List <PortCall> > getAllShips() { List <PortCall> portCalls = await RestHandler.getPortCalls(); foreach (PortCall p in portCalls) { string imo = p.vessel.imo; string name = p.vessel.name; string imgURL = p.vessel.photoURL; string portCallId = p.id; string arrivalDate = p.arrivalDate; Console.WriteLine(arrivalDate); conn = new MySqlConnection(connectionString); conn.Open(); MySqlCommand cmd = new MySqlCommand("INSERT IGNORE INTO tbl_ship SET imoNumber = '" + imo + "', name = '" + name + "', imgURL = '" + imgURL + "', portCallID = '" + portCallId + "', active = '0', arrivalDate = '" + arrivalDate + "';"); cmd.Connection = conn; cmd.ExecuteNonQuery(); conn.Close(); } return(portCalls); }
public static async Task <string> createDepartureMessage(string shipIMO) { string portCallID = DataBaseHandler.getPortCallId(shipIMO); departureMessage.Clear(); departureMessage.Append("PortCall ID: " + portCallID + "<br />"); List <portCallMessage> list = await RestHandler.getEvents(portCallID); //Sort list based on DateTime time list.Sort((x, y) => DateTime.Compare(LocationOrService(x), LocationOrService(y))); foreach (portCallMessage pcm in list) { appendMessageInfo(pcm); } addComment("<br />" + portCallID); return(departureMessage.ToString()); }