public List<string> Updater(MVTDeparture oldKunde, MVTDeparture newJunde, int JolID) { List<string> messageList = new List<string>(); string FlightNumber = oldKunde.FlightNumber.Substring(2, 3); DateTime startDDate = FilterDate(Convert.ToDateTime(oldKunde.EstimatedTimeOfArrival), "start"); DateTime endDDate = FilterDate(Convert.ToDateTime(oldKunde.EstimatedTimeOfArrival), "end"); DateTime AirborneTimeDDate = FilterDate(Convert.ToDateTime(oldKunde.AirborneTime), "time"); string startDate = startDDate.Year.ToString() + '-' + startDDate.Month.ToString() + '-' + startDDate.Day.ToString(); string endDate = endDDate.Year.ToString() + '-' + endDDate.Month.ToString() + '-' + endDDate.Day.ToString(); string AirboneTTime = AirborneTimeDDate.ToString("HHmm"); string UpdateTExt = ""; try { if (JolID == 1) command.CommandText = "SELECT aodb.ArrivalFlight.arrivalFlightId, aodb.ArrivalFlight.flightNumber, aodb.ArrivalFlight.scheduledTime, aodb.ArrivalFlight.airlineId, aodb.ArrivalFlight.ATTR_7, aodb.Airline.iataCode, aodb.ArrivalFlight.ATTR_381" + " FROM aodb.ArrivalFlight INNER JOIN aodb.Airline ON aodb.ArrivalFlight.airlineId = aodb.Airline.airlineId" + " WHERE (aodb.ArrivalFlight.flightNumber = N'" + FlightNumber + "') AND (aodb.ArrivalFlight.scheduledTime BETWEEN CONVERT(DATETIME, '" + startDate + "', 102) AND CONVERT(DATETIME, '" + endDate + "', 102))"; else command.CommandText = "SELECT * FROM [aodb].[ArrivalFlight] where arrivalFlightId = 76 "; //command.CommandType = CommandType.Text; connection.Open(); messageList.Add(command.CommandText); using (SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection)) { while (dr.Read()) { if (JolID == 1) { UpdateTExt = ""; if (oldKunde.AmountOfPassengers != 0) { UpdateTExt = UpdateTExt + ", ATTR_208 = '" + oldKunde.AmountOfPassengers+"'"; } if (oldKunde.DelayCode != null) { UpdateTExt = UpdateTExt + ", ATTR_144 = '" + oldKunde.DelayCode + "'"; } command.CommandText = "UPDATE AMS.aodb.ArrivalFlight set ATTR_381 = '" + AirboneTTime + "'"+ UpdateTExt + " WHERE arrivalFlightId = " + dr["arrivalFlightId"].ToString(); } else command.CommandText = "UPDATE Daily_Values SET Daily_Values.value = '" + dr["arrivalFlightId"].ToString() + "' WHERE Field='auaraiu' and Daily_ID=" + oldKunde.FlightNumber; } } if (command.CommandText.StartsWith("UPDATE")) { command.Connection.Open(); command.ExecuteNonQuery(); messageList.Add(command.CommandText); } return messageList; } catch (Exception) { throw; } finally { if (connection != null) { connection.Close(); } } }
public List<MVTDeparture> FillListBox(string Occupation) { List<MVTDeparture> messageList = new List<MVTDeparture>(); try { string line; Boolean Blok; Blok = false; int dayEA; string mvtType; MVT messageMVT = new MVT(); MVTArrival messageMVTArrival = new MVTArrival(); //MessageRCV-нің соңына дейін бару while (reader.Peek() >= 0) { if (reader.ReadLine() == Occupation) { while (reader.Peek() >= 0) { if (reader.ReadLine().Length == 0) { break; } } break; } } while ((line = reader.ReadLine()) != null) { MVTDeparture messageMVTDeparture = new MVTDeparture(); if (line == "MVT") { Blok = true; messageMVT.FlightNumber = ""; } else if (line.Length == 0) { Blok = false; } else if (Blok) { if (line.IndexOf("/") != -1 && messageMVT.FlightNumber == "") { messageMVT.FlightNumber = line.Substring(0, line.IndexOf("/")); messageMVT.DayOfMonth = Convert.ToInt32(line.Substring(line.IndexOf("/") + 1, 2)); // B2775/08.EW399PO.MSQ messageMVT.AircraftRegistration = line.Substring(line.IndexOf("/") + 4, (line.Length - 4) - (line.IndexOf("/") + 4)); messageMVT.Airport = line.Substring(line.Length - 3, 3); } else if (line.StartsWith("AAA") && line.IndexOf("/") != -1) { mvtType = line.Substring(0, line.IndexOf("/")); messageMVTArrival.FlightNumber = messageMVT.FlightNumber; messageMVTArrival.Registration = messageMVT.AircraftRegistration; messageMVTArrival.AirportOfMovement = messageMVT.Airport; //messageList.Add(messageMVTArrival.FlightNumber); //messageList.Add(messageMVTArrival.Registration); //messageList.Add(messageMVTArrival.AirportOfMovement); if (mvtType.Length == 6) { messageMVTArrival.TouchDownTime = mvtType.Substring(2, 4); //messageList.Add(messageMVTArrival.TouchDownTime); } else if (mvtType.Length == 7) { messageMVTArrival.TouchDownTime = mvtType.Substring(3, 4); //messageList.Add(messageMVTArrival.TouchDownTime + " 7 counts"); } else { messageMVTArrival.TouchDownTime = mvtType.Substring(4, 4); messageMVTArrival.DayOfOperation = Convert.ToInt32(mvtType.Substring(2, 2)); //messageList.Add(messageMVTArrival.TouchDownTime + " Day: " + messageMVTArrival.DayOfOperation); } if ((line.Length - line.LastIndexOf("/")) == 7) { messageMVTArrival.OnBlockTime = "Off Block Day:" + line.Substring(line.LastIndexOf("/") + 1, 2) + " " + line.Substring(line.LastIndexOf("/") + 3, 4); //messageList.Add(messageMVTArrival.OnBlockTime); } else { messageMVTArrival.OnBlockTime = "Off Block noDay:" + line.Substring(line.LastIndexOf("/") + 1, 4); //messageList.Add(messageMVTArrival.OnBlockTime); } //listBox1.Items.Add(mvtType + " Arrival " + mvtType.Substring(0, 2)); } else if (line.StartsWith("AD") && line.IndexOf("/") != -1 && (messageMVT.Airport != "TSE") && line.Trim().EndsWith("TSE")) { mvtType = line.Substring(0, line.IndexOf("/")); messageMVTDeparture.MessageIdentifier = "dep"; messageMVTDeparture.FlightNumber = messageMVT.FlightNumber; messageMVTDeparture.DayofOperation = messageMVT.DayOfMonth; messageMVTDeparture.Registration = messageMVT.AircraftRegistration; messageMVTDeparture.DestinationAirport = messageMVT.Airport; //messageList.Add(messageMVTDeparture.FlightNumber + " Day: " + Convert.ToString(messageMVTDeparture.DayofOperation)); //messageList.Add(messageMVTDeparture.Registration); //messageList.Add(messageMVTDeparture.DestinationAirport); messageMVTDeparture.OfBlockTime = mvtType.Substring(2, 4); if (mvtType.Length == 6) { messageMVTDeparture.OfBlockTime = Convert.ToString(ConvertLocal(messageMVTDeparture.DayofOperation.ToString(), mvtType.Substring(2, 4))); //messageList.Add(messageMVTDeparture.OfBlockTime); } else if (mvtType.Length == 7) { messageMVTDeparture.OfBlockTime = Convert.ToString(ConvertLocal("", mvtType.Substring(3, 4))); //messageList.Add(messageMVTDeparture.OfBlockTime + " 7 counts"); } else { messageMVTDeparture.OfBlockTime = Convert.ToString(ConvertLocal(mvtType.Substring(2, 2), mvtType.Substring(4, 4))); messageMVTDeparture.DayofOperation = Convert.ToInt32(mvtType.Substring(2, 2)); //messageList.Add(messageMVTDeparture.OfBlockTime + " Day: " + messageMVTDeparture.DayofOperation); } if ((line.IndexOf(" ") - line.IndexOf("/")) == 7) { messageMVTDeparture.AirborneTime = Convert.ToString(ConvertLocal(line.Substring(line.IndexOf("/") + 1, 2), line.Substring(line.IndexOf("/") + 3, 4))); //messageList.Add(messageMVTDeparture.AirborneTime); } else { messageMVTDeparture.AirborneTime = Convert.ToString(ConvertLocal(messageMVTDeparture.DayofOperation.ToString(), line.Substring(line.LastIndexOf("/") + 1, 4))); //messageList.Add(messageMVTDeparture.AirborneTime); } if (line.Contains("EA") && (line.LastIndexOf(" ") - line.IndexOf("EA") == 8)) { messageMVTDeparture.EstimatedTimeOfArrival = Convert.ToString(ConvertLocal(line.Substring(line.IndexOf(" ") + 3, 2), line.Substring(line.IndexOf(" ") + 5, 4))); //messageList.Add(messageMVTDeparture.EstimatedTimeOfArrival); } else if (line.Contains("EA") && (line.LastIndexOf(" ") - line.IndexOf("EA") == 6)) { messageMVTDeparture.EstimatedTimeOfArrival = Convert.ToString(ConvertLocal(messageMVTDeparture.DayofOperation.ToString(), line.Substring(line.IndexOf(" ") + 3, 4))); if ((dayEA = Convert.ToDateTime(messageMVTDeparture.AirborneTime).Day) > Convert.ToDateTime(messageMVTDeparture.EstimatedTimeOfArrival).Day) { messageMVTDeparture.EstimatedTimeOfArrival = Convert.ToString(ConvertLocal(dayEA.ToString(), line.Substring(line.IndexOf(" ") + 3, 4))); } //messageList.Add(messageMVTDeparture.EstimatedTimeOfArrival); } while ((line = reader.ReadLine()) != "") { if (reader.EndOfStream) break; if (line.StartsWith("DL")) { if (line.Length == 9) { messageMVTDeparture.DelayCode = line.Substring(2, 2); messageMVTDeparture.DelayTime = line.Substring(5, 4); } else if (line.Length == 17) { messageMVTDeparture.DelayCode = line.Substring(2, 2); messageMVTDeparture.DelayTime = line.Substring(8, 4); } } else if (line.StartsWith("PX")) { if (line.Contains("/")) { //PX2/97 string Transit = line.Substring(2, line.IndexOf("/") - 2); string Destination = "0"; string Destination2 = "0"; if (line.Length == 13) { Destination = line.Substring(line.IndexOf("/") + 1, 3); Destination2 = line.Substring(line.IndexOf("/") + 5, 3); } else Destination = line.Substring(line.IndexOf("/") + 1, line.Length - line.IndexOf("/") - 1); messageMVTDeparture.AmountOfPassengers = Convert.ToInt32(Transit) + Convert.ToInt32(Destination) + Convert.ToInt32(Destination2); } else if (!line.Contains(" ") && !line.Contains("+")) messageMVTDeparture.AmountOfPassengers = Convert.ToInt32(line.Substring(2, line.Length - 2)); } } Blok = false; } if (messageMVTDeparture.FlightNumber != null) { messageList.Add(messageMVTDeparture); } } else if (line.StartsWith("Message RCV")) { SaveOccupation(line,"MVT"); } } return messageList; } catch (Exception) { throw; } finally { if (reader != null) { // reader.Close(); // reader.Dispose(); } } }