public void RevisionPasajeroRoleDelete(RevisionOid localOid, RevisionPasajeroOid relatedOid)
{
ONSqlUpdate lOnSql = new ONSqlUpdate();
lOnSql.AddUpdate(CtesBD.TBL_REVISIONPASAJERO);
lOnSql.AddSet(CtesBD.FLD_REVISIONPASAJERO_FK_REVISION_1, ONInt.Null);
lOnSql.AddWhere(CtesBD.FLD_REVISIONPASAJERO_FK_REVISION_1, localOid.Id_RevisarAeronaveAttr);
lOnSql.AddWhere(CtesBD.FLD_REVISIONPASAJERO_ID_REVISIONPASAJERO, relatedOid.Id_RevisionPasajeroAttr);
Execute(lOnSql);
}
/// <summary>
/// Execute a query to retrieve an instance.
/// </summary>
/// <param name="context">Current context.</param>
/// <returns>A DataTable with the instance searched.</returns>
public static DataTable ExecuteQueryInstance(IUQueryContext context)
{
RevisionPasajeroOid lOid = null;
if (context.ExchangeInformation != null && context.ExchangeInformation.SelectedOids.Count > 0)
{
lOid = new RevisionPasajeroOid(context.ExchangeInformation.SelectedOids[0]);
}
return(ExecuteQueryInstance(context.Agent, lOid, context.DisplaySetAttributes));
}
/// <summary>
/// Extracts the OID from the XML message and converts it in structures of the application
/// </summary>
/// <param name="xmlReader">XML with the request message</param>
/// <param name="dtdVersion">Version of DTD that follows the XML message</param>
public static RevisionPasajeroOid XML2ON(XmlReader xmlReader, double dtdVersion)
{
try
{
if (xmlReader.IsStartElement(ONXml.XMLTAG_NULL))
{
xmlReader.Skip();
return(RevisionPasajeroXml.Null);
}
if (!xmlReader.IsStartElement(ONXml.XMLTAG_OID))
{
throw new ONXMLStructureException(null, ONXml.XMLTAG_OID);
}
}
catch (Exception e)
{
throw new ONXMLStructureException(e, ONXml.XMLTAG_OID);
}
string lClass = xmlReader.GetAttribute("Class");
if (string.Compare(lClass, "RevisionPasajero", true) != 0)
{
throw new ONXMLOIDWrongClassException(null, "Clas_1348178673664478_Alias", "RevisionPasajero", lClass);
}
RevisionPasajeroOid lOid = new RevisionPasajeroOid();
xmlReader.ReadStartElement(ONXml.XMLTAG_OID);
try
{
lOid.Id_RevisionPasajeroAttr = ONXmlAutonumeric.XML2ON(xmlReader, dtdVersion, ONXml.XMLTAG_OIDFIELD);
}
catch (Exception e)
{
throw new ONXMLOIDFieldException(e, "Clas_1348178673664478_Alias", "RevisionPasajero", "Clas_1348178673664478Atr_1_Alias", "id_RevisionPasajero");
}
try
{
xmlReader.ReadEndElement();
}
catch
{
throw new ONXMLStructureException(null, ONXml.XMLTAG_OID);
}
return(lOid);
}
public ONCollection RevisionPasajeroRole(RevisionPasajeroOid oid)
{
ONSqlSelect lOnSql = new ONSqlSelect();
//Create select
RevisionPasajeroData.AddPath(lOnSql, "Revision", new ONPath("Revision"), null, "");
RetrieveInstances(lOnSql, null, new ONPath("Revision"), OnContext);
//Fix related instance
RevisionPasajeroData.FixInstance(lOnSql, null, null, oid);
//Execute
return(ExecuteQuery(lOnSql));
}
internal void Delete_instanceServ(RevisionPasajeroOid p_thisRevisionPasajeroArg)
{
if (Instance != null)
{
ONFilterList onfilt = new ONFilterList();
onfilt.Add("QueryByOid", new QueryByOidFilter(Instance.Oid));
Instance.Find(onfilt);
}
// Execute service
RevisionPasajeroAction lAction = new RevisionPasajeroAction(OnContext);
lAction.Instance = Instance;
lAction.Delete_instanceServ(p_thisRevisionPasajeroArg);
}
/// <summary>
/// Converts an OID into XML in order to put it in XML message response
/// </summary>
/// <param name="xmlWriter">XML with the response message</param>
/// <param name="oid">OID that will be insert into XML message</param>
/// <param name="dtdVersion">Version of DTD that follows the XML message</param>
/// <param name="xmlElement">Element in the XML message in order to convert in the right form of the XML</param>
public static void ON2XML(XmlWriter xmlWriter, RevisionPasajeroOid oid, double dtdVersion, string xmlElement)
{
if (oid == null)
{
xmlWriter.WriteElementString(ONXml.XMLTAG_NULL, null);
}
else
{
xmlWriter.WriteStartElement(ONXml.XMLTAG_OID);
xmlWriter.WriteAttributeString(ONXml.XMLATT_CLASS, "RevisionPasajero");
ONXmlAutonumeric.ON2XML(xmlWriter, oid.Id_RevisionPasajeroAttr, dtdVersion, xmlElement);
xmlWriter.WriteEndElement(); // OID
}
}
/// <summary>
/// Method that solves the execution of 'delete_instance' service.
/// </summary>
/// <param name="agent">Application agent.</param>
/// <param name="p_thisRevisionPasajeroArg">Value of the inbound argument 'p_thisRevisionPasajero'.</param>
/// <returns>Outbound argument values.</returns>
public static Dictionary <string, object> ExecuteService(Oid agent, List <Oid> p_thisRevisionPasajeroArg)
{
RevisionPasajeroOid lp_thisRevisionPasajero = null;
if ((p_thisRevisionPasajeroArg != null) && (p_thisRevisionPasajeroArg.Count > 0) && (p_thisRevisionPasajeroArg[0] != null))
{
lp_thisRevisionPasajero = (p_thisRevisionPasajeroArg[0] as RevisionPasajeroOid);
}
Dictionary <string, object> lValues = GetInputFieldValues(lp_thisRevisionPasajero);
Dictionary <string, ModelType> lTypes = GetInboundArgumentTypes();
Dictionary <string, string> lDomains = GetInboundArgumentDomains();
Dictionary <string, object> lOutboundArguments = Logic.Adaptor.ExecuteService(agent, "RevisionPasajero", "delete_instance", lTypes, lValues, lDomains);
return(UtilFunctions.ProcessOutboundArgsList(lOutboundArguments));
}
public void Delete_instanceServ(RevisionPasajeroOid p_thisRevisionPasajeroArg)
{
// Create new context
using (ONServiceContext lOnContext = new ONServiceContext(OnContext))
{
// Change to Transactional OnContext
Instance.OnContext = lOnContext;
// Call Executive
RevisionPasajeroExecutive lExecutive = new RevisionPasajeroExecutive();
lExecutive.OnContext = lOnContext;
lExecutive.Instance = Instance;
lExecutive.Delete_instanceServ(p_thisRevisionPasajeroArg);
// Change to Non-Transactional OnContext
Instance.OnContext = OnContext;
}
}
/// <summary>
/// Execute a query to retrieve a set of instances, without any condition.
/// </summary>
/// <param name="context">Current context.</param>
/// <returns>A DataTable with the instances searched.</returns>
public static DataTable ExecuteQueryPopulation(IUPopulationContext context)
{
// Last Oid
RevisionPasajeroOid lLastOid = null;
if (context.LastOids.Count > 0)
{
lLastOid = new RevisionPasajeroOid(context.LastOids.Peek());
}
// Last Block
bool lLastBlock = true;
NavigationalFiltering navigationalFiltering = NavigationalFiltering.GetNavigationalFiltering(context);
DataTable lDataTable = ExecuteQueryRelated(context.Agent, new Dictionary <string, Oid>(), context.DisplaySetAttributes, context.OrderCriteriaNameSelected, navigationalFiltering, lLastOid, context.BlockSize, ref lLastBlock);
context.LastBlock = lLastBlock;
return(lDataTable);
}
public override void Copy(ONInstance instance)
{
RevisionPasajeroInstance linstance = instance as RevisionPasajeroInstance;
Oid = new RevisionPasajeroOid(linstance.Oid);
RevisionRoleTemp = linstance.RevisionRoleTemp;
if (linstance.RevisionRoleOidTemp != null)
{
RevisionRoleOidTemp = new RevisionOid(linstance.RevisionRoleOidTemp);
}
PasajeroAeronaveRoleTemp = linstance.PasajeroAeronaveRoleTemp;
if (linstance.PasajeroAeronaveRoleOidTemp != null)
{
PasajeroAeronaveRoleOidTemp = new PasajeroAeronaveOid(linstance.PasajeroAeronaveRoleOidTemp);
}
StateObj = new ONString(linstance.StateObj);
base.Copy(instance);
}
/// <summary>
/// Execute a query to retrieve an instance.
/// </summary>
/// <param name="agent">Application agent.</param>
/// <param name="oid">Specific 'RevisionPasajeroOid' Oid of the instance to be searched.</param>
/// <param name="displaySet">Display set that will be retrieved.</param>
/// <returns>A DataTable with the instance searched.</returns>
public static DataTable ExecuteQueryInstance(Oid agent, RevisionPasajeroOid oid, string displaySet)
{
return(Logic.Adaptor.ExecuteQueryInstance(agent, "RevisionPasajero", string.Empty, oid, displaySet));
}
/// <summary>
/// Execute a query related with a PasajeroAeronave
/// </summary>
/// <param name="agent">Application agent</param>
/// <param name="relatedOid">PasajeroAeronave oid related</param>
/// <param name="displaySet">List of attributes to return</param>
/// <param name="orderCriteria">Order criteria name</param>
/// <param name="lastOid">Oid from whitch to search (not included)</param>
/// <param name="blockSize">Number of instances to return (0 for all population)</param>
/// <param name="lastBlock">Returns if it is last block</param>
/// <returns>Query data</returns>
public static DataTable ExecuteQueryRelatedPasajeroAeronave(Oid agent, PasajeroAeronaveOid relatedOid, string displaySet, string orderCriteria, RevisionPasajeroOid lastOid, int blockSize, ref bool lastBlock)
{
Dictionary <string, Oid> lLinkItems = new Dictionary <string, Oid>(StringComparer.CurrentCultureIgnoreCase);
lLinkItems.Add("PasajeroAeronave", relatedOid);
return(ExecuteQueryRelated(agent, lLinkItems, displaySet, orderCriteria, lastOid, blockSize, ref lastBlock));
}
/// <summary>
/// Execute a query related with other instance.
/// </summary>
/// <param name="agent">Application agent.</param>
/// <param name="linkItems">List of related instance oids (path - role).</param>
/// <param name="displaySet">List of attributes to return.</param>
/// <param name="orderCriteria">Order criteria name.</param>
/// <param name="lastOid">Oid from which to search (not included).</param>
/// <param name="blockSize">Number of instances to return (0 for all population).</param>
/// <param name="lastBlock">Return it is last block.</param>
/// <returns>A DataTable with the instances searched.</returns>
public static DataTable ExecuteQueryRelated(Oid agent, Dictionary <string, Oid> linkItems, string displaySet, string orderCriteria, RevisionPasajeroOid lastOid, int blockSize, ref bool lastBlock)
{
DataTable lDataTable = Logic.Adaptor.ExecuteQueryRelated(agent, "RevisionPasajero", linkItems, displaySet, orderCriteria, lastOid, blockSize);
// Last block.
if (lDataTable.ExtendedProperties.Contains("LastBlock"))
{
lastBlock = (bool)lDataTable.ExtendedProperties["LastBlock"];
}
else
{
lastBlock = false;
}
return(lDataTable);
}
/// <summary>
/// Execute a query related with other instance.
/// </summary>
/// <param name="context">Current context.</param>
/// <returns>A DataTable with the instances searched.</returns>
public static DataTable ExecuteQueryRelated(IUQueryContext context)
{
try
{
ExchangeInfo lExchangeInfo = context.ExchangeInformation;
if (lExchangeInfo.ExchangeType != ExchangeType.Navigation || lExchangeInfo.SelectedOids.Count == 0)
{
return(null);
}
IUPopulationContext lIUContext = context as IUPopulationContext;
int blockSize = 1;
if (lIUContext != null)
{
blockSize = lIUContext.BlockSize;
}
ExchangeInfoNavigation lNavInfo = lExchangeInfo as ExchangeInfoNavigation;
// Specific case. No role name indicates Query by Instance.
if (lNavInfo.RolePath == "")
{
if (lIUContext != null)
{
lIUContext.LastBlock = true;
}
RevisionPasajeroOid lOidInstance = new RevisionPasajeroOid(lNavInfo.SelectedOids[0]);
return(ExecuteQueryInstance(context.Agent, lOidInstance, context.DisplaySetAttributes));
}
// Get link items.
Oid lOid = lNavInfo.SelectedOids[0];
Dictionary <string, Oid> lLinkItems = new Dictionary <string, Oid>(StringComparer.CurrentCultureIgnoreCase);
lLinkItems.Add(lNavInfo.RolePath, lOid);
bool lLastBlock = true;
RevisionPasajeroOid lLastOid = null;
string lOrderCriteria = string.Empty;
// Get population members.
if (lIUContext != null)
{
if (lIUContext.LastOid != null)
{
lLastOid = new RevisionPasajeroOid(lIUContext.LastOid);
}
lOrderCriteria = lIUContext.OrderCriteriaNameSelected;
}
NavigationalFiltering navigationalFiltering = NavigationalFiltering.GetNavigationalFiltering(context);
DataTable lDataTable = ExecuteQueryRelated(context.Agent, lLinkItems, context.DisplaySetAttributes, lOrderCriteria, navigationalFiltering, lLastOid, blockSize, ref lLastBlock);
if (lIUContext != null)
{
lIUContext.LastBlock = lLastBlock;
}
return(lDataTable);
}
catch (Exception e)
{
ScenarioManager.LaunchErrorScenario(e);
return(null);
}
}
/// <summary>
/// Execute a query to retrieve a set of instances, without any condition.
/// </summary>
/// <param name="agent">Application agent.</param>
/// <param name="displaySet">List of attributes to return.</param>
/// <param name="orderCriteria">Order criteria name.</param>
/// <param name="lastOid">Oid from which to search (not included).</param>
/// <param name="blockSize">Number of instances to return (0 for all population).</param>
/// <returns>A DataTable with the instances searched.</returns>
public static DataTable ExecuteQueryPopulation(Oid agent, string displaySet, string orderCriteria, RevisionPasajeroOid lastOid, int blockSize, ref bool lastBlock)
{
return(ExecuteQueryRelated(agent, new Dictionary <string, Oid>(), displaySet, orderCriteria, lastOid, blockSize, ref lastBlock));
}
public void Edit_instanceServ(ref string ticket, ref ONOid agentOid, XmlReader xmlReader, XmlWriter xmlWriter, double dtdVersion, string clientName)
{
// Process the service arguments
ONServiceInfo lSInfo = new ONServiceInfo("Clas_1348178673664478Ser_3_Alias", RevisionPasajeroClassText.Edit_instanceServiceAlias, "Clas_1348178673664478_Alias", RevisionPasajeroClassText.ClassAlias);
lSInfo.AddOIDArgument("p_thisRevisionPasajero", false, "RevisionPasajero", "Clas_1348178673664478Ser_3Arg_1_Alias", RevisionPasajeroClassText.Edit_instance_P_thisRevisionPasajeroArgumentAlias);
try
{
lSInfo.XML2ON(xmlReader, dtdVersion, true);
}
catch (Exception e)
{
throw new ONServiceArgumentsException(e, "Clas_1348178673664478_Alias", RevisionPasajeroClassText.ClassAlias, "Clas_1348178673664478Ser_3_Alias", RevisionPasajeroClassText.Edit_instanceServiceAlias);
}
RevisionPasajeroOid lP_thisRevisionPasajeroArg = (RevisionPasajeroOid)((ONArgumentInfo)lSInfo.mArgumentList["p_thisRevisionPasajero"]).Value;
// Create Context
ONServiceContext lOnContext = new ONServiceContext();
lOnContext.OidAgent = agentOid;
// Execute Service
RevisionPasajeroInstance lInstance = null;
try
{
ONFilterList lFilterList = new ONFilterList();
RevisionPasajeroInstance lThisInstance = new RevisionPasajeroInstance(lOnContext);
if (lP_thisRevisionPasajeroArg != null)
{
lFilterList = new ONFilterList();
lFilterList.Add("HorizontalVisibility", new RevisionPasajeroHorizontalVisibility());
lThisInstance = lP_thisRevisionPasajeroArg.GetInstance(lOnContext, lFilterList);
if (lThisInstance == null)
{
throw new ONInstanceNotExistException(null, "Clas_1348178673664478_Alias", RevisionPasajeroClassText.ClassAlias);
}
}
using (RevisionPasajeroServer lServer = new RevisionPasajeroServer(lOnContext, lThisInstance))
{
lServer.Edit_instanceServ(lP_thisRevisionPasajeroArg);
lInstance = lServer.Instance;
}
ticket = lOnContext.GetTicket(dtdVersion, clientName);
}
catch (SecurityException)
{
throw new ONAccessAgentValidationException(null);
}
catch
{
throw;
}
// Write Oid
if (dtdVersion >= 3.1)
{
if (lInstance != null)
{
ON2XML(xmlWriter, lInstance.Oid, dtdVersion, ONXml.XMLTAG_OIDFIELD);
}
}
// Write Outbound Arguments
xmlWriter.WriteStartElement("Arguments");
// Write Outbound Arguments
xmlWriter.WriteEndElement(); // Arguments
}