public SystemLogService(BackendDBContext context, IMapper mapper,
ILogger <SystemLogService> logger)
{
this.context = context;
Mapper = mapper;
Logger = logger;
}
public MyUserPasswordHistoryService(BackendDBContext context, IMapper mapper,
ILogger <MyUserPasswordHistoryService> logger)
{
this.context = context;
Mapper = mapper;
Logger = logger;
}
public FlowHistoryService(BackendDBContext context, IMapper mapper,
ILogger <FlowHistoryService> logger)
{
this.context = context;
Mapper = mapper;
Logger = logger;
}
public AccountPolicyService(BackendDBContext context, IMapper mapper,
ILogger <AccountPolicyService> logger)
{
this.context = context;
Mapper = mapper;
Logger = logger;
}
public MenuRoleService(BackendDBContext context, IMapper mapper,
ILogger <MenuRoleService> logger)
{
this.context = context;
Mapper = mapper;
Logger = logger;
}
static async Task Main(string[] args)
{
#region 取得 Blazor 專案內的連線字串
IConfiguration config = new ConfigurationBuilder()
.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true)
.Build();
string connectionString = config.GetConnectionString(MagicHelper.DefaultConnectionString);
#endregion
#region 使用取得的連線字串，建立 DbContext
DbContextOptions <BackendDBContext> options = new DbContextOptionsBuilder <BackendDBContext>()
.UseSqlServer(connectionString)
.Options;
BackendDBContext context = new BackendDBContext(options);
#endregion
Random random = new Random();
Console.WriteLine("請輸入任意鍵後");
Console.WriteLine("開始執行 Database Initialization");
Console.ReadKey();
#region 適用於 Code First ，刪除資料庫與移除資料庫
Console.WriteLine($"請稍後，刪除資料庫中");
await context.Database.EnsureDeletedAsync();
Console.WriteLine($"請稍後，建立資料庫中");
await context.Database.EnsureCreatedAsync();
#endregion
await GenerateTestDataAsync(context, random);
}
public ChangePasswordService(BackendDBContext context, IMapper mapper,
AuthenticationStateProvider authenticationStateProvider)
{
this.context = context;
Mapper = mapper;
AuthenticationStateProvider = authenticationStateProvider;
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, BackendDBContext db)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
//https://stackoverflow.com/questions/50507668/database-migrate-creating-database-but-not-tables-ef-net-core-2
db.Database.Migrate(); //Udfør migration fra koden
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseCookiePolicy();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
//https://stackoverflow.com/questions/47101155/ambiguites-in-aspnet-core-2-0-using-swagger-in-web-api
app.UseSwagger();
app.UseSwaggerUI(c =>
{
c.SwaggerEndpoint("/swagger/v1/swagger.json", "F19ITONK Haandvaerker API V1");
});
}
public static void Clean <T>(BackendDBContext context) where T : class
{
foreach (var fooXItem in context.Set <T>().Local)
{
context.Entry(fooXItem).State = EntityState.Detached;
}
}
public CategoryMainService(BackendDBContext context, IMapper mapper,
ILogger <CategoryMainService> logger)
{
this.context = context;
Mapper = mapper;
Logger = logger;
}
public PasswordPolicyService(BackendDBContext context, IMapper mapper,
ILogger <PasswordPolicyService> logger)
{
this.context = context;
Mapper = mapper;
Logger = logger;
}
public PhaseCategoryService(BackendDBContext context, IMapper mapper,
ILogger <PhaseCategoryService> logger)
{
this.context = context;
Mapper = mapper;
Logger = logger;
}
public PolicyHeaderViewModel(IPolicyHeaderService CurrentService,
BackendDBContext context, IMapper Mapper,
TranscationResultHelper transcationResultHelper)
{
this.CurrentService = CurrentService;
this.context = context;
mapper = Mapper;
TranscationResultHelper = transcationResultHelper;
PolicyHeaderSort.Initialization(SortConditions);
#region 工具列按鈕初始化
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdAdd,
Text = "新增",
TooltipText = "新增",
Type = ItemType.Button,
PrefixIcon = "mdi mdi-plus-thick",
Align = ItemAlign.Left,
});
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdRefresh,
Text = "重新整理",
TooltipText = "重新整理",
PrefixIcon = "mdi mdi-refresh",
Align = ItemAlign.Left,
});
Toolbaritems.Add("Search");
#endregion
}
public MailQueueViewModel(IMailQueueService CurrentService,
BackendDBContext context, IMapper Mapper,
TranscationResultHelper transcationResultHelper)
{
this.CurrentService = CurrentService;
this.context = context;
mapper = Mapper;
TranscationResultHelper = transcationResultHelper;
MailQueueSort.Initialization(SortConditions);
MailQueueStatusCondition.Initialization(MailQueueStatusConditions);
CurrentMailQueueStatusCondition.Id = MailQueueStatusConditions[0].Id;
CurrentMailQueueStatusCondition.Title = MailQueueStatusConditions[0].Title;
FilterMailQueueStatusCondition = CurrentMailQueueStatusCondition.Id;
#region 工具列按鈕初始化
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdAdd,
Text = "新增",
TooltipText = "新增",
Type = ItemType.Button,
PrefixIcon = "mdi mdi-plus-thick",
Align = ItemAlign.Left,
});
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdRefresh,
Text = "重新整理",
TooltipText = "重新整理",
PrefixIcon = "mdi mdi-refresh",
Align = ItemAlign.Left,
});
Toolbaritems.Add("Search");
#endregion
}
public ProductService(BackendDBContext context, IMapper mapper,
ILogger <ProductService> logger)
{
this.context = context;
Mapper = mapper;
Logger = logger;
}
public WorkOrderService(BackendDBContext context, IMapper mapper,
ILogger <WorkOrderService> logger)
{
this.context = context;
Mapper = mapper;
Logger = logger;
}
private static async Task SetIdentityInsertAsync <T>([NotNull] BackendDBContext context, bool enable)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
//var entityType = context.Model.FindEntityType(typeof(T).Name);
// We need dbcontext to access the models
var models = context.Model;
// Get all the entity types information
var entityTypes = models.GetEntityTypes();
// T is Name of class
var entityType = entityTypes.First(t => t.ClrType == typeof(T));
var value = enable ? "ON" : "OFF";
try
{
var cmd = $"SET IDENTITY_INSERT {entityType.GetTableName()} {value}";
await context.Database.ExecuteSqlRawAsync(cmd);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public ProductViewModel(IProductService CurrentService,
BackendDBContext context,
IMapper Mapper)
{
this.CurrentService = CurrentService;
this.context = context;
mapper = Mapper;
ProductSort.Initialization(SortConditions);
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdAdd,
Text = "新增",
TooltipText = "新增",
Type = ItemType.Button,
PrefixIcon = "mdi mdi-plus-thick",
Align = ItemAlign.Left,
});
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdRefresh,
Text = "重新整理",
TooltipText = "重新整理",
PrefixIcon = "mdi mdi-refresh",
Align = ItemAlign.Left,
});
Toolbaritems.Add("Search");
}
public PolicyDetailService(BackendDBContext context, IMapper mapper,
ILogger <PolicyDetailService> logger)
{
this.context = context;
Mapper = mapper;
Logger = logger;
}
private static async Task GenerateTestDataAsync(BackendDBContext context, Random random)
{
context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
#region 產生開發用的測試資料
//await GenerateMyUserAsync(context, random);
#endregion
}
public MyUserService(BackendDBContext context, IMapper mapper,
IConfiguration configuration, ILogger <MyUserService> logger)
{
this.context = context;
Mapper = mapper;
Configuration = configuration;
Logger = logger;
}
public FlowInboxService(BackendDBContext context, IMapper mapper,
ILogger <FlowInboxService> logger, UserHelper currentUserHelper)
{
this.context = context;
Mapper = mapper;
Logger = logger;
CurrentUserHelper = currentUserHelper;
}
public DatabaseInitService(BackendDBContext context, IMapper mapper,
IConfiguration configuration, ILogger <DatabaseInitService> logger,
IHttpContextAccessor httpContextAccessor, SystemLogHelper systemLogHelper)
{
this.context = context;
Mapper = mapper;
Configuration = configuration;
Logger = logger;
HttpContextAccessor = httpContextAccessor;
SystemLogHelper = systemLogHelper;
}
public static async Task SaveChangesWithIdentityInsertAsync <T>([NotNull] this BackendDBContext context)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
await using var transaction = await context.Database.BeginTransactionAsync();
await context.EnableIdentityInsertAsync <T>();
await context.SaveChangesAsync();
await context.EnableIdentityInsertAsync <T>();
await transaction.CommitAsync();
}
private static async Task GenerateMyUserAsync(BackendDBContext context, Random random)
{
List <MyUser> users = new List <MyUser>();
for (int i = 1; i < 30; i++)
{
MyUser MyUser = new MyUser()
{
Account = $"user{i}",
Name = $"user{i}",
Password = "******",
};
users.Add(MyUser);
}
await context.BulkInsertAsync(users);
}
public FlowMasterViewModel(IFlowMasterService CurrentService,
BackendDBContext context, IMapper Mapper,
UserHelper currentUserHelper,
TranscationResultHelper transcationResultHelper,
CurrentUser currentUser)
{
this.CurrentService = CurrentService;
this.context = context;
mapper = Mapper;
CurrentUserHelper = currentUserHelper;
TranscationResultHelper = transcationResultHelper;
CurrentUser = currentUser;
FlowMasterSort.Initialization(SortConditions);
#region 工具列按鈕初始化
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdAdd,
Text = "新增",
TooltipText = "新增",
Type = ItemType.Button,
PrefixIcon = "mdi mdi-plus-thick",
Align = ItemAlign.Left,
});
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdRefresh,
Text = "重新整理",
TooltipText = "重新整理",
PrefixIcon = "mdi mdi-refresh",
Align = ItemAlign.Left,
});
Toolbaritems.Add("Search");
#endregion
#region 互動式彈出功能表 ContextMenu 初始化
ContextMenuItems.Add(new ContextMenuItemModel
{
Text = "查看來源記錄",
Target = ".e-content",
Id = "查看來源記錄",
IconCss = "mdi mdi-file-find",
});
#endregion
}
public ExceptionRecordRazorModel(IExceptionRecordService CurrentService,
BackendDBContext context,
IMapper Mapper)
{
this.CurrentService = CurrentService;
this.context = context;
mapper = Mapper;
ExceptionRecordSort.Initialization(SortConditions);
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdRefresh,
Text = "重新整理",
TooltipText = "重新整理",
PrefixIcon = "mdi mdi-refresh",
Align = ItemAlign.Left,
});
Toolbaritems.Add("Search");
}
public static async Task SaveChangesWithoutIdentityInsertAsync <T>([NotNull] this BackendDBContext context)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
await using var transaction = await context.Database.BeginTransactionAsync();
await context.EnableIdentityInsertAsync <T>();
try
{
await context.SaveChangesAsync();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
await context.EnableIdentityInsertAsync <T>();
await transaction.CommitAsync();
}
public FlowHistoryViewModel(IFlowHistoryService CurrentService,
BackendDBContext context, IMapper Mapper,
TranscationResultHelper transcationResultHelper)
{
this.CurrentService = CurrentService;
this.context = context;
mapper = Mapper;
TranscationResultHelper = transcationResultHelper;
FlowHistorySort.Initialization(SortConditions);
#region 工具列按鈕初始化
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdRefresh,
Text = "重新整理",
TooltipText = "重新整理",
PrefixIcon = "mdi mdi-refresh",
Align = ItemAlign.Left,
});
Toolbaritems.Add("Search");
#endregion
}
public MenuDataViewModel(IMenuDataService CurrentService,
BackendDBContext context, IMapper Mapper,
TranscationResultHelper transcationResultHelper)
{
this.CurrentService = CurrentService;
this.context = context;
mapper = Mapper;
TranscationResultHelper = transcationResultHelper;
MenuDataSort.Initialization(SortConditions);
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdAdd,
Text = "新增",
TooltipText = "新增",
Type = ItemType.Button,
PrefixIcon = "mdi mdi-plus-thick",
Align = ItemAlign.Left,
});
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdRefresh,
Text = "重新整理",
TooltipText = "重新整理",
PrefixIcon = "mdi mdi-refresh",
Align = ItemAlign.Left,
});
Toolbaritems.Add(new ItemModel()
{
Id = ButtonIdHelper.ButtonIdReOrder,
Text = "重新編號",
TooltipText = "重新編號",
PrefixIcon = "mdi mdi-order-numeric-ascending",
Align = ItemAlign.Left,
});
Toolbaritems.Add("Search");
}
