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);
}
}
