public IHttpActionResult UpdateCharItemById(EditCharItem editCharItem)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var service = CreateCharItemService();
string errorText = service.UpdateCharItemById(editCharItem);
if (errorText == null)
{
return(Ok("Update completed"));
}
return(BadRequest(errorText));
}
public string UpdateCharItemById(EditCharItem model)
{
using (var ctx = new ApplicationDbContext())
{
if (ctx.CharItems.Count(e => e.CharItemId == model.CharItemId) == 0)
{
return("Record not found in table");
}
if (ctx.Characters.Count(e => e.CharId == model.CharId) == 0)
{
return($"Character {model.CharId} NOT found in table");
}
if (ctx.Items.Count(e => e.ItemId == model.ItemId) == 0)
{
return($"Item {model.ItemId} NOT found in table");
}
if (ctx.CharItems.Count(e => e.CharId == model.CharId && e.ItemId == model.ItemId) != 0)
{
return("Combination already exists in table");
}
var entity =
ctx
.CharItems
.Single(e => e.CharItemId == model.CharItemId);
entity.CharId = model.CharId;
entity.ItemId = model.ItemId;
if (ctx.SaveChanges() == 1)
{
return(null);
}
return("Update failed - unknown error");
}
}
