public IActionResult Entry(Trainee model) { if (ModelState.IsValid) { TrainingDbContext db = new TrainingDbContext(); db.Trainees.Add(model); db.SaveChanges(); } return(View()); }
public static void SeedHostDb(TrainingDbContext context) { context.SuppressAutoSetTenantId = true; // Host seed new InitialHostDbBuilder(context).Create(); // Default tenant seed (in host database). new DefaultTenantBuilder(context).Create(); new TenantRoleAndUserBuilder(context, 1).Create(); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, TrainingDbContext context) { //TrainingSeedData.Initialize(context); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); //app.UseWebpackDevMiddleware(new WebpackDevMiddlewareOptions //{ // HotModuleReplacement = true //}); } else { app.UseExceptionHandler("/Home/Error"); } app.UseCors("angular"); app.UseStaticFiles(); using (var serviceScope = app.ApplicationServices.GetService <IServiceScopeFactory>().CreateScope()) { var dbContext = serviceScope.ServiceProvider.GetService <ApplicationDbContext>(); var roleManager = serviceScope.ServiceProvider.GetService <RoleManager <ApplicationRole> >(); var userManager = serviceScope.ServiceProvider.GetService <UserManager <ApplicationUser> >(); dbContext.Database.Migrate(); UserDataSeeder.SeedIdentityData(dbContext, roleManager, userManager); } app.UseAuthentication(); app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller=Home}/{action=Index}/{id?}"); routes.MapSpaFallbackRoute( name: "spa-fallback", defaults: new { controller = "Home", action = "Index" }); }); }
public InitialHostDbBuilder(TrainingDbContext context) { _context = context; }
public SectionRepository(TrainingDbContext context) { db = context; }
public DefaultSettingsCreator(TrainingDbContext context) { _context = context; }
public TopicController(TrainingDbContext dbContext) { context = dbContext; }
public TenantRoleAndUserBuilder(TrainingDbContext context, int tenantId) { _context = context; _tenantId = tenantId; }
public DefaultEditionCreator(TrainingDbContext context) { _context = context; }
public TrainingService(TrainingDbContext dbContext) { _dbContext = dbContext; }
public DefaultLanguagesCreator(TrainingDbContext context) { _context = context; }
public TrainingApplication(TrainingDbContext context, IMapper mapper) { this.Context = context; this.Mapper = mapper; }
public SearchRepository(TrainingDbContext _db) { db = _db; }
//private readonly IHttpContextAccessor _httpContextAccessor; #endregion #region ctor public UnitOfWork(TrainingDbContext _context) { //Disposetransaction = false; Context = _context; // _httpContextAccessor = httpContextAccessor; }
public StudentRepository(TrainingDbContext _context) { db = _context; }
public HostRoleAndUserCreator(TrainingDbContext context) { _context = context; }
public BatchImportController(TrainingDbContext _db) { db = _db; }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { #region DbContext services.AddDbContext <TrainingDbContext>(o => o.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"))); services.AddDbContext <ApplicationDbContext>(o => o.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"))); services.AddScoped <IUnitOfWork, UnitOfWork>(); services.AddScoped <IRepository <TrainingDbContext>, Repository <TrainingDbContext> >(); using (var context = new TrainingDbContext()) { context.Database.Migrate(); } #endregion #region Localization //services.Configure<RequestLocalizationOptions>(o => //{ // var SupportedCultrues = new List<CultureInfo> // { // new CultureInfo("ar-SA"), // new CultureInfo("en-US") // }; // o.DefaultRequestCulture =new RequestCulture( ArCustomCulture.GetCustomCulture(); // //o.DefaultRequestCulture.Culture.DateTimeFormat = new CultureInfo("en-GB").DateTimeFormat; // //o.DefaultRequestCulture.UICulture.DateTimeFormat = new CultureInfo("en-GB").DateTimeFormat; // o.SupportedCultures = SupportedCultrues; // o.SupportedUICultures = SupportedCultrues; // o.RequestCultureProviders = new[] { new RouteDataRequestCultureProvider { } }; //}); services.AddLocalization(options => options.ResourcesPath = nameof(Resource)); #endregion #region Jwt var key = Encoding.ASCII.GetBytes(Jwt.Key); services.AddAuthentication(options => { options.DefaultAuthenticateScheme = JwtBearerDefaults.AuthenticationScheme; options.DefaultChallengeScheme = JwtBearerDefaults.AuthenticationScheme; }) .AddJwtBearer(o => { o.TokenValidationParameters = new Microsoft.IdentityModel.Tokens.TokenValidationParameters { ValidateIssuer = true, ValidateAudience = true, ValidateIssuerSigningKey = true, RequireExpirationTime = true, ValidIssuer = Jwt.Issuer, ValidAudience = Jwt.Audience, IssuerSigningKey = new SymmetricSecurityKey(key) }; }); services.ConfigureApplicationCookie(o => { o.Events = new CookieAuthenticationEvents() { OnRedirectToLogin = (ctx) => { ctx.Response.StatusCode = 401; return(Task.CompletedTask); } }; }); #endregion #region Cors services.AddCors(options => { options.AddPolicy("AllowAll", builder => { builder.AllowAnyOrigin() .AllowAnyMethod() .AllowAnyHeader() .SetIsOriginAllowed(isOriginAllowed: _ => true); //for all origins; //builder.SetIsOriginAllowed(isOriginAllowed: _ => true); //for all origins }); IConfigurationSection CorsWebsite = Configuration.GetSection("AllowAll"); string[] itemArray = CorsWebsite.AsEnumerable().ToList().Where(x => !string.IsNullOrEmpty(x.Value)).Select(x => x.Value).ToArray(); options.AddPolicy("Client4200", builder => { builder.WithOrigins(itemArray).AllowAnyHeader().AllowAnyMethod().AllowCredentials() .SetIsOriginAllowed(isOriginAllowed: _ => true); //for all origins;; }); }); #endregion #region JasonResponseFormate and Filters //o =>{o.Filters.Add(typeof(SetLanguage));} services.AddMvc().AddNewtonsoftJson() .AddNewtonsoftJson(options => options.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore ).AddJsonOptions(opts => { //opts.JsonSerializerOptions.Converters.Add(new JsonStringEnumConverter()); }) ; #endregion #region Swagger services.AddSwaggerGen(); // Register the Swagger generator, defining 1 or more Swagger documents services.AddSwaggerGen(options => { options.SwaggerDoc("v1", new OpenApiInfo { Title = "Api 1", Version = "v1" }); options.OperationFilter <CustomHeaderSwaggerAttribute>(); options.ResolveConflictingActions(apiDescriptions => apiDescriptions.First()); //This line //options.OperationFilter<SwaggerFileOperationFilter>(); options.AddSecurityDefinition(JwtBearerDefaults.AuthenticationScheme, new OpenApiSecurityScheme { Description = "JWT Authorization header using the Bearer scheme. Example: \"Authorization: Bearer {token}\"", In = ParameterLocation.Header, Type = SecuritySchemeType.ApiKey, Scheme = JwtBearerDefaults.AuthenticationScheme, Name = "Authorization" }); options.AddSecurityRequirement(new OpenApiSecurityRequirement() { { new OpenApiSecurityScheme { Reference = new OpenApiReference { Type = ReferenceType.SecurityScheme, Id = "Bearer" }, Scheme = "oauth2", Name = "Bearer", In = ParameterLocation.Header, }, new List <string>() } }); //var security = new Dictionary<string, IEnumerable<string>> //{ //{"Bearer", new string[] { }}, }); #endregion #region Mapping // Auto Mapper Configurations var mappingConfig = new MapperConfiguration(mc => { mc.AddProfile(new MapProfile()); }); IMapper mapper = mappingConfig.CreateMapper(); services.AddSingleton(mapper); #endregion Mapping #region Debdancy Injection services.AddScoped <IJwt, ValidateJwt>(); services.AddScoped <IEncryption, Encryption>(); services.AddSingleton(typeof(IConverter), new SynchronizedConverter(new PdfTools())); services.AddScoped <ICategoryService, CategoryService>(); services.AddScoped <IProductService, ProductService>(); #endregion }
public DefaultAuthorCreator(TrainingDbContext context) { _context = context; }
public UsersController(TrainingDbContext context, IConfiguration configuration) { _context = context; Configuration = configuration; }
public TopicService(TrainingDbContext trainingDb) { _dbContext = trainingDb; }
public DefaultCategoryCreator(TrainingDbContext context) { _context = context; }
public static void Initialize(TrainingDbContext context) { context.Database.EnsureCreated(); if (context.Courses.Any()) { return; } //if (context.Sections.Any()) //{ // return; //} //if (context.Students.Any()) //{ // return; //} var c1 = new Course() { CourseId = Guid.NewGuid(), CourseName = "健康職場講座-姿勢好.運動對.痠痛說掰掰", CourseStartDate = "2017/12/12", CourseEndDate = "2017/12/12", CreateDate = new DateTime(2017, 12, 12), TrainHours = 2.0 }; var c2 = new Course() { CourseId = Guid.NewGuid(), CourseName = "106-1期「大型發電機測試及維護班」", CourseStartDate = "2017/12/04", CourseEndDate = "2017/12/08", CreateDate = new DateTime(2017, 12, 4), TrainHours = 26.5 }; var c3 = new Course() { CourseId = Guid.NewGuid(), CourseName = "106-1期「軸承與潤滑班」", CourseStartDate = "2017/10/05", CourseEndDate = "2017/10/13", CreateDate = new DateTime(2017, 10, 05), TrainHours = 28.5 }; var courses = new Course[] { c1, c2, c3 }; //var SectionM = new Section() //{ // //SectionId=1, // SectionName = "機械組", // SectionCode = "M" //}; //var SectionN = new Section() //{ // //SectionId=1, // SectionName = "核析組", // SectionCode = "N" //}; //var SectionE = new Section() //{ // //SectionId=1, // SectionName = "電氣組", // SectionCode = "E" //}; //var SectionB = new Section() //{ // //SectionId=1, // SectionName = "PE II", // SectionCode = "B" //}; //var SectionA = new Section() //{ // //SectionId=1, // SectionName = "策劃組", // SectionCode = "A" //}; //var SectionJ = new Section() //{ // //SectionId=1, // SectionName = "儀控組", // SectionCode = "J", //}; //var SectionV = new Section() //{ // //SectionId=1, // SectionName = "處長室", // SectionCode = "V", //}; //var SectionO = new Section() //{ // //SectionId=1, // SectionName = "移出", // SectionCode = "O", //}; //var sections = new Section[] //{ // SectionM, // SectionN, // SectionE, // SectionB, // SectionA, // SectionJ, // SectionV, // SectionO //}; //foreach (var course in courses) //{ // context.Courses.Add(course); //} //foreach (var section in sections) //{ // context.Sections.Add(section); //} //context.SaveChanges(); //var SJ1 = new Student() //{ // //StudentId=1, // StudentName = "李念中", // SectionCode = "J", // SectionName = "儀控組", // Section=null, // SectionId = SectionJ.SectionId //}; //var SA1 = new Student() //{ // // StudentId=2, // StudentName = "廖經政", // SectionCode = "A", // SectionName = "策劃組", // Section = null, // SectionId = SectionA.SectionId //}; //var SN1 = new Student() //{ // //StudentId=3, // StudentName = "李宗翰", // SectionCode = "N", // SectionName = "核析組", // Section = null, // SectionId = SectionN.SectionId //}; //var SE1 = new Student() //{ // // // StudentName = "謝文龍", // SectionCode = "E", // SectionName = "電氣組", // Section = null, // SectionId = SectionE.SectionId //}; //var SB1 = new Student() //{ // // // StudentName = "張漢清", // SectionCode = "B", // SectionName = "PE_II", // Section = null, // SectionId = SectionB.SectionId //}; //var SM1 = new Student() //{ // //StudentId=6, // StudentName = "陳政瑋", // SectionCode = "M", // SectionName = "機械組", // Section = null, // SectionId = SectionM.SectionId //}; //var SV1 = new Student() //{ // //StudentId=6, // StudentName = "李瑞蓮", // SectionCode = "V", // SectionName = "處長室", // Section = null, // SectionId = SectionV.SectionId //}; //var SO1 = new Student() //{ // //StudentId=6, // StudentName = "賴逢裕", // SectionCode = "O", // SectionName = "移出", // Section = null, // SectionId = SectionO.SectionId //}; //var students = new Student[] //{ // SJ1, // SE1, // SA1, // SB1, // SN1, // SM1, // SV1, // SO1 //}; //SectionJ.Students = new List<Student>{ // SJ1 //}; //SectionE.Students = new List<Student> { // SE1 //}; //SectionA.Students = new List<Student> { // SA1 //}; //SectionB.Students = new List<Student> { // SB1 //}; //SectionN.Students = new List<Student> { // SN1 //}; //SectionM.Students = new List<Student> { // SM1 //}; //SectionV.Students = new List<Student> { // SV1 //}; //SectionO.Students = new List<Student> { // SO1 //}; //foreach (var student in students) //{ // context.Students.Add(student); //} //context.SaveChanges(); //var sc1 = new StudentCourse //{ // CourseId=c1.CourseId, // StudentId=SJ1.StudentId, //}; //var sc2 = new StudentCourse //{ // CourseId = c1.CourseId, // StudentId = SJ1.StudentId, //}; //var scs = new StudentCourse[] //{ // sc1 //}; //var scs = new StudentCourse[] //{ // sc1, // sc2, //}; //context.StudentCourses.AddRange(scs); //context.SaveChanges(); }
public DefaultTenantBuilder(TrainingDbContext context) { _context = context; }
public TrainingRepository(TrainingDbContext context) { this.context = context; }
public CategoryController(TrainingDbContext dbContext) { context = dbContext; }
public SubjectRepository(TrainingDbContext context) : base(context) { }
public AttendeesController(TrainingDbContext dbContext) { this._dbContext = dbContext; }
public CourseRepository(TrainingDbContext _context) { db = _context; }
public TrainingsController(TrainingDbContext context) { _context = context; }