public static void Should_not_throw_DbUpdateException() { var options = new DbContextOptionsBuilder() .UseSqlServer($"Data Source=(local);Initial Catalog=Test_{nameof(GH15666_Explicit)};Integrated Security=SSPI;").Options; using (var db = new TestContext(options)) { db.Database.EnsureDeleted(); db.Database.EnsureCreated(); var counterparty = new Counterparty() { Name = "Foo" }; db.Add(counterparty); db.SaveChanges(); var left = new FollowUpInteraction() { InteractedWithCounterparty = counterparty }; db.Add(left); db.SaveChanges(); } }
public static void Should_not_throw_InvalidOperationException_when_using_enum_as_discriminator(bool applyColumnType) { var options = new DbContextOptionsBuilder() .UseSqlServer($"Data Source=(local);Initial Catalog=Test_{nameof(GH11454)}_{applyColumnType};Integrated Security=SSPI;").Options; using (var db = new TestContext(options, applyColumnType)) { db.Database.EnsureDeleted(); db.Database.EnsureCreated(); // TODO write save logic var left = new Left() { }; db.Add(left); var right = new Right() { }; db.Add(right); db.SaveChanges(); } }
public IActionResult Create(User user) { if (ModelState.IsValid) { if (dbContext.Users.Any(u => u.Email == user.Email)) { ModelState.AddModelError("Email", "Email already in use!"); return(View("Register")); } if (dbContext.Users.Any(u => u.Username == user.Username)) { ModelState.AddModelError("Username", "Username already in use!"); return(View("Register")); } PasswordHasher <User> Hasher = new PasswordHasher <User>(); user.Password = Hasher.HashPassword(user, user.Password); dbContext.Add(user); dbContext.SaveChanges(); HttpContext.Session.SetInt32("UserId", user.UserId); return(RedirectToAction("HomePage")); } else { return(View("Register")); } }
public static void One_Child_TablePerHierarchy_SanityCheck(bool applyColumnType) { var options = new DbContextOptionsBuilder() .UseSqlServer($"Data Source=(local);Initial Catalog=Test_{nameof(ProgramOneChildTphSanityCheck)}_{applyColumnType};Integrated Security=SSPI;").Options; using (var db = new TestContext(options, applyColumnType)) { db.Database.EnsureDeleted(); db.Database.EnsureCreated(); // TODO write save logic var goodChild = new GoodChild() { GoodChildData = Random30Characters() }; db.Add(goodChild); var badChild = new BadChild() { }; db.Add(badChild); db.SaveChanges(); } }
public static void One_TablePerHierarchy_To_One_TablePerHierarchy_Different_Discriminator_Names_With_Identity_Insert() { var options = new DbContextOptionsBuilder() .UseSqlServer($"Data Source=(local);Initial Catalog=Test_{nameof(ProgramOneTphToOneTphDifferentDiscriminatorNamesWithIdentityInsert)};Integrated Security=SSPI;").Options; using (var db = new TestContext(options)) { db.Database.EnsureDeleted(); db.Database.EnsureCreated(); // TODO write save logic var goodChild = new GoodChild() { Parent = new GoodParent() { }, GoodChildData = Random30Characters() }; db.Add(goodChild); var badChild = new BadChild() { Parent = new BadParent() { }, BadChildData = Random30Characters() }; db.Add(badChild); var goodParent = new GoodParent() { Child = new GoodChild() { GoodChildData = Random30Characters() }, GoodParentData = Random30Characters() }; db.Add(goodParent); var badParent = new BadParent() { Child = new BadChild() { BadChildData = Random30Characters() }, BadParentData = Random30Characters() }; db.Add(badParent); db.SaveChanges(); } }
public bool Check(Guid userId, string path) { //if (CheckDuplicateCall(userId, path)) return false; //Check for duplicate calls var requestLimit = GetLimit(path); var timeDiff = GetDiff(path); var requests = _context.Requests.Where(r => r.UserId == userId && r.RequestTime > timeDiff).Select(r => r).ToList(); if (requests.Count <= requestLimit) { var request = new Request() { UserId = userId, Path = path, RequestTime = DateTime.Now }; _context.Add(request); _context.SaveChanges(); _context.Dispose(); return(true); } else { return(false); } }
public static void Should_not_throw_InvalidOperationException_when_using_enum_as_discriminator(ConversionStrategy conversionStrategy, bool applyColumnType) { var options = new DbContextOptionsBuilder() .UseSqlServer($"Data Source=(local);Initial Catalog=Test_{nameof(MsftDocsValueConversionExample)}_{conversionStrategy}_{applyColumnType};Integrated Security=SSPI;").Options; using (var db = new TestContext(options, conversionStrategy, applyColumnType)) { db.Database.EnsureDeleted(); db.Database.EnsureCreated(); // TODO write save logic var rider = new Rider() { Mount = EquineBeast.Horse }; db.Add(rider); db.SaveChanges(); var sameRider = db.Set <Rider>().FirstOrDefault(r => r.Id == rider.Id); Assert.True(sameRider != null); var sameRider2 = db.Set <Rider>().FirstOrDefault(r => r.Mount == EquineBeast.Horse); Assert.True(sameRider2 != null); } }
public void WithDbUpdateExceptionDestructurerShouldNotLogDbValues() { // Arrange var jsonWriter = new StringWriter(); ILogger logger = new LoggerConfiguration() .Enrich.WithExceptionDetails(new DestructuringOptionsBuilder().WithDefaultDestructurers().WithDestructurers(new[] { new TestDbUpdateExceptionDestructurer() })) .WriteTo.Sink(new TestTextWriterSink(jsonWriter, new JsonFormatter())) .CreateLogger(); using var ctx = new TestContext(); ctx.Database.EnsureDeleted(); ctx.Database.EnsureCreated(); var entry = ctx.Add(new User { UserId = Guid.NewGuid().ToString(), }); // Act logger.Error(new TestDbUpdateException("DbUpdate Error", entry), "Error"); // Assert var writtenJson = jsonWriter.ToString(); writtenJson.Should().NotContain(TestContext.UserIdIDoNotWantToSee); }
public async Task <IActionResult> Create([Bind("MgaaId,MgaaMbdcClasse,MgaaMatricola,MgaaDescr,MgaaNote,MgaaDataIns,MgaaDataUltMod")] MgAnaArt mgAnaArt) { try { if (ModelState.IsValid) { var emptyComponent = new MgAnaArt(); _context.Add(mgAnaArt); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } } catch (DbUpdateException ex) { string msg = "Unable to save changes. " + "Try again, and if the problem persists " + "see your system administrator."; if (ex.InnerException.Message.Contains("UNIQUE")) { msg = "Attribute Code must be unique"; } //Log the error (uncomment ex variable name and write a log. ModelState.AddModelError("", msg); } return(View(mgAnaArt)); }
public async Task ExecuteAsync_does_not_call_Commit_if_existing_transaction(bool async) { using (var context = new TestContext()) { var connection = SetupConnection(context); var transaction = new FakeDbTransaction(connection); context.Database.UseTransaction(transaction); context.Add( new Foo { Id = "1" }); if (async) { await context.SaveChangesAsync(); } else { context.SaveChanges(); } Assert.Empty(connection.DbTransactions); Assert.Equal(0, transaction.CommitCount); } }
public override void PreWebTest(object sender, PreWebTestEventArgs e) { ITestContext context = new TestContext(e, AuthenticationInfo.Authorization); context.Add(TestContextConst.BaseUri, e.WebTest.Context[TestContextConst.BaseUri]); context.SetEventArgs(e); e.WebTest.Context[TestContextConst.ContextKey] = context; //TestContext.Context = context; //TestContext.Context.SetEventArgs(e); base.PreWebTest(sender, e); string loginUri = TemplateHelper.CompileTemplate(this.Url, context); var loginRequest = new LoginRequest(this.UserName, this.Password); IConnector connector = new RESTConnector(); IResponseData <LoginResponse> response = connector.Post <LoginRequest, LoginResponse>(loginUri, loginRequest); if (response.HasError()) { e.WebTest.Stop(); return; } e.WebTest.Context.Add(LoadTestConst.Authorization, response.Data.Authorization); AuthenticationInfo.Authorization = new Authorization(response.Data.Authorization, response.Data.AuthToken); context = e.WebTest.Context[TestContextConst.ContextKey] as ITestContext; context.SetAuthorization(AuthenticationInfo.Authorization); }
public async Task Test1() { var connection = new SqliteConnection("DataSource=:memory:"); connection.Open(); try { var options = new DbContextOptionsBuilder <TestContext>() .UseSqlite(connection); using (var context = new TestContext(options.Options)) { await context.Database.EnsureCreatedAsync(); } var org1Id = Guid.NewGuid(); var user1Id = Guid.NewGuid(); using (var context = new TestContext(options.Options)) { context.Add(new OrganisationRecord { Id = org1Id, Name = "Org 1", }); context.Add(new UserRecord { OrganisationId = org1Id, Id = user1Id, Name = "user 1", }); await context.SaveChangesAsync(); } using (var context = new TestContext(options.Options)) { } } finally { connection.Close(); } }
public Response <Client> Save(Client client) { try { _context.Add(client); _context.SaveChanges(); return(new Response <Client>(client)); } catch (Exception e) { return(new Response <Client>($"Error del aplicacion: {e.Message}")); } }
public async Task <IActionResult> Create([Bind("ID,UnitName")] Unit unit) { if (ModelState.IsValid) { _context.Add(unit); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(unit)); }
public async Task <IActionResult> Create([Bind("MbmgId,MbmgMag,MbmgDescr,MbmgDataFinVal,MbmgCode")] MbMag mbMag) { if (ModelState.IsValid) { _context.Add(mbMag); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(mbMag)); }
public async Task <IActionResult> Create([Bind("Id,MovieName,Genre,Rating,ReleaseYear,ImdbLink")] MovieList movieList) { if (ModelState.IsValid) { _context.Add(movieList); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(movieList)); }
public async Task <IActionResult> Create([Bind("ID,Name,Uri")] ApiModel apiModel) { if (ModelState.IsValid) { _context.Add(apiModel); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(apiModel)); }
public async Task <IActionResult> Create([Bind("Id,Question,Answer1,Answer2,Answer3,Answer4,RightAnswer,Notification")] Test test) { if (ModelState.IsValid) { _context.Add(test); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(test)); }
public async Task <IActionResult> Create([Bind("PkanId,PkanNum,PkanData,PkanDesc,PkanNote,PkanScaric,PkanYear")] PkAnag pkAnag) { if (ModelState.IsValid) { _context.Add(pkAnag); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(pkAnag)); }
public async Task <IActionResult> Create([Bind("ProductId,Name,Category,Color,UnitPrice,AvailableQuantity,CratedDate")] Products products) { if (ModelState.IsValid) { _context.Add(products); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(products)); }
public async Task <IActionResult> Create([Bind("ID,Name,Variables,Urls")] TestModel testModel) { if (ModelState.IsValid) { _context.Add(testModel); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(testModel)); }
public async Task <IActionResult> Create([Bind("Id,Description,IsEnabled")] Permission permission) { if (ModelState.IsValid) { _context.Add(permission); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(permission)); }
public async Task <IActionResult> Create([Bind("Id,FirstName,LastName,Age,BirthDate,IsEnabled")] User user) { if (ModelState.IsValid) { _context.Add(user); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(user)); }
public async Task <IActionResult> Create([Bind("ID,Name,Vorname,Email")] User user) { if (ModelState.IsValid) { _context.Add(user); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(user)); }
public async Task <IActionResult> Create([Bind("StandardId,StandardName,StandardYear")] Standard standard) { if (ModelState.IsValid) { _context.Add(standard); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(standard)); }
public async Task <IActionResult> Create([Bind("Id,Name")] ClassM classM) { if (ModelState.IsValid) { _context.Add(classM); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(classM)); }
public async Task <IActionResult> Create([Bind("Id,text")] Table1 table1) { if (ModelState.IsValid) { _context.Add(table1); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(table1)); }
public async Task <IActionResult> Create([Bind("Sn,Name,Hight,Weight,Birthday,Photo,Memo,ClassId")] Student student) { if (ModelState.IsValid) { _context.Add(student); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["ClassId"] = new SelectList(_context.ClassMs, "Id", "Name", student.ClassId); return(View(student)); }
public async Task <IActionResult> Create([Bind("MgauId,MgauMbmgId,MgauCodice,MgauCodCompl,MgauDescr,MgauTreeCtrl,MgauDataIns,MgauLivello,MgauProfondita,MgauLarghezza,MgauAltezza,MgauBloccata,MgauPrenotata,MgauUbiDef")] MgAnaUbicazioni mgAnaUbicazioni) { if (ModelState.IsValid) { _context.Add(mgAnaUbicazioni); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["MgauMbmgId"] = new SelectList(_context.MbMag, "MbmgId", "MbmgCode", mgAnaUbicazioni.MgauMbmgId); return(View(mgAnaUbicazioni)); }
public async Task <IActionResult> Create([Bind("SId,SName,SAddress,StandardId")] Student student) { if (ModelState.IsValid) { _context.Add(student); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["StandardId"] = new SelectList(_context.Standards, "StandardId", "StandardName", student.StandardId); return(View(student)); }