public async Task <ActionResult> Post(product_value productValue)
{
if (ModelState.IsValid)
{
string proplem = ConstraintsTest(productValue).Result;
if (proplem == "")
{
var result = await dbContext.fdc_products_values.AddAsync(productValue);
if (result != null && result.State == EntityState.Added)
{
try
{
await dbContext.SaveChangesAsync();
var response = await dbContext.GetProductValue(result.Entity.product_value_id);
return(Ok(response));
}
catch
{ }
}
return(NotFound($"{result.State}"));
}
else
{
return(NotFound($"{proplem}"));
}
}
return(BadRequest());
}
public async Task <ActionResult> Put(int id, product_value productValue)
{
if (ModelState.IsValid)
{
productValue.product_property_id = id;
string proplem = ConstraintsTest(productValue).Result;
if (proplem == "")
{
var result = dbContext.fdc_products_values.Update(productValue);
if (result != null && result.State == EntityState.Modified)
{
await dbContext.SaveChangesAsync();
var response = await dbContext.GetProductValue(result.Entity.product_property_id);
return(Ok(response));
}
return(NotFound("Свойства продукта не найден"));
}
else
{
return(NotFound($"{proplem}"));
}
}
return(BadRequest());
}
/// <summary>
/// Проверка на существования связанных сущностей в БД
/// </summary>
private async Task <string> ConstraintsTest(product_value productValue)
{
var product_type = await dbContext.GetProduct(productValue.product_property_id);
var product = await dbContext.GetProduct(productValue.product_id);
string proplem = string.Format("{0}{1}"
, product == null ? "Не указан продукт. " : ""
, product_type == null ? "Не указан тип продукта. " : "");
return(proplem);
}
