public string ResolveRecord([FromBody] NewQuestionsEntity entity) { string res; CloudStorageAccount storageAccount = CloudStorageAccount.Parse(_connectionString); CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); CloudTable table = tableClient.GetTableReference("NewQuestions"); TableOperation retrieveOperation = TableOperation.Retrieve <NewQuestionsEntity>(entity.PartitionKey, entity.RowKey); TableResult retrievedResult = table.Execute(retrieveOperation); NewQuestionsEntity updateEntity = (NewQuestionsEntity)retrievedResult.Result; if (updateEntity != null) { updateEntity.Status = "Resolved"; TableOperation updateOperation = TableOperation.Replace(updateEntity); table.Execute(updateOperation); Console.WriteLine("Entity updated."); res = "Entity updated"; } else { Console.WriteLine("Entity could not be retrieved."); res = "Entity could not be retrieved."; } return(res); }
public string DeleteRecord(NewQuestionsEntity entity) { string res; CloudStorageAccount storageAccount = CloudStorageAccount.Parse(_connectionString); CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); CloudTable table = tableClient.GetTableReference("NewQuestions"); TableOperation retrieveOperation = TableOperation.Retrieve <NewQuestionsEntity>(entity.PartitionKey, entity.RowKey); TableResult retrievedResult = table.Execute(retrieveOperation); NewQuestionsEntity deleteEntity = (NewQuestionsEntity)retrievedResult.Result; if (deleteEntity != null) { TableOperation deleteOperation = TableOperation.Delete(deleteEntity); table.Execute(deleteOperation); Console.WriteLine("Entity deleted."); res = "Entity Deleted"; } else { Console.WriteLine("Could not retrieve the entity."); res = "error in deletingentity"; } return(res); }