public void AddGetDeleteSingleEntityTest() { // Arrange ITableManager tableManager = new TableManager(new ConfigManagerHelper()); const string testTableName = "Test"; var entity = new DiscoveredKeywordEntity { PartitionKey = Guid.NewGuid().ToString(), RowKey = Guid.NewGuid().ToString(), OccurrenceInFeed = 2, Text = Guid.NewGuid().ToString(), Volume = 10 }; // Act tableManager.InsertOrMerge(testTableName, entity); var entityRetrieved = tableManager.Get <DiscoveredKeywordEntity>(testTableName, entity.PartitionKey, entity.RowKey); // Cleanup tableManager.Delete(testTableName, entity); var entityRetrievedAfterDelete = tableManager.Get <DiscoveredKeywordEntity>(testTableName, entity.PartitionKey, entity.RowKey); // Assert Assert.IsNotNull(entityRetrieved); Assert.IsNull(entityRetrievedAfterDelete); Assert.AreEqual(entity.PartitionKey, entityRetrieved.PartitionKey); Assert.AreEqual(entity.RowKey, entityRetrieved.RowKey); Assert.AreEqual(entity.OccurrenceInFeed, entityRetrieved.OccurrenceInFeed); Assert.AreEqual(entity.Volume, entityRetrieved.Volume); Assert.AreEqual(entity.Text, entityRetrieved.Text); }
private static void TableUsage() { MyEntity entity = new MyEntity { PartitionKey = Guid.NewGuid().ToString(), RowKey = "5", TrackId = 5, DateInserted = DateTime.Now.ToShortDateString(), ETag = "*" }; Console.WriteLine("Table CreateIfExists Executing"); var tm = new TableManager <MyEntity>("TestTable"); Console.WriteLine("Table CreateIfExists Done"); Console.WriteLine("Record Write Executing"); tm.Write(entity); Console.WriteLine("Record Write Done"); Console.WriteLine("Record Update Executing"); entity.TrackId = 6; tm.Update(entity); Console.WriteLine("Record Update Done"); Console.WriteLine("Record Search Executing"); var search = tm.Search("TrackId", 6); Console.WriteLine("Record Search Done"); Console.WriteLine("Record Delete Executing"); tm.Delete(entity); Console.WriteLine("Record Delete Done"); Console.WriteLine("End Tables, hit enter"); }
public void AddGetDeleteSingleEntityTest() { // Arrange ITableManager tableManager = new TableManager(new ConfigManagerHelper()); const string testTableName = "Test"; var entity = new DiscoveredKeywordEntity { PartitionKey = Guid.NewGuid().ToString(), RowKey = Guid.NewGuid().ToString(), OccurrenceInFeed = 2, Text = Guid.NewGuid().ToString(), Volume = 10 }; // Act tableManager.InsertOrMerge(testTableName, entity); var entityRetrieved = tableManager.Get<DiscoveredKeywordEntity>(testTableName, entity.PartitionKey, entity.RowKey); // Cleanup tableManager.Delete(testTableName, entity); var entityRetrievedAfterDelete = tableManager.Get<DiscoveredKeywordEntity>(testTableName, entity.PartitionKey, entity.RowKey); // Assert Assert.IsNotNull(entityRetrieved); Assert.IsNull(entityRetrievedAfterDelete); Assert.AreEqual(entity.PartitionKey, entityRetrieved.PartitionKey); Assert.AreEqual(entity.RowKey, entityRetrieved.RowKey); Assert.AreEqual(entity.OccurrenceInFeed, entityRetrieved.OccurrenceInFeed); Assert.AreEqual(entity.Volume, entityRetrieved.Volume); Assert.AreEqual(entity.Text, entityRetrieved.Text); }
private void ItemDelete_Click(object sender, EventArgs e) { try { if (treeViewSI.SelectedNode == null) { return; } int Level = treeViewSI.SelectedNode.Level; string selectedNode = treeViewSI.SelectedNode.Text; DialogResult result; switch (Level) { case 0: result = MessageBox.Show(this, string.Format("Are you sure delete channel: {0}?", selectedNode), "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == System.Windows.Forms.DialogResult.Yes) { Server fCh = objServerManager.GetBySQLServerName(selectedNode); objServerManager.Delete(fCh); treeViewSI.SelectedNode.Remove(); IsDataChanged = true; } break; case 1: result = MessageBox.Show(this, string.Format("Are you sure delete device: {0} of the channel: {1}?", selectedNode, treeViewSI.SelectedNode.Parent.Text), "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == System.Windows.Forms.DialogResult.Yes) { Server fCh = objServerManager.GetBySQLServerName(treeViewSI.SelectedNode.Parent.Text); DataBaseManager.Delete(fCh, selectedNode); treeViewSI.SelectedNode.Remove(); IsDataChanged = true; } break; case 2: result = MessageBox.Show(this, string.Format("Are you sure delete datablock: {0} of the device: {1}, channel: {2}?", selectedNode, treeViewSI.SelectedNode.Parent.Text, treeViewSI.SelectedNode.Parent.Parent.Text), "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == System.Windows.Forms.DialogResult.Yes) { Server chCurrent = objServerManager.GetBySQLServerName(treeViewSI.SelectedNode.Parent.Parent.Text); DataBase dvCurrent = DataBaseManager.GetByDataBaseName(chCurrent, treeViewSI.SelectedNode.Parent.Text); Table dbCurrent = TableManager.GetByTableName(dvCurrent, treeViewSI.SelectedNode.Text); TableManager.Delete(dvCurrent, dbCurrent); treeViewSI.SelectedNode.Remove(); IsDataChanged = true; } break; default: break; } } catch (Exception ex) { EventscadaException?.Invoke(GetType().Name, ex.Message); } }
public RestaurantDS Delete(int Id) { var restSingle = GetRestuarantById(Id); if (restSingle != null) { tm.Delete(restSingle); } //After delete, should not return anything except for status return(null); }
public void AddGetDeleteMultipleEntityTest() { // Arrange ITableManager tableManager = new TableManager(new ConfigManagerHelper()); const string testTableName = "Test"; var partitionKey = Guid.NewGuid().ToString(); var entities = new List <DiscoveredKeywordEntity> { new DiscoveredKeywordEntity { PartitionKey = partitionKey, RowKey = Guid.NewGuid().ToString(), OccurrenceInFeed = 2, Text = Guid.NewGuid().ToString(), Volume = 10 }, new DiscoveredKeywordEntity { PartitionKey = partitionKey, RowKey = Guid.NewGuid().ToString(), OccurrenceInFeed = 2, Text = Guid.NewGuid().ToString(), Volume = 10 } }; // Act tableManager.InsertOrMerge <DiscoveredKeywordEntity>(testTableName, entities); var entitiesRetrieved = tableManager.Get <DiscoveredKeywordEntity>(testTableName, partitionKey).ToList(); // Cleanup tableManager.Delete <DiscoveredKeywordEntity>(testTableName, entities); var entitiesRetrievedAfterDelete = tableManager.Get <DiscoveredKeywordEntity>(testTableName, partitionKey).ToList(); // Assert Assert.AreEqual(entities.Count, entitiesRetrieved.Count()); Assert.AreEqual(0, entitiesRetrievedAfterDelete.Count()); for (var x = 0; x < entities.Count; x++) { Assert.AreEqual(entities[x].PartitionKey, entitiesRetrieved[x].PartitionKey); Assert.AreEqual(entities[x].RowKey, entitiesRetrieved[x].RowKey); Assert.AreEqual(entities[x].OccurrenceInFeed, entitiesRetrieved[x].OccurrenceInFeed); Assert.AreEqual(entities[x].Volume, entitiesRetrieved[x].Volume); Assert.AreEqual(entities[x].Text, entitiesRetrieved[x].Text); } }
public void AddGetDeleteMultipleEntityTest() { // Arrange ITableManager tableManager = new TableManager(new ConfigManagerHelper()); const string testTableName = "Test"; var partitionKey = Guid.NewGuid().ToString(); var entities = new List<DiscoveredKeywordEntity> { new DiscoveredKeywordEntity { PartitionKey = partitionKey, RowKey = Guid.NewGuid().ToString(), OccurrenceInFeed = 2, Text = Guid.NewGuid().ToString(), Volume = 10 }, new DiscoveredKeywordEntity { PartitionKey = partitionKey, RowKey = Guid.NewGuid().ToString(), OccurrenceInFeed = 2, Text = Guid.NewGuid().ToString(), Volume = 10 } }; // Act tableManager.InsertOrMerge<DiscoveredKeywordEntity>(testTableName, entities); var entitiesRetrieved = tableManager.Get<DiscoveredKeywordEntity>(testTableName, partitionKey).ToList(); // Cleanup tableManager.Delete<DiscoveredKeywordEntity>(testTableName, entities); var entitiesRetrievedAfterDelete = tableManager.Get<DiscoveredKeywordEntity>(testTableName, partitionKey).ToList(); // Assert Assert.AreEqual(entities.Count, entitiesRetrieved.Count()); Assert.AreEqual(0, entitiesRetrievedAfterDelete.Count()); for (var x = 0; x < entities.Count; x++) { Assert.AreEqual(entities[x].PartitionKey, entitiesRetrieved[x].PartitionKey); Assert.AreEqual(entities[x].RowKey, entitiesRetrieved[x].RowKey); Assert.AreEqual(entities[x].OccurrenceInFeed, entitiesRetrieved[x].OccurrenceInFeed); Assert.AreEqual(entities[x].Volume, entitiesRetrieved[x].Volume); Assert.AreEqual(entities[x].Text, entitiesRetrieved[x].Text); } }
public void RemoveFromCollection(Author author) { _authorCollection.Delete(author); }
public void RemoveFromCollection(Book book) { _bookCollection.Delete(GetDbModel(book)); }
private void ItemDelete_ItemClick(object sender, ItemClickEventArgs e) { try { var SelectebNodes = treeList1.Selection; var Level = SelectebNodes[0].Level; if (SelectebNodes[0] == null) { return; } DialogResult result; switch (Level) { case 0: result = MessageBox.Show(this, $"Are you sure delete Server: {SelectebNodesHelpr[0]}?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { var fCh = objServerManager.GetBySQLServerName(SelectebNodesHelpr[0]); objServerManager.Delete(fCh); treeList1.DeleteSelectedNodes(); IsDataChanged = true; } break; case 1: result = MessageBox.Show(this, $"Are you sure delete DataBase: {SelectebNodesHelpr[0]} of the channel: {SelectebNodesHelpr[1]}?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { var fCh = objServerManager.GetBySQLServerName(SelectebNodesHelpr[0]); DataBaseManager.Delete(fCh, SelectebNodesHelpr[1]); treeList1.DeleteSelectedNodes(); IsDataChanged = true; } break; case 2: result = MessageBox.Show(this, $"Are you sure delete Table: {SelectebNodesHelpr[0]} of the device: {SelectebNodesHelpr[1]}, channel: {SelectebNodesHelpr[2]}?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { var chCurrent = objServerManager.GetBySQLServerName(SelectebNodesHelpr[0]); var dvCurrent = DataBaseManager.GetByDataBaseName(chCurrent, SelectebNodesHelpr[1]); var dbCurrent = TableManager.GetByTableName(dvCurrent, SelectebNodesHelpr[2]); TableManager.Delete(dvCurrent, dbCurrent); treeList1.DeleteSelectedNodes(); IsDataChanged = true; } break; } } catch (Exception ex) { EventscadaException?.Invoke(this.GetType().Name, ex.Message); } }
public bool DeleteTable(string tableId) { TableManager mgr = new TableManager(); return(mgr.Delete(tableId)); }