private static void DeleteTestDataFromDb()
        {
            Exhibit.DeleteExhibit(_caseId, _exhibitId);
            _exhibitDatabase.DropExhibitDatabase(_exhibitId);
            Case.DeleteCase(_caseId);

            //TODO OV is there a BLL method that can be used to replace this one?
            if (_userWorkflowTable.IsWorkflowFoundByCustomName(_workflowDataModel.CustomWorkflowName))
            {
                var workflowId = _userWorkflowTable.GetWorkflowIdByName(_workflowDataModel.CustomWorkflowName);
                Assert.AreEqual(1, _userWorkflowTable.DeleteUserWorkflow(workflowId));
            }
        }
        private static void DeleteDataFromDb()
        {
            _distributedDatabase.ResetDistributedDatabase();

            if (_exhibitId != 0)
            {
                _exhibitDatabase = new ExhibitDatabase(_exhibitDatabaseConnectionString);
                _exhibitDatabase.ResetExhibitDatabase(_exhibitId);
                Exhibit.DeleteExhibit(_caseId, _exhibitId);
                _exhibitDatabase.DropExhibitDatabase(_exhibitId);
            }

            if (_caseId != 0)
            {
                Case.DeleteCase(_caseId);
            }
        }
        private static void InsertTestDataToDb()
        {
            _caseId = Case.InsertCase(_caseDataModel.PoliceFileNumber,
                                      _caseDataModel.EclCaseNumber,
                                      _caseDataModel.Description,
                                      _caseDataModel.OfficerInChargeId,
                                      _caseDataModel.DistrictId,
                                      _caseDataModel.SiteId,
                                      _caseDataModel.OffenceTypeId,
                                      _caseDataModel.CreatedById);

            _exhibitId = Exhibit.CreateExhibit(_caseId,
                                               _caseDataModel.CreatedById,
                                               _exhibitDataModel.EclExhibitNumber,
                                               _exhibitDataModel.Description,
                                               _exhibitDataModel.PoliceExhibitNumber);

            _mediaDataModel.EvidencePath = _evidencePath;


            EVE.Site.BLL.Media.InsertMedia(_exhibitId,
                                           _mediaDataModel.MediaNumber,
                                           _mediaDataModel.Description,
                                           _mediaDataModel.EvidencePath,
                                           MediaStatus.Defined,
                                           AcquisitionFormatType.ForensicImage,
                                           string.Empty);

            var connectionString = Config.GetConnectionString(DataStore.Central);

            _userWorkflowTable = new UserWorkflowTable(connectionString);

            var exhibitDbConnectionString = EVE.Site.DAL.Config.GetConnectionString(DataStore.Exhibit).Replace(EVE.Site.DAL.Config.ExhibitPlaceholder, _exhibitId.ToString(CultureInfo.InvariantCulture));

            _exhibitDatabase = new ExhibitDatabase(exhibitDbConnectionString);
        }