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