internal ContractWorker Create(ContractWorker newContractWorker) { int id = _repo.Create(newContractWorker); newContractWorker.id = id; return(newContractWorker); }
internal ContractWorker Get(int id) { ContractWorker data = _repo.Get(id); if (data == null) { throw new Exception("Invalid Id"); } return(data); }
public ActionResult <ContractWorker> Post([FromBody] ContractWorker newContractWorker) { try { return(Ok(_cs.Create(newContractWorker))); } catch (Exception e) { return(BadRequest(e.Message)); } }
internal int Create(ContractWorker newContractWorker) { string sql = @" INSERT INTO contractworkers (Name, Ratings) VALUES (@Name, @Ratings); SELECT LAST_INSERT_ID();"; return(_db.ExecuteScalar <int>(sql, newContractWorker)); }