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