private IDBView ClaimPermission(IDBSchema sch)
{
var ret = sch.AddView("ClaimPermission", new DBViewDescriptor()
{
Body =
@"SELECT
ID = newid(), t.ClaimID, t.PrincipalID, CanExecute = CAST(MAX(CAST(t.CanExecute AS INT)) AS BIT)
FROM
(
SELECT
PrincipalID, ClaimID, CanExecute
FROM
Common.PrincipalPermission pp
UNION ALL
SELECT
phr.PrincipalID, rp.ClaimID, rp.CanExecute
FROM
Common.RolePermission rp
INNER JOIN Common.PrincipalHasRole phr ON rp.RoleID = phr.RoleID
) t
GROUP BY
t.PrincipalID, t.ClaimID" ,
WithSchemaBinding = false
},
new DBRevision(new DateTime(2016, 6, 10), 4, eDBRevisionType.Create));
return(ret);
}
private IDBTable tblCases(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2016, 9, 19), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableIDNaziv("tblCases", sch, rev);
return(ret);
}
private IDBTable RolePermission(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("RolePermission", sch, rev);
var fld = DBMacros.AddForeignKeyFieldID("RoleID", true, ret, sch.Name + ".Role",
new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create));
fld.AddRevision(new DBRevision(new DateTime(2016, 6, 10), 2, eDBRevisionType.Modify),
new DBFieldDescriptor(fld.Descriptor)
{
Nullable = false
});
DBMacros.AddForeignKeyFieldID("ClaimID", true, ret, sch.Name + ".Claim",
new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create));
ret.AddField("CanExecute", DBMacros.DBFieldBitDescriptor(false),
new DBRevision(new DateTime(2016, 6, 10), 2, eDBRevisionType.Create));
ret.AddIndex(new DBIndexDescriptor(new List <string>()
{
"RoleID", "ClaimID"
}, new List <string>()
{
"CanExecute"
})
{
Unique = true
},
new DBRevision(new DateTime(2016, 6, 10), 3, eDBRevisionType.Create));
return(ret);
}
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);
}
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()
{
IDBSchema sch = AddSchema("dbo", new DBSchemaDescriptor());
Drzava(sch);
Grad(sch);
}
private void CreateTimeLine(IDBModule module)
{
IDBSchema sch = module.AddSchema(module.DefaultSchemaName, new DBSchemaDescriptor());
tblCases(sch);
vw_cus_cus_CustomView(sch);
}
private void Initialize(string connectionStringName)
{
connectionStringName = string.IsNullOrEmpty(connectionStringName) ? "default" : connectionStringName;
ConnectionConfig info = SimpleDALConfig.GetConnectionConfig(connectionStringName);
_ConnectionString = info.ConnectionString;
_Schema = SimpleDALConfig.GetSchemaService(info.ProviderName);
_IsCustomToken = info.IsCustomToken;
_Factory = DbProviderFactories.GetFactory(info.ProviderName);
_ParamToken = _Schema.ParameterToken;
_Connection = CreateConnection();
_DalLogger = SimpleDALConfig.GetLogService(info.LoggerName);
_IsLoggable = info.IsDebug;
_SessionID = Guid.NewGuid().ToString();
Info("New Create SimpleDB");
Debug("Connection Name is: " + connectionStringName);
Debug("Provider is " + info.ProviderName);
}
private IDBTable Mjesto(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2016, 7, 8), 1, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableIDNaziv("Mjesto", sch, rev);
return(ret);
}
private IDBTable UserDetail(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2019, 9, 9), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("UserDetail", sch, rev);
ret.AddConstraint(new DBForeignKeyConstraintDescriptor(new List <string>()
{
"ID"
}, "Common.Principal", new List <string>()
{
"ID"
}),
new DBRevision(rev));
ret.AddField("Username", new DBFieldDescriptor()
{
FieldType = new DBFieldTypeNvarchar(), Size = 512, Nullable = false
},
new DBRevision(rev));
ret.AddConstraint(new DBUniqueConstraintDescriptor("Username"),
new DBRevision(rev));
ret.AddField("Email", new DBFieldDescriptor()
{
FieldType = new DBFieldTypeNvarchar(), Size = 512, Nullable = false
},
new DBRevision(rev));
var fldFullName = ret.AddField("Fullname", new DBFieldDescriptor()
{
FieldType = new DBFieldTypeNvarchar(), Size = 512, Nullable = false
},
new DBRevision(rev));
fldFullName.AddRevision(new DBRevision(new DateTime(2019, 10, 10), 0, eDBRevisionType.Delete));
ret.AddField("FirstName", new DBFieldDescriptor()
{
FieldType = new DBFieldTypeNvarchar(), Size = 512, Nullable = false
},
new DBRevision(rev));
ret.AddField("LastName", new DBFieldDescriptor()
{
FieldType = new DBFieldTypeNvarchar(), Size = 512, Nullable = false
},
new DBRevision(rev));
var fldNickName = ret.AddField("Nickname", new DBFieldDescriptor()
{
FieldType = new DBFieldTypeNvarchar(), Size = 512, Nullable = false
},
new DBRevision(rev));
fldNickName.AddRevision(new DBRevision(new DateTime(2019, 10, 10), 0, eDBRevisionType.Delete));
return(ret);
}
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 CreateTimeLine(IDBModule module)
{
IDBSchema sch = module.AddSchema(module.DefaultSchemaName, new DBSchemaDescriptor());
Drzava(sch);
Grad(sch);
Mjesto(sch);
}
private IDBTable MjestoTroska(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2016, 9, 19), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableIDNaziv("MjestoTroska", sch, rev);
//ret.AddRevision(new DBRevision(new DateTime(2016, 6, 28), 0, eDBRevisionType.Task, null, null));
return(ret);
}
private IDBTable Grad(IDBSchema sch)
{
var ret = sch.AddTable("Grad", new DBTableDescriptor());
ret.AddField("Active", DBMacros.DBFieldActiveDescriptor(),
new DBRevision(new DateTime(2016, 6, 10), 2, eDBRevisionType.Create));
return(ret);
}
private IDBTable Drzava(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableIDNaziv("Drzava", sch, rev);
ret.AddRevision(new DBRevision(new DateTime(2016, 6, 28), 0, eDBRevisionType.Task, FillDrzava, null, 150));
return(ret);
}
private IDBTable Claim(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("Claim", sch, rev);
ret.AddField("Name", DBMacros.DBFieldNazivDescriptor(false), rev);
return(ret);
}
private void tblCases(IDBSchema sch)
{
IDBTable tblCases = sch.AddTable("tblCases", new DBTableDescriptor());
tblCases.AddField("Ctx1MinKul_Opis", new DBFieldDescriptor()
{
FieldType = new DBFieldTypeNvarchar(), Nullable = true, Size = 512
},
new DBRevision(new DateTime(2016, 9, 19), 1, eDBRevisionType.Create));
}
private IDBTable Organization(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2020, 4, 14), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("Organization", sch, new DBRevision(rev));
ret.AddField("Name", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev));
return(ret);
}
private IDBTable Principal(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("Principal", sch, rev);
ret.AddField("Username", DBMacros.DBFieldNazivDescriptor(false), rev);
ret.AddField("SuperAdmin", DBMacros.DBFieldBitDescriptor(false), rev);
return(ret);
}
private string GetColumnSelectors(IDBSchema scheme)
{
List <string> inputs = new List <string>();
for (int i = 0; i < scheme.Columns.Length; i++)
{
inputs.Add($"{scheme.Table}.{scheme.Columns[i].ColumnName}");
}
return(String.Join(",", inputs.ToArray()));
}
private IDBTable PrincipalHasRole(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("PrincipalHasRole", sch, rev);
DBMacros.AddForeignKeyFieldID("PrincipalID", true, ret, sch.Name + ".Principal",
new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create));
DBMacros.AddForeignKeyFieldID("RoleID", true, ret, sch.Name + ".Role",
new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create));
return(ret);
}
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);
}
private IDBTable LineEmployee(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("LineEmployee", sch, new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("LineID", false, ret, sch.Name + ".Line",
new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("EmployeeID", false, ret, sch.Name + ".UserDetail",
new DBRevision(rev));
return(ret);
}
private IDBTable BusinessDay(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2020, 4, 14), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("BusinessDay", sch, new DBRevision(rev));
ret.AddField("ShortName", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev));
ret.AddField("FullName", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev));
ret.AddConstraint(new DBUniqueConstraintDescriptor("ShortName"), new DBRevision(rev));
ret.AddConstraint(new DBUniqueConstraintDescriptor("FullName"), new DBRevision(rev));
return(ret);
}
private void Initialize(SimpleTransaction trans)
{
_ParamToken = trans.DB.ParameterToken;
_Factory = trans.DB.Factory;
_Connection = trans.DB.Connection;
_Transaction = trans.DB.Transaction;
_Schema = trans.DB.Schema;
_DistributeDB = true;
_IsLoggable = trans.DB._IsLoggable;
_DalLogger = trans.DB._DalLogger;
_IsCustomToken = trans.DB.IsCustomToken;
_SessionID = trans.DB._SessionID;
}
private IDBTable LinePhoto(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("LinePhoto", sch, new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("LineID", false, ret, sch.Name + ".Line",
new DBRevision(rev));
ret.AddField("PhotoName", DBMacros.DBFieldNazivDescriptor(false),
new DBRevision(rev));
ret.AddField("PhotoUrl", DBMacros.DBFieldLongTextDescriptor(false),
new DBRevision(rev));
return(ret);
}
private IDBTable Grad(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("Grad", sch, rev);
ret.AddField("Naziv", new DBFieldDescriptor()
{
Nullable = false, FieldType = new DBFieldTypeNvarchar(), Size = 512
},
new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("DrzavaID", true, ret, sch.Name + ".Drzava",
new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create));
return(ret);
}
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"));
}
private static void GenerateTemplate_ViewModel(string templateFileName, List<string> tableList, IDBSchema dbSchema, string modelNamespaceVal, string savePath)
{
DisplayTemplateName(templateFileName);
var templateText = TemplateHelper.ReadTemplate(templateFileName);
foreach (var tableName in tableList)
{
var table = dbSchema.GetTableMetadata(tableName);
if (table.PKs.Count == 0) throw new Exception(string.Format("表{0}:没有设置主键！", tableName));
Display(tableName, table);
dynamic viewbag = new DynamicViewBag();
viewbag.classnameVal = tableName;
viewbag.namespaceVal = modelNamespaceVal;
var outputText = TemplateHelper.Parse(TemplateKey.ViewModel, templateText, table, viewbag);
outputText = TemplateHelper.Clean(outputText, RegexPub.H1());
FileHelper.Save(string.Format(@"{0}\{1}ViewModel.cs", savePath, viewbag.classnameVal), outputText);
}
}
public static IDBObject Create(IDBSchema sch)
{
DBStoredProcedure sp = (DBStoredProcedure)sch.AddDBObject("CleanDataForTesting",
new DBStoredProcedureDescriptor()
{
Parameters = "",
Body = @"
DELETE FROM Flyinline.UserDetail
DELETE FROM Common.principalhasrole
DELETE FROM Common.principal
",
ErrorHandling = true
},
new DBRevision(new DateTime(2019, 9, 20), 0, eDBRevisionType.Create));
return(sp);
}
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);
}
private IDBTable LineLocation(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("LineLocation", sch, new DBRevision(rev));
ret.AddField("Longitude", new DBFieldDescriptor()
{
Size = 18, Precision = 6, FieldType = new DBFieldTypeDecimal(), DefaultValue = "0", Nullable = false
},
new DBRevision(rev));
ret.AddField("Latitude", new DBFieldDescriptor()
{
Size = 18, Precision = 6, FieldType = new DBFieldTypeDecimal(), DefaultValue = "0", Nullable = false
},
new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("CountryID", false, ret, sch.Name + ".Country",
new DBRevision(rev));
ret.AddField("StreetAddress", DBMacros.DBFieldNazivDescriptor(false),
new DBRevision(rev));
ret.AddField("City", DBMacros.DBFieldNazivDescriptor(false),
new DBRevision(rev));
ret.AddField("State", DBMacros.DBFieldNazivDescriptor(true),
new DBRevision(rev));
ret.AddField("ZipCode", DBMacros.DBFieldNazivDescriptor(true),
new DBRevision(rev));
ret.AddConstraint(new DBForeignKeyConstraintDescriptor(new List <string>()
{
"ID"
}, sch.Name + ".Line", new List <string>()
{
"ID"
}),
new DBRevision(rev));
return(ret);
}
