public static void InsertRecord(OrganisationStatusEventModel organisationStatusEvent)
{
var sql =
@"set identity_insert [OrganisationStatusEvent] ON; INSERT INTO [OrganisationStatusEvent] (Id,[OrganisationStatusId],[CreatedOn],[ProviderId]) VALUES " +
$@"(@Id,@OrganisationStatusId, @createdOn, @providerId); set identity_insert [OrganisationStatusEvent] OFF; ";
DatabaseService.Execute(sql, organisationStatusEvent);
}
public void Set_up_data()
{
event1CreatedOn = DateTime.Today;
event2CreatedOn = DateTime.Today.AddDays(-1);
event3CreatedOn = DateTime.Today.AddDays(-2);
event4CreatedOn = DateTime.Today.AddDays(-3);
event5CreatedOn = DateTime.Today.AddDays(-4);
event6CreatedOn = DateTime.Today.AddDays(-5);
_repository = new OrganisationRepository(_databaseService.DbConnectionHelper);
OrganisationStatusHandler.InsertRecord(new OrganisationStatusModel {
Id = OrganisationStatus.Active, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "Active", EventDescription = "ACTIVE"
});
OrganisationStatusHandler.InsertRecord(new OrganisationStatusModel {
Id = OrganisationStatus.Onboarding, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "Onboarding", EventDescription = "INITIATED"
});
OrganisationStatusHandler.InsertRecord(new OrganisationStatusModel {
Id = OrganisationStatus.ActiveNotTakingOnApprentices, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "active not taking", EventDescription = "ACTIVENOSTARTS"
});
OrganisationStatusHandler.InsertRecord(new OrganisationStatusModel {
Id = OrganisationStatus.Removed, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "Removed", EventDescription = "REMOVED"
});
event1Active = new OrganisationStatusEventModel {
Id = 1, CreatedOn = event1CreatedOn, OrganisationStatusId = OrganisationStatus.Active, ProviderId = 11112221
};
event2Onboarding = new OrganisationStatusEventModel {
Id = 2, CreatedOn = event2CreatedOn, OrganisationStatusId = OrganisationStatus.Onboarding, ProviderId = 11112222
};
event3Active = new OrganisationStatusEventModel {
Id = 3, CreatedOn = event3CreatedOn, OrganisationStatusId = OrganisationStatus.Active, ProviderId = 11112223
};
event4Removed = new OrganisationStatusEventModel {
Id = 4, CreatedOn = event4CreatedOn, OrganisationStatusId = OrganisationStatus.Removed, ProviderId = 11112224
};
event5ActiveNotTaking = new OrganisationStatusEventModel {
Id = 5, CreatedOn = event5CreatedOn, OrganisationStatusId = OrganisationStatus.ActiveNotTakingOnApprentices, ProviderId = 11112225
};
event6Active = new OrganisationStatusEventModel {
Id = 6, CreatedOn = event6CreatedOn, OrganisationStatusId = OrganisationStatus.Active, ProviderId = 11112226
};
OrganisationStatusEventHandler.InsertRecord(event1Active);
OrganisationStatusEventHandler.InsertRecord(event2Onboarding);
OrganisationStatusEventHandler.InsertRecord(event3Active);
OrganisationStatusEventHandler.InsertRecord(event4Removed);
OrganisationStatusEventHandler.InsertRecord(event5ActiveNotTaking);
OrganisationStatusEventHandler.InsertRecord(event6Active);
}