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