public ActionResult <ContractorJobs> Post([FromBody] ContractorJobs newCj)
{
try
{
return(Ok(_cjs.Create(newCj)));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public int Create(ContractorJobs newCj)
{
string sql = @"
INSERT INTO contractorjobs
(contractorId, jobId)
VALUES
(@ContractorId, @JobId);
SELECT LAST_INSERT_ID();";
return(_db.ExecuteScalar <int>(sql, newCj));
}
public ActionResult <ContractorJobs> Create([FromBody] ContractorJobs newContractorJobs)
{
try
{
return(Ok(_service.Create(newContractorJobs)));
}
catch (System.Exception e)
{
return(BadRequest(e.Message));
}
}
