public void Add(T entity)
{
var addEntity = _efContext.Entry(entity);
addEntity.State = EntityState.Added;
_efContext.SaveChanges();
}
public void Add <T>(params T[] saveObjects) where T : class
{
foreach (var saveObject in saveObjects)
{
_context.Entry(saveObject).State = EntityState.Added;
}
_context.SaveChanges();
}
public void Edit(T entity)
{
_context.Attach(entity);
_context.Entry(entity).State = EntityState.Modified;
_context.SaveChanges();
_context.Entry(entity).State = EntityState.Detached;
}
public virtual void Delete(int id)
{
TEntity entityToDelete = DbSet.Find(id);
if (Context.Entry(entityToDelete).State == EntityState.Detached)
{
DbSet.Attach(entityToDelete);
}
DbSet.Remove(entityToDelete);
}
public virtual T Update(T entity)
{
var obj = _ctx.Set <T>().Find(entity.Id);
if (obj == null)
{
return(Add(entity));
}
_ctx.Entry(obj).CurrentValues.SetValues(entity);
_ctx.SaveChanges();
return(obj);
}
public async Task <IHttpActionResult> PutEmployee(int id, Employee employee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != employee.Id)
{
return(BadRequest());
}
db.Entry(employee).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void Update(Habit habit)
{
var entity = _context.Habits.Find(habit.Id);
_context.Entry(entity).CurrentValues.SetValues(habit);
_context.SaveChanges();
}
// PUT api/<controller>/5
public HttpResponseMessage Put(int id, Avenger Avenger)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
if (id != Avenger.Id)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
_db.Entry(Avenger).State = EntityState.Modified;
try
{
_db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public async Task <IActionResult> PutGame(long id, Game game)
{
if (id != game.Id)
{
return(BadRequest());
}
_context.Entry(game).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!GameExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PutTeamMembers(int id, TeamMembers teamMembers)
{
if (id != teamMembers.Id)
{
return(BadRequest());
}
_context.Entry(teamMembers).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TeamMembersExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PutEmployee(Guid id, Employee employee)
{
if (id != employee.EmployeeId)
{
return(BadRequest());
}
_context.Entry(employee).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IHttpActionResult PutRecipe(int id, Recipe recipe)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != recipe.Id)
{
return(BadRequest());
}
_db.Entry(recipe).State = EntityState.Modified;
try
{
_db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!RecipeExists(id))
{
return(NotFound());
}
throw;
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IActionResult> PutMood(int id, Mood mood)
{
if (id != mood.Id)
{
return(BadRequest());
}
_context.Entry(mood).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MoodExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PutTodoList([FromRoute] int id, [FromBody] TodoList todoList)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != todoList.Id)
{
return(BadRequest());
}
_context.Entry(todoList).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TodoListExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PutOrganization(Guid id, Organization organization)
{
if (id != organization.OrganizationId)
{
return(BadRequest());
}
_context.Entry(organization).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!OrganizationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void Update(User user)
{
var entity = _context.Users.Find(user.Id);
_context.Entry(entity).CurrentValues.SetValues(user);
_context.SaveChanges();
}
public static User AddOrUpdate(User user)
{
var set = db.Users.Update(user).Entity;
db.SaveChanges();
db.Entry(user).State = EntityState.Detached;
return(set);
}
public static Category AddOrUpdate(Category category)
{
var set = db.Categories.Update(category).Entity;
db.SaveChanges();
db.Entry(category).State = EntityState.Detached;
return(set);
}
public static Product AddOrUpdate(Product product)
{
var set = db.Products.Update(product).Entity;
db.SaveChanges();
db.Entry(product).State = EntityState.Detached;
return(set);
}
public static Order AddOrUpdate(Order order)
{
var set = db.Orders.Update(order).Entity;
db.SaveChanges();
db.Entry(order).State = EntityState.Detached;
return(set);
}
public ActionResult Edit([Bind(Include = "Id,Name")] CategoryItem categoryItem)
{
if (ModelState.IsValid)
{
db.Entry(categoryItem).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categoryItem));
}
public void Update(TEntity entity)
{
if (entity == null)
{
throw new ArgumentNullException(nameof(entity));
}
_entities.Attach(entity);
_context.Entry(entity).State = (EntityState)System.Data.Entity.EntityState.Modified;
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Occupation,Name,Birthday")] Employee employee)
{
if (ModelState.IsValid)
{
db.Entry(employee).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public async Task <ActionResult> Edit([Bind(Include = "ClientId,Name,PhoneNumber")] Client client)
{
if (ModelState.IsValid)
{
db.Entry(client).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(client));
}
public ActionResult Edit([Bind(Include = "Id")] Training training)
{
if (ModelState.IsValid)
{
db.Entry(training).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(training));
}
public ActionResult Edit([Bind(Include = "Id,Name,Password")] UserGroup userGroup)
{
if (ModelState.IsValid)
{
db.Entry(userGroup).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userGroup));
}
public ActionResult Edit([Bind(Include = "Id")] PointsFrame pointsFrame)
{
if (ModelState.IsValid)
{
db.Entry(pointsFrame).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pointsFrame));
}
public async Task <IActionResult> PutTeamCheckpoint(int id, TeamCheckpoints item)
{
if (id != item.Id)
{
return(BadRequest());
}
_context.Entry(item).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(NoContent());
}
public ActionResult Edit(
[Bind(Include = "Id,BeginDate,BeginTime,EndDate,EndTime,UnitDescription")] DateTimeItem dateTimeItem)
{
if (ModelState.IsValid)
{
db.Entry(dateTimeItem).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dateTimeItem));
}
public void EfContext_can_CRUD_device_AutoFix()
{
var fix = new Fixture();
fix.Behaviors.Add(new OmitOnRecursionBehavior());
var dev = fix.Build <Device>().Without(x => x.Jobs).Create();
var newDev = fix.Build <Device>().Without(x => x.Jobs).Create();
using (var con = new EfContext())
{
//CREATE
con.Devices.Add(dev);
con.SaveChanges();
}
using (var con = new EfContext())
{
//READ(CREATE)
var loaded = con.Devices.Find(dev.Id);
//Assert.AreEqual(dev.Name + "-", loaded.Name);
loaded.Name.Should().Be(dev.Name);
loaded.Should().BeEquivalentTo(dev, c => c.Excluding(x => x.Id));
//UPDATE
newDev.Id = loaded.Id;
con.Entry(loaded).CurrentValues.SetValues(newDev);
con.SaveChanges();
}
using (var con = new EfContext())
{
//READ(UPDATE)
var loaded = con.Devices.Find(dev.Id);
loaded.Should().BeEquivalentTo(newDev, c => c.Excluding(x => x.Modified));
//DELETE
con.Devices.Remove(loaded);
con.SaveChanges();
}
using (var con = new EfContext())
{
//READ(DELETE)
var loaded = con.Devices.Find(dev.Id);
Assert.IsNull(loaded);
}
}
