private static void DeleteTestDataFromDb() { var connectionString = EVE.Site.DAL.Config.GetConnectionString(DataStore.Site); var exhibitTable = new ExhibitTable(connectionString); var exhibitId = exhibitTable.GetExhibitIdByExhibitNumber(_exhibitDataModel.EclExhibitNumber); var exhibitDbConnectionString = EVE.Site.DAL.Config.GetConnectionString(DataStore.Exhibit).Replace(EVE.Site.DAL.Config.ExhibitPlaceholder, exhibitId.ToString(CultureInfo.InvariantCulture)); var exhibitDatabase = new ExhibitDatabase(exhibitDbConnectionString); Exhibit.DeleteExhibit(_caseId, exhibitId); exhibitDatabase.DropExhibitDatabase(exhibitId); Case.DeleteCase(_caseId); }
private static void DeleteDataFromDb() { _distributedDatabase.ResetDistributedDatabase(); if (_exhibitId != 0) { _exhibitDatabase = new ExhibitDatabase(_exhibitDatabaseConnectionString); _exhibitDatabase.ResetExhibitDatabase(_exhibitId); _exhibitDatabase.DropExhibitDatabase(_exhibitId); Exhibit.DeleteExhibit(_caseId, _exhibitId); } if (_caseId != 0) { Case.DeleteCase(_caseId); } }
public static void InitialiseTables() { var distributedConnectionString = EVE.Site.DAL.Config.GetConnectionString(DataStore.Distributed); _workTable = new WorkTable(distributedConnectionString); _exhibitDatabaseConnectionString = EVE.Site.DAL.Config.GetConnectionString(DataStore.Exhibit) .Replace(EVE.Site.DAL.Config.ExhibitPlaceholder, _exhibitId.ToString(CultureInfo.InvariantCulture)); _fileMetadataTable = new FileMetadataTable(_exhibitDatabaseConnectionString); _entityTable = new EntityTable(_exhibitDatabaseConnectionString); _connectionMetadataTable = new ConnectionMetadataTable(_exhibitDatabaseConnectionString); _mediaTable = new MediaTable(_exhibitDatabaseConnectionString); _exhibitDatabase = new ExhibitDatabase(_exhibitDatabaseConnectionString); var distributedDbConnctionString = EVE.Site.DAL.Config.GetConnectionString(DataStore.Distributed); _distributedDatabase = new DistributedDatabase(distributedDbConnctionString); }
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); }