/// <summary>
/// Searches the operation did finish with result.
/// </summary>
/// <param name="operation">The operation.</param>
/// <param name="result">The result.</param>
public virtual void SearchOperationDidFinishWithResult(Operation operation, UPCRMResult result)
{
int count = result.RowCount;
for (int i = 0; i < count; i++)
{
UPCRMResultRow resultRow = (UPCRMResultRow)result.ResultRowAtIndex(i);
var rowValues = resultRow.ValuesWithFunctions();
string rep = (string)rowValues.ValueOrDefault(Constants.UPRepAcceptanceFunctionName_RepId);
int repId = rep.ToInt();
if (repId > 0)
{
rep = StringExtensions.NineDigitStringFromRep(Convert.ToInt32(rep));
var repParticipant = this.ParticipantWithKey(rep);
if (repParticipant is UPCRMRepParticipant)
{
string acceptance = (string)rowValues[Constants.UPRepAcceptanceFunctionName_Acceptance];
((UPCRMRepParticipant)repParticipant).AcceptanceFromRecordIdentification(acceptance, resultRow.RootRecordIdentification);
}
}
}
this.repAcceptanceCrmQuery = null;
this.Loaded();
}
/// <summary>
/// Loads the with result.
/// </summary>
/// <param name="result">The result.</param>
/// <returns></returns>
public override bool LoadWithResult(UPCRMResult result)
{
if (result.RowCount > 0)
{
return(this.LoadWithResultRow((UPCRMResultRow)result.ResultRowAtIndex(0)));
}
return(false);
}
/// <summary>
/// The handle result client.
/// </summary>
/// <param name="result">
/// The result.
/// </param>
/// <param name="client">
/// The client.
/// </param>
public void HandleResultClient(UPCRMResult result, bool client)
{
if (this.queryWithLinkRecord)
{
if (result.RowCount > 0)
{
UPCRMResultRow resultRow = (UPCRMResultRow)result.ResultRowAtIndex(0);
this.DestinationRecordIdentification = resultRow.RootRecordIdentification;
}
}
else
{
UPCRMResultRow row = (UPCRMResultRow)result.ResultRowAtIndex(0);
if (client)
{
this.DestinationRecordIdentification = this.RecordIdentificationFromResultRow(row);
}
else
{
int position = 0;
Dictionary <string, int> linkPositions = new Dictionary <string, int>();
foreach (UPCRMLinkReaderLinkContext context in this.linkContexts)
{
string linkKey = $"{context.LinkInfo.TargetInfoAreaId}_{(context.LinkInfo.LinkId < 0 ? 0 : context.LinkInfo.LinkId)}";
if (linkPositions.ValueOrDefault(linkKey) == 0)
{
continue;
}
this.DestinationRecordIdentification = row.RecordIdentificationAtIndex(++position);
if (!string.IsNullOrEmpty(this.DestinationRecordIdentification))
{
break;
}
linkPositions[linkKey] = position - 1;
}
}
}
this.TheDelegate?.LinkReaderDidFinishWithResult(this, this.DestinationRecordIdentification);
}
/// <summary>
/// Searches the operation did finish with result.
/// </summary>
/// <param name="operation">The operation.</param>
/// <param name="result">The result.</param>
public void SearchOperationDidFinishWithResult(Operation operation, UPCRMResult result)
{
if (result.RowCount == 0)
{
this.Tiles.TileFinishedWithError(this, new Exception($"Record Not found: {this.recordIdentification}"));
}
else
{
this.LoadWithResultRow((UPCRMResultRow)result.ResultRowAtIndex(0));
}
}
/// <summary>
/// The read link record identification from row.
/// </summary>
/// <param name="row">
/// The row.
/// </param>
/// <returns>
/// The <see cref="string"/>.
/// </returns>
public string ReadLinkRecordIdentificationFromRow(UPCRMResultRow row)
{
if (!this.LinkInfo.UseLinkFields)
{
return(null);
}
int nextIndex = this.StartingPosition;
string targetInfoAreaId = this.LinkInfo.TargetInfoAreaId;
UPContainerMetaInfo query = new UPContainerMetaInfo(new List <UPCRMField>(), targetInfoAreaId);
UPInfoAreaCondition condition = null;
foreach (UPCRMLinkInfoField linkInfoField in this.LinkInfo.LinkFieldArray)
{
UPInfoAreaCondition leaf;
if (linkInfoField.FieldId >= 0)
{
string value = row.RawValueAtIndex(nextIndex++);
if (linkInfoField.TargetFieldId < 0)
{
if (!value.Equals(linkInfoField.TargetValue))
{
return(null);
}
}
leaf = new UPInfoAreaConditionLeaf(targetInfoAreaId, linkInfoField.TargetFieldId, value);
}
else
{
leaf = new UPInfoAreaConditionLeaf(
targetInfoAreaId,
linkInfoField.TargetFieldId,
linkInfoField.SourceValue);
}
condition = condition != null?condition.InfoAreaConditionByAppendingAndCondition(leaf) : leaf;
}
if (condition != null)
{
query.RootInfoAreaMetaInfo.AddCondition(condition);
}
UPCRMResult result = query.Find();
if (result.RowCount >= 1)
{
return(((UPCRMResultRow)result.ResultRowAtIndex(0)).RootRecordIdentification);
}
return(null);
}
/// <summary>
/// Searches the operation did finish with result.
/// </summary>
/// <param name="operation">The operation.</param>
/// <param name="result">The result.</param>
public override void SearchOperationDidFinishWithResult(Operation operation, UPCRMResult result)
{
if (this.crmQuery != null)
{
int count = result.RowCount;
int infoAreaCount = result.MetaInfo.NumberOfResultInfoAreaMetaInfos();
for (int i = 0; i < count; i++)
{
UPCRMResultRow resultRow = (UPCRMResultRow)result.ResultRowAtIndex(i);
for (int j = 1; j < infoAreaCount; j++)
{
string linkRecordIdentification = resultRow.RecordIdentificationAtIndex(j);
if (linkRecordIdentification?.Length > 6)
{
UPCRMLinkParticipant linkParticipant = new UPCRMLinkParticipant(resultRow, j);
this.AddLinkParticipant(linkParticipant);
if (!string.IsNullOrEmpty(this.ProtectedLinkRecordIdentification) && this.ProtectedLinkRecordIdentification == linkParticipant.LinkRecordIdentification)
{
linkParticipant.MayNotBeDeleted = true;
}
break;
}
else
{
UPContainerInfoAreaMetaInfo iaMeta = result.MetaInfo.ResultInfoAreaMetaInfoAtIndex(j);
UPCRMLinkReader _linkReader = new UPCRMLinkReader(resultRow.RootRecordIdentification, iaMeta.InfoAreaIdWithLink, null);
string linkRecordId = _linkReader.RequestLinkRecordOffline();
if (!string.IsNullOrEmpty(linkRecordId) && UPCRMDataStore.DefaultStore.RecordExistsOffline(linkRecordId))
{
UPCRMLinkParticipant linkParticipant = new UPCRMLinkParticipant(resultRow, linkRecordId);
this.AddLinkParticipant(linkParticipant);
break;
}
}
}
}
this.Finished(null);
}
else
{
base.SearchOperationDidFinishWithResult(operation, result);
}
}
/// <summary>
/// Merges the server result with local results.
/// </summary>
/// <param name="serverResult">
/// The server result.
/// </param>
/// <param name="localResults">
/// The local results.
/// </param>
public void MergeServerResultWithLocalResults(UPCRMResult serverResult, Dictionary <string, object> localResults)
{
var resultsOfCurrentQuery = new List <ICrmDataSourceRow>();
for (var i = 0; i < serverResult.RowCount; i++)
{
var serverResultRow = (UPCRMResultRow)serverResult.ResultRowAtIndex(i);
var localResultRow = localResults.ValueOrDefault(serverResultRow.RootRecordId) as UPCRMResultRow;
if (localResultRow != null)
{
serverResultRow.SetHasLocalCopy(true);
}
resultsOfCurrentQuery.Add(serverResultRow);
}
this.AddResult(serverResult);
this.SetResultRows(resultsOfCurrentQuery);
}
/// <summary>
/// The request link record offline.
/// </summary>
/// <returns>
/// The <see cref="string"/>.
/// </returns>
public string RequestLinkRecordOffline()
{
this.linkContexts = this.LinkReaderContextsForParentLinkString(this.ParentLinkString);
if (this.linkContexts == null || this.linkContexts.Count == 0)
{
return(null);
}
if (this.linkContexts.Count == 1)
{
UPCRMLinkReaderLinkContext context = this.linkContexts[0];
if (context.LinkInfo.IsGeneric)
{
UPContainerMetaInfo crmQuery = this.QueryForLinkLinkRecord(context.LinkInfo, this.SourceRecordIdentification);
UPCRMResult result = crmQuery.Find();
if (result.RowCount > 0)
{
UPCRMResultRow row = (UPCRMResultRow)result.ResultRowAtIndex(0);
return(row.RootRecordIdentification);
}
return(null);
}
}
UPContainerMetaInfo crmQuery2 = this.ClientQuery();
UPCRMResult result2 = crmQuery2.Find();
if (result2.RowCount == 0)
{
return(null);
}
UPCRMResultRow row2 = (UPCRMResultRow)result2.ResultRowAtIndex(0);
return(this.RecordIdentificationFromResultRow(row2));
}
/// <summary>
/// Sources the field result row for link.
/// </summary>
/// <param name="link">The link.</param>
/// <returns></returns>
List <string> SourceFieldResultRowForLink(UPCRMLink link)
{
UPCRMTableInfo sourceTableInfo = this.dataStore.TableInfoForInfoArea(link.InfoAreaId);
UPCRMLinkInfo linkInfo = this.tableInfo.LinkInfoForTargetInfoAreaIdLinkId(link.InfoAreaId, link.LinkId);
bool noFields = true;
if (sourceTableInfo == null || linkInfo?.LinkFieldArray == null)
{
return(null);
}
List <UPCRMFieldSetterField> fieldMap = new List <UPCRMFieldSetterField>(linkInfo.LinkFieldArray.Count);
foreach (UPCRMLinkInfoField field in linkInfo.LinkFieldArray)
{
UPCRMFieldInfo fieldInfo = sourceTableInfo.FieldInfoForFieldId(field.TargetFieldId);
if (fieldInfo != null)
{
fieldMap.Add(new UPCRMFieldSetterSourceField(field.TargetFieldId));
noFields = false;
}
else
{
UPCRMFieldSetterSourceLink sourceLink = null;
List <UPCRMLinkInfo> allLinks = sourceTableInfo.LinksWithField();
foreach (UPCRMLinkInfo currentLinkInfo in allLinks)
{
foreach (UPCRMLinkInfoField linkInfoField in currentLinkInfo.LinkFieldArray)
{
if (linkInfoField.FieldId == field.TargetFieldId)
{
UPCRMTableInfo parentTableInfo = this.dataStore.TableInfoForInfoArea(currentLinkInfo.TargetInfoAreaId);
UPCRMLinkInfo parentIdentLink = parentTableInfo.IdentLink;
if (parentIdentLink != null)
{
if (parentIdentLink.FirstField.TargetFieldId == linkInfoField.TargetFieldId)
{
sourceLink = new UPCRMFieldSetterSourceLink(currentLinkInfo.TargetInfoAreaId, currentLinkInfo.LinkId, 0);
break;
}
if (parentIdentLink.SecondField.TargetFieldId == linkInfoField.TargetFieldId)
{
sourceLink = new UPCRMFieldSetterSourceLink(currentLinkInfo.TargetInfoAreaId, currentLinkInfo.LinkId, 1);
break;
}
}
}
}
if (sourceLink != null)
{
break;
}
}
if (sourceLink != null)
{
fieldMap.Add(sourceLink);
noFields = false;
}
else
{
fieldMap.Add(new UPCRMFieldSetterField());
}
}
}
if (noFields)
{
return(null);
}
List <UPCRMField> queryFields = new List <UPCRMField>();
int resultPosition = 0;
foreach (UPCRMFieldSetterField fieldSetterField in fieldMap)
{
if (fieldSetterField.IsField)
{
queryFields.Add(fieldSetterField.FieldWithInfoAreaId(link.InfoAreaId));
fieldSetterField.ResultPosition = resultPosition++;
}
}
foreach (UPCRMFieldSetterField fieldSetterField in fieldMap)
{
if (fieldSetterField.IsLink)
{
queryFields.Add(fieldSetterField.FieldWithInfoAreaId(link.InfoAreaId));
fieldSetterField.ResultPosition = resultPosition++;
}
}
UPContainerMetaInfo crmQuery = new UPContainerMetaInfo(queryFields, linkInfo.TargetInfoAreaId);
UPCRMResult result = crmQuery.ReadRecord(link.RecordIdentification);
if (result != null && result.RowCount == 1)
{
UPCRMResultRow row = (UPCRMResultRow)result.ResultRowAtIndex(0);
List <string> resultArray = new List <string>(fieldMap.Count);
foreach (UPCRMFieldSetterField field in fieldMap)
{
if (field.IsField)
{
resultArray.Add(row.RawValueAtIndex(field.ResultPosition));
}
else if (field.IsLink)
{
string recordId = row.RawValueAtIndex(field.ResultPosition);
if (string.IsNullOrEmpty(recordId))
{
resultArray.Add(string.Empty);
}
else if (recordId.StartsWith("new") && recordId.Length == 15)
{
long offlineLnr = (Convert.ToInt64(recordId.Substring(3, 8), 16) << 16) + Convert.ToInt64(recordId.Substring(11, 4), 16);
if (this.offlineStationNumber > 0 && offlineLnr > 0)
{
if (((UPCRMFieldSetterSourceLink)field).FieldIndex == 0)
{
resultArray.Add(this.offlineStationNumber.ToString());
}
else
{
resultArray.Add(offlineLnr.ToString());
}
}
}
else if (((UPCRMFieldSetterSourceLink)field).FieldIndex == 0)
{
resultArray.Add(recordId.StatNoFromRecordIdString());
}
else
{
resultArray.Add(recordId.RecordNoFromRecordIdString());
}
}
else
{
resultArray.Add(string.Empty);
}
}
return(resultArray);
}
return(null);
}
/// <summary>
/// Reads the rep with identifier.
/// </summary>
/// <param name="repId">The rep identifier.</param>
/// <returns></returns>
public UPCRMRep ReadRepWithId(string repId)
{
if (string.IsNullOrEmpty(repId))
{
return(null);
}
if (this.missingRepDictionary == null)
{
this.missingRepDictionary = new Dictionary <string, UPCRMRep>();
}
else
{
var returnRep = this.missingRepDictionary.ValueOrDefault(repId);
if (returnRep != null)
{
return(returnRep);
}
if (this.emptyRepDictionary.ValueOrDefault(repId) != null)
{
return(null);
}
}
var configStore = ConfigurationUnitStore.DefaultStore;
var repSearchAndList = configStore.SearchAndListByName("IDSystem");
FieldControl fieldControl = null;
if (repSearchAndList != null)
{
fieldControl = configStore.FieldControlByNameFromGroup("List", "IDSystem");
}
if (fieldControl?.Fields == null ||
fieldControl.Fields.Count == 0)
{
return(null);
}
UPCRMField vField = fieldControl.Fields[0].Field;
var fromCondition = new UPInfoAreaConditionLeaf(fieldControl.InfoAreaId, vField.FieldId, "=", repId);
var metaInfo = new UPContainerMetaInfo(fieldControl);
metaInfo.RootInfoAreaMetaInfo.AddCondition(fromCondition);
UPCRMResult result = metaInfo.Find();
int count = result.RowCount;
if (count > 0)
{
lock (this.missingRepDictionary)
{
for (var i = 0; i < count; i++)
{
var row = result.ResultRowAtIndex(i);
var rep = new UPCRMRep(
row.RawValueAtIndex(0),
row.RawValueAtIndex(2),
row.RawValueAtIndex(1),
row.RootRecordId,
this.RepTypeFromStringRepTypeId(row.RawValueAtIndex(3)));
this.missingRepDictionary[rep.RepId] = rep;
}
foreach (var rep in this.repArray)
{
if (string.IsNullOrEmpty(rep.RepOrgGroupId))
{
continue;
}
var parentRep = this.missingRepDictionary.ValueOrDefault(rep.RepOrgGroupId);
parentRep?.AddChildRep(rep);
}
}
return(this.missingRepDictionary.ValueOrDefault(repId));
}
if (this.emptyRepDictionary == null)
{
this.emptyRepDictionary = new Dictionary <string, string>();
}
this.emptyRepDictionary[repId] = repId;
return(null);
}