public void Edit_instanceServ(
[ONInboundArgument("Clas_1348178542592347Ser_3Arg_1_Alias", RevisionClassText.Edit_instance_P_thisRevisarAeronaveArgumentAlias, "", "Clas_1348178542592347Ser_3_Alias", RevisionClassText.Edit_instanceServiceAlias, "Clas_1348178542592347_Alias", RevisionClassText.ClassAlias, AllowsNull = false)] RevisionOid p_thisRevisarAeronaveArg)
{
try
{
}
catch (Exception e)
{
if (e is ONException)
{
throw e;
}
else
{
string ltraceItem = "Definition class: Revision, Service: edit_instance, Component: RevisionAction, Method: Edit_instanceServ";
if (e is ONSystemException)
{
ONSystemException lException = e as ONSystemException;
lException.addTraceInformation(ltraceItem);
throw lException;
}
throw new ONSystemException(e, ltraceItem);
}
}
}
/// <summary>
/// Execute a query related with a Revision
/// </summary>
/// <param name="agent">Application agent</param>
/// <param name="relatedOid">Revision 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 ExecuteQueryRelatedRevision(Oid agent, RevisionOid relatedOid, string displaySet, string orderCriteria, RevisionPasajeroOid lastOid, int blockSize, ref bool lastBlock)
{
Dictionary <string, Oid> lLinkItems = new Dictionary <string, Oid>(StringComparer.CurrentCultureIgnoreCase);
lLinkItems.Add("Revision", relatedOid);
return(ExecuteQueryRelated(agent, lLinkItems, displaySet, orderCriteria, lastOid, blockSize, ref lastBlock));
}
public void RevisionPasajeroRoleInsert(RevisionOid localOid, RevisionPasajeroOid relatedOid)
{
ONSqlUpdate lOnSql = new ONSqlUpdate();
lOnSql.AddUpdate(CtesBD.TBL_REVISIONPASAJERO);
lOnSql.AddSet(CtesBD.FLD_REVISIONPASAJERO_FK_REVISION_1, localOid.Id_RevisarAeronaveAttr);
lOnSql.AddWhere(CtesBD.FLD_REVISIONPASAJERO_ID_REVISIONPASAJERO, relatedOid.Id_RevisionPasajeroAttr);
Execute(lOnSql);
}
/// <summary>Default Constructor</summary>
public RevisionInstance(ONContext onContext) : base(onContext, "Revision", "Clas_1348178542592347_Alias")
{
Oid = new RevisionOid();
NombreRevisorAttr = ONString.Null;
FechaRevisionAttr = ONDate.Null;
Id_AeronaveAttr = ONString.Null;
RevisionPasajeroRoleTemp = null;
StateObjAttrTemp = null;
}
/// <summary>
/// Gets a list with the arguments values.
/// </summary>
/// <param name="p_thisRevisarAeronaveArg">Value of the inbound argument 'p_thisRevisarAeronave'.</param>
/// <returns>List of inbound arguments values.</returns>
private static Dictionary <string, object> GetInputFieldValues(RevisionOid p_thisRevisarAeronaveArg)
{
// Fill values dictionary.
Dictionary <string, object> lValues = new Dictionary <string, object>();
lValues.Add("p_thisRevisarAeronave", p_thisRevisarAeronaveArg);
return(lValues);
}
/// <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)
{
RevisionOid lOid = null;
if (context.ExchangeInformation != null && context.ExchangeInformation.SelectedOids.Count > 0)
{
lOid = new RevisionOid(context.ExchangeInformation.SelectedOids[0]);
}
return(ExecuteQueryInstance(context.Agent, lOid, context.DisplaySetAttributes));
}
public void RevisionPasajeroRoleDelete(RevisionOid oid)
{
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, oid.Id_RevisarAeronaveAttr);
Execute(lOnSql);
}
/// <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 RevisionOid XML2ON(XmlReader xmlReader, double dtdVersion)
{
try
{
if (xmlReader.IsStartElement(ONXml.XMLTAG_NULL))
{
xmlReader.Skip();
return(RevisionXml.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, "Revision", true) != 0)
{
throw new ONXMLOIDWrongClassException(null, "Clas_1348178542592347_Alias", "Revision", lClass);
}
RevisionOid lOid = new RevisionOid();
xmlReader.ReadStartElement(ONXml.XMLTAG_OID);
try
{
lOid.Id_RevisarAeronaveAttr = ONXmlAutonumeric.XML2ON(xmlReader, dtdVersion, ONXml.XMLTAG_OIDFIELD);
}
catch (Exception e)
{
throw new ONXMLOIDFieldException(e, "Clas_1348178542592347_Alias", "Revision", "Clas_1348178542592347Atr_1_Alias", "id_RevisarAeronave");
}
try
{
xmlReader.ReadEndElement();
}
catch
{
throw new ONXMLStructureException(null, ONXml.XMLTAG_OID);
}
return(lOid);
}
internal void Delete_instanceServ(RevisionOid p_thisRevisarAeronaveArg)
{
if (Instance != null)
{
ONFilterList onfilt = new ONFilterList();
onfilt.Add("QueryByOid", new QueryByOidFilter(Instance.Oid));
Instance.Find(onfilt);
}
// Execute service
RevisionAction lAction = new RevisionAction(OnContext);
lAction.Instance = Instance;
lAction.Delete_instanceServ(p_thisRevisarAeronaveArg);
}
public override void Copy(ONInstance instance)
{
RevisionInstance linstance = instance as RevisionInstance;
Oid = new RevisionOid(linstance.Oid);
NombreRevisorAttr = new ONString(linstance.NombreRevisorAttr);
FechaRevisionAttr = new ONDate(linstance.FechaRevisionAttr);
Id_AeronaveAttr = new ONString(linstance.Id_AeronaveAttr);
RevisionPasajeroRoleTemp = linstance.RevisionPasajeroRoleTemp;
StateObj = new ONString(linstance.StateObj);
base.Copy(instance);
}
/// <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, RevisionOid 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, "Revision");
ONXmlAutonumeric.ON2XML(xmlWriter, oid.Id_RevisarAeronaveAttr, dtdVersion, xmlElement);
xmlWriter.WriteEndElement(); // OID
}
}
/// <summary>
/// Method that solves the execution of 'edit_instance' service.
/// </summary>
/// <param name="agent">Application agent.</param>
/// <param name="p_thisRevisarAeronaveArg">Value of the inbound argument 'p_thisRevisarAeronave'.</param>
/// <returns>Outbound argument values.</returns>
public static Dictionary <string, object> ExecuteService(Oid agent, List <Oid> p_thisRevisarAeronaveArg)
{
RevisionOid lp_thisRevisarAeronave = null;
if ((p_thisRevisarAeronaveArg != null) && (p_thisRevisarAeronaveArg.Count > 0) && (p_thisRevisarAeronaveArg[0] != null))
{
lp_thisRevisarAeronave = (p_thisRevisarAeronaveArg[0] as RevisionOid);
}
Dictionary <string, object> lValues = GetInputFieldValues(lp_thisRevisarAeronave);
Dictionary <string, ModelType> lTypes = GetInboundArgumentTypes();
Dictionary <string, string> lDomains = GetInboundArgumentDomains();
Dictionary <string, object> lOutboundArguments = Logic.Adaptor.ExecuteService(agent, "Revision", "edit_instance", lTypes, lValues, lDomains);
return(UtilFunctions.ProcessOutboundArgsList(lOutboundArguments));
}
public void Delete_instanceServ(RevisionOid p_thisRevisarAeronaveArg)
{
// Create new context
using (ONServiceContext lOnContext = new ONServiceContext(OnContext))
{
// Change to Transactional OnContext
Instance.OnContext = lOnContext;
// Call Executive
RevisionExecutive lExecutive = new RevisionExecutive();
lExecutive.OnContext = lOnContext;
lExecutive.Instance = Instance;
lExecutive.Delete_instanceServ(p_thisRevisarAeronaveArg);
// Change to Non-Transactional OnContext
Instance.OnContext = OnContext;
}
}
public void Delete_instanceServ(
[ONInboundArgument("Clas_1348178542592347Ser_2Arg_1_Alias", RevisionClassText.Delete_instance_P_thisRevisarAeronaveArgumentAlias, "", "Clas_1348178542592347Ser_2_Alias", RevisionClassText.Delete_instanceServiceAlias, "Clas_1348178542592347_Alias", RevisionClassText.ClassAlias, AllowsNull = false)] RevisionOid p_thisRevisarAeronaveArg)
{
try
{
RevisionData lData = new RevisionData(OnContext);
#region Cardinality check for role 'RevisionPasajero'
// Minimum cardinality check (inverse)
if (Instance.RevisionPasajeroRole.Count > 0)
{
throw new ONMinCardinalityException(null, RevisionPasajeroClassText.ClassAlias, "Clas_1348178673664478_Alias", RevisionPasajeroClassText.RevisionRoleAlias, "Agr_1348602167296276Rol_2_Alias", 1);
}
#endregion Cardinality check for role 'RevisionPasajero'
// Delete relationships
{
RevisionData lDataRel = new RevisionData(OnContext);
lDataRel.RevisionPasajeroRoleDelete(Instance.Oid);
}
// Delete instance
lData.UpdateDeleted(Instance);
}
catch (Exception e)
{
if (e is ONException)
{
throw e;
}
else
{
string ltraceItem = "Definition class: Revision, Service: delete_instance, Component: RevisionAction, Method: Delete_instanceServ";
if (e is ONSystemException)
{
ONSystemException lException = e as ONSystemException;
lException.addTraceInformation(ltraceItem);
throw lException;
}
throw new ONSystemException(e, ltraceItem);
}
}
}
/// <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
RevisionOid lLastOid = null;
if (context.LastOids.Count > 0)
{
lLastOid = new RevisionOid(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>
/// Method that solves the execution of 'create_instance' service.
/// </summary>
/// <param name="agent">Application agent.</param>
/// <param name="p_agrPasajeroAeronaveArg">Value of the inbound argument 'p_agrPasajeroAeronave'.</param>
/// <param name="p_agrRevisionArg">Value of the inbound argument 'p_agrRevision'.</param>
/// <param name="p_atrid_RevisionPasajeroArg">Value of the inbound argument 'p_atrid_RevisionPasajero'.</param>
/// <returns>Outbound argument values.</returns>
public static Dictionary <string, object> ExecuteService(Oid agent, List <Oid> p_agrPasajeroAeronaveArg, List <Oid> p_agrRevisionArg, int?p_atrid_RevisionPasajeroArg)
{
PasajeroAeronaveOid lp_agrPasajeroAeronave = null;
if ((p_agrPasajeroAeronaveArg != null) && (p_agrPasajeroAeronaveArg.Count > 0) && (p_agrPasajeroAeronaveArg[0] != null))
{
lp_agrPasajeroAeronave = (p_agrPasajeroAeronaveArg[0] as PasajeroAeronaveOid);
}
RevisionOid lp_agrRevision = null;
if ((p_agrRevisionArg != null) && (p_agrRevisionArg.Count > 0) && (p_agrRevisionArg[0] != null))
{
lp_agrRevision = (p_agrRevisionArg[0] as RevisionOid);
}
Dictionary <string, object> lValues = GetInputFieldValues(lp_agrPasajeroAeronave, lp_agrRevision, p_atrid_RevisionPasajeroArg);
Dictionary <string, ModelType> lTypes = GetInboundArgumentTypes();
Dictionary <string, string> lDomains = GetInboundArgumentDomains();
Dictionary <string, object> lOutboundArguments = Logic.Adaptor.ExecuteService(agent, "RevisionPasajero", "create_instance", lTypes, lValues, lDomains);
return(UtilFunctions.ProcessOutboundArgsList(lOutboundArguments));
}
public void CheckSTDiagram_create_instance(PasajeroAeronaveOid p_agrPasajeroAeronaveArg, RevisionOid p_agrRevisionArg, ONInt p_atrid_RevisionPasajeroArg)
{
Instance.StateObj = new ONString("Revisi0");
}
public RevisionPasajeroInstance Create_instanceServ(
[ONInboundArgument("Clas_1348178673664478Ser_1Arg_3_Alias", RevisionPasajeroClassText.Create_instance_P_agrPasajeroAeronaveArgumentAlias, "", "Clas_1348178673664478Ser_1_Alias", RevisionPasajeroClassText.Create_instanceServiceAlias, "Clas_1348178673664478_Alias", RevisionPasajeroClassText.ClassAlias, AllowsNull = false)] PasajeroAeronaveOid p_agrPasajeroAeronaveArg,
[ONInboundArgument("Clas_1348178673664478Ser_1Arg_4_Alias", RevisionPasajeroClassText.Create_instance_P_agrRevisionArgumentAlias, "", "Clas_1348178673664478Ser_1_Alias", RevisionPasajeroClassText.Create_instanceServiceAlias, "Clas_1348178673664478_Alias", RevisionPasajeroClassText.ClassAlias, AllowsNull = false)] RevisionOid p_agrRevisionArg,
[ONInboundArgument("Clas_1348178673664478Ser_1Arg_1_Alias", RevisionPasajeroClassText.Create_instance_P_atrid_RevisionPasajeroArgumentAlias, "autonumeric", "Clas_1348178673664478Ser_1_Alias", RevisionPasajeroClassText.Create_instanceServiceAlias, "Clas_1348178673664478_Alias", RevisionPasajeroClassText.ClassAlias, AllowsNull = false)] ONInt p_atrid_RevisionPasajeroArg)
{
try
{
RevisionPasajeroData lData = new RevisionPasajeroData(OnContext);
#region Construct OID
Instance.Oid = new RevisionPasajeroOid();
Instance.Oid.Id_RevisionPasajeroAttr = new ONInt(p_atrid_RevisionPasajeroArg);
#endregion Construct OID
#region Argument initialization 'p_agrPasajeroAeronave' (PasajeroAeronave)
if (p_agrPasajeroAeronaveArg != null)
{
PasajeroAeronaveData lPasajeroAeronaveData = new PasajeroAeronaveData(OnContext);
if (!lPasajeroAeronaveData.Exist(p_agrPasajeroAeronaveArg, null))
{
throw new ONInstanceNotExistException(null, "Clas_1348178542592177_Alias", PasajeroAeronaveClassText.ClassAlias);
}
Instance.PasajeroAeronaveRole = null;
Instance.PasajeroAeronaveRoleOidTemp = p_agrPasajeroAeronaveArg;
// Maximum cardinality check (inverse role)
if (p_agrPasajeroAeronaveArg.GetInstance(OnContext).RevisionPasajeroRole.Count >= 1)
{
throw new ONMaxCardinalityException(null, PasajeroAeronaveClassText.ClassAlias, "Clas_1348178542592177_Alias", PasajeroAeronaveClassText.RevisionPasajeroRoleAlias, "Agr_1348602167296649Rol_1_Alias", 1);
}
}
#endregion Argument Initialization 'p_agrPasajeroAeronave' (PasajeroAeronave)
#region Argument initialization 'p_agrRevision' (Revision)
if (p_agrRevisionArg != null)
{
RevisionData lRevisionData = new RevisionData(OnContext);
if (!lRevisionData.Exist(p_agrRevisionArg, null))
{
throw new ONInstanceNotExistException(null, "Clas_1348178542592347_Alias", RevisionClassText.ClassAlias);
}
Instance.RevisionRole = null;
Instance.RevisionRoleOidTemp = p_agrRevisionArg;
// Maximum cardinality check (inverse role)
if (p_agrRevisionArg.GetInstance(OnContext).RevisionPasajeroRole.Count >= 1)
{
throw new ONMaxCardinalityException(null, RevisionClassText.ClassAlias, "Clas_1348178542592347_Alias", RevisionClassText.RevisionPasajeroRoleAlias, "Agr_1348602167296276Rol_1_Alias", 1);
}
}
#endregion Argument Initialization 'p_agrRevision' (Revision)
#region Autonumeric attribute 'id_RevisionPasajero'
if (Instance.Id_RevisionPasajeroAttr < new ONInt(0))
{
RevisionPasajeroData lAutonumericData = new RevisionPasajeroData(OnContext);
lAutonumericData.ClassName = "RevisionPasajero";
//Get Autonumeric
Instance.Oid.Id_RevisionPasajeroAttr = lAutonumericData.GetAutonumericid_RevisionPasajero();
}
#endregion Autonumeric attribute 'id_RevisionPasajero'
//Search if instance exists
if (lData.Exist(Instance.Oid, null))
{
throw new ONInstanceExistException(null, "Clas_1348178673664478_Alias", RevisionPasajeroClassText.ClassAlias);
}
//Update the new instance
lData.UpdateAdded(Instance);
#region Cardinality check for role 'PasajeroAeronave'
// Minimum cardinality check
if (Instance.PasajeroAeronaveRole == null)
{
throw new ONMinCardinalityException(null, RevisionPasajeroClassText.ClassAlias, "Clas_1348178673664478_Alias", RevisionPasajeroClassText.PasajeroAeronaveRoleAlias, "Agr_1348602167296649Rol_2_Alias", 1);
}
#endregion Cardinality check for role 'PasajeroAeronave'
#region Cardinality check for role 'PasajeroAeronave'
// Maximum cardinality check (inverse)
foreach (PasajeroAeronaveInstance lRelatedInstance in Instance.PasajeroAeronaveRole)
{
if (lRelatedInstance.RevisionPasajeroRole.Count > 1)
{
throw new ONMaxCardinalityException(null, PasajeroAeronaveClassText.ClassAlias, "Clas_1348178542592177_Alias", PasajeroAeronaveClassText.RevisionPasajeroRoleAlias, "Agr_1348602167296649Rol_1_Alias", 1);
}
}
#endregion Cardinality check for role 'PasajeroAeronave'
#region Cardinality check for role 'Revision'
// Minimum cardinality check
if (Instance.RevisionRole == null)
{
throw new ONMinCardinalityException(null, RevisionPasajeroClassText.ClassAlias, "Clas_1348178673664478_Alias", RevisionPasajeroClassText.RevisionRoleAlias, "Agr_1348602167296276Rol_2_Alias", 1);
}
#endregion Cardinality check for role 'Revision'
#region Cardinality check for role 'Revision'
// Maximum cardinality check (inverse)
foreach (RevisionInstance lRelatedInstance in Instance.RevisionRole)
{
if (lRelatedInstance.RevisionPasajeroRole.Count > 1)
{
throw new ONMaxCardinalityException(null, RevisionClassText.ClassAlias, "Clas_1348178542592347_Alias", RevisionClassText.RevisionPasajeroRoleAlias, "Agr_1348602167296276Rol_1_Alias", 1);
}
}
#endregion Cardinality check for role 'Revision'
}
catch (Exception e)
{
if (e is ONException)
{
throw e;
}
else
{
string ltraceItem = "Definition class: RevisionPasajero, Service: create_instance, Component: RevisionPasajeroAction, Method: Create_instanceServ";
if (e is ONSystemException)
{
ONSystemException lException = e as ONSystemException;
lException.addTraceInformation(ltraceItem);
throw lException;
}
throw new ONSystemException(e, ltraceItem);
}
}
return(Instance);
}
/// <summary>
/// Execute a query to retrieve an instance.
/// </summary>
/// <param name="agent">Application agent.</param>
/// <param name="oid">Specific 'RevisionOid' 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, RevisionOid oid, string displaySet)
{
return(Logic.Adaptor.ExecuteQueryInstance(agent, "Revision", string.Empty, oid, displaySet));
}
internal RevisionPasajeroInstance Create_instanceServ(PasajeroAeronaveOid p_agrPasajeroAeronaveArg, RevisionOid p_agrRevisionArg, ONInt p_atrid_RevisionPasajeroArg)
{
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 = new RevisionPasajeroInstance(OnContext);
Instance = lAction.Create_instanceServ(p_agrPasajeroAeronaveArg, p_agrRevisionArg, p_atrid_RevisionPasajeroArg);
OnContext.OperationStack.Pop();
OnContext.OperationStack.Push(Instance);
return(Instance);
}
/// <summary>This method adds to the SQL statement the part that fixes the instance</summary>
/// <param name="onSql">This parameter has the current SQL statement</param>
/// <param name="onPath">Path to add to SQL statement</param>
/// <param name="processedOnPath">Path pocessed until the call of this method</param>
/// <param name="oid">OID to fix the instance in the SQL statement</param>
/// <param name="isLinkedTo">The alias belongs to a role in a linked To element</param>
public static void FixInstance(ONSqlSelect onSql, ONPath onPath, ONPath processedOnPath, RevisionOid oid, bool isLinkedTo)
{
if ((onPath != null) && (string.Compare(onPath.Path, "agent", true) == 0))
{
if (onSql.GetParameter("agent") == null)
{
string lAlias = AddPath(onSql, JoinType.InnerJoin, "Revision", onPath, processedOnPath, "Revision", false, isLinkedTo);
onSql.AddWhere(lAlias + "." + CtesBD.FLD_REVISION_ID_REVISARAERONAVE + " = ?");
onSql.AddWhereParameter("agent", oid.Id_RevisarAeronaveAttr);
}
}
else
{
string lAlias = AddPath(onSql, JoinType.InnerJoin, "Revision", onPath, processedOnPath, "", false, isLinkedTo);
onSql.AddWhere(lAlias + "." + CtesBD.FLD_REVISION_ID_REVISARAERONAVE + " = ?");
onSql.AddWhereParameter("", oid.Id_RevisarAeronaveAttr);
}
}
/// <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, RevisionOid lastOid, int blockSize, ref bool lastBlock)
{
return(ExecuteQueryRelated(agent, new Dictionary <string, Oid>(), displaySet, orderCriteria, lastOid, blockSize, ref lastBlock));
}
/// <summary>This method adds to the SQL statement the part that fixes the instance</summary>
/// <param name="onSql">This parameter has the current SQL statement</param>
/// <param name="onPath">Path to add to SQL statement</param>
/// <param name="processedOnPath">Path pocessed until the call of this method</param>
/// <param name="oid">OID to fix the instance in the SQL statement</param>
public static void FixInstance(ONSqlSelect onSql, ONPath onPath, ONPath processedOnPath, RevisionOid oid)
{
FixInstance(onSql, onPath, processedOnPath, oid, false);
}
/// <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;
}
RevisionOid lOidInstance = new RevisionOid(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;
RevisionOid lLastOid = null;
string lOrderCriteria = string.Empty;
// Get population members.
if (lIUContext != null)
{
if (lIUContext.LastOid != null)
{
lLastOid = new RevisionOid(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);
}
}
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_1348178542592347Ser_3_Alias", RevisionClassText.Edit_instanceServiceAlias, "Clas_1348178542592347_Alias", RevisionClassText.ClassAlias);
lSInfo.AddOIDArgument("p_thisRevisarAeronave", false, "Revision", "Clas_1348178542592347Ser_3Arg_1_Alias", RevisionClassText.Edit_instance_P_thisRevisarAeronaveArgumentAlias);
try
{
lSInfo.XML2ON(xmlReader, dtdVersion, true);
}
catch (Exception e)
{
throw new ONServiceArgumentsException(e, "Clas_1348178542592347_Alias", RevisionClassText.ClassAlias, "Clas_1348178542592347Ser_3_Alias", RevisionClassText.Edit_instanceServiceAlias);
}
RevisionOid lP_thisRevisarAeronaveArg = (RevisionOid)((ONArgumentInfo)lSInfo.mArgumentList["p_thisRevisarAeronave"]).Value;
// Create Context
ONServiceContext lOnContext = new ONServiceContext();
lOnContext.OidAgent = agentOid;
// Execute Service
RevisionInstance lInstance = null;
try
{
ONFilterList lFilterList = new ONFilterList();
RevisionInstance lThisInstance = new RevisionInstance(lOnContext);
if (lP_thisRevisarAeronaveArg != null)
{
lFilterList = new ONFilterList();
lFilterList.Add("HorizontalVisibility", new RevisionHorizontalVisibility());
lThisInstance = lP_thisRevisarAeronaveArg.GetInstance(lOnContext, lFilterList);
if (lThisInstance == null)
{
throw new ONInstanceNotExistException(null, "Clas_1348178542592347_Alias", RevisionClassText.ClassAlias);
}
}
using (RevisionServer lServer = new RevisionServer(lOnContext, lThisInstance))
{
lServer.Edit_instanceServ(lP_thisRevisarAeronaveArg);
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
}
public RevisionPasajeroInstance Create_instanceServ(PasajeroAeronaveOid p_agrPasajeroAeronaveArg, RevisionOid p_agrRevisionArg, ONInt p_atrid_RevisionPasajeroArg)
{
// Create new context
using (ONServiceContext lOnContext = new ONServiceContext(OnContext))
{
// Call Executive
RevisionPasajeroExecutive lExecutive = new RevisionPasajeroExecutive();
lExecutive.OnContext = lOnContext;
lExecutive.Instance = Instance;
Instance = lExecutive.Create_instanceServ(p_agrPasajeroAeronaveArg, p_agrRevisionArg, p_atrid_RevisionPasajeroArg);
}
return(Instance);
}
/// <summary>
/// Gets a list with the arguments values.
/// </summary>
/// <param name="p_agrPasajeroAeronaveArg">Value of the inbound argument 'p_agrPasajeroAeronave'.</param>
/// <param name="p_agrRevisionArg">Value of the inbound argument 'p_agrRevision'.</param>
/// <param name="p_atrid_RevisionPasajeroArg">Value of the inbound argument 'p_atrid_RevisionPasajero'.</param>
/// <returns>List of inbound arguments values.</returns>
private static Dictionary <string, object> GetInputFieldValues(PasajeroAeronaveOid p_agrPasajeroAeronaveArg, RevisionOid p_agrRevisionArg, int?p_atrid_RevisionPasajeroArg)
{
// Fill values dictionary.
Dictionary <string, object> lValues = new Dictionary <string, object>();
lValues.Add("p_agrPasajeroAeronave", p_agrPasajeroAeronaveArg);
lValues.Add("p_agrRevision", p_agrRevisionArg);
lValues.Add("p_atrid_RevisionPasajero", p_atrid_RevisionPasajeroArg);
return(lValues);
}
public void Create_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_1_Alias", RevisionPasajeroClassText.Create_instanceServiceAlias, "Clas_1348178673664478_Alias", RevisionPasajeroClassText.ClassAlias);
lSInfo.AddOIDArgument("p_agrPasajeroAeronave", false, "PasajeroAeronave", "Clas_1348178673664478Ser_1Arg_3_Alias", RevisionPasajeroClassText.Create_instance_P_agrPasajeroAeronaveArgumentAlias);
lSInfo.AddOIDArgument("p_agrRevision", false, "Revision", "Clas_1348178673664478Ser_1Arg_4_Alias", RevisionPasajeroClassText.Create_instance_P_agrRevisionArgumentAlias);
lSInfo.AddDataValuedArgument("p_atrid_RevisionPasajero", false, DataTypeEnumerator.Autonumeric, 0, "Clas_1348178673664478Ser_1Arg_1_Alias", RevisionPasajeroClassText.Create_instance_P_atrid_RevisionPasajeroArgumentAlias);
try
{
lSInfo.XML2ON(xmlReader, dtdVersion, true);
}
catch (Exception e)
{
throw new ONServiceArgumentsException(e, "Clas_1348178673664478_Alias", RevisionPasajeroClassText.ClassAlias, "Clas_1348178673664478Ser_1_Alias", RevisionPasajeroClassText.Create_instanceServiceAlias);
}
PasajeroAeronaveOid lP_agrPasajeroAeronaveArg = (PasajeroAeronaveOid)((ONArgumentInfo)lSInfo.mArgumentList["p_agrPasajeroAeronave"]).Value;
RevisionOid lP_agrRevisionArg = (RevisionOid)((ONArgumentInfo)lSInfo.mArgumentList["p_agrRevision"]).Value;
ONInt lP_atrid_RevisionPasajeroArg = (ONInt)((ONArgumentInfo)lSInfo.mArgumentList["p_atrid_RevisionPasajero"]).Value;
// Create Context
ONServiceContext lOnContext = new ONServiceContext();
lOnContext.OidAgent = agentOid;
// Execute Service
RevisionPasajeroInstance lInstance = null;
try
{
ONFilterList lFilterList = new ONFilterList();
PasajeroAeronaveInstance lp_agrPasajeroAeronaveInstance = new PasajeroAeronaveInstance(lOnContext);
if (lP_agrPasajeroAeronaveArg != null)
{
lFilterList = new ONFilterList();
lFilterList.Add("HorizontalVisibility", new PasajeroAeronaveHorizontalVisibility());
lp_agrPasajeroAeronaveInstance = lP_agrPasajeroAeronaveArg.GetInstance(lOnContext, lFilterList);
if (lp_agrPasajeroAeronaveInstance == null)
{
throw new ONInstanceNotExistException(null, "Clas_1348178542592177_Alias", PasajeroAeronaveClassText.ClassAlias);
}
}
RevisionInstance lp_agrRevisionInstance = new RevisionInstance(lOnContext);
if (lP_agrRevisionArg != null)
{
lFilterList = new ONFilterList();
lFilterList.Add("HorizontalVisibility", new RevisionHorizontalVisibility());
lp_agrRevisionInstance = lP_agrRevisionArg.GetInstance(lOnContext, lFilterList);
if (lp_agrRevisionInstance == null)
{
throw new ONInstanceNotExistException(null, "Clas_1348178542592347_Alias", RevisionClassText.ClassAlias);
}
}
using (RevisionPasajeroServer lServer = new RevisionPasajeroServer(lOnContext, null))
{
lServer.Create_instanceServ(lP_agrPasajeroAeronaveArg, lP_agrRevisionArg, lP_atrid_RevisionPasajeroArg);
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
}
/// <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, RevisionOid lastOid, int blockSize, ref bool lastBlock)
{
DataTable lDataTable = Logic.Adaptor.ExecuteQueryRelated(agent, "Revision", linkItems, displaySet, orderCriteria, lastOid, blockSize);
// Last block.
if (lDataTable.ExtendedProperties.Contains("LastBlock"))
{
lastBlock = (bool)lDataTable.ExtendedProperties["LastBlock"];
}
else
{
lastBlock = false;
}
return(lDataTable);
}
