private static async Task <Boolean> isIdInTable(CloudTable table, String colName, string platId) { TableQuery <PlateNumber> idQuery = new TableQuery <PlateNumber>() .Where(TableQuery.GenerateFilterCondition(colName, QueryComparisons.Equal, platId)); TableQuerySegment <PlateNumber> queryResult = await table.ExecuteQuerySegmentedAsync(idQuery, null); PlateNumber plateNumber = queryResult.FirstOrDefault(); if (plateNumber == null) { return(false); } ownerName = plateNumber.PartitionKey; return(true); }
private static async Task <String> updatePlateNumber(CloudTable cloudTable, string id, string owner, string action) { if (action.Equals("add")) { try { PlateNumber newPlate = new PlateNumber(); newPlate.PartitionKey = owner; newPlate.RowKey = id; TableOperation add = TableOperation.InsertOrReplace(newPlate); await cloudTable.ExecuteAsync(add); } catch (Exception e) { return(e.Message); } return("Success"); // action=='remove' } else { try { List <string> list = new List <string>(); list.Add(id); TableOperation retrieve = TableOperation.Retrieve <PlateNumber>(owner, id); TableResult result = await cloudTable.ExecuteAsync(retrieve); var deleteEntity = (PlateNumber)result.Result; TableOperation delete = TableOperation.Delete(deleteEntity); await cloudTable.ExecuteAsync(delete); } catch (Exception e) { return(e.Message); } return("Success"); } }