public SpellReagentDTO Update(SpellReagentDTO data)
{
if (_repo.Update(data))
{
return(data);
}
throw new Exception("Something has gone wrong...");
}
public ActionResult <SpellReagentDTO> Update([FromBody] SpellReagentDTO data)
{
try
{
SpellReagentDTO update = _service.Update(data);
return(Ok(update));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public ActionResult <SpellReagentDTO> Create([FromBody] SpellReagentDTO data)
{
try
{
SpellReagentDTO newReagent = _service.Create(data);
return(Ok(newReagent));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
internal bool Update(SpellReagentDTO data)
{
string sql = @"
UPDATE spell_reagents
SET
spellId = @SpellId,
reagentId = @ReagentId
WHERE id = @Id
";
int affectedRows = _db.Execute(sql, data);
return(affectedRows == 1);
}
public SpellReagentDTO Create(SpellReagentDTO data)
{
string sql = @"
INSERT INTO spell_reagents
(spellId, reagentId)
VALUES
(@SpellId, @ReagentId)
SELECT LAST_INSERT_ID()
";
data.Id = _db.ExecuteScalar <int>(sql, data);
return(data);
}
public SpellReagentDTO Create(SpellReagentDTO data)
{
return(_repo.Create(data));
}
