public static void Start(IApplicationBuilder app)
{
UserAssetServer.Start(app);
SignumControllerFactory.RegisterArea(MethodInfo.GetCurrentMethod());
EntityPackTS.AddExtension += ep =>
{
if (ep.entity.IsNew || !DashboardPermission.ViewDashboard.IsAuthorized())
{
return;
}
var dashboards = DashboardLogic.GetDashboardsEntity(ep.entity.GetType());
if (dashboards.Any())
{
ep.extension.Add("dashboards", dashboards);
}
var result = DashboardLogic.GetEmbeddedDashboard(ep.entity.GetType());
if (result != null)
{
ep.extension.Add("embeddedDashboard", result);
}
};
}
public void LoadFeatures()
{
DashboardLogic logic = new DashboardLogic();
if (AppState.Instance.IsNetworkAvilable())
{
logic.LoadFeaturesOnline();
}
else
{
logic.LoadFeatureOffline();
}
if (AppState.Instance.UserLicenseList != null)
{
foreach (var data in AppState.Instance.UserLicenseList)
{
foreach (var pro in data.Products)
{
foreach (var fet in pro.Features)
{
FeataureList.Add(fet);
}
}
}
}
}
public static void Start(IApplicationBuilder app)
{
UserAssetServer.Start(app);
SignumControllerFactory.RegisterArea(MethodInfo.GetCurrentMethod());
EntityPackTS.AddExtension += ep =>
{
if (ep.entity.IsNew || !DashboardPermission.ViewDashboard.IsAuthorized())
{
return;
}
var dashboards = DashboardLogic.GetDashboardsEntity(ep.entity.GetType());
if (dashboards.Any())
{
ep.extension.Add("dashboards", dashboards);
}
var result = DashboardLogic.GetEmbeddedDashboards(ep.entity.GetType());
if (result != null)
{
ep.extension.Add("embeddedDashboards", result);
}
};
SignumServer.WebEntityJsonConverterFactory.AfterDeserilization.Register((DashboardEntity uq) =>
{
uq.ParseData(q => QueryLogic.Queries.QueryDescription(q.ToQueryName()));
});
}
public Lite <DashboardEntity>?Home()
{
if (TypeAuthLogic.GetAllowed(typeof(DashboardEntity)).MaxUI() == TypeAllowedBasic.None)
{
return(null);
}
var result = DashboardLogic.GetHomePageDashboard();
return(result?.ToLite());
}
public ActionResult Index()
{
if (UserEntity.Current == null)
{
return(RedirectToAction("PublicCatalog"));
}
var panel = DashboardLogic.GetHomePageDashboard();
if (panel != null)
{
return(View(DashboardClient.ViewPrefix.FormatWith("Dashboard"), panel));
}
return(View());
}
public static DashboardResponse ObtenerListado(DashboardLogic Logic)
{
DashboardResponse Response = new DashboardResponse();
Response.CodigoIndicador = Logic.CodigoIndicador;
Response.Anio = Logic.Anio;
Response.Fecha = Logic.Fecha;
Response.TipoPeriodicidad = Logic.TipoPeriodicidad;
Response.Indicador = Logic.Indicador;
Response.Ponderacion = Logic.Ponderacion;
Response.Valor = Logic.Valor;
//Obligatorios
Response.EstadoRegistro = Logic.EstadoRegistro;
Response.NumeroFila = Logic.NumeroRegistro;
Response.FilasTotal = Logic.TotalRegistro;
return(Response);
}
public DashboardWithCachedQueries GetDashboard([FromBody] Lite <DashboardEntity> dashboard)
{
var db = DashboardLogic.RetrieveDashboard(dashboard);
if (db.CacheQueryConfiguration == null)
{
return new DashboardWithCachedQueries {
Dashboard = db, CachedQueries = new List <CachedQueryEntity>()
}
}
;
var cachedQueries = DashboardLogic.GetCachedQueries(dashboard).ToList();
if (db.CacheQueryConfiguration.AutoRegenerateWhenOlderThan is int limit)
{
var maxDate = cachedQueries.Max(a => (DateTime?)a.CreationDate);
if (maxDate == null || maxDate.Value.AddMinutes(limit) < Clock.Now)
{
lock (lockKey)
{
cachedQueries = DashboardLogic.GetCachedQueries(dashboard).ToList();
maxDate = cachedQueries.Max(a => (DateTime?)a.CreationDate);
if (maxDate == null || maxDate.Value.AddMinutes(limit) < Clock.Now)
{
using (UserHolder.UserSession(AuthLogic.SystemUser !))
db.Execute(DashboardOperation.RegenerateCachedQueries);
cachedQueries = DashboardLogic.GetCachedQueries(dashboard).ToList();
}
}
}
}
return(new DashboardWithCachedQueries
{
Dashboard = db,
CachedQueries = cachedQueries,
});
}
}
public ViewResult View(Lite <DashboardEntity> panel, Lite <Entity> currentEntity)
{
DashboardPermission.ViewDashboard.AssertAuthorized();
var cp = DashboardLogic.RetrieveDashboard(panel);
if (cp.EntityType != null)
{
if (currentEntity == null)
{
throw new ArgumentNullException("currentEntity");
}
ViewData["currentEntity"] = currentEntity.Retrieve();
}
return(View(DashboardClient.ViewPrefix.FormatWith("Dashboard"), cp));
}
private async void BuscarDados()
{
try
{
DashboardLogic dL = new DashboardLogic();
var json = await dL.GetPedidosMes();
var pedMes = JsonConvert.DeserializeObject <List <DashboardPedidosMesModel> >(json);
if (pedMes?.Count > 0 && App.current.bboDashboard)
{
VL_VENDIDO = pedMes[0].VL_TOTAL;
QT_ITENS = pedMes[0].QT_TOTITEM;
}
else
{
VL_VENDIDO = 0;
QT_ITENS = 0;
}
}
catch { }
}
public Lite <DashboardEntity>?Home()
{
var result = DashboardLogic.GetHomePageDashboard();
return(result?.ToLite());
}
public void DeleteList(string listname, string user)
{
DashboardLogic logic = new DashboardLogic();
logic.DeleteList(listname, user);
}
public static void Start(string connectionString, bool includeDynamic = true)
{
using (HeavyProfiler.Log("Start"))
using (var initial = HeavyProfiler.Log("Initial"))
{
string? logDatabase = Connector.TryExtractDatabaseNameWithPostfix(ref connectionString, "_Log");
SchemaBuilder sb = new CustomSchemaBuilder { LogDatabaseName = logDatabase, Tracer = initial };
sb.Schema.Version = typeof(Starter).Assembly.GetName().Version!;
sb.Schema.ForceCultureInfo = CultureInfo.GetCultureInfo("en-US");
MixinDeclarations.Register<OperationLogEntity, DiffLogMixin>();
MixinDeclarations.Register<UserEntity, UserEmployeeMixin>();
OverrideAttributes(sb);
var detector = SqlServerVersionDetector.Detect(connectionString);
Connector.Default = new SqlConnector(connectionString, sb.Schema, detector!.Value);
CacheLogic.Start(sb);
}
TypeLogic.Start(sb);
OperationLogic.Start(sb);
ExceptionLogic.Start(sb);
MigrationLogic.Start(sb);
CultureInfoLogic.Start(sb);
FilePathEmbeddedLogic.Start(sb);
EmailLogic.Start(sb, () => Configuration.Value.Email, (et, target) => Configuration.Value.EmailSender);
AuthLogic.Start(sb, "System", null);
AuthLogic.StartAllModules(sb);
ResetPasswordRequestLogic.Start(sb);
UserTicketLogic.Start(sb);
ProcessLogic.Start(sb);
PackageLogic.Start(sb, packages: true, packageOperations: true);
SchedulerLogic.Start(sb);
QueryLogic.Start(sb);
UserQueryLogic.Start(sb);
UserQueryLogic.RegisterUserTypeCondition(sb, AtTestGroup.UserEntities);
UserQueryLogic.RegisterRoleTypeCondition(sb, AtTestGroup.RoleEntities);
ChartLogic.Start(sb);
UserChartLogic.RegisterUserTypeCondition(sb, AtTestGroup.UserEntities);
UserChartLogic.RegisterRoleTypeCondition(sb, AtTestGroup.RoleEntities);
DashboardLogic.Start(sb);
DashboardLogic.RegisterUserTypeCondition(sb, AtTestGroup.UserEntities);
DashboardLogic.RegisterRoleTypeCondition(sb, AtTestGroup.RoleEntities);
ViewLogLogic.Start(sb, new HashSet<Type> { typeof(UserQueryEntity), typeof(UserChartEntity), typeof(DashboardEntity) });
DiffLogLogic.Start(sb, registerAll: true);
ExcelLogic.Start(sb, excelReport: true);
ToolbarLogic.Start(sb);
FileLogic.Start(sb);
TranslationLogic.Start(sb, countLocalizationHits: false);
TranslatedInstanceLogic.Start(sb, () => CultureInfo.GetCultureInfo("en"));
WordTemplateLogic.Start(sb);
MapLogic.Start(sb);
PredictorLogic.Start(sb, () => new FileTypeAlgorithm(f => new PrefixPair(Starter.Configuration.Value.Folders.PredictorModelFolder)));
PredictorLogic.RegisterAlgorithm(CNTKPredictorAlgorithm.NeuralNetwork, new CNTKNeuralNetworkPredictorAlgorithm());
PredictorLogic.RegisterPublication(ProductPredictorPublication.MonthlySales, new PublicationSettings(typeof(OrderEntity)));
EmployeeLogic.Start(sb);
ProductLogic.Start(sb);
CustomerLogic.Start(sb);
OrderLogic.Start(sb);
ShipperLogic.Start(sb);
StartAtTestConfiguration(sb);
TypeConditionLogic.Register<OrderEntity>(AtTestGroup.UserEntities, o => o.Employee == EmployeeEntity.Current);
TypeConditionLogic.Register<EmployeeEntity>(AtTestGroup.UserEntities, e => EmployeeEntity.Current.Is(e));
TypeConditionLogic.Register<OrderEntity>(AtTestGroup.CurrentCustomer, o => o.Customer == CustomerEntity.Current);
TypeConditionLogic.Register<PersonEntity>(AtTestGroup.CurrentCustomer, o => o == CustomerEntity.Current);
TypeConditionLogic.Register<CompanyEntity>(AtTestGroup.CurrentCustomer, o => o == CustomerEntity.Current);
ProfilerLogic.Start(sb,
timeTracker: true,
heavyProfiler: true,
overrideSessionTimeout: true);
if (includeDynamic)
{
}
SetupCache(sb);
Schema.Current.OnSchemaCompleted();
}
public static void Start(string connectionString)
{
string logDatabase = Connector.TryExtractDatabaseNameWithPostfix(ref connectionString, "_Log");
SchemaBuilder sb = new SchemaBuilder();
sb.Schema.Version = typeof(Starter).Assembly.GetName().Version;
sb.Schema.ForceCultureInfo = CultureInfo.GetCultureInfo("en-US");
MixinDeclarations.Register <OperationLogEntity, DiffLogMixin>();
MixinDeclarations.Register <UserEntity, UserEmployeeMixin>();
OverrideAttributes(sb);
SetupDisconnectedStrategies(sb);
DynamicQueryManager dqm = new DynamicQueryManager();
Connector.Default = new SqlConnector(connectionString, sb.Schema, dqm, SqlServerVersion.SqlServer2012);
CacheLogic.Start(sb);
TypeLogic.Start(sb, dqm);
OperationLogic.Start(sb, dqm);
MigrationLogic.Start(sb, dqm);
CultureInfoLogic.Start(sb, dqm);
EmbeddedFilePathLogic.Start(sb, dqm);
SmtpConfigurationLogic.Start(sb, dqm);
EmailLogic.Start(sb, dqm, () => Configuration.Value.Email, et => Configuration.Value.SmtpConfiguration);
AuthLogic.Start(sb, dqm, "System", null);
AuthLogic.StartAllModules(sb, dqm);
ResetPasswordRequestLogic.Start(sb, dqm);
UserTicketLogic.Start(sb, dqm);
SessionLogLogic.Start(sb, dqm);
ProcessLogic.Start(sb, dqm);
PackageLogic.Start(sb, dqm, packages: true, packageOperations: true);
MapLogic.Start(sb, dqm);
SchedulerLogic.Start(sb, dqm);
QueryLogic.Start(sb);
UserQueryLogic.Start(sb, dqm);
UserQueryLogic.RegisterUserTypeCondition(sb, SouthwindGroup.UserEntities);
UserQueryLogic.RegisterRoleTypeCondition(sb, SouthwindGroup.RoleEntities);
ChartLogic.Start(sb, dqm);
UserChartLogic.RegisterUserTypeCondition(sb, SouthwindGroup.UserEntities);
UserChartLogic.RegisterRoleTypeCondition(sb, SouthwindGroup.RoleEntities);
DashboardLogic.Start(sb, dqm);
DashboardLogic.RegisterUserTypeCondition(sb, SouthwindGroup.UserEntities);
DashboardLogic.RegisterRoleTypeCondition(sb, SouthwindGroup.RoleEntities);
ViewLogLogic.Start(sb, dqm, new HashSet <Type> {
typeof(UserQueryEntity), typeof(UserChartEntity), typeof(DashboardEntity)
});
DiffLogLogic.Start(sb, dqm);
ExceptionLogic.Start(sb, dqm);
SMSLogic.Start(sb, dqm, null, () => Configuration.Value.Sms);
SMSLogic.RegisterPhoneNumberProvider <PersonEntity>(p => p.Phone, p => null);
SMSLogic.RegisterDataObjectProvider((PersonEntity p) => new { p.FirstName, p.LastName, p.Title, p.DateOfBirth });
SMSLogic.RegisterPhoneNumberProvider <CompanyEntity>(p => p.Phone, p => null);
NoteLogic.Start(sb, dqm, typeof(UserEntity), /*Note*/ typeof(OrderEntity));
AlertLogic.Start(sb, dqm, typeof(UserEntity), /*Alert*/ typeof(OrderEntity));
FileLogic.Start(sb, dqm);
TranslationLogic.Start(sb, dqm);
TranslatedInstanceLogic.Start(sb, dqm, () => CultureInfo.GetCultureInfo("en"));
HelpLogic.Start(sb, dqm);
WordTemplateLogic.Start(sb, dqm);
EmployeeLogic.Start(sb, dqm);
ProductLogic.Start(sb, dqm);
CustomerLogic.Start(sb, dqm);
OrderLogic.Start(sb, dqm);
ShipperLogic.Start(sb, dqm);
StartSouthwindConfiguration(sb, dqm);
TypeConditionLogic.Register <OrderEntity>(SouthwindGroup.UserEntities, o => o.Employee.RefersTo(EmployeeEntity.Current));
TypeConditionLogic.Register <EmployeeEntity>(SouthwindGroup.UserEntities, e => e == EmployeeEntity.Current);
TypeConditionLogic.Register <OrderEntity>(SouthwindGroup.CurrentCustomer, o => o.Customer == CustomerEntity.Current);
TypeConditionLogic.Register <PersonEntity>(SouthwindGroup.CurrentCustomer, o => o == CustomerEntity.Current);
TypeConditionLogic.Register <CompanyEntity>(SouthwindGroup.CurrentCustomer, o => o == CustomerEntity.Current);
DisconnectedLogic.Start(sb, dqm);
DisconnectedLogic.BackupFolder = @"D:\SouthwindTemp\Backups";
DisconnectedLogic.BackupNetworkFolder = @"D:\SouthwindTemp\Backups";
DisconnectedLogic.DatabaseFolder = @"D:\SouthwindTemp\Database";
ProfilerLogic.Start(sb, dqm,
timeTracker: true,
heavyProfiler: true,
overrideSessionTimeout: true);
SetupCache(sb);
SetSchemaNames(Schema.Current);
if (logDatabase.HasText())
{
SetLogDatabase(sb.Schema, new DatabaseName(null, logDatabase));
}
Schema.Current.OnSchemaCompleted();
}
public static void Register()
{
new Execute(DashboardOperation.Save)
{
CanBeNew = true,
CanBeModified = true,
Execute = (cp, _) => { }
}.Register();
new Delete(DashboardOperation.Delete)
{
Delete = (cp, _) =>
{
var parts = cp.Parts.Select(a => a.Content).ToList();
cp.Delete();
Database.DeleteList(parts);
}
}.Register();
new ConstructFrom <DashboardEntity>(DashboardOperation.Clone)
{
Construct = (cp, _) => cp.Clone()
}.Register();
new Execute(DashboardOperation.RegenerateCachedQueries)
{
CanExecute = c => c.CacheQueryConfiguration == null?ValidationMessage._0IsNotSet.NiceToString(ReflectionTools.GetPropertyInfo(() => c.CacheQueryConfiguration)) : null,
AvoidImplicitSave = true,
Execute = (db, _) =>
{
var cq = db.CacheQueryConfiguration !;
var oldCachedQueries = db.CachedQueries().ToList();
oldCachedQueries.ForEach(a => a.File.DeleteFileOnCommit());
db.CachedQueries().UnsafeDelete();
var definitions = DashboardLogic.GetCachedQueryDefinitions(db).ToList();
var combined = DashboardLogic.CombineCachedQueryDefinitions(definitions);
foreach (var c in combined)
{
var qr = c.QueryRequest;
if (qr.Pagination is Pagination.All)
{
qr = qr.Clone();
qr.Pagination = new Pagination.Firsts(cq.MaxRows + 1);
}
var now = Clock.Now;
Stopwatch sw = Stopwatch.StartNew();
var rt = Connector.CommandTimeoutScope(cq.TimeoutForQueries).Using(_ => QueryLogic.Queries.ExecuteQuery(qr));
var queryDuration = sw.ElapsedMilliseconds;
if (c.QueryRequest.Pagination is Pagination.All)
{
if (rt.Rows.Length == cq.MaxRows)
{
throw new ApplicationException($"The query for {c.UserAssets.CommaAnd(a => a.KeyLong())} has returned more than {cq.MaxRows} rows: " +
JsonSerializer.Serialize(QueryRequestTS.FromQueryRequest(c.QueryRequest), EntityJsonContext.FullJsonSerializerOptions));
}
else
{
rt = new ResultTable(rt.AllColumns(), null, new Pagination.All());
}
}
sw.Restart();
var json = new CachedQueryJS
{
CreationDate = now,
QueryRequest = QueryRequestTS.FromQueryRequest(c.QueryRequest),
ResultTable = rt,
};
var bytes = JsonSerializer.SerializeToUtf8Bytes(json, EntityJsonContext.FullJsonSerializerOptions);
var file = new Entities.Files.FilePathEmbedded(CachedQueryFileType.CachedQuery, "CachedQuery.json", bytes).SaveFile();
var uploadDuration = sw.ElapsedMilliseconds;
new CachedQueryEntity
{
CreationDate = now,
UserAssets = c.UserAssets.ToMList(),
NumColumns = qr.Columns.Count + (qr.GroupResults ? 0 : 1),
NumRows = rt.Rows.Length,
QueryDuration = queryDuration,
UploadDuration = uploadDuration,
File = file,
Dashboard = db.ToLite(),
}.Save();
}
}
}.SetMinimumTypeAllowed(TypeAllowedBasic.Read).Register();
public static void Start(string connectionString, bool isPostgres, string?azureStorageConnectionString, string?broadcastSecret, string?broadcastUrls, bool includeDynamic = true, bool detectSqlVersion = true)
{
AzureStorageConnectionString = azureStorageConnectionString;
using (HeavyProfiler.Log("Start"))
using (var initial = HeavyProfiler.Log("Initial"))
{
StartParameters.IgnoredDatabaseMismatches = new List <Exception>();
StartParameters.IgnoredCodeErrors = new List <Exception>();
string?logDatabase = Connector.TryExtractDatabaseNameWithPostfix(ref connectionString, "_Log");
SchemaBuilder sb = new CustomSchemaBuilder {
LogDatabaseName = logDatabase, Tracer = initial
};
sb.Schema.Version = typeof(Starter).Assembly.GetName().Version !;
sb.Schema.ForceCultureInfo = CultureInfo.GetCultureInfo("en-US");
MixinDeclarations.Register <OperationLogEntity, DiffLogMixin>();
MixinDeclarations.Register <UserEntity, UserEmployeeMixin>();
MixinDeclarations.Register <OrderDetailEmbedded, OrderDetailMixin>();
MixinDeclarations.Register <BigStringEmbedded, BigStringMixin>();
ConfigureBigString(sb);
OverrideAttributes(sb);
if (!isPostgres)
{
var sqlVersion = detectSqlVersion ? SqlServerVersionDetector.Detect(connectionString) : SqlServerVersion.AzureSQL;
Connector.Default = new SqlServerConnector(connectionString, sb.Schema, sqlVersion !.Value);
}
else
{
var postgreeVersion = detectSqlVersion ? PostgresVersionDetector.Detect(connectionString) : null;
Connector.Default = new PostgreSqlConnector(connectionString, sb.Schema, postgreeVersion);
}
CacheLogic.Start(sb, serverBroadcast:
sb.Settings.IsPostgres ? new PostgresBroadcast() :
broadcastSecret != null && broadcastUrls != null ? new SimpleHttpBroadcast(broadcastSecret, broadcastUrls) :
null);/*Cache*/
/* LightDynamic
* DynamicLogic.Start(sb, withCodeGen: false);
* LightDynamic */
DynamicLogicStarter.Start(sb);
if (includeDynamic)//Dynamic
{
DynamicLogic.CompileDynamicCode();
DynamicLogic.RegisterMixins();
DynamicLogic.BeforeSchema(sb);
}//Dynamic
// Framework modules
TypeLogic.Start(sb);
OperationLogic.Start(sb);
ExceptionLogic.Start(sb);
QueryLogic.Start(sb);
// Extensions modules
MigrationLogic.Start(sb);
CultureInfoLogic.Start(sb);
FilePathEmbeddedLogic.Start(sb);
BigStringLogic.Start(sb);
EmailLogic.Start(sb, () => Configuration.Value.Email, (template, target, message) => Configuration.Value.EmailSender);
AuthLogic.Start(sb, "System", "Anonymous"); /* null); anonymous*/
AuthLogic.Authorizer = new SouthwindAuthorizer(() => Configuration.Value.ActiveDirectory);
AuthLogic.StartAllModules(sb, activeDirectoryIntegration: true);
AzureADLogic.Start(sb, adGroups: true, deactivateUsersTask: true);
ResetPasswordRequestLogic.Start(sb);
UserTicketLogic.Start(sb);
SessionLogLogic.Start(sb);
TypeConditionLogic.RegisterCompile <UserEntity>(SouthwindTypeCondition.UserEntities, u => u.Is(UserEntity.Current));
ProcessLogic.Start(sb);
PackageLogic.Start(sb, packages: true, packageOperations: true);
SchedulerLogic.Start(sb);
OmniboxLogic.Start(sb);
UserQueryLogic.Start(sb);
UserQueryLogic.RegisterUserTypeCondition(sb, SouthwindTypeCondition.UserEntities);
UserQueryLogic.RegisterRoleTypeCondition(sb, SouthwindTypeCondition.RoleEntities);
UserQueryLogic.RegisterTranslatableRoutes();
ChartLogic.Start(sb, googleMapsChartScripts: false /*requires Google Maps API key in ChartClient */);
UserChartLogic.RegisterUserTypeCondition(sb, SouthwindTypeCondition.UserEntities);
UserChartLogic.RegisterRoleTypeCondition(sb, SouthwindTypeCondition.RoleEntities);
UserChartLogic.RegisterTranslatableRoutes();
DashboardLogic.Start(sb, GetFileTypeAlgorithm(p => p.CachedQueryFolder));
DashboardLogic.RegisterUserTypeCondition(sb, SouthwindTypeCondition.UserEntities);
DashboardLogic.RegisterRoleTypeCondition(sb, SouthwindTypeCondition.RoleEntities);
DashboardLogic.RegisterTranslatableRoutes();
ViewLogLogic.Start(sb, new HashSet <Type> {
typeof(UserQueryEntity), typeof(UserChartEntity), typeof(DashboardEntity)
});
SystemEventLogLogic.Start(sb);
DiffLogLogic.Start(sb, registerAll: true);
ExcelLogic.Start(sb, excelReport: true);
ToolbarLogic.Start(sb);
ToolbarLogic.RegisterTranslatableRoutes();
SMSLogic.Start(sb, null, () => Configuration.Value.Sms);
NoteLogic.Start(sb, typeof(UserEntity), /*Note*/ typeof(OrderEntity));
AlertLogic.Start(sb, typeof(UserEntity), /*Alert*/ typeof(OrderEntity));
FileLogic.Start(sb);
TranslationLogic.Start(sb, countLocalizationHits: false);
TranslatedInstanceLogic.Start(sb, () => CultureInfo.GetCultureInfo("en"));
HelpLogic.Start(sb);
WordTemplateLogic.Start(sb);
MapLogic.Start(sb);
PredictorLogic.Start(sb, GetFileTypeAlgorithm(p => p.PredictorModelFolder));
PredictorLogic.RegisterAlgorithm(TensorFlowPredictorAlgorithm.NeuralNetworkGraph, new TensorFlowNeuralNetworkPredictor());
PredictorLogic.RegisterPublication(ProductPredictorPublication.MonthlySales, new PublicationSettings(typeof(OrderEntity)));
RestLogLogic.Start(sb);
RestApiKeyLogic.Start(sb);
WorkflowLogicStarter.Start(sb, () => Starter.Configuration.Value.Workflow);
ProfilerLogic.Start(sb,
timeTracker: true,
heavyProfiler: true,
overrideSessionTimeout: true);
// Southwind modules
EmployeeLogic.Start(sb);
ProductLogic.Start(sb);
CustomerLogic.Start(sb);
OrderLogic.Start(sb);
ShipperLogic.Start(sb);
StartSouthwindConfiguration(sb);
TypeConditionLogic.Register <OrderEntity>(SouthwindTypeCondition.CurrentEmployee, o => o.Employee.Is(EmployeeEntity.Current));
if (includeDynamic)//2
{
DynamicLogic.StartDynamicModules(sb);
}//2
SetupCache(sb);
Schema.Current.OnSchemaCompleted();
if (includeDynamic)//3
{
DynamicLogic.RegisterExceptionIfAny();
}//3
}
}
public static void Start(string connectionString, bool isPostgres, bool includeDynamic = true, bool detectSqlVersion = true)
{
using (HeavyProfiler.Log("Start"))
using (var initial = HeavyProfiler.Log("Initial"))
{
StartParameters.IgnoredDatabaseMismatches = new List <Exception>();
StartParameters.IgnoredCodeErrors = new List <Exception>();
string?logDatabase = Connector.TryExtractDatabaseNameWithPostfix(ref connectionString, "_Log");
SchemaBuilder sb = new CustomSchemaBuilder {
LogDatabaseName = logDatabase, Tracer = initial
};
sb.Schema.Version = typeof(Starter).Assembly.GetName().Version !;
sb.Schema.ForceCultureInfo = CultureInfo.GetCultureInfo("en-US");
MixinDeclarations.Register <OperationLogEntity, DiffLogMixin>();
MixinDeclarations.Register <UserEntity, UserEmployeeMixin>();
MixinDeclarations.Register <OrderDetailEmbedded, OrderDetailMixin>();
MixinDeclarations.Register <BigStringEmbedded, BigStringMixin>();
ConfigureBigString(sb);
OverrideAttributes(sb);
if (!isPostgres)
{
var sqlVersion = detectSqlVersion ? SqlServerVersionDetector.Detect(connectionString) : SqlServerVersion.AzureSQL;
Connector.Default = new SqlServerConnector(connectionString, sb.Schema, sqlVersion !.Value);
}
else
{
var postgreeVersion = detectSqlVersion ? PostgresVersionDetector.Detect(connectionString) : null;
Connector.Default = new PostgreSqlConnector(connectionString, sb.Schema, postgreeVersion);
}
CacheLogic.Start(sb, cacheInvalidator: sb.Settings.IsPostgres ? new PostgresCacheInvalidation() : null);
DynamicLogicStarter.Start(sb);
if (includeDynamic)//Dynamic
{
DynamicLogic.CompileDynamicCode();
DynamicLogic.RegisterMixins();
DynamicLogic.BeforeSchema(sb);
}//Dynamic
// Framework modules
TypeLogic.Start(sb);
OperationLogic.Start(sb);
ExceptionLogic.Start(sb);
QueryLogic.Start(sb);
// Extensions modules
MigrationLogic.Start(sb);
CultureInfoLogic.Start(sb);
FilePathEmbeddedLogic.Start(sb);
BigStringLogic.Start(sb);
EmailLogic.Start(sb, () => Configuration.Value.Email, (template, target, message) => Configuration.Value.EmailSender);
AuthLogic.Start(sb, "System", "Anonymous"); /* null); anonymous*/
AuthLogic.StartAllModules(sb);
ResetPasswordRequestLogic.Start(sb);
UserTicketLogic.Start(sb);
SessionLogLogic.Start(sb);
WebAuthnLogic.Start(sb, () => Configuration.Value.WebAuthn);
ProcessLogic.Start(sb);
PackageLogic.Start(sb, packages: true, packageOperations: true);
SchedulerLogic.Start(sb);
OmniboxLogic.Start(sb);
UserQueryLogic.Start(sb);
UserQueryLogic.RegisterUserTypeCondition(sb, RG2Group.UserEntities);
UserQueryLogic.RegisterRoleTypeCondition(sb, RG2Group.RoleEntities);
UserQueryLogic.RegisterTranslatableRoutes();
ChartLogic.Start(sb, googleMapsChartScripts: false /*requires Google Maps API key in ChartClient */);
UserChartLogic.RegisterUserTypeCondition(sb, RG2Group.UserEntities);
UserChartLogic.RegisterRoleTypeCondition(sb, RG2Group.RoleEntities);
UserChartLogic.RegisterTranslatableRoutes();
DashboardLogic.Start(sb);
DashboardLogic.RegisterUserTypeCondition(sb, RG2Group.UserEntities);
DashboardLogic.RegisterRoleTypeCondition(sb, RG2Group.RoleEntities);
DashboardLogic.RegisterTranslatableRoutes();
ViewLogLogic.Start(sb, new HashSet <Type> {
typeof(UserQueryEntity), typeof(UserChartEntity), typeof(DashboardEntity)
});
DiffLogLogic.Start(sb, registerAll: true);
ExcelLogic.Start(sb, excelReport: true);
ToolbarLogic.Start(sb);
ToolbarLogic.RegisterTranslatableRoutes();
FileLogic.Start(sb);
TranslationLogic.Start(sb, countLocalizationHits: false);
TranslatedInstanceLogic.Start(sb, () => CultureInfo.GetCultureInfo("en"));
HelpLogic.Start(sb);
WordTemplateLogic.Start(sb);
MapLogic.Start(sb);
RestLogLogic.Start(sb);
RestApiKeyLogic.Start(sb);
WorkflowLogicStarter.Start(sb, () => Starter.Configuration.Value.Workflow);
ProfilerLogic.Start(sb,
timeTracker: true,
heavyProfiler: true,
overrideSessionTimeout: true);
// RG2 modules
EmployeeLogic.Start(sb);
ProductLogic.Start(sb);
CustomerLogic.Start(sb);
OrderLogic.Start(sb);
ShipperLogic.Start(sb);
ItemLogic.Start(sb);
ItemCategoryLogic.Start(sb);
StartRG2Configuration(sb);
TypeConditionLogic.Register <OrderEntity>(RG2Group.UserEntities, o => o.Employee == EmployeeEntity.Current);
TypeConditionLogic.Register <EmployeeEntity>(RG2Group.UserEntities, e => EmployeeEntity.Current.Is(e));
TypeConditionLogic.Register <OrderEntity>(RG2Group.CurrentCustomer, o => o.Customer == CustomerEntity.Current);
TypeConditionLogic.Register <PersonEntity>(RG2Group.CurrentCustomer, o => o == CustomerEntity.Current);
TypeConditionLogic.Register <CompanyEntity>(RG2Group.CurrentCustomer, o => o == CustomerEntity.Current);
if (includeDynamic)//2
{
DynamicLogic.StartDynamicModules(sb);
}//2
SetupCache(sb);
Schema.Current.OnSchemaCompleted();
if (includeDynamic)//3
{
DynamicLogic.RegisterExceptionIfAny();
}//3
}
}
public IEnumerable <Lite <DashboardEntity> > FromEntityType(string typeName)
{
return(DashboardLogic.GetDashboardsEntity(TypeLogic.GetType(typeName)));
}
public static void Start(bool navBar)
{
if (Navigator.Manager.NotDefined(MethodInfo.GetCurrentMethod()))
{
Navigator.RegisterArea(typeof(DashboardClient));
UserAssetsClient.Start();
UserAssetsClient.RegisterExportAssertLink<DashboardEntity>();
Navigator.AddSettings(new List<EntitySettings>
{
new EntitySettings<DashboardEntity> { PartialViewName = e => AdminViewPrefix.FormatWith("DashboardAdmin") },
new EmbeddedEntitySettings<PanelPartEmbedded>(),
new EntitySettings<UserChartPartEntity>(),
new EntitySettings<UserQueryPartEntity>(),
//new EntitySettings<CountSearchControlPartEntity>(),
//new EmbeddedEntitySettings<CountUserQueryElementEmbedded> { PartialViewName = e => AdminViewPrefix.FormatWith("CountUserQueryElement") },
new EntitySettings<LinkListPartEntity>(),
//new EntitySettings<LinkPartEntity>(),
new EmbeddedEntitySettings<LinkElementEmbedded> { PartialViewName = e => AdminViewPrefix.FormatWith("LinkElement") },
});
//if(navBar)
//{
// Navigator.AddSettings(new List<EntitySettings>
// {
// new EntitySettings<OmniboxPanelPartEmbedded> { },
// new EntitySettings<UserQueryCountPartEntity> { PartialViewName = e => AdminViewPrefix.FormatWith("UserQueryCountPartAdmin") },
// });
// DashboardClient.PanelPartViews.Add(
// typeof(OmniboxPanelPartEmbedded),
// new DashboardClient.PartViews(ViewPrefixOmnibox.FormatWith("OmniboxPanelPart"), ViewPrefixOmnibox.FormatWith("OmniboxPanelPart")));
// DashboardClient.PanelPartViews.Add(
// typeof(UserQueryCountPartEntity),
// new DashboardClient.PartViews(ViewPrefix.FormatWith("UserQueryCountPart"), AdminViewPrefix.FormatWith("UserQueryCountPartAdmin")));
//}
Constructor.Register(ctx => new DashboardEntity { Owner = UserQueryUtils.DefaultOwner() });
LinksClient.RegisterEntityLinks<DashboardEntity>((cp, ctx) => new[]
{
!DashboardPermission.ViewDashboard.IsAuthorized() ? null:
new QuickLinkAction(DashboardMessage.Preview, RouteHelper.New().Action<DashboardController>(cpc => cpc.View(cp, null)))
});
LinksClient.RegisterEntityLinks<Entity>((entity, ctrl) =>
{
if (!DashboardPermission.ViewDashboard.IsAuthorized())
return null;
return DashboardLogic.GetDashboardsEntity(entity.EntityType)
.Select(cp => new DashboardQuickLink(cp, entity)).ToArray();
});
WidgetsHelper.GetEmbeddedWidget += ctx =>
{
if (!DashboardPermission.ViewDashboard.IsAuthorized() || !(ctx.Entity is Entity) || ((Entity)ctx.Entity).IsNew)
return null;
var dashboard = DashboardLogic.GetEmbeddedDashboard(ctx.Entity.GetType());
if (dashboard == null)
return null;
return new DashboardEmbeddedWidget { Dashboard = dashboard, Entity = (Entity)ctx.Entity };
};
}
}
public static void Start(string connectionString)
{
using (HeavyProfiler.Log("Start"))
using (var initial = HeavyProfiler.Log("Initial"))
{
StartParameters.IgnoredDatabaseMismatches = new List <Exception>();
StartParameters.IgnoredCodeErrors = new List <Exception>();
string?logDatabase = Connector.TryExtractDatabaseNameWithPostfix(ref connectionString, "_Log");
SchemaBuilder sb = new CustomSchemaBuilder {
LogDatabaseName = logDatabase, Tracer = initial
};
sb.Schema.Version = typeof(Starter).Assembly.GetName().Version;
sb.Schema.ForceCultureInfo = CultureInfo.GetCultureInfo("en-US");
MixinDeclarations.Register <OperationLogEntity, DiffLogMixin>();
MixinDeclarations.Register <UserEntity, UserEmployeeMixin>();
OverrideAttributes(sb);
var detector = SqlServerVersionDetector.Detect(connectionString);
Connector.Default = new SqlConnector(connectionString, sb.Schema, detector !.Value);
CacheLogic.Start(sb);
DynamicLogicStarter.Start(sb);
DynamicLogic.CompileDynamicCode();
DynamicLogic.RegisterMixins();
DynamicLogic.BeforeSchema(sb);
TypeLogic.Start(sb);
OperationLogic.Start(sb);
ExceptionLogic.Start(sb);
MigrationLogic.Start(sb);
CultureInfoLogic.Start(sb);
FilePathEmbeddedLogic.Start(sb);
SmtpConfigurationLogic.Start(sb);
EmailLogic.Start(sb, () => Configuration.Value.Email, (et, target) => Configuration.Value.SmtpConfiguration);
AuthLogic.Start(sb, "System", null);
AuthLogic.StartAllModules(sb);
ResetPasswordRequestLogic.Start(sb);
UserTicketLogic.Start(sb);
SessionLogLogic.Start(sb);
ProcessLogic.Start(sb);
PackageLogic.Start(sb, packages: true, packageOperations: true);
SchedulerLogic.Start(sb);
QueryLogic.Start(sb);
UserQueryLogic.Start(sb);
UserQueryLogic.RegisterUserTypeCondition(sb, SouthwindGroup.UserEntities);
UserQueryLogic.RegisterRoleTypeCondition(sb, SouthwindGroup.RoleEntities);
ChartLogic.Start(sb);
UserChartLogic.RegisterUserTypeCondition(sb, SouthwindGroup.UserEntities);
UserChartLogic.RegisterRoleTypeCondition(sb, SouthwindGroup.RoleEntities);
DashboardLogic.Start(sb);
DashboardLogic.RegisterUserTypeCondition(sb, SouthwindGroup.UserEntities);
DashboardLogic.RegisterRoleTypeCondition(sb, SouthwindGroup.RoleEntities);
ViewLogLogic.Start(sb, new HashSet <Type> {
typeof(UserQueryEntity), typeof(UserChartEntity), typeof(DashboardEntity)
});
DiffLogLogic.Start(sb, registerAll: true);
ExcelLogic.Start(sb, excelReport: true);
ToolbarLogic.Start(sb);
SMSLogic.Start(sb, null, () => Configuration.Value.Sms);
SMSLogic.RegisterPhoneNumberProvider <PersonEntity>(p => p.Phone, p => null);
SMSLogic.RegisterDataObjectProvider((PersonEntity p) => new { p.FirstName, p.LastName, p.Title, p.DateOfBirth });
SMSLogic.RegisterPhoneNumberProvider <CompanyEntity>(p => p.Phone, p => null);
NoteLogic.Start(sb, typeof(UserEntity), /*Note*/ typeof(OrderEntity));
AlertLogic.Start(sb, typeof(UserEntity), /*Alert*/ typeof(OrderEntity));
FileLogic.Start(sb);
TranslationLogic.Start(sb, countLocalizationHits: false);
TranslatedInstanceLogic.Start(sb, () => CultureInfo.GetCultureInfo("en"));
HelpLogic.Start(sb);
WordTemplateLogic.Start(sb);
MapLogic.Start(sb);
PredictorLogic.Start(sb, () => new FileTypeAlgorithm(f => new PrefixPair(Starter.Configuration.Value.Folders.PredictorModelFolder)));
PredictorLogic.RegisterAlgorithm(CNTKPredictorAlgorithm.NeuralNetwork, new CNTKNeuralNetworkPredictorAlgorithm());
PredictorLogic.RegisterPublication(ProductPredictorPublication.MonthlySales, new PublicationSettings(typeof(OrderEntity)));
RestLogLogic.Start(sb);
RestApiKeyLogic.Start(sb);
WorkflowLogicStarter.Start(sb, () => Starter.Configuration.Value.Workflow);
EmployeeLogic.Start(sb);
ProductLogic.Start(sb);
CustomerLogic.Start(sb);
OrderLogic.Start(sb);
ShipperLogic.Start(sb);
StartSouthwindConfiguration(sb);
TypeConditionLogic.Register <OrderEntity>(SouthwindGroup.UserEntities, o => o.Employee == EmployeeEntity.Current);
TypeConditionLogic.Register <EmployeeEntity>(SouthwindGroup.UserEntities, e => EmployeeEntity.Current.Is(e));
TypeConditionLogic.Register <OrderEntity>(SouthwindGroup.CurrentCustomer, o => o.Customer == CustomerEntity.Current);
TypeConditionLogic.Register <PersonEntity>(SouthwindGroup.CurrentCustomer, o => o == CustomerEntity.Current);
TypeConditionLogic.Register <CompanyEntity>(SouthwindGroup.CurrentCustomer, o => o == CustomerEntity.Current);
ProfilerLogic.Start(sb,
timeTracker: true,
heavyProfiler: true,
overrideSessionTimeout: true);
DynamicLogic.StartDynamicModules(sb);
DynamicLogic.RegisterExceptionIfAny();
SetupCache(sb);
Schema.Current.OnSchemaCompleted();
}
}
public HomeController()
{
dashboardLogic = new DashboardLogic();
}
