public DateTime getATAItinerary(int Itinerarie)
{
try
{
string ATA = "";
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT ATA,ATATime FROM Co.Itinerary WHERE ID = " + Itinerarie;
clientORN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
Char delimiter = '|';
string[] substrings = data.Split(delimiter);
ATA = substrings[0] + " " + substrings[1];
}
}
return(DateTime.Parse(ATA));
}
catch (Exception ex)
{
MessageBox.Show("getATAItinerary: " + ex.Message + "Detail: " + ex.StackTrace);
return(DateTime.Now);
}
}
private string GetMTOW(string idICAO)
{
try
{
string weight = "";
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT Weight FROM CO.AircraftType WHERE ICAODesignator= '" + idICAO + "'";
clientORN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
weight = data;
}
}
return(String.IsNullOrEmpty(weight) ? "" : weight);
}
catch (Exception ex)
{
MessageBox.Show("GetMTOW" + ex.Message + "Det:" + ex.StackTrace);
return("");
}
}
public bool HasPayable(string Service)
{
try
{
bool has = false;
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT COUNT(ID) FROM CO.Payables WHERE Services =" + Service;
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
has = Convert.ToInt32(data) > 0 ? true : false;
}
}
return(has);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "Det" + ex.StackTrace);
return(false);
}
}
private void UpdateCosts()
{
try
{
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT ID FROM CO.Services WHERE Incident =" + IncidentID;
globalContext.LogMessage(queryString);
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1000, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
if (!HasPayable(data))
{
UpdatePaxPrice(Convert.ToInt32(data), 0);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("UpdateCosts" + ex.Message + " Det :" + ex.StackTrace);
}
}
public string getTailName(int IdTail)
{
try
{
string tail = "";
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT LookupName,AircraftType1 FROM CO.Aircraft WHERE ID =" + IdTail;
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 10000, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
Char delimiter = '|';
String[] substrings = data.Split(delimiter);
tail = substrings[0];
ICAODesignator = getICAODesi(Convert.ToInt32(substrings[1]));
}
}
return(tail);
}
catch (Exception ex)
{
MessageBox.Show("getTailName: " + ex.Message + "Det" + ex.StackTrace);
return("");
}
}
public string getICAODesi(int IdAircraftType)
{
try
{
string Icao = "";
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT ICAODesignator FROM CO.AircraftType WHERE ID = " + IdAircraftType;
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 10000, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
Icao = data;
}
}
return(Icao);
}
catch (Exception ex)
{
MessageBox.Show("getICAODesi: " + ex.Message + "Det" + ex.StackTrace);
return("");
}
}
public string getAirport(int IdAirport)
{
try
{
string IATACODE = "";
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT LookupName FROM CO.Airports WHERE ID =" + IdAirport;
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 10000, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
IATACODE = data;
}
}
return(IATACODE);
}
catch (Exception ex)
{
MessageBox.Show("getAirport: " + ex.Message + "Det" + ex.StackTrace);
return("");
}
}
private int UpdpatePayables()
{
try
{
int i = 0;
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT Sum(TicketAmount),Services FROM CO.Payables WHERE Services.Incident =" + IncidentID + " GROUP BY Services";
globalContext.LogMessage(queryString);
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 10000, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
Char delimiter = '|';
string[] substrings = data.Split(delimiter);
double amount = Convert.ToDouble(substrings[0]);
int service = Convert.ToInt32(substrings[1]);
if (amount != 0)
{
UpdatePaxPrice(service, amount);
i++;
}
}
}
return(i);
}
catch (Exception ex)
{
MessageBox.Show("UpdpatePayables" + ex.Message + " Det :" + ex.StackTrace);
return(0);
}
}
private bool CheckExtraordinary(int Airport)
{
bool extra = true;
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT OpensZULUTime,ClosesZULUTime FROM CO.Airport_WorkingHours WHERE Type = 1 AND Airports =" + Airport + " Order by CreatedTime ASC";
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
Char delimiter = '|';
String[] substrings = data.Split(delimiter);
DateTime dateOpensCompare = DateTime.Parse("2018/01/01 " + substrings[0].Trim());
DateTime dateClosesCompare = DateTime.Parse("2018/01/01 " + substrings[1].Trim());
double totalminutesOpen = (dateClosesCompare - dateOpens).TotalMinutes;
double totalminutesClose = (dateOpensCompare - dateCloses).TotalMinutes;
if (totalminutesOpen >= 0 || totalminutesClose <= 0)
{
extra = false;
}
}
}
return(extra);
}
private bool boolGetHours(int Airport)
{
bool hours = false;
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT OpensZULUTime,ClosesZULUTime FROM CO.Airport_WorkingHours WHERE Type = 25 AND Airports =" + Airport + " Order by CreatedTime ASC";
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
int i = 0;
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
Char delimiter = '|';
String[] substrings = data.Split(delimiter);
dateOpens = DateTime.Parse("2018/01/01 " + substrings[0].Trim());
dateCloses = DateTime.Parse("2018/01/01 " + substrings[1].Trim());
i++;
}
}
return(i > 0 ? true : false);
}
public bool AirportOpen24(string Itinerarie)
{
try
{
bool open = true;
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT ArrivalAirport.HoursOpen24 FROM Co.Itinerary WHERE ID =" + Itinerarie;
clientORN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
open = data == "1" ? true : false;
}
}
return(open);
}
catch (Exception ex)
{
MessageBox.Show("AirportOpen24: " + ex.Message + "Detail: " + ex.StackTrace);
return(false);
}
}
public static void Main(string[] args)
{
BasicHttpBinding basicHttpBinding = null;
EndpointAddress endpointAddress = null;
basicHttpBinding = new BasicHttpBinding(BasicHttpSecurityMode.Transport);
endpointAddress = new EndpointAddress(new Uri("url-soap-aqui"));
try
{
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
ServiceReference1.RightNowSyncPortClient syncClient = new RightNowSyncPortClient(basicHttpBinding,endpointAddress);
syncClient.ClientCredentials.UserName.UserName = "******";
syncClient.ClientCredentials.UserName.Password = "******";
Contact contact = new Contact();
ID cID = new ID();
cID.id = 0;
cID.idSpecified = true;
contact.ID = cID;
var api = new APIAccessRequestHeader();
GetProcessingOptions getProcessiongOptions = new GetProcessingOptions();
getProcessiongOptions.FetchAllNames = false;
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
clientInfoHeader.AppID = "Read Contact";
RNObject[] orgObjects = new RNObject[] { contact };
RNObject[] readReturn;
var resp = syncClient.GetAsync(clientInfoHeader, api,
orgObjects, getProcessiongOptions);
readReturn = resp.Result.RNObjectsResult;
Contact readContact = (Contact)readReturn[0];
Console.WriteLine("Lookup name: " + readContact.LookupName);
Console.WriteLine("Login: "******"Digite \"ENTER\" para sair...");
Console.ReadLine();
}
private void ObtenerInfoWorkOrder(string WorkId)
{
try
{
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT case_note,Contact.Name.First, Contact_City,Contact_Email,Contact_Mobile_Phone, Contact_Postal_Code,Contact_State.name StateName ,Contact_Street,Time_Slot.name TimeSlot, contact.CustomFields.c.org_name, contact.CustomFields.c.curp,contact.CustomFields.c.nss, contact.CustomFields.c.afore.LookupName AS afore, contact.CustomFields.c.regimen.LookupName AS regimen,X,Y,contact.CustomFields.c.amaterno,contact.CustomFields.c.fechacedido,contact_phone,Contact.Name.Last,WO_Date FROM TOA.Work_Order WHERE ID =" + Convert.ToInt32(WorkId) + "";
globalContext.LogMessage("BuscarWorkOrder: \n " + queryString);
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
Char delimiter = '|';
String[] substrings = data.Split(delimiter);
Observaciones = substrings[0];
Contacto = substrings[1];
city = substrings[2];
Correo = substrings[3];
PhoneCel = substrings[4];
postalCode = substrings[5];
stateProvince = substrings[6];
streetAddress = substrings[7];
TimeSlot = substrings[8];
Empresa = substrings[9];
CURP = substrings[10];
NSS = substrings[11];
Afore = substrings[12];
Regimen = substrings[13];
X = substrings[14];
Y = substrings[15];
ApellidoMaterno = substrings[16];
Meses = GetMeses(string.IsNullOrEmpty(substrings[17]) ? DateTime.Now : Convert.ToDateTime(substrings[17]));
PhoneHome = substrings[18];
ApellidoPaterno = substrings[19];
WODate = substrings[20];
}
}
}
catch (Exception ex)
{
MessageBox.Show("ObtenerInfoWorkOrder" + ex.Message + "Detalle: " + ex.StackTrace);
}
}
public int getArrivalAirport(string Itinerarie)
{
int arriv = 0;
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT ArrivalAirport FROM Co.Itinerary WHERE ID =" + Itinerarie;
clientORN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
arriv = String.IsNullOrEmpty(data) ? 0 : Convert.ToInt32(data);
}
}
return(arriv);
}
private bool Allday(int Airport)
{
bool all = true;
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT HoursOpen24 FROM CO.Airports WHERE ID=" + Airport;
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 10000, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
all = Convert.ToInt32(data) == 0 ? false : true;
}
}
return(all);
}
public int GetIncidentId(string Service)
{
int i = 0;
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT Incident.Id FROM CO.Services WHERE ID =" + Service;
clientORN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
i = string.IsNullOrEmpty(data) ? 0 : Convert.ToInt32(data);
}
}
return(i);
}
public string getItinerary(string service)
{
string itinerary = "";
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT Itinerary FROM CO.Services WHERE ID =" + service;
clientORN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
itinerary = data;
}
}
return(itinerary);
}
public string getICAODesi(int Incident)
{
string Icao = "";
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT CustomFields.co.Aircraft.AircraftType1.ICAODesignator FROM Incident WHERE ID =" + Incident;
clientORN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
Icao = data;
}
}
return(Icao);
}
public string getOpenArrivalAirport(int Arrival)
{
string opens = "";
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT OpensZuluTime FROM Co.Airport_WorkingHours WHERE Airports =" + Arrival + " AND Type = 1";
clientORN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
opens = data;
}
}
return(opens);
}
public string getIsoCode(int Country)
{
string iSO = "";
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT ISOCode FROM Country WHERE ID = " + Country;
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 10000, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
iSO = data;
}
}
return(iSO);
}
public string getEstado(int Country, int Province)
{
string Estado = "";
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT Country.provinces.name FROM Country WHERE Country.ID =" + Country + " AND Country.Provinces.ID=" + Province + "";
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 10000, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
Estado = data;
}
}
return(Estado);
}
public string[] GetAircraftType(int aircraft)
{
string[] substring = new string[3];
ClientInfoHeader clientInfoHeader = new ClientInfoHeader();
APIAccessRequestHeader aPIAccessRequest = new APIAccessRequestHeader();
clientInfoHeader.AppID = "Query Example";
String queryString = "SELECT AircraftType1.LookupName,Organization.LookupName FROM CO.Aircraft WHERE ID = " + aircraft;
globalContext.LogMessage("QueryGetAircraftType: " + queryString);
clientRN.QueryCSV(clientInfoHeader, aPIAccessRequest, queryString, 1, "|", false, false, out CSVTableSet queryCSV, out byte[] FileData);
foreach (CSVTable table in queryCSV.CSVTables)
{
String[] rowData = table.Rows;
foreach (String data in rowData)
{
Char delimiter = '|';
substring = data.Split(delimiter);
}
}
return(substring);
}
