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