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