private async Task <List <PackageCheckTableEntity> > QueryPacakgeId(string packageId)
{
List <PackageCheckTableEntity> queryResult = await table.RetrieveEntities <PackageCheckTableEntity>(PackageCheckConstants.ID_FIELD_NAME,
QueryComparisons.Equal,
packageId, tableName);
return(queryResult);
}
public async Task <string> QueryPendingSerials()
{
List <AppleDepTableEntity> queryResult = await table.RetrieveEntities <AppleDepTableEntity>(AppleDepConstants.STATUS_FIELD_NAME,
QueryComparisons.Equal,
AppleDepConstants.STATUS_PENDING, tableName);
return(Mappings.ToEntityJSON(queryResult));
}
public async Task <List <MaterialDeliveryTableEntity> > QueryMaterialDeliveryOnWebid(string webid, bool robotQuery)
{
if (robotQuery == false)
{
string guidFilter = TableQuery.GenerateFilterCondition(MaterialDeliveryConstants.WEBID_FIELD_NAME, QueryComparisons.Equal, webid);
string statusFilter = TableQuery.GenerateFilterConditionForInt(MaterialDeliveryConstants.STATUS_FIELD_NAME, QueryComparisons.Equal, MaterialDeliveryConstants.STATUS_WAITING);
List <MaterialDeliveryTableEntity> queryResult = await table.RetrieveEntitiesCombinedFilter <MaterialDeliveryTableEntity>(guidFilter,
TableOperators.And,
statusFilter,
tableName);
return(queryResult);
}
else if (robotQuery == true)
{
List <MaterialDeliveryTableEntity> queryResult = await table.RetrieveEntities <MaterialDeliveryTableEntity>(MaterialDeliveryConstants.WEBID_FIELD_NAME, QueryComparisons.Equal, webid, tableName);
return(queryResult);
}
return(null);
}
private async Task <List <ReturnForCreditEntityTableEntity> > QueryReturnForCreditOnReturnsNumber(string returnsNumber)
{
List <ReturnForCreditEntityTableEntity> queryResult = await table.RetrieveEntities <ReturnForCreditEntityTableEntity>(ReturnForCreditEntityConstants.RETURNS_NUMBER_FIELD_NAME, QueryComparisons.Equal, returnsNumber, tableName);
return(queryResult);
}
private async Task <List <MaterialDeliveryTableEntity> > QueryMaterialDeliveryOnStatus(int status)
{
List <MaterialDeliveryTableEntity> queryResult = await table.RetrieveEntities <MaterialDeliveryTableEntity>(MaterialDeliveryConstants.STATUS_FIELD_NAME, QueryComparisons.Equal, status, tableName);
return(queryResult);
}
