public async Task <IActionResult> Create([Bind("Id,Username,Password,FirstName,LastName,Sex,BirthDate,Description,RegistrationDate")] User user) { user.RegistrationDate = DateTime.Now; if (ModelState.IsValid) { _context.Add(user); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(user)); }
static void Main(string[] args) { CreateWebHostBuilder(args).Build().Run(); var optionsBuilder = new DbContextOptionsBuilder <UserManagementDbContext>(); //optionsBuilder.UseNpgsql("Server=10.137.114.199;Database=UserManagement;uid=postgres;pwd=CompanyName@2018"); optionsBuilder.UseNpgsql("Server=127.0.0.1;Database=AdminSite;uid=sa;pwd=sa"); using (UserManagementDbContext context = new UserManagementDbContext(optionsBuilder.Options)) { City ci = new City() { Id = "1", CityName = "cn" }; Capital c = new Capital() { City = ci, other = "2" }; context.Add(c); //Realm r = new Realm(); //r.RlmId = 1; //r.RealmName = "Realm1"; //context.Add<Realm>(r); Realm realm1 = context.Realms.Where(i => EF.Functions.ILike(i.RealmName, "r%")).FirstOrDefault(); Realm realm2 = context.Realms.Where(i => i.RealmName.Contains("realm1")).FirstOrDefault(); //AdminUser user = new AdminUser(); //user.Id = 1; //user.Name = "user1"; //user.Realm = r; //context.Add<AdminUser>(user); //Solution s1 = new Solution(); //s1.SlnId = 1; //s1.SolutionName = "sln1"; //RealmSolution realmSolution = new RealmSolution(); //realmSolution.RlmId = 1; //s1.RealmSolutions.Add(realmSolution); //context.Add(s1); context.SaveChanges(true); //AdminUser us = context.AdminUsers.Include(u=>u.Realm).Where(u => u.Id == 1).FirstOrDefault(); //Realm rl = context.Realms.Where(rlm => rlm.RlmId == 1).FirstOrDefault(); //Realm r2 = new Realm(); //r2.RlmId = 2; //r2.RealmName = "r1"; //context.SaveChanges(true); //Realm realm = context.Realms.Where(r => r.RlmId == 2).FirstOrDefault(); //realm.RealmSolutions = new List<RealmSolution>(); //realm.RealmSolutions.Add(new RealmSolution() { SlnId = 2 }); //context.Update(realm); //context.SaveChanges(true); } }