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); }