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)); }