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);
}
public RevisionInstance Create_instanceServ(ONInt p_atrid_RevisarAeronaveArg, ONDate p_atrFechaRevisionArg, ONString p_atrNombreRevisorArg, ONString p_atrId_AeronaveArg)
{
// Create new context
using (ONServiceContext lOnContext = new ONServiceContext(OnContext))
{
// Call Executive
RevisionExecutive lExecutive = new RevisionExecutive();
lExecutive.OnContext = lOnContext;
lExecutive.Instance = Instance;
Instance = lExecutive.Create_instanceServ(p_atrid_RevisarAeronaveArg, p_atrFechaRevisionArg, p_atrNombreRevisorArg, p_atrId_AeronaveArg);
}
return Instance;
}
internal RevisionInstance Create_instanceServ(ONInt p_atrid_RevisarAeronaveArg, ONDate p_atrFechaRevisionArg, ONString p_atrNombreRevisorArg, ONString p_atrId_AeronaveArg)
{
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 = new RevisionInstance(OnContext);
Instance = lAction.Create_instanceServ(p_atrid_RevisarAeronaveArg, p_atrFechaRevisionArg, p_atrNombreRevisorArg, p_atrId_AeronaveArg);
OnContext.OperationStack.Pop();
OnContext.OperationStack.Push(Instance);
return Instance;
}
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
}
protected override ONInstance InhGetInstance(ONContext onContext, ONFilterList onFilterList)
{
// Add oid filter to the list
ONFilterList lOnFilterList = new ONFilterList(onFilterList);
lOnFilterList.Add("QueryByOid", new QueryByOidFilter(this));
// Search Instance
ONInstance lInstance = new RevisionInstance(onContext);
lInstance.Oid = this;
lInstance = lInstance.Find(lOnFilterList);
if (lInstance == null)
lInstance = new RevisionInstance(onContext);
return lInstance;
}
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
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="onContext">This parameter has the current context</param>
/// <param name="instance">This parameter has the instance that exectues the service</param>
public RevisionServer(ONServiceContext onContext, RevisionInstance instance)
: base(onContext, instance, "Revision")
{
}
///<summary> This method adds the order criteria to the SQL statement </summary>
///<param name = "onSql"> This parameter represents the SQL component </param>
///<param name = "comparer"> This parameter has all the information refering to the order criteria to add to SQL statement</param>
/// <param name="startRowOid">This parameter has the OID necessary to start the search</param>
/// <param name="blockSize">This parameter represents the number of instances to be returned</param>
protected override void AddOrderCriteria(ONSqlSelect onSql, ONOrderCriteria comparer, ONOid startRowOid, int blockSize, ONPath initialPath)
{
//Initilizate StartRow
RevisionInstance lInstance = null;
if (startRowOid != null)
{
lInstance = new RevisionInstance(OnContext);
lInstance.Oid = startRowOid as RevisionOid;
}
//Default OrderCriteria
if (comparer == null)
{
string lAlias = onSql.GetAlias("Revision", initialPath);
if (lInstance != null)
{
onSql.AddOrderBy(lAlias, CtesBD.FLD_REVISION_ID_REVISARAERONAVE, OrderByTypeEnumerator.Asc, lInstance.Oid.Id_RevisarAeronaveAttr);
}
else
{
onSql.AddOrderBy(lAlias, CtesBD.FLD_REVISION_ID_REVISARAERONAVE, OrderByTypeEnumerator.Asc, null);
}
return;
}
//Add OrderCriteria
bool lUseStartRow = (!comparer.InMemory);
foreach (ONOrderCriteriaItem lOrderCriteriaItem in comparer.OrderCriteriaSqlItem)
{
ONPath lPath = new ONPath(lOrderCriteriaItem.OnPath);
if((lInstance != null) && (lUseStartRow))
{
ONSimpleType lAttrStartRow = null;
if (lPath.Path == "")
lAttrStartRow = lInstance[lOrderCriteriaItem.Attribute] as ONSimpleType;
else
{
ONCollection lCollection = (lInstance[lPath.Path] as ONCollection);
if((lCollection != null) && (lCollection.Count > 0))
lAttrStartRow = lCollection[0][lOrderCriteriaItem.Attribute] as ONSimpleType;
}
onSql.AddOrderBy(RevisionData.AddPath(onSql, JoinType.LeftJoin, lOrderCriteriaItem.Facet, lPath, null, lOrderCriteriaItem.DomainArgument, false), lOrderCriteriaItem.Attribute, lOrderCriteriaItem.Type, lAttrStartRow);
lUseStartRow = (lAttrStartRow != null);
}
else
onSql.AddOrderBy(RevisionData.AddPath(onSql, JoinType.LeftJoin, lOrderCriteriaItem.Facet, lPath, null, lOrderCriteriaItem.DomainArgument, false), lOrderCriteriaItem.Attribute, lOrderCriteriaItem.Type, null);
}
return;
}
/// <summary>
/// Load the data retrieved from the Data Base to components of the application
/// </summary>
/// <param name="onContext">This parameter has the current context</param>
/// <param name="columns">This parameter has the data collected from the database</param>
/// <param name="index">This parameter has the position of the first data to fix in the application</param>
public static RevisionInstance LoadFacet(ONContext onContext, ONDisplaySet displaySet, object[] columns, ref int index)
{
RevisionInstance lInstance = new RevisionInstance(onContext);
lInstance.Oid = new RevisionOid();
// Field 'id_RevisarAeronave'
lInstance.Oid.Id_RevisarAeronaveAttr = new ONInt(Convert.ToInt32(columns[index++]));
lInstance.StateObj = new ONString(((string) columns[index++]).TrimEnd());
lInstance.Lmd = new ONDateTime((DateTime) columns[index++]);
// Field 'NombreRevisor'
lInstance.NombreRevisorAttr = new ONString(((string) columns[index++]).TrimEnd());
// Field 'FechaRevision'
lInstance.FechaRevisionAttr = new ONDate(Convert.ToDateTime(columns[index++]));
// Field 'Id_Aeronave'
lInstance.Id_AeronaveAttr = new ONString(((string) columns[index++]).TrimEnd());
lInstance.Modified = false;
return lInstance;
}
