public async Task <IActionResult> PutServer_Info([FromRoute] int id, [FromBody] server Server_Info) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != Server_Info.Server_ID) { return(BadRequest()); } _context.Entry(Server_Info).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Server_InfoExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutArchivalreq([FromRoute] int id, [FromBody] Archivalreq archivalreq) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != archivalreq.Request_ID) { return(BadRequest()); } _context.Entry(archivalreq).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ArchivalreqExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutSAPPurgeTable([FromRoute] int id, [FromBody] SAPPurgeTable sAPPurgeTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != sAPPurgeTable.TableID) { return(BadRequest()); } _context.Entry(sAPPurgeTable).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SAPPurgeTableExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void repo_test() { using (var db = new db_context()) { db.Database.EnsureCreated(); Assert.IsTrue(db.UserTest == db.Set <UserTest>(), "error1"); var model = new UserTest() { Name = Lib.helper.Com.GetUUID() }; Assert.IsTrue(db.Entry(model).State == EntityState.Detached); db.Set <UserTest>().Attach(model); Assert.IsTrue(db.Entry(model).State == EntityState.Added); model.Name = "fa"; Assert.IsTrue(db.Entry(model).State == EntityState.Added); db.Set <UserTest>().Remove(model); Assert.IsTrue(db.Entry(model).State == EntityState.Detached); db.UserTest.Add(model); Assert.IsTrue(db.Entry(model).State == EntityState.Added); db.SaveChanges(); Assert.IsTrue(db.Entry(model).State == EntityState.Unchanged); model.Name = "xx"; Assert.IsTrue(db.Entry(model).State == EntityState.Modified); db.SaveChanges(); Assert.IsTrue(db.Entry(model).State == EntityState.Unchanged); db.UserTest.Remove(model); Assert.IsTrue(db.Entry(model).State == EntityState.Deleted); db.SaveChanges(); Assert.IsTrue(db.Entry(model).State == EntityState.Detached); var new_user = db.Set <UserTest>().AsNoTrackingQueryable().FirstOrDefault(x => x.Name == "xx"); Assert.IsTrue(db.Entry(new_user).State == EntityState.Detached); new_user = db.Set <UserTest>().AsTracking().FirstOrDefault(x => x.Name == "xx"); Assert.IsTrue(db.Entry(new_user).State == EntityState.Unchanged); } var collection = new ServiceCollection(); collection.AddTransient(typeof(IEFRepository <>), typeof(Repo <>)); var provider = collection.BuildServiceProvider().SetAsRootServiceProvider(); using (var user_repo = provider.Resolve_ <IEFRepository <UserTest> >()) { user_repo.Insert(new UserTest() { Name = "xx" }); user_repo.Insert(new UserTest() { Name = "xx" }); user_repo.Insert(new UserTest() { Name = "xx" }); user_repo.Insert(new UserTest() { Name = "xx" }); var m = user_repo.QueryOne(x => x.Name == "xx"); m.Name += "-dd"; var effected = user_repo.Update(m); Assert.IsTrue(effected > 0); } }