public async Task <IActionResult> PutCategory([FromRoute] int id, [FromBody] Category category)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != category.Id)
{
return(BadRequest());
}
_context.Entry(category).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CategoryExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void Update(Variant item)
{
var variant = _context.Variants.FirstOrDefault(o => o.Id == item.Id);
bool isModified = false;
if (variant.ModificationId != item.ModificationId)
{
variant.ModificationId = item.ModificationId;
isModified = true;
}
if (variant.ItemId != item.ItemId)
{
variant.ItemId = item.ItemId;
isModified = true;
}
if (variant.New != item.New)
{
variant.New = item.New;
isModified = true;
}
if (isModified)
{
_context.Entry(variant).State = EntityState.Modified;
_context.SaveChanges();
}
}
public void Update(User us)
{
var user = db.Users.FirstOrDefault(u => u.Id == us.Id);
bool isModified = false;
if (user.Login != us.Login)
{
user.Login = us.Login;
isModified = true;
}
if (user.Password != us.Password)
{
user.Password = us.Password;
isModified = true;
}
if (user.RoleId != us.RoleId)
{
var userTmp = db.Roles.FirstOrDefault(id => id.Id == us.RoleId);
if (userTmp != null)
{
user.RoleId = us.RoleId;
isModified = true;
}
}
if (isModified)
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
}
}
public async Task <IActionResult> PutType(int id, Models.Type @type)
{
if (id != @type.Id)
{
return(BadRequest());
}
_context.Entry(@type).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TypeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PutMaterial(int id, Material material)
{
if (id != material.Id)
{
return(BadRequest());
}
_context.Entry(material).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MaterialExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void Update(OrderDetails item)
{
var order = _context.OrderDetails.FirstOrDefault(o => o.Id == item.Id);
bool isModified = false;
if (order.OrderId != item.OrderId)
{
order.OrderId = item.OrderId;
isModified = true;
}
if (order.ProductId != item.ProductId)
{
order.ProductId = item.ProductId;
isModified = true;
}
if (order.Quantity != item.Quantity)
{
order.Quantity = item.Quantity;
isModified = true;
}
if (order.Quantity != item.Quantity)
{
order.Quantity = item.Quantity;
isModified = true;
}
if (isModified)
{
_context.Entry(order).State = EntityState.Modified;
_context.SaveChanges();
}
}
public void Update(Modification item)
{
var modification = _context.Modifications.FirstOrDefault(o => o.Id == item.Id);
bool isModified = false;
if (modification.ModelId != item.ModelId)
{
modification.ModelId = item.ModelId;
isModified = true;
}
if (modification.Name != item.Name)
{
modification.Name = item.Name;
isModified = true;
}
if (modification.TypeSort != item.TypeSort)
{
modification.TypeSort = item.TypeSort;
isModified = true;
}
if (isModified)
{
_context.Entry(modification).State = EntityState.Modified;
_context.SaveChanges();
}
}
public async Task <IActionResult> PutClothesColors(int id, ClothesColors clothesColors)
{
if (id != clothesColors.Id)
{
return(BadRequest());
}
_context.Entry(clothesColors).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ClothesColorsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PutOrder(int id, Order order)
{
if (id != order.Id)
{
return(BadRequest());
}
_context.Entry(order).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!OrderExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void Delete(int id)
{
Photo photo = _context.Photos.FirstOrDefault(o => o.Id == id);
//удаление всех связей данного фото.
var models = _context.Models.Where(o => o.PhotoId == photo.Id);
foreach (var model in models)
{
model.PhotoId = null;
//обновляем запись модель(автомобиля), убирая картинку
_context.Entry(model).State = EntityState.Modified;
_context.SaveChanges();
}
_context.Photos.Remove(photo);
_context.SaveChanges();
}
public void Update(Employee emp)
{
var employee = db.Employees.FirstOrDefault(empl => empl.Id == emp.Id);
bool isModified = false;
if (employee.FirstName != emp.FirstName)
{
employee.FirstName = emp.FirstName;
isModified = true;
}
if (employee.LastName != emp.LastName)
{
employee.LastName = emp.LastName;
isModified = true;
}
if (employee.Partonymic != emp.Partonymic)
{
employee.Partonymic = emp.Partonymic;
isModified = true;
}
if (employee.Age != emp.Age)
{
employee.Age = emp.Age;
isModified = true;
}
if (employee.DateofBirth != emp.DateofBirth)
{
employee.DateofBirth = emp.DateofBirth;
isModified = true;
}
if (employee.PositionId != emp.PositionId)
{
var employeeTmp = db.Positions.FirstOrDefault(id => id.Id == emp.PositionId);
if (employeeTmp != null)
{
employee.PositionId = emp.PositionId;
isModified = true;
}
}
if (isModified)
{
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Update(Category categ)
{
var category = db.Categories.FirstOrDefault(o => o.Id == categ.Id);
bool isModified = false;
if (category.Name != categ.Name)
{
category.Name = categ.Name;
isModified = true;
}
if (isModified)
{
db.Entry(category).State = EntityState.Modified;
}
}
public void Update(Role rol)
{
var roles = db.Roles.FirstOrDefault(r => r.Id == rol.Id);
bool isModified = false;
if (roles.Name != rol.Name)
{
roles.Name = rol.Name;
isModified = true;
}
if (isModified)
{
db.Entry(roles).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Update(Position pos)
{
var position = db.Positions.FirstOrDefault(posi => posi.Id == pos.Id);
bool isModified = false;
if (position.Name != pos.Name)
{
position.Name = pos.Name;
isModified = true;
}
if (isModified)
{
db.Entry(position).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Update(Product prod)
{
var product = db.Products.FirstOrDefault(o => o.Id == prod.Id);
bool isModified = false;
if (product.Name != prod.Name)
{
product.Name = prod.Name;
isModified = true;
}
if (product.Descriptions != prod.Descriptions)
{
product.Descriptions = prod.Descriptions;
isModified = true;
}
if (product.Price != prod.Price)
{
product.Price = prod.Price;
isModified = true;
}
if (product.CategoryId != prod.CategoryId)
{
product.CategoryId = prod.CategoryId;
isModified = true;
}
if (product.IsDeleted != prod.IsDeleted)
{
product.IsDeleted = prod.IsDeleted;
isModified = true;
}
if (product.Count != prod.Count)
{
product.Count = prod.Count;
isModified = true;
}
if (isModified)
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Update(User user)
{
var userT = _context.Users.FirstOrDefault(o => o.Id == user.Id);
bool isModified = false;
if (userT.Name != user.Name)
{
userT.Name = user.Name;
isModified = true;
}
if (userT.Password != user.Password)
{
userT.Password = user.Password;
isModified = true;
}
if (userT.GroupId != user.GroupId)
{
userT.GroupId = user.GroupId;
isModified = true;
}
if (userT.IsDeleted != user.IsDeleted)
{
userT.IsDeleted = user.IsDeleted;
isModified = true;
}
if (userT.IsDeleted != user.IsDeleted)
{
userT.IsDeleted = user.IsDeleted;
isModified = true;
}
if (isModified)
{
_context.Entry(userT).State = EntityState.Modified;
_context.SaveChanges();
}
}
public void Update(Product item)
{
var prod = db.Products.FirstOrDefault(o => o.Id == item.Id);
bool isModified = false;
if (prod.Name != item.Name)
{
prod.Name = item.Name;
isModified = true;
}
if (prod.Count != item.Count)
{
prod.Count = item.Count;
isModified = true;
}
if (isModified)
{
db.Entry(prod).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Update(Mark item)
{
var mark = _context.Marks.FirstOrDefault(o => o.Id == item.Id);
bool isModified = false;
if (mark.Name != item.Name)
{
mark.Name = item.Name;
isModified = true;
}
if (mark.Main != item.Main)
{
mark.Main = item.Main;
isModified = true;
}
if (isModified)
{
_context.Entry(mark).State = EntityState.Modified;
_context.SaveChanges();
}
}
public void Update(Order item)
{
var order = _context.Orders.FirstOrDefault(o => o.Id == item.Id);
bool isModified = false;
if (order.UserId != item.UserId)
{
order.UserId = item.UserId;
isModified = true;
}
if (order.OrderDate != item.OrderDate)
{
order.OrderDate = item.OrderDate;
isModified = true;
}
if (isModified)
{
_context.Entry(order).State = EntityState.Modified;
_context.SaveChanges();
}
}
public void Update(Model item)
{
var model = _context.Models.FirstOrDefault(o => o.Id == item.Id);
bool isModified = false;
if (model.MarkId != item.MarkId)
{
model.MarkId = item.MarkId;
isModified = true;
}
if (model.Name != item.Name)
{
model.Name = item.Name;
isModified = true;
}
if (model.Years_Body != item.Years_Body)
{
model.Years_Body = item.Years_Body;
isModified = true;
}
if (model.Start != item.Start)
{
model.Start = item.Start;
isModified = true;
}
if (model.End != item.End)
{
model.End = item.End;
isModified = true;
}
if (model.TecDoc != item.TecDoc)
{
model.TecDoc = item.TecDoc;
isModified = true;
}
if (model.PhotoId != item.PhotoId)
{
model.PhotoId = item.PhotoId;
isModified = true;
}
if (model.Main != item.Main)
{
model.Main = item.Main;
isModified = true;
}
if (model.Market != item.Market)
{
model.Market = item.Market;
isModified = true;
}
if (model.Type != item.Type)
{
model.Type = item.Type;
isModified = true;
}
if (isModified)
{
_context.Entry(model).State = EntityState.Modified;
_context.SaveChanges();
}
}
