private void Tasks(IDBSchema sch)
{
sch.AddRevision(new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Task, FillAdmin));
sch.AddRevision(new DBRevision(new DateTime(2016, 6, 10), 2, eDBRevisionType.Task, FillAdmin2));
sch.AddRevision(new DBRevision(new DateTime(2019, 9, 9), 0, eDBRevisionType.AlwaysExecuteTask, FillAdminRolePermissions));
}
private void Tasks(IDBSchema sch)
{
sch.AddRevision(new DBRevision(new DateTime(2019, 9, 9), 0, eDBRevisionType.AlwaysExecuteTask, FillClaims));
sch.AddRevision(new DBRevision(new DateTime(2019, 9, 10), 0, eDBRevisionType.AlwaysExecuteTask, FillRoles));
sch.AddRevision(new DBRevision(new DateTime(2019, 9, 30), 0, eDBRevisionType.AlwaysExecuteTask, FillRolePermissions));
sch.AddRevision(new DBRevision(new DateTime(2020, 4, 14), 3, eDBRevisionType.AlwaysExecuteTask, FillBusinessDays));
}
private void Always(IDBSchema sch)
{
sch.AddRevision(new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.AlwaysExecuteTask, UpdateStatistics));
//sch.AddView("testAlways", new DBViewDescriptor() { Body = "SELECT Broj = 1", WithSchemaBinding = false },
// new DBRevision(new DateTime(2016, 6, 29), 0, eDBRevisionType.AlwaysExecuteTask));
}
public override void CreateTimeLine()
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
IDBSchema sch = AddSchema(DefaultSchemaName, new DBSchemaDescriptor());
if (DefaultSchemaName != "dbo")
{
sch.AddRevision(new DBRevision(rev));
}
UserDetail(sch);
Organization(sch);
Line(sch);
LineEmployee(sch);
LineEmployeeInvited(sch);
LineEmployeeAccepted(sch);
Country(sch);
LineLocation(sch);
LinePhoto(sch);
BusinessDay(sch);
LineBusinessHour(sch);
LineStatus(sch);
ClearDbForTesting.Create(sch);
Tasks(sch);
}
public override void CreateTimeLine()
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
IDBSchema sch = AddSchema(DefaultSchemaName, new DBSchemaDescriptor());
if (DefaultSchemaName != "dbo")
{
sch.AddRevision(new DBRevision(rev));
}
MjestoTroska(sch);
}
public override void CreateTimeLine()
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
IDBSchema sch = AddSchema(DefaultSchemaName, new DBSchemaDescriptor());
if (DefaultSchemaName != "dbo")
{
sch.AddRevision(new DBRevision(rev));
}
tblCases(sch);
var ass = System.Reflection.Assembly.GetExecutingAssembly();
sch.AddExecuteOnceTask(new DateTime(2016, 9, 21), 0, Framework.Core.Helpers.ReadEmbeddedTextResource(ass, "Resources.CentrixCore.sp_Zbroji_v1.txt"));
}
public override void CreateTimeLine()
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
IDBSchema sch = AddSchema(DefaultSchemaName, new DBSchemaDescriptor());
if (DefaultSchemaName != "dbo")
{
sch.AddRevision(new DBRevision(rev));
}
UserDetail(sch);
ClearDbForTesting.Create(sch);
Tasks(sch);
}
public override void CreateTimeLine()
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
IDBSchema sch = AddSchema(DefaultSchemaName, new DBSchemaDescriptor());
if (DefaultSchemaName != "dbo")
{
sch.AddRevision(new DBRevision(rev));
}
Drzava(sch);
Grad(sch);
Always(sch);
DBStoredProcedure sp = (DBStoredProcedure)sch.AddDBObject("sp_Stora", new DBStoredProcedureDescriptor()
{
Parameters = "@broj int, @broj2 int, @tekst nvarchar(max)", Body = "SELECT Dijeljenje = @broj / @broj2, Tekst = @tekst", ErrorHandling = true
},
new DBRevision(new DateTime(2016, 9, 19), 0, eDBRevisionType.Create));
}
public override void CreateTimeLine()
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
IDBSchema sch = AddSchema(DefaultSchemaName, new DBSchemaDescriptor());
if (DefaultSchemaName != "dbo")
{
sch.AddRevision(new DBRevision(rev));
}
Principal(sch);
Role(sch);
Claim(sch);
PrincipalHasRole(sch);
RolePermission(sch);
PrincipalPermission(sch);
ClaimPermission(sch);
Tasks(sch);
}
private void Tasks(IDBSchema sch)
{
sch.AddRevision(new DBRevision(new DateTime(2017, 3, 22), 0, eDBRevisionType.AlwaysExecuteTask, FillClaims));
}
