public void DeleteWarehouseInDatabase()
{
using (TransactionScope scope = new TransactionScope()) //auto roll back
{
int brojac = 0;
Warehouse warehouse = new Warehouse();
warehouse.Name = "Random name";
warehouse.LocationId = 1024;
warehouseRepositoryBus.InsertWarehouse(warehouse);
foreach (Warehouse categ in warehouseRepositoryBus.GetAllWarehouses())
{
if (categ.Name == warehouse.Name && categ.LocationId == warehouse.LocationId)
{
brojac++;
warehouse = categ;
}
}
Assert.AreEqual(1, brojac);
warehouseRepositoryBus.DeleteWarehouse(warehouse.Id);
foreach (Warehouse categ in warehouseRepositoryBus.GetAllWarehouses())
{
if (categ.Name == warehouse.Name && categ.LocationId == warehouse.LocationId)
{
brojac++;
}
}
Assert.AreEqual(1, brojac);
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (warehouseTable.SelectedRows.Count > 0)
{
int id = Convert.ToInt32(warehouseTable.SelectedRows[0].Cells["Id"].Value.ToString());
try
{
warehouseRepository.DeleteWarehouse(id);
}
catch (Exception exe)
{
MessageBox.Show("This Record is used and cannot be deleted!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
InsertDataIntoTable();
}
}